WINDOWs2000下安装ORACLE9I与10G
上一篇 /
下一篇 2007-12-03 17:02:44
/ 个人分类:ORACLE
操作系统:windows2000 server
软件oracle9i+oracle10G102
步骤:(先装9i再装10g)
1、先安装oracle9i,完成后关闭所有服务。
2、安装oracle10G,安装的路径与9i路径不一致,完成。
3、重启系统(个人行为),修改oracle9i监听程序端口listener.ora(1522)并修改tnsnames.ora、snmp_ro.ora文件中的相关端口。
问题:
1、装完9i后发现可以登录,但点击时出现“ORACLE不可用”
方法:sqlplus /nolog
conn sys/sys as sysdba
startup
执行以上命令后,就可以登入了
2、装完10G且修改好9i的监听程序端口后,进入9i同样出现“ORACLE不可用”,用一中的方法不行,执行tnsping orcl9i发现指向的10G的目录
方法一:我的电脑->属性->高级->环境变量->path;修改path值将"oracle9i\...\bin"放到"oracle10g\...\bin"前,重启系统再使用问题一的方法就可以了。
方法二:不修改path值,修改10g下的tnsnames.ora文件,将9i中的配置拷入10的tnsnames.ora,同样修改9i的tnsnames.ora文件。再使用命令启动9i数据库(修改后的tnsnames.ora文件见下面)
sqlplus /nolog
connsys/sys@orcl9ias sysdba
startup
以上只为个人做参考用,感谢天涯浪子的帮助
10G的tnsnames.ora
====================================================
ORCL10G =
(DEscrīptION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl10g)
)
)
ORCL9I =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL9I)
)
)
EXTPROC_CONNECTION_DATA =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
====================================================
9i的tnsnames.ora
====================================================
ORCL10G =
(DEscrīptION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl10g)
)
)
ORCL9I =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL9I)
)
)
INST1_HTTP =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xt-b271dac81b07)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION =http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DEscrīptION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
相关阅读:
- 设计和实施Oracle RAC项目 (51testing, 2007-11-02)
- 提高Oracle的查询统计速度方法简介 (51testing, 2007-11-07)
- 浅析SQL Server与Oracle、DB2的比较 (51testing, 2007-11-12)
- 浅析SQL Server与Oracle、DB2的比较 (lf0026, 2007-11-12)
- 浅析SQL Server与Oracle、DB2的比较 (51testing, 2007-11-13)
- oracle几个常用的监控视图 (51testing, 2007-11-15)
- 使用oracle sql loader批量导入数据 (51testing, 2007-11-20)
- 测试Oracle 11g系统分区遇错 (51testing, 2007-11-22)
- Oracle数据库的安全性、完整性、并发控制和恢复 (51testing, 2007-11-23)
- ORACLE发布新的.NET驱动和开发插件 (51testing, 2007-11-26)
收藏
举报
TAG:
ORACLE