ORA-03135: connection lost contact , Archivelogs not shipping automatically
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