這篇文章主要介紹oracle如何實(shí)現(xiàn)網(wǎng)絡(luò)配置，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

為巴馬等地區(qū)用戶提供了全套網(wǎng)頁(yè)設(shè)計(jì)制作服務(wù)，及巴馬網(wǎng)站建設(shè)行業(yè)解決方案。主營(yíng)業(yè)務(wù)為成都網(wǎng)站制作、成都網(wǎng)站設(shè)計(jì)、巴馬網(wǎng)站設(shè)計(jì)，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠(chéng)的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會(huì)得到認(rèn)可，從而選擇與我們長(zhǎng)期合作。這樣，我們也可以走得更遠(yuǎn)！

網(wǎng)絡(luò)配置的方法：

1、tnsname客戶端--A 直接修改文件
                           B 通過客戶端工具“網(wǎng)絡(luò)配置助手”--win端直接打開調(diào)用Linux端，netca命令調(diào)出配置工具

2、監(jiān)聽器配置--服務(wù)器端

客戶端配置監(jiān)聽服務(wù)室沒有任何意義的，因?yàn)榭蛻舳藳]有oracle server

監(jiān)聽器配置文件：/u01/oracle/product/10.2.0/db_1/network/admin/listener.ora

[oracle@oracle3 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
 )

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1521))
   )
 )

服務(wù)器端配置一個(gè)監(jiān)聽器

[oracle@oracle3 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1522))
   )
 ) --新的監(jiān)聽器，監(jiān)聽器監(jiān)聽是1522端口

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
 )

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1521))
   )
 )

------------------------------------------------------------------------------------

一個(gè)數(shù)據(jù)庫(kù)實(shí)例被多個(gè)監(jiān)聽器監(jiān)聽案例

[oracle@oracle3 admin]$ lsnrctl status --默認(rèn)打開的是LISTENER

[oracle@oracle3 admin]$ lsnrctl status LISTENER1 --打開的是第二個(gè)監(jiān)聽器

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JUN-2014 14:28:42

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle3)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER1
Version                  TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date               06-JUN-2014 14:26:15
Uptime                   0 days 0 hr. 2 min. 26 sec
Trace Level              off
Security                 ON: Local OS Authentication
SNMP                     OFF
Listener Parameter File  /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File        /u01/oracle/product/10.2.0/db_1/network/log/listener1.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1522)))
The listener supports no services
The command completed successfully


將ORCL注冊(cè)到第二個(gè)監(jiān)聽器：

修改監(jiān)聽器配置文件：

LISTENER1 =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1522))
   )
 )

SID_LIST_LISTENER1 =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SID_NAME=ORCL)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
   )
 )

通過監(jiān)聽器2訪問：創(chuàng)建一個(gè)1522端口的連接串訪問。

     LISTENER1（1522）       LISTENER（1521）
       |                        |
       ---------------------------
              |
            ORCL
              |
          Oracle軟件

并發(fā)訪問：一個(gè)群組通過1521訪問，一個(gè)群組通過1522訪問.

-------------------------------------------------------------------------------------

一個(gè)監(jiān)聽器監(jiān)聽多個(gè)端口案例

方法1：服務(wù)器端用netmgr工具添加端口

[oracle@oracle3 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1522))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1527))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1528))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1529))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1530))
   )
 )

SID_LIST_LISTENER1 =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SID_NAME = ORCL)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
   )
 )

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1521))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1523))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1524))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1525))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1526))
   )
 )

方法2：直接改這個(gè)配置文件

另外兩個(gè)監(jiān)聽器都需要配置SID_LIST_串，監(jiān)聽器配置文件最終：

[oracle@oracle3 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1522))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1527))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1528))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1529))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1530))
   )
 )

SID_LIST_LISTENER1 =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SID_NAME = ORCL)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
   )
 )

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1521))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1523))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1524))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1525))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1526))
   )
 )


架構(gòu)圖：

     LISTENER1（1522、1527~1530）       LISTENER（1521、1523~1526）
       |                                          |
       ----------------------------------------------
              |
            ORCL
              |
          Oracle軟件

