Two technical issues over the weekend (I)

Symptoms: An application failed to connect to a database on the server which hosts databases of different Oracle versions (10gR2 and 11gR2), because of no listener.

Check: DBA can log into the server and then connect to a database. Using the lsnrctl tool, a listener is actually up and running.

Cause: A lower version of the listener is running. This can be verified by:

[oracle@ttplxdb-01 ~]$ pgrep -lf tnslsnr
23042 /app/oracle/product/10gR2/bin/tnslsnr listener -inherit

Workaround: shutdown the currently-runnig listener and start the higher version counterpart. And this then can be confirmed as:

[oracle@ttplxdb-01 ~]$ pgrep -lf tnslsnr
23042 /app/oracle/product/11gR2/bin/tnslsnr listener -inherit

Because the root cause of the issue is that the server reboot script calls the listener in the wrong path (pointing to the lower version), a permanent solution is to modify the reboot scripts to point to the path to the higher version of listener.

This entry was posted in Blogroll. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s