ORA-12154 and standby
I am seeing ora-12154 in the v$archive_desc view on a main database
SQL> select dest_id, destination, status, error, fail_date from v$archive_dest
2 ;
DEST_ID DESTINATION STATUS ERROR FAIL_DATE
-------- ------------------------------ --------- ------------------------------ -------------------
2 pcrp01a ERROR ORA-12154: TNS:could not resol 01-13-2011 11:12:29
ve the connect identifier spec
ified
However when I attempt to connect to the same database (pcrp01a) via sqlnet I am not seeing the same error
SQL> connect /@pcrp01a
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
This message is fine because the prcp01a database is in recovery mode