after rebooting our SAP system together with the Oracle 18.104.22.168 database and the oracle listener (on a Linux SuSe SLES 10 Enterprise Server), the oracle listner hangs during startup.
The output after lsnrctl start is only:
LSNRCTL for Linux: Version 22.214.171.124.0 - Production on 18-OCT-2012 10:43:21
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /oracle/J01/112_64/bin/tnslsnr: please wait...
..and then the listener hangs 'forever'...
We don´t change anything during the reboot in the area of the listener config files.
In the listener trace file we could find a line like this:
2012-10-17 18:43:07.308452 : snlinGetAddrInfo:getaddrinfo() failed with error -2"
in the log.xml file only these line are visible:
<msg time='2012-10-18T11:05:31.009+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='bwportal'
<txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bwportal)(PORT=1527)))
After implementing the latest linux kernel the problem was solved (?!), everythink works fine (listener, database, and sap instance) but after some hours -and a new test reboot of the SAP-Instance with database and listener- the problem occurs again.
We don´t find any problems in the network area of the server. No firewall is active.
-> If anybody has an idea, what we have to do or which area or log we have to check, please inform us.
Hi Jörg ,
Hope you are doing good.
According to the symptoms, SAP Note 723147 seems to be relevant.
Please use "relink all" to relink the oracle binaries. Also make sure that all environment variables are set correctly. If the above fails, please refer to SAP Note 505630 point 12 and perform accordingly.
Thank you and have a nice day :).
this is a pretty common issue based on the following reasons:
If you are not sure - you can run the tool "strace" on the listener process to check the exact reason.