ORA -12514 or ORA -12528 - While Attempting Cold Backup from RMAN or EM Grid Console (Doc ID 397027.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Net Services - Version 10.2.0.1.0 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

* You have connected to the instance remotely via listener. While performing shutdown and the startup from the same session. 

* You are trying to take cold backup from RMAN or EM Grid console, which involves shutdown and startup of the instance.

You may get the below errors:

ORA-12514  : TNS:listener does not currently know of service requested in connect descriptor
ORA-12528  :  TNS:listener: all appropriate instances are blocking new connections

Cause

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