今天有个朋友在机器上安装oracle单位实例
启动不了监听报tns-12560:TNS-00511
[oracle@weblogic29 ~]$ lsnrctl stop LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-NOV-2012 17:11:41 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=weblogic29)(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))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused
原因是因为他以前用这台机器作为rac的一节点安装过rac
且在/etc/hosts文件中的配置没有修改，而它配置监听时主机使用的是主机名
10.138.130.29 weblogic29 jyrac1 10.138.130.209 weblogic29 jyrac1-priv 10.138.130.219 weblogic29 jyrac1-vip 10.138.130.28 weblogic28 jyrac2 10.138.130.208 weblogic28 jyrac2-priv 10.138.130.218 weblogic28 jyrac2-vip
后修改为
10.138.130.29 weblogic29 localhost
重新启动监听就行了
[oracle@weblogic29 ~]$ lsnrctl start LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-NOV-2012 17:20:19 Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting /u01/app/oracle/product/10.2.0/db/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/10.2.0/db/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.2.0/db/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=weblogic29)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=weblogic29)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 28-NOV-2012 17:20:21 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/product/10.2.0/db/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10.2.0/db/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=weblogic29)(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