" This article declined to reprint Original from http://990487026.blog.51cto.com"
The phenomenon of error:
[[email protected] ~]$ lsnrctl startlsnrctl for linux: version 11.2.0.1.0 - production on 29-aug-2016 10:38:59copyright (c) 1991, 2009, oracle. all rights reserved. Starting /opt/oracle/app/product/11.2.0/dbhome_1/bin/tnslsnr: please wait ... tnslsnr for linux: version 11.2.0.1.0 - productionsystem parameter file is /opt/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.oralog messages written to /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xmllistening on: ( Description= (address= (PROTOCOL=IPC) (key=extproc1521)) error listening on: (DESCRIPTION= (ADDRESS = (protocol=tcp) (HOST=ORACLE11) (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 existlistener failed to start. see the error message (s) above ...
The above is an error message.
Start to check the wrong,
Tns-12545:connect failed because target host or object does not exist
[[email protected] ~]$ > /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xml[[ Email protected] ~]$ lsnrctl start[[email protected] ~]$ grep txt /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xml <txt>system parameter file is /opt/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora <txt>log messages written to /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xml <txt>trace information written to /opt/oracle/app/diag/tnslsnr/oracle11/listener/ Trace/ora_3706_140351658579712.trc <txt>trace level is currently 0 <txt >Started with pid=3706 <txt>Listening on: (description= (address= (protocol= IPC) (key=extproc1521)) <txt>Error listening on: (description= (address= (protocol=tcp ) (HOST=ORACLE11) (port=1521)) <txt>TNS-12545: Connect failed because target host or object does not exist <txt>no longer listening on: (DESCRIPTION= (Address= (PROTOCOL=IPC) (key=extproc1521))) [[email protected] ~]$
Online Search [Tns-12545:connect failed] Locate Tnsnames.ora file
cat/opt/oracle/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Tnsnames.ora Network Configuration File:/ opt/oracle/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = oracle11) (PORT = 1521)) (Connect_data = (SERVER = DED icated) (service_name = ORCL)))
See: HOST = Oracle11
View my Hosts file and really don't have this:
[Email protected] ~]$ cat/etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6[[email protected] ~]$
Add an article:
[email protected] ~]$ su rootpassword: [[email protected] oracle]# echo "127.0.0.1 oracle11" >>/etc/hosts[[email Protected] oracle]# cat/etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6127.0.0.1 oracle11 [[email protected] oracle]#
Access test:, start monitoring:
[[email protected] ~]$ ping oracle11ping oracle11 (127.0.0.1) 56 ( ) bytes of data.64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.090 ms64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.048 ms64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.046 ms[[email protected] ~]$ lsnrctl startlsnrctl for linux: Version 11.2.0.1.0 - Production on 29-AUG-2016 10:47:44Copyright (c) 1991, 2009, oracle. all rights reserved. Starting /opt/oracle/app/product/11.2.0/dbhome_1/bin/tnslsnr: please wait ... tnslsnr for linux: version 11.2.0.1.0 - productionsystem parameter File is /opt/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.oralog messages written to /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/ log.xmllistening on: (description= (address= (PROTOCOL=IPC) (key=extproc1521)) Listening on: (Description= (address= (protocol=tcp) (HOST=ORACLE11) (port=1521))) connecting to (description= (address= (PROTOCOL=IPC) (key=extproc1521)) status of the LISTENER------------------------alias LISTENERVersion tnslsnr for linux: Version 11.2.0.1.0 - ProductionStart Date 29-AUG-2016 10:47:44Uptime 0 days 0 hr. 0 min. 0 sectrace level offSecurity ON: Local os authenticationsnmp offlistener parameter file /opt/ oracle/app/product/11.2.0/dbhome_1/network/admin/listener.oralistener log file /opt/oracle/app/diag/tnslsnr/oracle11/listener/alert/log.xmllistening Endpoints Summary... (description= (address= (PROTOCOL=IPC) (key=extproc1521)) (Description= (address= (protocol=tcp) (HOST=ORACLE11) (port=1521))) The listener supports no servicesthe command completed successfully[[email protected] ~]$
Scott landed up and tried it:
My database service has started
[[email protected] ~]$ sqlplus scott/11sql*plus: release 11.2.0.1.0 production on mon aug 29 10:48:36 2016copyright (c) 1982, 2009, oracle. all rights reserved. connected to:oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit productionwith the partitioning, olap, data mining and Real Application Testing optionsSQL> select * from dept; deptno dname loc---------- -------------- -------------50 oracle england10 accounting new york20 research dallas30 sales chicago40 operations bostonsql> sql> exit;disconnected From oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit productionwith the partitioning, olap, data mining and real application testing options[[email protected] ~]$
Get!
This article from "Soul Bucket Luo" blog, declined reprint!
Linux Oracle 11g, lsnrctl start monitoring service startup failure workaround