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: 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

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
  Symptoms
  Changes
  Cause
  Solution

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