Oracle 靜態監聽註冊詳解

標籤：des   style   color   io   os   ar   for   檔案   sp   

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] 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 靜態監聽註冊詳解