客户问题解决记录-监听问题
http://www.itpub.net/tree/index_1/]oracle@read-db1:/home/bdmp/oracle/product/11.2.0/network/admin> lsnrctl
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 11-MAR-2014 21:26:27
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> stop Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused LSNRCTL> start Starting /home/bdmp/oracle/product/11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production Log messages written to /home/bdmp/oracle/diag/tnslsnr/read-db1/listener/alert/log.xml Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
2. 很明显ip别占用了,所以查询了下1521是否别占用了。[table=98%,rgb(208,206,206)]
[td=594] read-db1:~ # netstat -pan|grep 1521 tcp 0 0 10.1.88.143:1521 0.0.0.0:* LISTEN 56047/tnslsnr tcp 0 0 10.1.88.143:1521 10.1.88.141:9773 ESTABLISHED 56047/tnslsnr tcp 0 0 10.1.88.143:1521 10.1.88.141:42211 ESTABLISHED 56047/tnslsnr tcp 0 0 10.1.88.141:42211 10.1.88.143:1521 ESTABLISHED 8226/asm_pmon_+ASM1 tcp 0 0 10.1.88.141:9773 10.1.88.143:1521 ESTABLISHED
3. 现在客户已经无法连接到数据库了所以就直接杀掉占用进程了。[table=98%,rgb(208,206,206)]
[td=594] read-db1:~ # kill 56047 read-db1:~ # inetstat -pan|grep 1521 -bash: inetstat: command not found read-db1:~ # netstat -pan|grep 1521 tcp 0 0 10.1.88.143:1521 10.1.88.141:9773 TIME_WAIT - tcp 0 0 10.1.88.143:1521 10.1.88.141:42211 TIME_WAIT -
4. 确定杀掉后在尝试启动监听。
[td=594] STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 11-MAR-2014 21:35:39 Uptime 0 days 0 hr. 1 min. 41 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Log File /home/bdmp/oracle/diag/tnslsnr/read-db1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=read-db1)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "bdmp" has 2 instance(s). Instance "bdmp1", status READY, has 2 handler(s) for this service... Instance "bdmp2", status READY, has 1 handler(s) for this service... Service "bdmpXDB" has 2 instance(s). Instance "bdmp1", status READY, has 1 handler(s) for this service... Instance "bdmp2", status READY, has 1 handler(s) for this service... The command completed successfully
5. 监听启动成功。