關於Listener動態註冊

n-lauren發表於2013-07-25
之前有遇到過很多次,動態註冊不了,原因在listener.ora配置的host與主機名hostname不一致導致,改成一致便可以.

--host檔案對應
[oracle@odd admin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
172.20.24.177 odd

--主機名
[oracle@odd admin]$ cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=odd
[oracle@odd admin]$ hostname
odd

--listener.ora檔案
[oracle@odd admin]$ cat /u01/app/oracle/network/admin/listener.ora
LISTENER =
  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=odd)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

SID_LIST_LISTENER=
   (SID_LIST=
        (SID_DESC=
          (GLOBAL_DBNAME=PROD)
          (SID_NAME=PROD)
          (ORACLE_HOME=/u01/app/oracle/)
         )
        (SID_DESC=
          (GLOBAL_DBNAME=EMREP)
          (SID_NAME=EMREP)
          (ORACLE_HOME=/u01/app/oracle/)
         )

--監聽狀態,已存在動態註冊
[oracle@odd admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-JUL-2013 02:26:01

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=odd)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                25-JUL-2013 02:25:37
Uptime                    0 days 0 hr. 0 min. 23 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/network/admin/listener.ora
Listener Log File         /u01/app/oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=odd)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
Services Summary...
Service "EMREP" has 1 instance(s).
  Instance "EMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD" has 2 instance(s).
  Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
  Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PROD_XPT" has 1 instance(s).
  Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22990797/viewspace-767094/，如需轉載，請註明出處，否則將追究法律責任。

相關文章