Home > Database, Linux, Oracle, SLES > SLES 11 SP1 Hangs on Boot with Oracle Listener

SLES 11 SP1 Hangs on Boot with Oracle Listener

February 3rd, 2015

Every once in a while you might experience boot issues if you have configured Oracle to automatically start the listener, instance and agent in the /etc/sysconfig/oracle.

There might be few reasons for this to happen.

In my case after some troubleshooting I noticed that the tnsnames.ora file was configured to use an IP address rather than hostname.

Since the DHCP has renewed the lease, the server was getting a new IP address which prevented the normal Oracle startup.

Check if your server is configured to automatically receive hostname over DHCP and remove that.

Check the /etc/hosts file for incorrect entries.

In order for me to change the configuration I had to reboot in single mode, remount the partition with read and write permissions and make the changes to the configuration file.

After reboot the server obtained an Ip address correctly and the oracle processes started as expected.

Servers using DHCP, yes I know..

Categories: Database, Linux, Oracle, SLES Tags:
Comments are closed.