Hello All,
Today i have got one malicious error on our alert log file.Error are give below.
Thread 1 advanced to log sequence 14103 (LGWR switch)
Current log# 3 seq# 14103 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 06:28:32 2011
Thread 1 advanced to log sequence 14104 (LGWR switch)
Current log# 1 seq# 14104 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 06:28:54 2011
Thread 1 advanced to log sequence 14105 (LGWR switch)
Current log# 2 seq# 14105 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 06:29:15 2011
Thread 1 advanced to log sequence 14106 (LGWR switch)
Current log# 3 seq# 14106 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 06:29:36 2011
Thread 1 advanced to log sequence 14107 (LGWR switch)
Current log# 1 seq# 14107 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 06:29:58 2011
Thread 1 advanced to log sequence 14108 (LGWR switch)
Current log# 2 seq# 14108 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 06:30:20 2011
Thread 1 advanced to log sequence 14109 (LGWR switch)
Current log# 3 seq# 14109 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 06:30:41 2011
Thread 1 advanced to log sequence 14110 (LGWR switch)
Current log# 1 seq# 14110 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 06:48:40 2011
Thread 1 advanced to log sequence 14111 (LGWR switch)
Current log# 2 seq# 14111 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 07:33:21 2011
Thread 1 advanced to log sequence 14112 (LGWR switch)
Current log# 3 seq# 14112 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 08:19:51 2011
Thread 1 advanced to log sequence 14113 (LGWR switch)
Current log# 1 seq# 14113 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 09:04:32 2011
Thread 1 advanced to log sequence 14114 (LGWR switch)
Current log# 2 seq# 14114 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 09:49:44 2011
Thread 1 advanced to log sequence 14115 (LGWR switch)
Current log# 3 seq# 14115 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 10:34:46 2011
Thread 1 advanced to log sequence 14116 (LGWR switch)
Current log# 1 seq# 14116 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 11:23:00 2011
Thread 1 advanced to log sequence 14117 (LGWR switch)
Current log# 2 seq# 14117 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 12:07:34 2011
Thread 1 advanced to log sequence 14118 (LGWR switch)
Current log# 3 seq# 14118 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 12:52:12 2011
Thread 1 advanced to log sequence 14119 (LGWR switch)
Current log# 1 seq# 14119 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 13:35:48 2011
Thread 1 advanced to log sequence 14120 (LGWR switch)
Current log# 2 seq# 14120 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 14:23:16 2011
Thread 1 advanced to log sequence 14121 (LGWR switch)
Current log# 3 seq# 14121 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 15:07:02 2011
Thread 1 advanced to log sequence 14122 (LGWR switch)
Current log# 1 seq# 14122 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 15:50:45 2011
Thread 1 advanced to log sequence 14123 (LGWR switch)
Current log# 2 seq# 14123 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 16:34:52 2011
Thread 1 advanced to log sequence 14124 (LGWR switch)
Current log# 3 seq# 14124 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 17:22:49 2011
Thread 1 advanced to log sequence 14125 (LGWR switch)
Current log# 1 seq# 14125 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 17:58:13 2011
Thread 1 advanced to log sequence 14126 (LGWR switch)
Current log# 2 seq# 14126 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 17:58:32 2011
Thread 1 advanced to log sequence 14127 (LGWR switch)
Current log# 3 seq# 14127 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 17:58:50 2011
Thread 1 cannot allocate new log, sequence 14128
Checkpoint not complete
Current log# 3 seq# 14127 mem# 0: /u01/oradata/openview/redo03.log
Thread 1 advanced to log sequence 14128 (LGWR switch)
Current log# 1 seq# 14128 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 17:59:02 2011
Thread 1 advanced to log sequence 14129 (LGWR switch)
Current log# 2 seq# 14129 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 17:59:41 2011
Thread 1 advanced to log sequence 14130 (LGWR switch)
Current log# 3 seq# 14130 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 18:14:35 2011
Thread 1 advanced to log sequence 14131 (LGWR switch)
Current log# 1 seq# 14131 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 18:59:04 2011
Thread 1 advanced to log sequence 14132 (LGWR switch)
Current log# 2 seq# 14132 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 19:42:22 2011
Thread 1 advanced to log sequence 14133 (LGWR switch)
Current log# 3 seq# 14133 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 20:29:35 2011
Thread 1 advanced to log sequence 14134 (LGWR switch)
Current log# 1 seq# 14134 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 21:14:27 2011
Thread 1 advanced to log sequence 14135 (LGWR switch)
Current log# 2 seq# 14135 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 21:34:35 2011
Starting background process CJQ0
Wed Apr 20 21:34:36 2011
CJQ0 started with pid=40, OS id=18415
Wed Apr 20 21:58:05 2011
Thread 1 advanced to log sequence 14136 (LGWR switch)
Current log# 3 seq# 14136 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 22:00:00 2011
Setting Resource Manager plan SCHEDULER[0x2C4B]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Wed Apr 20 22:00:02 2011
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Wed Apr 20 22:00:41 2011
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Wed Apr 20 22:02:05 2011
Thread 1 advanced to log sequence 14137 (LGWR switch)
Current log# 1 seq# 14137 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 22:02:53 2011
Thread 1 advanced to log sequence 14138 (LGWR switch)
Current log# 2 seq# 14138 mem# 0: /u01/oradata/openview/redo02.log
Wed Apr 20 22:28:41 2011
Thread 1 advanced to log sequence 14139 (LGWR switch)
Current log# 3 seq# 14139 mem# 0: /u01/oradata/openview/redo03.log
Wed Apr 20 23:12:03 2011
Thread 1 advanced to log sequence 14140 (LGWR switch)
Current log# 1 seq# 14140 mem# 0: /u01/oradata/openview/redo01.log
Wed Apr 20 23:54:49 2011
Thread 1 advanced to log sequence 14141 (LGWR switch)
Current log# 2 seq# 14141 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 00:12:25 2011
Thread 1 advanced to log sequence 14142 (LGWR switch)
Current log# 3 seq# 14142 mem# 0: /u01/oradata/openview/redo03.log
Thread 1 advanced to log sequence 14143 (LGWR switch)
Current log# 1 seq# 14143 mem# 0: /u01/oradata/openview/redo01.log
Thread 1 advanced to log sequence 14144 (LGWR switch)
Current log# 2 seq# 14144 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 00:12:46 2011
Thread 1 advanced to log sequence 14145 (LGWR switch)
Current log# 3 seq# 14145 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 00:50:07 2011
Thread 1 advanced to log sequence 14146 (LGWR switch)
Current log# 1 seq# 14146 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 01:33:40 2011
Thread 1 advanced to log sequence 14147 (LGWR switch)
Current log# 2 seq# 14147 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 02:00:00 2011
Clearing Resource Manager plan via parameter
Thu Apr 21 02:00:57 2011
Thread 1 advanced to log sequence 14148 (LGWR switch)
Current log# 3 seq# 14148 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 02:44:32 2011
Thread 1 advanced to log sequence 14149 (LGWR switch)
Current log# 1 seq# 14149 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 03:11:06 2011
Stopping background process CJQ0
Thu Apr 21 03:30:19 2011
Thread 1 advanced to log sequence 14150 (LGWR switch)
Current log# 2 seq# 14150 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 04:13:55 2011
Thread 1 advanced to log sequence 14151 (LGWR switch)
Current log# 3 seq# 14151 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 04:58:19 2011
Thread 1 advanced to log sequence 14152 (LGWR switch)
Current log# 1 seq# 14152 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 05:42:41 2011
Thread 1 advanced to log sequence 14153 (LGWR switch)
Current log# 2 seq# 14153 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 06:28:07 2011
Thread 1 advanced to log sequence 14154 (LGWR switch)
Current log# 3 seq# 14154 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 06:28:35 2011
Thread 1 advanced to log sequence 14155 (LGWR switch)
Current log# 1 seq# 14155 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 06:28:56 2011
Thread 1 advanced to log sequence 14156 (LGWR switch)
Current log# 2 seq# 14156 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 06:29:17 2011
Thread 1 advanced to log sequence 14157 (LGWR switch)
Current log# 3 seq# 14157 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 06:29:37 2011
Thread 1 advanced to log sequence 14158 (LGWR switch)
Current log# 1 seq# 14158 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 06:30:08 2011
Thread 1 advanced to log sequence 14159 (LGWR switch)
Current log# 2 seq# 14159 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 06:30:49 2011
Thread 1 advanced to log sequence 14160 (LGWR switch)
Current log# 3 seq# 14160 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 06:31:11 2011
Thread 1 advanced to log sequence 14161 (LGWR switch)
Current log# 1 seq# 14161 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 06:32:38 2011
Thread 1 advanced to log sequence 14162 (LGWR switch)
Current log# 2 seq# 14162 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 07:18:57 2011
Thread 1 advanced to log sequence 14163 (LGWR switch)
Current log# 3 seq# 14163 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 08:01:57 2011
Thread 1 advanced to log sequence 14164 (LGWR switch)
Current log# 1 seq# 14164 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 08:45:31 2011
Thread 1 advanced to log sequence 14165 (LGWR switch)
Current log# 2 seq# 14165 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 09:30:40 2011
Thread 1 advanced to log sequence 14166 (LGWR switch)
Current log# 3 seq# 14166 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 10:15:58 2011
Thread 1 advanced to log sequence 14167 (LGWR switch)
Current log# 1 seq# 14167 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 10:59:31 2011
Thread 1 advanced to log sequence 14168 (LGWR switch)
Current log# 2 seq# 14168 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 11:30:11 2011
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for HPUX: Version 11.1.0.7.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for HPUX: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for HPUX: Version 11.1.0.7.0 - Production
Time: 21-APR-2011 11:30:11
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
ORA-609 : opiodr aborting process unknown ospid (5410_1)
Thu Apr 21 11:37:47 2011
Thread 1 advanced to log sequence 14169 (LGWR switch)
Current log# 3 seq# 14169 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 12:24:10 2011
Thread 1 advanced to log sequence 14170 (LGWR switch)
Current log# 1 seq# 14170 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 13:07:17 2011
Thread 1 advanced to log sequence 14171 (LGWR switch)
Current log# 2 seq# 14171 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 13:50:10 2011
Thread 1 advanced to log sequence 14172 (LGWR switch)
Current log# 3 seq# 14172 mem# 0: /u01/oradata/openview/redo03.log
Thu Apr 21 14:34:03 2011
Thread 1 advanced to log sequence 14173 (LGWR switch)
Current log# 1 seq# 14173 mem# 0: /u01/oradata/openview/redo01.log
Thu Apr 21 15:19:48 2011
Thread 1 advanced to log sequence 14174 (LGWR switch)
Current log# 2 seq# 14174 mem# 0: /u01/oradata/openview/redo02.log
Thu Apr 21 16:03:08 2011
Thread 1 advanced to log sequence 14175 (LGWR switch)
Current log# 3 seq# 14175 mem# 0: /u01/oradata/openview/redo03.log
bash-4.0$
Can anyone tell me what is the prob in our DB?More or less i can't find nothing by googling.
Thanks in adv.