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: and later   [Release: 9.2 and later ]
The problem documented here is limited to HPUX and Oracle Database.


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.


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.


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