嘗試通過不同的監(jiān)聽器不同的端口訪問oracle server

[oracle@oracle3 admin]$ lsnrctl status LISTENER

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JUN-2014 14:54:41

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date               06-JUN-2014 14:48:35
Uptime                   0 days 0 hr. 6 min. 5 sec
Trace Level              off
Security                 ON: Local OS Authentication
SNMP                     OFF
Listener Parameter File  /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File        /u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1523)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1524)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1525)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1526)))
Services Summary...
Service "ORCL" has 2 instance(s).
 Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
 Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
 Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCL_XPT" has 1 instance(s).
 Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
 Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@oracle3 admin]$ lsnrctl status LISTENER1

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JUN-2014 14:54:47

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle3)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER1
Version                  TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date               06-JUN-2014 14:49:08
Uptime                   0 days 0 hr. 5 min. 39 sec
Trace Level              off
Security                 ON: Local OS Authentication
SNMP                     OFF
Listener Parameter File  /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File        /u01/oracle/product/10.2.0/db_1/network/log/listener1.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1522)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1527)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1528)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1529)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1530)))
Services Summary...
Service "ORCL" has 1 instance(s).
 Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
 Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
------------------------------------------------------------------------------------

靜態(tài)注冊(cè)--監(jiān)聽參數(shù)是手工添加的，啟動(dòng)監(jiān)聽后強(qiáng)制將ORCL注冊(cè)到監(jiān)聽器。由于是強(qiáng)制的，只能確認(rèn)監(jiān)聽器是正確的，但是
      數(shù)據(jù)庫(kù)不一定訪問通，所以狀態(tài)為UNKNOW。但是能否訪問不是和這個(gè)狀態(tài)有關(guān)系的。
動(dòng)態(tài)注冊(cè)--根據(jù)監(jiān)聽配置文件中的配置，由oracle的后臺(tái)進(jìn)程pmon將ORCL注冊(cè)到監(jiān)聽器，而且是一定能訪問通的，因?yàn)?nbsp;        PMON進(jìn)程會(huì)測(cè)試。但是PMON不是時(shí)時(shí)刻刻都去注冊(cè)的，有時(shí)間間隔，所以先啟動(dòng)數(shù)據(jù)庫(kù)再啟動(dòng)監(jiān)聽不一定
      馬上監(jiān)到，   有時(shí)間的延遲，因?yàn)閜mon的工作是有時(shí)間間隔的。一旦監(jiān)聽到，狀態(tài)為ready，即一定能訪問通。

[oracle@oracle3 admin]$ ps -ef|grep ora_pmon
oracle   9190    1 0 11:07 ?       00:00:00 ora_pmon_ORCL


Oracle默認(rèn)監(jiān)聽的注冊(cè)方法是動(dòng)態(tài)注冊(cè)，即往默認(rèn)的監(jiān)聽器LISTENER上注冊(cè)，listener.ora文件中不需要SID_LIST_LISTENER即可。但是靜態(tài)注冊(cè)必須要SID_LIST_LISTENER串和LISTENER串。

LISTENER1 =                       --LISTENER1靜態(tài)注冊(cè)
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1522))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1527))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1528))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1529))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1530))
   )
 )

SID_LIST_LISTENER1 =
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SID_NAME = ORCL)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
   )
 )

LISTENER =                                  --LISTENER動(dòng)態(tài)注冊(cè)
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1521))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1523))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1524))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1525))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1526))
   )
 )


可以改變默認(rèn)的注冊(cè)監(jiān)聽器：即將默認(rèn)的監(jiān)聽器由LISTENER改為L(zhǎng)ISTENER1（LISTENER1改為動(dòng)態(tài)的，LISTENER改為靜態(tài)的），需要做以下幾步：

step1：在oracle server的tnsname.ora文件中配置一個(gè)連接串：

ORCL =
 (DESCRIPTION =
   (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.3)(PORT = 1522))  --1522對(duì)應(yīng)的監(jiān)聽器是非默認(rèn)的LISTENER1
   )
 )

