My Oracle Support Banner

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.