ORA-12514 with connections but Database is mounted and open and LOCAL_LISTENER is set correctly
(Doc ID 2621090.1)
Last updated on MARCH 04, 2020
Applies to:Oracle Net Services - Version 18.104.22.168 and later
Information in this document applies to any platform.
Possibly after a reboot, connections are failing through the Listener:
The Database is mounted and open and the LOCAL_LISTENER (Database) Parameter is correctly set to the Listener TCP address:
LOCAL_LISTENER '(address = (protocol = tcp)(host = <listener_hostname>)(port = <listener_port#>))'
Also, IPv6 is DISABLED on this Server.
A restart of the Server or Listener after some operating system security updates / installations.
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