Oracle Database Discussions

Hi to all,

I have a strange scenario here. Whenever the Log switch is happening none of the clients cant able to access the mails they cant able to access the internet. This problem is happening only on the time of Log Switch. We are having one Standby Server.

I personally feel whenever the log files are transferred to the standby server it is chocking the switch.

I'm pasting my Alert log file output and the error file noted in alert log file.

Kindly post your suggestions on this regard.

Tue Aug 19 07:12:42 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:18:10 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:23:39 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:29:07 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:34:35 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:40:04 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:45:32 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12535: TNS:operation timed out

Tue Aug 19 07:50:39 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 07:55:47 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 07:59:12 2008
Thread 1 advanced to log sequence 13602
Current log# 1 seq# 13602 mem# 0: G:\ORACLE9I\LOGFILE\REDO01.LOG
Tue Aug 19 07:59:13 2008
ARC1: Evaluating archive log 4 thread 1 sequence 13601
ARC1: Beginning to archive log 4 thread 1 sequence 13601
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE9I\ARCHIVE\MANDATORY\JSL_001_13601.ARC'
ARC1: Completed archiving log 4 thread 1 sequence 13601
Tue Aug 19 08:00:54 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:03:24 2008
Thread 1 advanced to log sequence 13603
Current log# 2 seq# 13603 mem# 0: G:\ORACLE9I\LOGFILE\REDO02.LOG
Tue Aug 19 08:03:25 2008
ARC0: Evaluating archive log 1 thread 1 sequence 13602
ARC0: Beginning to archive log 1 thread 1 sequence 13602
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE9I\ARCHIVE\MANDATORY\JSL_001_13602.ARC'
ARC0: Completed archiving log 1 thread 1 sequence 13602
Tue Aug 19 08:06:00 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:09:39 2008
Thread 1 advanced to log sequence 13604
Current log# 3 seq# 13604 mem# 0: G:\ORACLE9I\LOGFILE\REDO03.LOG
Tue Aug 19 08:09:40 2008
ARC1: Evaluating archive log 2 thread 1 sequence 13603
ARC1: Beginning to archive log 2 thread 1 sequence 13603
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE9I\ARCHIVE\MANDATORY\JSL_001_13603.ARC'
ARC1: Completed archiving log 2 thread 1 sequence 13603
Tue Aug 19 08:11:07 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:16:14 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:21:21 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:26:29 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:29:35 2008
Thread 1 advanced to log sequence 13605
Current log# 5 seq# 13605 mem# 0: G:\ORACLE9I\LOGFILE\REDO05.LOG
Tue Aug 19 08:29:36 2008
ARC0: Evaluating archive log 3 thread 1 sequence 13604
ARC0: Beginning to archive log 3 thread 1 sequence 13604
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE9I\ARCHIVE\MANDATORY\JSL_001_13604.ARC'
ARC0: Completed archiving log 3 thread 1 sequence 13604
Tue Aug 19 08:31:36 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:36:43 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:41:51 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:46:58 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:52:06 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:57:13 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 08:59:51 2008
Thread 1 advanced to log sequence 13606
Current log# 4 seq# 13606 mem# 0: G:\ORACLE9I\LOGFILE\REDO04.LOG
Tue Aug 19 08:59:52 2008
ARC1: Evaluating archive log 5 thread 1 sequence 13605
ARC1: Beginning to archive log 5 thread 1 sequence 13605
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE9I\ARCHIVE\MANDATORY\JSL_001_13605.ARC'
ARC1: Completed archiving log 5 thread 1 sequence 13605
Tue Aug 19 09:02:20 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 09:07:27 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 09:12:35 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 09:17:42 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 09:19:09 2008
Thread 1 advanced to log sequence 13607
Current log# 1 seq# 13607 mem# 0: G:\ORACLE9I\LOGFILE\REDO01.LOG
Tue Aug 19 09:19:10 2008
ARC0: Evaluating archive log 4 thread 1 sequence 13606
ARC0: Beginning to archive log 4 thread 1 sequence 13606
Creating archive destination LOG_ARCHIVE_DEST_1: 'H:\ORACLE9I\ARCHIVE\MANDATORY\JSL_001_13606.ARC'
ARC0: Completed archiving log 4 thread 1 sequence 13606
Tue Aug 19 09:22:49 2008
Errors in file g:\oracle9i\bdump\jsl_arc0_3760.trc:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Tue Aug 19 09:27:58 2008
ARC1: Begin FAL archive (thread 1 sequence 13593 destination JSLSTBY)
Tue Aug 19 09:27:58 2008


===trace file mentioned in altert log file

*** 2008-08-19 07:23:39.031
Error 12535 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12535 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12535.
*** 2008-08-19 07:23:39.078
kcrrfail: dest:2 err:12535 force:0
ORA-12535: TNS:operation timed out
*** 2008-08-19 07:29:07.437
Error 12535 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12535 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12535.
*** 2008-08-19 07:29:07.484
kcrrfail: dest:2 err:12535 force:0
ORA-12535: TNS:operation timed out
*** 2008-08-19 07:34:35.765
Error 12535 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12535 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12535.
*** 2008-08-19 07:34:35.828
kcrrfail: dest:2 err:12535 force:0
ORA-12535: TNS:operation timed out
*** 2008-08-19 07:40:04.171
Error 12535 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12535 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12535.
*** 2008-08-19 07:40:04.234
kcrrfail: dest:2 err:12535 force:0
ORA-12535: TNS:operation timed out
*** 2008-08-19 07:45:32.578
Error 12535 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12535 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12535.
*** 2008-08-19 07:45:32.625
kcrrfail: dest:2 err:12535 force:0
ORA-12535: TNS:operation timed out
*** 2008-08-19 07:50:39.890
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 07:50:39.937
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 07:55:47.187
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 07:55:47.250
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:00:54.015
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:00:54.062
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:06:00.625
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:06:00.687
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:11:07.156
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:11:07.203
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:16:14.453
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:16:14.500
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:21:21.750
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:21:21.812
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:26:29.078
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:26:29.125
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:31:36.406
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:31:36.468
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:36:43.859
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:36:43.890
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:41:51.328
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:41:51.390
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:46:58.687
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:46:58.734
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:52:06.046
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:52:06.109
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 08:57:13.562
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 08:57:13.625
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 09:02:20.218
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 09:02:20.281
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 09:07:27.734
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 09:07:27.781
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 09:12:35.156
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 09:12:35.203
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 09:17:42.812
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 09:17:42.875
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 09:22:49.687
Error 12505 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Error 12505 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'JSLSTBY'
Heartbeat failed to connect to standby 'JSLSTBY'. Error is 12505.
*** 2008-08-19 09:22:49.734
kcrrfail: dest:2 err:12505 force:0
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
*** 2008-08-19 09:27:57.250
Standby database restarted; old mount ID 0x76230266 now 0x762c95cd
Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode
Destination LOG_ARCHIVE_DEST_2 is in CLUSTER CONSISTENT mode
Destination LOG_ARCHIVE_DEST_2 is in MAXIMUM PERFORMANCE mode


======