Oracle 靜態監聽注冊具體解釋

標籤：message   apt   contact   10g   hand   version   end   service   with   

Oracle 靜態監聽注冊具體解釋

       網上有非常多關於oracle 監聽靜態注冊的文章。但大多都是簡單說說，並沒有具體的範例。這裡，將結合linux as4 下的oracle 10gR2.0.1 舉一個具體的範例
1、在 $ORACLE_HOME/network/admin/listener.ora 檔案裡增加一個靜態注冊的節點

[[email protected] oracle]$ cd $ORACLE_HOME/network/admin[[email protected] admin]$ vi listener.ora# listener.ora Network Configuration File: /mydatafile2/app/oracle/oracle/product/11.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 = /mydatafile2/app/oracle/oracle/product/11.2.0/db_1)      (PROGRAM = extproc)    )    (SID_DESC =      (SID_NAME = ORCL)      (ORACLE_HOME = /mydatafile2/app/oracle/oracle/product/11.2.0/db_1)      (GLOBAL_DBNAME=WOO.COM)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))      (ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))    )  )

注意這裡的GLOBAL_DBNAME=WOO.COM
SID_NAME=ORCL 
這個SID_NAME 應與你對外提供服務的 $ORACLE_SID 一致

[[email protected] admin]$ echo $ORACLE_SID ORCL

 2、配置相應的tnsnames.ora 中的節點

[[email protected] admin]$ vi tnsnames.ora# tnsnames.ora Network Configuration File: /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL=  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = ORCL)    )  )WOOORCL=  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = WOO.COM)    )  )

tnsname WOOORCL 中的 SERVICE_NAME=WOO.COM

這裡的服務名為 WOO.COM 而不是通常的 ORCL，由於在 listener.ora 中已經注冊了 WOO.COM,lsnrctl 啟動時會監聽 WOO.COM 。並相應到 SID_NAME=ORCL 上。

3、啟動監聽和服務

[[email protected] oracle]$ cat dbstartlsnrctl startsqlplus /nolog <<EOFconnect /as sysdbastartupEOF[[email protected] oracle]$ ./dbstartLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-FEB-2011 20:11:15Copyright (c) 1991, 2005, Oracle.  All rights reserved.Starting /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionSystem parameter file is /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/listener.oraLog messages written to /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prudent)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                13-FEB-2011 20:11:15Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/listener.oraListener Log File         /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/log/listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prudent)(PORT=1521)))Services Summary...Service "WOO.COM" has 1 instance(s).  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...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 successfullySQL*Plus: Release 11.2.0.1.0 - Production on Sun Feb 13 20:11:16 2011Copyright (c) 1982, 2005, Oracle.  All rights reserved.SQL> Connected to an idle instance.SQL> ORA-32004: obsolete and/or deprecated parameter(s) specifiedORACLE instance started.Total System Global Area  461373440 bytesFixed Size                  1220000 bytesVariable Size              75498080 bytesDatabase Buffers          381681664 bytesRedo Buffers                2973696 bytesDatabase mounted.Database opened.SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options

能夠看到  
Service "WOO.COM" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
正在被監聽。

4、驗證該服務能夠到達

[[email protected] oracle]$ tnsping WOOORCLTNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 13-FEB-2011 20:14:59Copyright (c) 1997, 2005, Oracle.  All rights reserved.Used parameter files:/mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = WOO.COM)))OK (10 msec)

5、利用靜態注冊的服務登入oracle

[[email protected]rudent oracle]$ sqlplus system/[email protected]SQL*Plus: Release 11.2.0.1.0 - Production on Sun Feb 13 20:17:27 2011Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select count(*) from date_log;  COUNT(*)----------SQL>

至此：已驗證該靜態注冊能夠成功的被解析，監聽，串連。

Oracle 靜態監聽注冊具體解釋