HPUX: Intermittent ORA-12505 Errors Connecting Via Listener to Instance (Doc ID 956199.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Net Services - Version: 9.2.0.8.0 and later   [Release: 9.2 and later ]
HP Tru64 UNIX
The problem documented here is limited to HPUX and 9.2.0.8 Oracle Database.

Symptoms

Connections that used to work begin to fail intermittently with ORA-12505 errors.


ORA-12505: TNS:listener does not currently know of SID given in connect descriptor


In this case, the error occurred as infrequently as 5-10 in a 24  hour period.



Changes

It is likely that an HP-UX OS patch was applied recently and the onset of this problem appears to have occurred at about the same time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms