以下文章是針對(duì)想用Windows2000建設(shè)網(wǎng)站，Oracle 9i/10g安裝搭建數(shù)據(jù)庫(kù)后臺(tái)的新手，高手可繞開(kāi)。具體安裝步驟如下：
操作系統(tǒng)：windows2000 server
軟件oracle9i+oracle10G102
步驟：（先裝9i再裝10g）
1、先安裝oracle9i,完成后關(guān)閉所有服務(wù)。
2、安裝oracle10G,安裝的路徑與9i路徑不一致，完成。
3、重啟系統(tǒng)（個(gè)人行為），修改oracle9i監(jiān)聽(tīng)程序端口listener.ora（1522）并修改tnsnames.ora、snmp_ro.ora文件中的相關(guān)端口。

安裝完9i后發(fā)現(xiàn)可以登錄，但點(diǎn)擊時(shí)出現(xiàn)“ORACLE不可用”
方法：sqlplus /nolog
     conn sys/sys as sysdba
     startup
     執(zhí)行以上命令后，就可以登入了

裝完10G且修改好9i的監(jiān)聽(tīng)程序端口后，進(jìn)入9i同樣出現(xiàn)“ORACLE不可用”，用一中的方法不行，執(zhí)行tnsping orcl9i發(fā)現(xiàn)指向的10G的目錄

方法一：我的電腦->屬性->高級(jí)->環(huán)境變量->path;修改path值將"oracle9i\...\bin"放到"oracle10g\...\bin"前，重啟系統(tǒng)再使用問(wèn)題一的方法就可以了。

方法二：不修改path值，修改10g下的tnsnames.ora文件，將9i中的配置拷入10的tnsnames.ora，同樣修改9i的tnsnames.ora文件。再使用命令啟動(dòng)9i數(shù)據(jù)庫(kù)(修改后的tnsnames.ora文件見(jiàn)下面)
     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)
     )
   )

如果感興趣可以留意網(wǎng)站上相關(guān)的文章。

【編輯推薦】

1. Oracle性能診斷不能不知的秘籍
2. 使用dtu遠(yuǎn)程連接Oracel 9i數(shù)據(jù)庫(kù)的方法
3. Oracle多表查詢優(yōu)化的代碼示例
4. Oracle更改的默認(rèn)端口號(hào)剖析
5. Oracle ERP上線準(zhǔn)備的5個(gè)經(jīng)驗(yàn)淺談