TNS-12541: TNS:no listener

来源:互联网 发布:经典java编程面试题 编辑:程序博客网 时间:2024/05/16 11:57
[oracle@MasterHadoop50 wallet]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2015 18:14:10Copyright (c) 1991, 2005, Oracle.  All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> LSNRCTL> statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centos5.localdomain)(PORT=1521)))TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error  TNS-00515: Connect failed because target host or object does not exist   Linux Error: 11: Resource temporarily unavailableConnecting 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 refusedLSNRCTL> startStarting /u01/oracle/11G/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /u01/oracle/11G/network/admin/listener.oraLog messages written to /u01/oracle/11G/network/log/listener.logError listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centos5.localdomain)(PORT=1521)))TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error  TNS-00515: Connect failed because target host or object does not exist   Linux Error: 11: Resource temporarily unavailableListener failed to start. See the error message(s) above...                            ".  Try "help"LSNRCTL> LSNRCTL> LSNRCTL> startStarting /u01/oracle/11G/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /u01/oracle/11G/network/admin/listener.oraLog messages written to /u01/oracle/11G/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.55.55)(PORT=1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=centos5.localdomain)(PORT=1521)))TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error  TNS-00515: Connect failed because target host or object does not exist   Linux Error: 11: Resource temporarily unavailableConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date                01-FEB-2015 18:20:40Uptime                    0 days 0 hr. 0 min. 0 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/oracle/11G/network/admin/listener.oraListener Log File         /u01/oracle/11G/network/log/listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.55.55)(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 successfullyLSNRCTL> 

重启成功是因为,改了HOST  

[oracle@MasterHadoop50 wallet]$ cat /u01/oracle/11G/network/admin/listener.ora# listener.ora Network Configuration File: /u01/oracle/11G/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = /u01/oracle/11G)      (PROGRAM = extproc)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.55.55)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))    )  )[oracle@MasterHadoop50 wallet]$


0 0
原创粉丝点击