error creating standby

Dear All,

Iam getting the following error in my primary database-alert log when I give the command 'Recover managed standby database'

ARC0: Error 12154 connecting to standby host 'standby1'
ARC0: Error 12154 creating archivelog file 'standby1'

I have given the following parameters in the standby parameter file:

log_archive_dest_1 = "location=D:\oracle\oradata\cad95\archive"
standby_archive_dest = "location=D:\oracle\oradata\cad95\archive"

and corresponding values on the primary init.ora are:

log_archive_dest_1 = "location=D:\oracle\oradata\cad95\archive"
log_archive_dest_2 = "service=standby2"

The alert log of the standby reads that it is waiting for the log from the primary. Only manual recovery is possible.

Tnsnames.ora and listener.ora have also been configured. Could anyone point out the mistake made/ solution to this problem.

Regards,

K.Diwakar

A 12154 error indicates your primary database can't contact your standby. Most likely your tnsnames.ora entry needs to be altered.

Quote:

---

Originally posted by diwakar
Iam getting the following error in my primary database-alert log when I give the command 'Recover managed standby database'

ARC0: Error 12154 connecting to standby host 'standby1'
ARC0: Error 12154 creating archivelog file 'standby1'

and corresponding values on the primary init.ora are:

log_archive_dest_1 = "location=D:\oracle\oradata\cad95\archive"
log_archive_dest_2 = "service=standby2"

---

ARC0: Error 12154 connecting to standby host 'standby1'
ARC0: Error 12154 creating archivelog file 'standby1'

log_archive_dest_2 = "service=standby2"

standby1 ??? or standby2 ???

or Is it a typo in the post?

Sameer

Dear Sameer,

Thanks for pointing out the mistake and thanks to Marist too. But instead of mentioning the service name in the archive_log_dest_2, can we not give the location to point to the archive_log_dest of the standby databse?? Will that work??

Regards,

K.Diwakar

In case if the standby database is on the same machine as primary then it will work, but what if it is remote.. So its better to specify as SERVICE

Sameer