Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-03135: connection lost contact , Archivelogs not shipping automatically

user10702579Dec 9 2010 — edited Dec 15 2010
hi to all,

I m trying to setup oracle dataguard for 10G ; both primary and standby databases are in 10GR2(10.2.0.4).
Archivelogs are not shipping automatically.tnsping to PROD_STBY working fine. Neither Bandwidth issue nor firewall issue.
pfile has following entry :log_archive_dest_2='SERVICE=PROD_STBY reopen=60'
When we do following command on Primary
SQL> select status, Error from v$archive_dest where dest_id=2;

STATUS ERROR
--------- -----------------------------------------------------------------
ERROR ORA-03135: connection lost contact
Following is the alert log:
ORACLE Instance PROD - Archival Error. Archiver continuing.
Thu Dec 9 08:37:06 2010
Errors in file /oracle/PROD/saptrace/background/PROD_arc0_12394.trc:
ORA-03135: connection lost contact
Thu Dec 9 08:37:06 2010
FAL[server, ARC0]: FAL archive failed, see trace file.
Thu Dec 9 08:37:06 2010
Errors in file /oracle/PROD/saptrace/background/PROD_arc0_12394.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Dec 9 08:37:06 2010
ORACLE Instance PROD - Archival Error. Archiver continuing.

Trace file:
Error 1041 detaching RFS from standby instance at host 'PROD_STBY.WORLD'
kcrrwkx: unknown error:3135
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
ARCH: Connecting to console port...
*** 2010-12-09 08:37:03.850
Redo shipping client performing standby login
*** 2010-12-09 08:37:03.930 66535 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x2)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x2)
ABC: tkrsf_al_read: No mirror copies to re-read data
ARCH : Error 3135 sending stashed buffer
ORA-03135: connection lost contact
*** 2010-12-09 08:37:06.015 60970 kcrr.c
kcrrfail: dest:2 err:3135 force:0 blast:1
Error 1041 detaching RFS from standby instance at host 'PROD_STBY.WORLD'
kcrrwkx: unknown error:3135
ORA-16055: FAL request rejected
ARCH: Connecting to console port...

Thanks & Regards
Dhaanshree
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2011
Added on Dec 9 2010
6 comments
5,741 views