Database Administrator

RMAN Connection To Catalog Fails With ORA-12154



Applies to:
________________________________________________________________________________


Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.1.0.7 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.




Symptoms:
________________________________________________________________________________


Connection to RMAN fails with following errors :

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified




Cause:
________________________________________________________________________________


Problem could be due to wrong directory pointed in TNS_ADMIN variable.
Variable could be set in windows registry or as an OS environment variable.
If  both are set, environment variable will take precedence over registry setting.




Solution:
_________________________________________________________________________________


Check that the TNS_ADMIN variable is pointing to the correct and existing directory for Oracle Net Services configuration files.


References:
_______________________________________________________________________________________________
Oracle [Doc ID 729817.1]