oracle 11gr2 rac tns-12542: tns:address already in use 故障一例
一．问题描述
一朋友在生产库的一个节点上做了一个非常危险的操作，然后该节点的数据库监听出现了异常。
数据库是2个节点的rac，，版本11.2.0.3。
[grid@dave-db1 trace]$ lsnrctl status listener
lsnrctl for linux: version 11.2.0.3.0 - production on 22-feb-2013 18:40:27
copyright (c) 1991, 2011, oracle. all rights reserved.
connecting to (description=(address=(protocol=ipc)(key=listener)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 11.2.0.3.0 - production
start date 22-feb-2013 18:00:03
uptime 0 days 0 hr. 40 min. 23 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /oracle/11.2.0.3/grid/network/admin/listener.ora
listener log file /oracle/app/grid/diag/tnslsnr/dave-db1/listener/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=ipc)(key=listener)))
(description=(address=(protocol=tcp)(host=127.0.0.1)(port=1521)))
the listener supports no services
the command completed successfully
此处显示：the listener supports no services
[grid@dave-db1 trace]$ lsnrctl status listener_scan1
lsnrctl for linux: version 11.2.0.3.0 - production on 22-feb-2013 18:40:46
copyright (c) 1991, 2011, oracle. all rights reserved.
connecting to (description=(address=(protocol=ipc)(key=listener_scan1)))
status of the listener
------------------------
alias listener_scan1
version tnslsnr for linux: version 11.2.0.3.0 - production
start date 22-feb-2013 17:48:19
uptime 0 days 0 hr. 52 min. 27 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /oracle/11.2.0.3/grid/network/admin/listener.ora
listener log file /oracle/11.2.0.3/grid/log/diag/tnslsnr/dave-db1/listener_scan1/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=ipc)(key=listener_scan1)))
the listener supports no services
the command completed successfully
手工注册后，问题依旧：
sql>alter system register;
节点2上的监听是正常的：
[oracle@dave-db2 admin]$ lsnrctl status
lsnrctl for linux: version 11.2.0.3.0 - production on 22-feb-2013 18:38:06
copyright (c) 1991, 2011, oracle. all rights reserved.
connecting to (address=(protocol=tcp)(host=)(port=1521))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 11.2.0.3.0 - production
start date 22-feb-2013 17:30:45
uptime 0 days 1 hr. 7 min. 21 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /oracle/11.2.0.3/grid/network/admin/listener.ora
listener log file /oracle/app/grid/diag/tnslsnr/dave-db2/listener/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=ipc)(key=listener)))
(description=(address=(protocol=tcp)(host=127.0.0.1)(port=1521)))
(description=(address=(protocol=tcp)(host=192.168.106.14)(port=1521)))
services summary...
service +asm has 1 instance(s).
instance +asm1, status ready, has 1 handler(s) for this service...
service dave has 1 instance(s).
instance dave2, status ready, has 1 handler(s) for this service...
service oradb has 1 instance(s).
instance dave2, status ready, has 1 handler(s) for this service...
service oradbxdb has 1 instance(s).
instance dave2, status ready, has 1 handler(s) for this service...
the command completed successfully
--使用ps 查看监听的进程：
[grid@dave-db1 trace]$ ps -ef|grep listener
grid 421 1 0 17:48 ? 00:00:00 /oracle/11.2.0.3/grid/bin/tnslsnr listener_scan1 -inherit
grid 1435 1 0 18:00 ? 00:00:00 /oracle/11.2.0.3/grid/bin/tnslsnr listener -inherit
grid 4482 1333 0 18:39 pts/1 00:00:00 grep listener
grid 14380 1 0 2012 ? 00:02:56 /oracle/11.2.0.3/grid/bin/tnslsnr listener -inherit
grid 15075 1 0 2012 ? 00:03:07 /oracle/11.2.0.3/grid/bin/tnslsnr listener_scan1 –inherit
注意1：
这里是有问题的，因为监听的进程出现了2次。 我们继续看。
[grid@dave-db2 admin]$ crsctl stat resource -t
--------------------------------------------------------------------------------
name target state server state_details
--------------------------------------------------------------------------------
local resources
--------------------------------------------------------------------------------
ora.data.dg
online online dave-db1
online online dave-db2
ora.listener.lsnr
online intermediate dave-db1 not all endpoints registered
online online dave-db2
ora.asm
online online dave-db1 started
online online dave-db2 started
ora.gsd
offline offline dave-db1
offline offline dave-db2
ora.net1.network
online online dave-db1
online online dave-db2
ora.ons
online online dave-db1
online online dave-db2
ora.registry.acfs
online online dave-db1
online online dave-db2
--------------------------------------------------------------------------------
cluster resources
--------------------------------------------------------------------------------
ora.listener_scan1.lsnr
1 online intermediate dave-db1 not all endpoints registered
ora.cvu
1 online online dave-db1
ora.dave-db1.vip
1 online online dave-db1
ora.dave-db2.vip
1 online online dave-db2
ora.oc4j
1 online online dave-db1
ora.oradb.db
1 online online dave-db2 open
2 online online dave-db1 open
ora.scan1.vip
1 online online dave-db1
注意2：
通过crsctl stat resource –t命令，我们可以看到节点1上的ora.listener.lsnr状态是 intermediate，和not all endpoints registered 。