High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

ORA-12154 and standby

Hello

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center