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

新密網(wǎng)站制作公司哪家好，找創(chuàng)新互聯(lián)公司！從網(wǎng)頁設(shè)計(jì)、網(wǎng)站建設(shè)、微信開發(fā)、APP開發(fā)、成都響應(yīng)式網(wǎng)站建設(shè)公司等網(wǎng)站項(xiàng)目制作，到程序開發(fā)，運(yùn)營維護(hù)。創(chuàng)新互聯(lián)公司公司2013年成立到現(xiàn)在10年的時(shí)間，我們擁有了豐富的建站經(jīng)驗(yàn)和運(yùn)維經(jīng)驗(yàn)，來保證我們的工作的順利進(jìn)行。專注于網(wǎng)站建設(shè)就選創(chuàng)新互聯(lián)公司。

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

客戶端的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)聽步驟：

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

1. 設(shè)置service_names:

    alter system  set  service_names=test1,test2,test3;

 2. 編寫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;

客戶端配置：

 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)
    )
  )

以上動(dòng)態(tài)注冊配置完畢。以上改為靜態(tài)注冊步驟。

只需要在服務(wù)器端修改listener.ora