Listener无法启动

来源:转载

查看监听果然没有反应:

[[email protected] bdump]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-MAY-2010 10:31:40

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

查找到listener 的进程并杀死进程:

[[email protected] admin]$ ps -ef|grep ora

......

oracle   13720 28474  0 May15 ?        00:00:00 /u01/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

[[email protected] admin]$ kill -9 13720

重新启动监听:

[[email protected] bdump]$ lsnrctl stat

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-MAY-2010 10:49:37

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) 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=TCP)(HOST=erpdevdb)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused [[email protected] bdump]$ [[email protected] bdump]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-MAY-2010 10:49:44

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> stop Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) 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=TCP)(HOST=erpdevdb)(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 /u01/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdevdb.banping.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date                17-MAY-2010 10:49:52 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/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File         /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpdevdb.banping.com)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully LSNRCTL> LSNRCTL> exit

[[email protected] admin]$ ps -ef|grep tnslsnr oracle    5021     1  0 10:49 ?        00:00:00 /u01/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit

查看sqlnet.log记录:

Fatal NI connect error 12537, connecting to: (LOCAL=NO)

VERSION INFORMATION: TNS for Linux: Version 10.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production Time: 17-MAY-2010 10:49:23 Tracing not turned on. Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0

查看listener.log 记录

17-MAY-2010 10:49:23 * (CONNECT_DATA=(SERVICE_NAME=+ASM)(INSTANCE_NAME=+ASM)(UR=A)(CID=([email protected])(HOST=erpdevdb)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=45772)) * establish * +ASM * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 32: Broken pipe 17-MAY-2010 10:49:23 * service_update * erpoptm * 0 17-MAY-2010 10:49:23 * service_update * erpwh * 0 17-MAY-2010 10:49:23 * service_update * devdb * 0 17-MAY-2010 10:49:23 * service_update * erptest * 0 17-MAY-2010 10:49:23 * service_update * papererpdb * 0 17-MAY-2010 10:49:23 * service_update * erpstudydb * 0 17-MAY-2010 10:49:23 * service_update * +ASM * 0 17-MAY-2010 10:49:23 * service_update * erpoptm * 0 17-MAY-2010 10:49:23 * service_update * erpwh * 0 17-MAY-2010 10:49:23 * service_update * devdb * 0 17-MAY-2010 10:49:23 * service_update * papererpdb * 0 17-MAY-2010 10:49:23 * service_update * erpstudydb * 0 17-MAY-2010 10:49:23 * ping * 0 17-MAY-2010 10:49:23 * service_update * erptest * 0 17-MAY-2010 10:49:23 * service_update * +ASM * 0 17-MAY-2010 10:49:23 * ping * 0 17-MAY-2010 10:49:23 * ping * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(SID=erptest)(CID=([email protected])(HOST=erpdevdb)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=45907)) * establish * erptest * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(SERVICE_NAME=+ASM)(INSTANCE_NAME=+ASM)(UR=A)(CID=([email protected])(HOST=erpdevdb)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=45905)) * establish * +ASM * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=erptest)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=45863)) * establish * erptest * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(SID=erptest)(CID=([email protected])(HOST=erpdevdb)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=45774)) * establish * erptest * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(SERVICE_NAME=+ASM)(INSTANCE_NAME=+ASM)(UR=A)(CID=([email protected])(HOST=erpdevdb)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=46043)) * establish * +ASM * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=erptest)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=46005)) * establish * erptest * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=erptest)) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=46084)) * establish * erptest * 0 17-MAY-2010 10:49:23 * (CONNECT_DATA=(SID=erptest)(CID=([email protected])(HOST=erpdevdb)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.88)(PORT=46045)) * establish * erptest * 0 17-MAY-2010 10:49:23 * service_update * +ASM * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 17-MAY-2010 10:49:52

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

System parameter file is /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log Trace information written to /u01/app/oracle/oracle/product/10.2.0/db_1/network/trace/li


分享给朋友:
您可能感兴趣的文章:
随机阅读: