以下文章是針對想用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)
)
)
