Windows2000服务器下安装Oracle9i与10g

以下文章是针对想用Windows2000建设网站，Oracle 9i/10g安装搭建数据库后台的新手，高手可绕开。具体安装步骤如下：
操作系统：windows2000 server
软件oracle9i+oracle10G102
步骤：（先装9i再装10g）
1、先安装oracle9i,完成后关闭所有服务。
2、安装oracle10G,安装的路径与9i路径不一致，完成。
3、重启系统（个人行为），修改oracle9i监听程序端口listener.ora（1522）并修改tnsnames.ora、snmp_ro.ora文件中的相关端口。

安装完9i后发现可以登录，但点击时出现“ORACLE不可用”
方法：sqlplus /nolog
conn sys/sys as sysdba
startup
执行以上命令后，就可以登入了

装完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

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)
)
)

如果感兴趣可以留意网站上相关的文章。

1. Oracle性能诊断不能不知的秘籍
2. 使用dtu远程连接Oracel 9i数据库的方法
3. Oracle多表查询优化的代码示例
4. Oracle更改的默认端口号剖析
5. Oracle ERP上线准备的5个经验浅谈