关于Listener动态注册

之前有遇到过很多次,动态注册不了,原因在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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22990797/viewspace-767094/