oracle動(dòng)態(tài)注冊(cè)和靜態(tài)注冊(cè)監(jiān)聽(tīng)器

150次閱讀

共計(jì) 1545 個(gè)字符，預(yù)計(jì)需要花費(fèi) 4 分鐘才能閱讀完成。

自動(dòng)寫(xiě)代碼機(jī)器人，免費(fèi)開(kāi)通

oracle 動(dòng)態(tài)注冊(cè)和靜態(tài)注冊(cè)的區(qū)別：動(dòng)態(tài)監(jiān)聽(tīng)不需要在 listener.ora 文件中記錄關(guān)于數(shù)據(jù)的任何信息，只需要將監(jiān)聽(tīng)器的配置信息寫(xiě)入到該文件。例如：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL = IPC) (KEY=EXTPRO1))
(ADDRESS=(PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
)

客戶(hù)端的 tnsnames.ora 配置信息，需要加入每個(gè) service_name, 其他的任何東西不需要改動(dòng)，例如

YUCESHI1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
YUCESHI2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
YUCESH3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test3)
)
)

動(dòng)態(tài)監(jiān)聽(tīng)步驟：

服務(wù)器端配置如下：

設(shè)置 service_names:

alter system set service_names=test1,test2,test3;

2. 編寫(xiě) listener.ora 文件：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL = IPC) (KEY=EXTPRO1))
(ADDRESS=(PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
)

3. 重新啟動(dòng) oracle 實(shí)例，這樣做才能使 service_names 生效。（前提是 oracle 處于 open 狀態(tài)下才執(zhí)行）

conn /as sysdba;

shutdown immediate;

startup;

客戶(hù)端配置：

1. 編輯 tnsnames.ora, 保存后立即生效。

YUCESHI1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)
YUCESHI2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)
YUCESH3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test3)
)
)