My Oracle Support Banner

Connections Via the Listener Fail With Either ORA-12505 or ORA-12514 (Doc ID 437737.1)

Last updated on FEBRUARY 18, 2024

Applies to:

Oracle Net Services - Version 8.1.7.0 and later
Information in this document applies to any platform.


Symptoms

The database is started but remote clients are unable to connect via the listener.  Attempts to connect fail with any one of the following errors:

 

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
 1. Reconfigure listener to bind on system hostname
 2. Reconfigure the database instance
 3. Create a static service registration
References

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