step2：修改oracle參數(shù)：

SQL> alter system set local_listener=ORCL;

系統(tǒng)已更改。  --這樣oracle默認(rèn)往1522對(duì)應(yīng)的監(jiān)聽器上做動(dòng)態(tài)注冊(cè)。

step3：修改listener.ora文件

[oracle@oracle3 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =                --LISTENER1變?yōu)閯?dòng)態(tài)注冊(cè)
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1522))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1527))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1528))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1529))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1530))
   )
 )

SID_LIST_LISTENER =    --LISTENER變?yōu)殪o態(tài)注冊(cè)
 (SID_LIST =
   (SID_DESC =
     (SID_NAME = PLSExtProc)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
     (PROGRAM = extproc)
   )
   (SID_DESC =
     (SID_NAME = ORCL)
     (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
   )
 )

LISTENER =
 (DESCRIPTION_LIST =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1521))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1523))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1524))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1525))
   )
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = oracle3)(PORT = 1526))
   )
 )

step4：動(dòng)態(tài)注冊(cè)不能馬上生效，要等pmon進(jìn)程，有延遲，但是可以強(qiáng)制馬上

SQL> alter system register; --不等pmon，強(qiáng)制注冊(cè)

系統(tǒng)已更改。

step5：確認(rèn)

[oracle@oracle3 admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JUN-2014 16:05:49

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER
Version                  TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date               06-JUN-2014 15:46:21
Uptime                   0 days 0 hr. 19 min. 28 sec
Trace Level              off
Security                 ON: Local OS Authentication
SNMP                     OFF
Listener Parameter File  /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File        /u01/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1523)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1524)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1525)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1526)))
Services Summary...
Service "ORCL" has 1 instance(s).
 Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...         --LISTENER為靜態(tài)注冊(cè)
Service "PLSExtProc" has 1 instance(s).
 Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


[oracle@oracle3 admin]$ lsnrctl status LISTENER1

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 06-JUN-2014 16:06:24

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle3)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                    LISTENER1
Version                  TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date               06-JUN-2014 15:46:28
Uptime                   0 days 0 hr. 19 min. 56 sec
Trace Level              off
Security                 ON: Local OS Authentication
SNMP                     OFF
Listener Parameter File  /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File        /u01/oracle/product/10.2.0/db_1/network/log/listener1.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1522)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1527)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1528)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1529)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle3)(PORT=1530)))
Services Summary...
Service "ORCL" has 1 instance(s).
 Instance "ORCL", status READY, has 1 handler(s) for this service...  --LISTENER1為動(dòng)態(tài)注冊(cè)
Service "ORCLXDB" has 1 instance(s).
 Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCL_XPT" has 1 instance(s).
 Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully

注意：
1、一個(gè)實(shí)例只能有一個(gè)動(dòng)態(tài)注冊(cè)監(jiān)聽器，可以有多個(gè)靜態(tài)注冊(cè)的監(jiān)聽器。
2、動(dòng)態(tài)注冊(cè)監(jiān)聽器在某些時(shí)候是不可用的，pmon休息的時(shí)候，此時(shí)需要加一個(gè)靜態(tài)注冊(cè)監(jiān)聽，這樣保證數(shù)據(jù)庫(kù)可以時(shí)時(shí)刻刻對(duì)外訪問。
3、多個(gè)監(jiān)聽器可以均衡訪問的負(fù)載
4、到底用默認(rèn)還是非默認(rèn)的監(jiān)聽器做動(dòng)態(tài)注冊(cè)，取決于local_listener參數(shù)，默認(rèn)是NULL，表示默認(rèn)LISTENER是動(dòng)態(tài)注冊(cè)的，如果有值，根據(jù)值找到動(dòng)態(tài)注冊(cè)的監(jiān)聽器。

以上是“oracle如何實(shí)現(xiàn)網(wǎng)絡(luò)配置”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

本文題目：oracle如何實(shí)現(xiàn)網(wǎng)絡(luò)配置-創(chuàng)新互聯(lián)
文章URL：http://weahome.cn/article/cogcos.html