Oracle监听能正常启动，但实例监听不到故障应急处理一例

故障现象：监听能正常启动，但两个实例均未能监听到

[Oracle@L-DB-100-17 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-1月 -2002 14:29:33

Copyright （c） 1991, 2007, Oracle. All rights reserved.

Connecting to （DESCRIPTION=（ADDRESS=（PROTOCOL=TCP）（HOST=172.16.100.17）（PORT=1521）））

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date 07-1月 -2002 14:03:45

Uptime 0 days 0 hr. 25 min. 47 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=172.16.100.17）（PORT=1521）））

（DESCRIPTION=（ADDRESS=（PROTOCOL=ipc）（KEY=EXTPROC0）））

Services Summary...

Service "PLSExtProc" has 1 instance（s）.

Instance "PLSExtProc", status UNKNOWN, has 1 handler（s） for this service...

The command completed successfully
故障处理：

1、修改HOST地址

[oracle@L-DB-100-17 admin]$ vi listener.ora

修改IP地址为0.0.0.0,"HOST=0.0.0.0"
2、重启lsnrclt

[oracle@L-DB-100-17 admin]$ lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-1月 -2002 14:31:24

Copyright （c） 1991, 2007, Oracle. All rights reserved.

Connecting to （DESCRIPTION=（ADDRESS=（PROTOCOL=TCP）（HOST=0.0.0.0）（PORT=1521）））

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to （DESCRIPTION=（ADDRESS=（PROTOCOL=IPC）（KEY=EXTPROC0）））

The command completed successfully

[oracle@L-DB-100-17 admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 07-1月 -2002 14:31:37

Copyright （c） 1991, 2007, Oracle. All rights reserved.

Starting /u01/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production

System parameter file is /u01/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/product/10.2.0/db_1/network/log/listener.log

Listening on: （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=0.0.0.0）（PORT=1521）））

Listening on: （DESCRIPTION=（ADDRESS=（PROTOCOL=ipc）（KEY=EXTPROC0）））

Connecting to （DESCRIPTION=（ADDRESS=（PROTOCOL=TCP）（HOST=0.0.0.0）（PORT=1521）））

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date 07-1月 -2002 14:31:37

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/product/10.2.0/db_1/network/admin/listener.ora

Listener Log File /u01/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=0.0.0.0）（PORT=1521）））

（DESCRIPTION=（ADDRESS=（PROTOCOL=ipc）（KEY=EXTPROC0）））

Services Summary...

Service "PLSExtProc" has 1 instance（s）.

Instance "PLSExtProc", status UNKNOWN, has 1 handler（s） for this service...

The command completed successfully

Oracle数据库中有关触发器问题MySQL强制编码导出、导入数据相关资讯 Oracle监听

CentOS7下Oracle 11gR2监听启动错（04月23日）
Linux下修改Oracle监听地址（08/21/2015 10:11:58）
Oracle RAC Database 11.1.0.6监听（11/26/2014 11:07:04）

Oracle监听服务开启（03月28日）
Oracle 修改监听端口号1521 （02/12/2015 19:50:40）
Oracle 静态监听注册详解（09/14/2014 10:33:00）

本文评论查看全部评论（0）