Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error 12154 received logging on to the standby

user3714906Oct 14 2012 — edited Nov 18 2012

Hi,

We have standby for our production database,
since yesterday, we are getting below error in alert log file of production and the redo's are not getting shipped

Error 12154 received logging on to the standby
Sun Oct 14 13:47:46 2012
Error 12154 received logging on to the standby
Sun Oct 14 13:48:46 2012
Error 12154 received logging on to the standby
Sun Oct 14 13:49:46 2012
Error 12154 received logging on to the standby
Sun Oct 14 13:50:46 2012
Error 12154 received logging on to the standby
Sun Oct 14 13:51:46 2012
Error 12154 received logging on to the standby

SQL> select error from v$archive_dest;

ERROR
-----------------------------------------------------------------

ORA-12154: TNS:could not resolve the connect identifier specified

I could tnsping the STANDBY from production

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2012

Added on Oct 14 2012

#data-guard, #performance-availability

7 comments

34,516 views