troubleshooting Question


Avatar of novicedbaUK
novicedbaUK asked on
Oracle Database
2 Comments1 Solution916 ViewsLast Modified:

I am having problems with my standby and its driving me up the wall. I created the standby on Saturday, ready to go Live today. I created it from a cold backup. This was working fine, switched a few logfiles on the primary and these were applied on the standby. I had a hot backup run on the primary at 5.30 pm on the same day. Come in this morninga and the logs are not being applied to the standby. I get the following when I look at the trace file

kcrrfail: dest:2 err:12154 force:0
ORA-12154: TNS:could not resolve service name
*** 2007-10-22 13:02:19.026
Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'PRD01STBY'
Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'PRD01STBY'
Heartbeat failed to connect to standby 'MCSPRD01STBY'. Error is 12154.

This is very baffling as nothing has changed, my tns is fine and so is the listener. I am running Oracle 9i on AIX 5. Could someone please help as its a live environment


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros