When running a console initiated Oracle RMAN backup, RMAN manages to connect to the target database but fails to connect to the Recovery Catalog.
The error in the log shows:
RMAN-04004: error from recovery catalog database:
ORA-12154: TNS:could not resolve service name
There are multiple tnsnames.ora files used and the one referred to by the APM does not contain an entry for the Recovery Catalog service name.
By default 'tnsnames.ora' is located in:
- $ORACLE_HOME/network/admin directory on UNIX operating systems
- ORACLE_HOME\network\admin directory on Windows operating systems.
But 'tnsnames.ora' can also be stored in the following locations:
- The directory specified by the TNS_ADMIN environment variable (or registry value)
- On UNIX operating systems, the global configuration directory. For example, on the Solaris Operating System, this directory is /var/opt/oracle.
If you have multiple ORACLE_HOMES, be aware of which one you are using, as the location of the tnsnames.ora file can vary from one ORACLE_HOME to the next.
BakBone SFDC Solution Number: 00006029
