cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle listener hangs during startup

Jörg_Brockmann
Explorer
0 Kudos

Hello,

after rebooting our SAP system together with the Oracle 11.2.0.2 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 11.2.0.2.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'

host_addr='10.1.160.133'>

<txt>Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bwportal)(PORT=1527)))

</txt>

</msg>

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.


best regards

Jörg Brockmann

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

Hi Jörg,

this is a pretty common issue based on the following reasons:

  1. Invalid entries of DNS nameservers in /etc/resolv.conf and wrong configuration of nsswitch.conf
  2. Wrong configuration of NIS

If you are not sure - you can run the tool "strace" on the listener process to check the exact reason.

Best Regards

Stefan

Jörg_Brockmann
Explorer
0 Kudos

Hi Stefan,

the problem was a wrong entry in the nsswitch.conf (parameter passwd and passwd_compat). Our Linux colleagues could fix the error and everything works fine.

thank you !

Jörg

Answers (1)

Answers (1)

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

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 :).

_____________

Kind Regards,

Hemanth