/etc/hosts 文件引起的监听无法启动的处理过程

      新装了1个11.2的oracle数据库，配置监听时总是无法启动，最后发现竟然是hosts文件的原因，下面详细信息。

1.启动监听：

[oracle@chenbo ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-JAN-2011 15:12:46

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

Starting /u01/app/oracle/ora11gR2/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /u01/app/oracle/ora11gR2/product/11.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.1)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                12-JAN-2011 15:12:46

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/ora11gR2/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.1)(PORT=1521)))

Services Summary...

Service "orcl" has 1 instance(s).

  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

2.查看监听状态，却提示没有监听服务启动。

[oracle@chenbo dbs]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-JAN-2011 15:30:16

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.1)(PORT=1521)))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 111: Connection refused

3.查看监听日志：

[oracle@chenbo ~]$ tail -f /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/trace/listener.log

Trace information written to /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/trace/ora_20443_47949057950496.trc

Trace level is currently 0

Started with pid=20443

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.1)(PORT=1521)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

WARNING: Subscription for node down event still pending

12-JAN-2011 14:25:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=chenbo)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0

Wed Jan 12 14:29:26 2011

System parameter file is /u01/app/oracle/ora11gR2/product/11.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/alert/log.xml

Trace information written to /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/trace/ora_20479_47689240552224.trc

Trace level is currently 0

可以看到监听在启动的时候去读取了系统的主机名chenbo和登陆的用户oracle，因此这个主机名gaojf应该在/etc/hosts中唯一存在的，并且对oracle用户是可以使用的，

4.查看hosts文件，

[oracle@chenbo ~]$ cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1               chenbo

192.168.150.1           chenbo

#::1            localhost6.localdomain6 localhost6

5.刚开始尝试屏蔽 127.0.0.1行，重新启动服务器后，启动监听，还是错误。

后来修改127.0.0.1的机器名为localhost，如下：

[oracle@chenbo dbs]$ cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1               localhost

192.168.150.1           chenbo

# ::1           localhost6.localdomain6 localhost6

6.再次启动监听，可以看到已经成功启动了。

[oracle@chenbo dbs]$ lsnrctl start

[oracle@chenbo dbs]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-JAN-2011 16:03:34

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.1)(PORT=1521)))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                12-JAN-2011 15:43:47

Uptime                    0 days 0 hr. 19 min. 47 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/ora11gR2/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/ora11gR2/diag/tnslsnr/chenbo/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.1)(PORT=1521)))

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...

The command completed successfully

©著作权归作者所有：来自51CTO博客作者gjm008的原创作品，如需转载，请注明出处，否则将追究法律责任

职场休闲lsnrctloracle 基础