Linux Oracle 11g, lsnrctl start monitoring service startup failure workaround

" 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