Fri May 9 08:17:56 2008
Errors in file /usr/oracle/OraHome1/admin/db/bdump/orcl_s000_594.trc:
ORA-00942: table or view does not exist
Fri May 9 13:47:27 2008
Thread 1 advanced to log sequence 4523
Current log# 1 seq# 4523 mem# 0: /usr/oracle/OraHome1/oradata/db/redo01.log
Fri May 9 13:59:06 2008
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
SMON offlining US=20
SMON offlining US=21
Fri May 9 14:19:11 2008
Undo Segment 11 Onlined
Fri May 9 14:19:11 2008
Undo Segment 12 Onlined
Undo Segment 13 Onlined
Fri May 9 14:19:18 2008
Undo Segment 14 Onlined
Fri May 9 14:19:18 2008
Undo Segment 15 Onlined
Fri May 9 14:19:18 2008
Undo Segment 16 Onlined
Fri May 9 14:19:18 2008
Undo Segment 17 Onlined
Fri May 9 14:19:19 2008
Undo Segment 18 Onlined
Fri May 9 14:19:19 2008
Undo Segment 19 Onlined
Fri May 9 14:20:11 2008
Undo Segment 20 Onlined
Fri May 9 14:20:11 2008
Undo Segment 21 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU22$
Undo Segment 22 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU23$
Undo Segment 23 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU24$
Undo Segment 24 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU25$
Undo Segment 25 Onlined
Fri May 9 14:23:12 2008
Thread 1 advanced to log sequence 4524
Current log# 2 seq# 4524 mem# 0: /usr/oracle/OraHome1/oradata/db/redo02.log
Fri May 9 14:32:37 2008
Thread 1 advanced to log sequence 4525
Current log# 3 seq# 4525 mem# 0: /usr/oracle/OraHome1/oradata/db/redo03.log
Fri May 9 14:37:59 2008
Thread 1 cannot allocate new log, sequence 4526
Checkpoint not complete
Current log# 3 seq# 4525 mem# 0: /usr/oracle/OraHome1/oradata/db/redo03.log
Fri May 9 14:41:21 2008
Thread 1 advanced to log sequence 4526
Current log# 1 seq# 4526 mem# 0: /usr/oracle/OraHome1/oradata/db/redo01.log
Fri May 9 14:47:07 2008
Thread 1 advanced to log sequence 4527
Current log# 2 seq# 4527 mem# 0: /usr/oracle/OraHome1/oradata/db/redo02.log
Fri May 9 15:07:40 2008
Thread 1 cannot allocate new log, sequence 4528
Checkpoint not complete
Current log# 2 seq# 4527 mem# 0: /usr/oracle/OraHome1/oradata/db/redo02.log
Fri May 9 15:16:23 2008
Thread 1 advanced to log sequence 4528
Current log# 3 seq# 4528 mem# 0: /usr/oracle/OraHome1/oradata/db/redo03.log此为日志
我的问题是:1 alert中有表或视图不存在的问题,通过oracle能否查出具体的是那一张表或者视图。 2 Checkpoint not complete 为何总是存在而且十分平凡
Errors in file /usr/oracle/OraHome1/admin/db/bdump/orcl_s000_594.trc:
ORA-00942: table or view does not exist
Fri May 9 13:47:27 2008
Thread 1 advanced to log sequence 4523
Current log# 1 seq# 4523 mem# 0: /usr/oracle/OraHome1/oradata/db/redo01.log
Fri May 9 13:59:06 2008
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
SMON offlining US=20
SMON offlining US=21
Fri May 9 14:19:11 2008
Undo Segment 11 Onlined
Fri May 9 14:19:11 2008
Undo Segment 12 Onlined
Undo Segment 13 Onlined
Fri May 9 14:19:18 2008
Undo Segment 14 Onlined
Fri May 9 14:19:18 2008
Undo Segment 15 Onlined
Fri May 9 14:19:18 2008
Undo Segment 16 Onlined
Fri May 9 14:19:18 2008
Undo Segment 17 Onlined
Fri May 9 14:19:19 2008
Undo Segment 18 Onlined
Fri May 9 14:19:19 2008
Undo Segment 19 Onlined
Fri May 9 14:20:11 2008
Undo Segment 20 Onlined
Fri May 9 14:20:11 2008
Undo Segment 21 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU22$
Undo Segment 22 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU23$
Undo Segment 23 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU24$
Undo Segment 24 Onlined
Fri May 9 14:20:11 2008
Created Undo Segment _SYSSMU25$
Undo Segment 25 Onlined
Fri May 9 14:23:12 2008
Thread 1 advanced to log sequence 4524
Current log# 2 seq# 4524 mem# 0: /usr/oracle/OraHome1/oradata/db/redo02.log
Fri May 9 14:32:37 2008
Thread 1 advanced to log sequence 4525
Current log# 3 seq# 4525 mem# 0: /usr/oracle/OraHome1/oradata/db/redo03.log
Fri May 9 14:37:59 2008
Thread 1 cannot allocate new log, sequence 4526
Checkpoint not complete
Current log# 3 seq# 4525 mem# 0: /usr/oracle/OraHome1/oradata/db/redo03.log
Fri May 9 14:41:21 2008
Thread 1 advanced to log sequence 4526
Current log# 1 seq# 4526 mem# 0: /usr/oracle/OraHome1/oradata/db/redo01.log
Fri May 9 14:47:07 2008
Thread 1 advanced to log sequence 4527
Current log# 2 seq# 4527 mem# 0: /usr/oracle/OraHome1/oradata/db/redo02.log
Fri May 9 15:07:40 2008
Thread 1 cannot allocate new log, sequence 4528
Checkpoint not complete
Current log# 2 seq# 4527 mem# 0: /usr/oracle/OraHome1/oradata/db/redo02.log
Fri May 9 15:16:23 2008
Thread 1 advanced to log sequence 4528
Current log# 3 seq# 4528 mem# 0: /usr/oracle/OraHome1/oradata/db/redo03.log此为日志
我的问题是:1 alert中有表或视图不存在的问题,通过oracle能否查出具体的是那一张表或者视图。 2 Checkpoint not complete 为何总是存在而且十分平凡
解决方案 »
- 求助,关于create table as select的问题
- 关于PL-SQL工具请教两个问题
- plsql执行自定义函数问题
- oracle分类汇总相关求助!
- windows2008 能否装oracle10g
- ******叶水福物流集团Y3软件公司招聘IT D2K 开发人员 (熟悉 Oracle Developer 2000)******
- 请教一个触发器
- update问题?
- 请教oracle9i里回滚段怎么用
- EM RemoteOperationException: ERROR: Invalid username and/or password
- RMAN备份遇到的新问题,特别的急
- 如何在sql输出结果前加标题?
tail -100 orcl_s000_594.trc
*** SESSION ID:(29.10785) 2008-05-01 22:01:12.624
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-02 16:06:39.670
*** SESSION ID:(53.21217) 2008-05-02 16:06:39.670
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 07:48:55.343
*** SESSION ID:(58.4316) 2008-05-03 07:48:55.343
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 10:34:52.709
*** SESSION ID:(96.52456) 2008-05-03 10:34:52.709
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 10:42:53.490
*** SESSION ID:(96.52713) 2008-05-03 10:42:53.490
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 10:47:04.123
*** SESSION ID:(96.52894) 2008-05-03 10:47:04.123
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 11:11:38.338
*** SESSION ID:(136.17942) 2008-05-03 11:11:38.338
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 15:44:09.034
*** SESSION ID:(46.3292) 2008-05-03 15:44:09.034
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-03 20:08:28.730
*** SESSION ID:(46.10001) 2008-05-03 20:08:28.730
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-04 08:17:38.568
*** SESSION ID:(73.26730) 2008-05-04 08:17:38.568
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-04 15:45:38.458
*** SESSION ID:(129.17149) 2008-05-04 15:45:38.458
Invalid Login Using Trusted Authentication
*** 2008-05-04 16:06:33.130
*** SESSION ID:(129.17916) 2008-05-04 16:06:33.130
Invalid Login Using Trusted Authentication
*** 2008-05-05 09:50:01.969
*** SESSION ID:(157.52636) 2008-05-05 09:50:01.969
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-05 16:15:13.447
*** SESSION ID:(54.9833) 2008-05-05 16:15:13.447
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-05 16:34:57.207
*** SESSION ID:(46.61102) 2008-05-05 16:34:57.207
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-05 21:34:42.553
*** SESSION ID:(74.7386) 2008-05-05 21:34:42.553
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-06 15:41:08.926
*** SESSION ID:(125.2865) 2008-05-06 15:41:08.926
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-06 16:09:53.176
*** SESSION ID:(125.4368) 2008-05-06 16:09:53.176
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-07 07:47:31.527
*** SESSION ID:(35.5641) 2008-05-07 07:47:31.527
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-07 19:12:16.868
*** SESSION ID:(74.55565) 2008-05-07 19:12:16.868
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** SESSION ID:(74.55567) 2008-05-07 19:12:16.872
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-07 21:27:42.109
*** SESSION ID:(26.1571) 2008-05-07 21:27:42.109
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-08 10:13:25.439
*** SESSION ID:(126.55052) 2008-05-08 10:13:25.439
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-08 13:46:06.212
*** SESSION ID:(45.19970) 2008-05-08 13:46:06.212
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-05-09 08:17:42.312
*** SESSION ID:(158.33912) 2008-05-09 08:17:42.311
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist