windows2003下oracle雙節(jié)點(diǎn)雙數(shù)據(jù)庫cluster詳細(xì)配置過程4_數(shù)據(jù)庫AP1和AP2的測試

1、windows2003下oracle雙節(jié)點(diǎn)雙數(shù)據(jù)庫cluster詳細(xì)配置過程4數(shù)據(jù)庫AP1和AP2的測試1在主節(jié)點(diǎn)，服務(wù)端做測試在服務(wù)器端機(jī)器： 1保證listener已經(jīng)啟動(dòng) 2保證數(shù)據(jù)庫已經(jīng)啟動(dòng)。 如果數(shù)據(jù)庫沒有啟動(dòng)，用： Oracle 9i或10g: dos>sqlplus “/ as sysdba” sqlplus> startup Oracle 8i: dos>svrmgrl svrmgrl>connect internal svrmgrl>startup 命令啟動(dòng)數(shù)據(jù)庫 如果listener沒有啟動(dòng)，用： lsnrctl start listener

2、name lsnrctl status listener name 命令啟動(dòng)listener查看監(jiān)聽狀態(tài)lsnrctl status查看監(jiān)聽狀態(tài)lsnrctl start啟動(dòng)監(jiān)聽進(jìn)程lsnrctl reload重新連接Tnsping ap1 看是否ping通數(shù)據(jù)庫AP1Tnsping ap2 看是否ping通數(shù)據(jù)庫AP2在主節(jié)點(diǎn)上面：set oracle_sid=ap1sqlplus / as sysdbaselect name,open_mode from v$database;exitset oracle_sid=ap2sqlplus / as sysdbaselect name,open

3、_mode from v$database;exitsqlplus /nologconn sys/alexwuap1 as sysdba 測試連接ok則成功select name,open_mode from v$database;conn sys/alexwuap2 as sysdba 測試連接ok則成功select name,open_mode from v$database;exit在主節(jié)點(diǎn)上測試，如果出現(xiàn)適配器錯(cuò)誤：查看是不是資源不在主節(jié)點(diǎn)上出現(xiàn) 第1行出現(xiàn)錯(cuò)誤 請啟動(dòng)數(shù)據(jù)庫即可主節(jié)點(diǎn)上啟動(dòng)oraclesqlplus / as sysdbastartup 啟動(dòng)數(shù)據(jù)庫select nam

4、e,open_mode from v$database;exit2在客戶端做數(shù)據(jù)庫的測試客戶端安裝數(shù)據(jù)庫client軟件ORACLE 客戶端配置TNS，用net configuration assistant工具配置設(shè)置ap1的服務(wù)命名設(shè)置和服務(wù)端一致的主機(jī)名和端口點(diǎn)擊完成Ap1的TNS配置完成再次打開net configuration assistant工具添加AP2的TNS設(shè)置主機(jī)名為192.168.9.30端口為1522和服務(wù)端保持一致完成打開net manager工具，可以看見2個(gè)服務(wù)命名此時(shí)C:oracleproduct10.2.0client_1networkadmin目錄下的2個(gè)

5、文件sqlnet.ora和tnsnames.ora的內(nèi)容如下：sqlnet.ora文件內(nèi)容：# sqlnet.ora Network Configuration File: C:oracleproduct10.2.0client_1networkadminsqlnet.ora# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wo

6、nt exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES)tnsnames.ora文件內(nèi)容如下：# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0client_1networkadmintnsnames.ora# Generated

7、 by Oracle configuration tools.AP2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.30)(PORT = 1522) ) (CONNECT_DATA = (SERVICE_NAME = ap2) ) )AP1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.28)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = ap1) ) )打開DOS進(jìn)行測試，tnsping ap1tnsping ap2sqlplus /nologconn sys/alexwuap1 as sysdba 測試連接ok則成功select name