解析oracle數(shù)據(jù)庫(kù)中配置文件(編輯修改稿)
2025-07-04 22:10 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 四、為了使得外部進(jìn)程如 CAMS后臺(tái)程序能夠訪(fǎng)問(wèn) Oracle 數(shù)據(jù)庫(kù)必須配置 Oracle 網(wǎng)絡(luò)服務(wù)器環(huán)境配置 Oracle 網(wǎng)絡(luò)服務(wù)器環(huán)境是通過(guò)配置 和 共三個(gè)文件來(lái)進(jìn)行的 的存放路徑為 $ORACLE_HOME/network/admin 以下是一個(gè)示例：LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = pc149)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/product/) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = appacf) (ORACLE_HOME = /opt/oracle/product/) (SID_NAME = appacf) ) (SID_DESC = (GLOBAL_DBNAME = testrman) (ORACLE_HOME = /opt/oracle/product/) (SID_NAME = testrman) )) 說(shuō)明：1 文件中定義一個(gè)監(jiān)聽(tīng)器其缺省的名稱(chēng)為 LISTENE，這個(gè)監(jiān)聽(tīng)器缺省以tcp/ip為協(xié)議地址且端口號(hào)為1521運(yùn)行在CAMS應(yīng)用中監(jiān)聽(tīng)文件定義的監(jiān)聽(tīng)器就使用這個(gè)缺省名字并且使用缺省的協(xié)議 tcp/ip和缺省的端口號(hào) 1521 待配置好監(jiān)聽(tīng)文件以及隨后說(shuō)明的 文件之后就可以用以下命令將監(jiān)聽(tīng)文件中定義的監(jiān)聽(tīng)器啟動(dòng)啟動(dòng)監(jiān)聽(tīng)器的命令為：$ lsnrctl start 停止監(jiān)聽(tīng)器的命令為：$ lsnrctl stop 監(jiān)測(cè)監(jiān)聽(tīng)器當(dāng)前狀態(tài)的命令為：$ lsnrctl st
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1