troubleshooting Question

ORA-12571 error primary database not sending archive logs across?

Avatar of teched1000
teched1000 asked on
Oracle Database
12 Comments1 Solution1871 ViewsLast Modified:
Hi there everyone,

I have two databases on win 2k server's, one is the primary and one is the standby.

Now everything was working fine and then I think a log got passed across when either the standby's server was down or it was in open mode. Now when I try and send a log across I get a

ORA-12571: TNS: packet writer failure error

I have tried  

Svrgrl:> alter system set log_archive_dest_state_4=enable;

but I am still getting the same error.

The archive section in the primary's init file looks like.

log_archive_start = true
log_archive_min_succeed_dest = 2
log_archive_dest_1 = "location=D:\Oracle\oradata\primary\archive"
log_archive_dest_2 = "location=D:\Oracle\oradata\primary\archive2"
log_archive_dest_3 = "location=G:\Oracle\oradata\standby\tr2archive"
log_archive_dest_4 = 'SERVICE=STANDBY1 OPTIONAL REOPEN=60'
log_archive_dest_state_4= ENABLE
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

Any ideas???
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
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 12 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