Dump file d:\oracle\admin\echodms\bdump\alert_echodms.log Fri Jan 29 18:14:26 2010 ORACLE V9.2.0.1.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.2 , CPU type 586 Fri Jan 29 18:14:26 2010 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.1.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 50331648 large_pool_size = 8388608 java_pool_size = 33554432 control_files = D:\oracle\oradata\echodms\CONTROL01.CTL, D:\oracle\oradata\echodms\CONTROL02.CTL, D:\oracle\oradata\echodms\CONTROL03.CTL db_block_size = 8192 db_cache_size = 25165824 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = echodms dispatchers = (PROTOCOL=TCP) (SERVICE=echodmsXDB) job_queue_processes = 10 hash_join_enabled = TRUE background_dump_dest = D:\oracle\admin\echodms\bdump user_dump_dest = D:\oracle\admin\echodms\udump core_dump_dest = D:\oracle\admin\echodms\cdump sort_area_size = 524288 db_name = echodms open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 25165824 aq_tm_processes = 1 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 CJQ0 started with pid=8 QMN0 started with pid=9 Fri Jan 29 18:14:30 2010 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Fri Jan 29 18:14:31 2010 alter database mount exclusive Fri Jan 29 18:14:35 2010 Successful mount of redo thread 1, with mount id 972283463. Fri Jan 29 18:14:35 2010 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Fri Jan 29 18:14:35 2010 alter database open Fri Jan 29 18:14:35 2010 Beginning crash recovery of 1 threads Fri Jan 29 18:14:36 2010 Started first pass scan Fri Jan 29 18:14:36 2010 Completed first pass scan 2445 redo blocks read, 77 data blocks need recovery Fri Jan 29 18:14:36 2010 Started recovery at Thread 1: logseq 115, block 3, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 3 Seq 115 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\ECHODMS\REDO03.LOG Fri Jan 29 18:14:36 2010 Ended recovery at Thread 1: logseq 115, block 2448, scn 0.404286 77 data blocks read, 77 data blocks written, 2445 redo blocks read Crash recovery completed successfully Fri Jan 29 18:14:37 2010 Thread 1 advanced to log sequence 116 Thread 1 opened at log sequence 116 Current log# 1 seq# 116 mem# 0: D:\ORACLE\ORADATA\ECHODMS\REDO01.LOG Successful open of redo thread 1. Fri Jan 29 18:14:37 2010 SMON: enabling cache recovery Fri Jan 29 18:14:37 2010 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Fri Jan 29 18:14:37 2010 SMON: enabling tx recovery Fri Jan 29 18:14:37 2010 Database Characterset is ZHS16GBK replication_dependency_tracking turned off (no async multimaster replication found) Completed: alter database open Fri Jan 29 18:37:18 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 18:38:11 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 18:41:12 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 18:51:57 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 18:56:38 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:00:37 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:02:23 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:02:50 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:02:57 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:05:21 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:06:50 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:06:55 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:08:12 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:08:43 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:10:24 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:14:09 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existFri Jan 29 19:23:41 2010 Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc: ORA-00942: table or view does not existDump file d:\oracle\admin\echodms\bdump\alert_echodms.log Sat Jan 30 09:13:24 2010 ORACLE V9.2.0.1.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.2 , CPU type 586
Fri Jan 29 19:23:41 2010 停的 Sat Jan 30 09:13:24 2010 重新启的
alter database open 之后过了一段时间才出现问题,echodms_s000_416.trc记录了哪些内容?
在initechodms.ora里加上event = “00942 trace name errorstack”然后从pfile里启动,看看有什么信息没有
我加上那句话了,不过下面这个应该是系统调的 ================================================== session*** 2010-02-02 11:09:47.000 ksedmp: internal or fatal error ORA-00942: 表或视图不存在 Current SQL statement for this session: select grantee, name from sys.plsqldev_authorization where grantee in (user, 'PUBLIC') or grantee in (select role from sys.session_roles) ===================================================
Fri Jan 29 18:14:26 2010
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Fri Jan 29 18:14:26 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\echodms\CONTROL01.CTL, D:\oracle\oradata\echodms\CONTROL02.CTL, D:\oracle\oradata\echodms\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = echodms
dispatchers = (PROTOCOL=TCP) (SERVICE=echodmsXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\echodms\bdump
user_dump_dest = D:\oracle\admin\echodms\udump
core_dump_dest = D:\oracle\admin\echodms\cdump
sort_area_size = 524288
db_name = echodms
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Jan 29 18:14:30 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jan 29 18:14:31 2010
alter database mount exclusive
Fri Jan 29 18:14:35 2010
Successful mount of redo thread 1, with mount id 972283463.
Fri Jan 29 18:14:35 2010
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Jan 29 18:14:35 2010
alter database open
Fri Jan 29 18:14:35 2010
Beginning crash recovery of 1 threads
Fri Jan 29 18:14:36 2010
Started first pass scan
Fri Jan 29 18:14:36 2010
Completed first pass scan
2445 redo blocks read, 77 data blocks need recovery
Fri Jan 29 18:14:36 2010
Started recovery at
Thread 1: logseq 115, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 115 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\ECHODMS\REDO03.LOG
Fri Jan 29 18:14:36 2010
Ended recovery at
Thread 1: logseq 115, block 2448, scn 0.404286
77 data blocks read, 77 data blocks written, 2445 redo blocks read
Crash recovery completed successfully
Fri Jan 29 18:14:37 2010
Thread 1 advanced to log sequence 116
Thread 1 opened at log sequence 116
Current log# 1 seq# 116 mem# 0: D:\ORACLE\ORADATA\ECHODMS\REDO01.LOG
Successful open of redo thread 1.
Fri Jan 29 18:14:37 2010
SMON: enabling cache recovery
Fri Jan 29 18:14:37 2010
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Fri Jan 29 18:14:37 2010
SMON: enabling tx recovery
Fri Jan 29 18:14:37 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Fri Jan 29 18:37:18 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 18:38:11 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 18:41:12 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 18:51:57 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 18:56:38 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:00:37 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:02:23 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:02:50 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:02:57 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:05:21 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:06:50 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:06:55 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:08:12 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:08:43 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:10:24 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:14:09 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existFri Jan 29 19:23:41 2010
Errors in file d:\oracle\admin\echodms\udump\echodms_s000_416.trc:
ORA-00942: table or view does not existDump file d:\oracle\admin\echodms\bdump\alert_echodms.log
Sat Jan 30 09:13:24 2010
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Sat Jan 30 09:13:24 2010 重新启的
==================================================
session*** 2010-02-02 11:09:47.000
ksedmp: internal or fatal error
ORA-00942: 表或视图不存在
Current SQL statement for this session:
select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
===================================================
*** 2010-02-02 11:48:03.000
*** SESSION ID:(22.90) 2010-02-02 11:48:03.000
Invalid Login Using Trusted Authentication
*** 2010-02-02 11:49:03.000
*** SESSION ID:(20.45) 2010-02-02 11:49:03.000
Invalid Login Using Trusted Authentication
*** 2010-02-02 11:52:31.000
*** SESSION ID:(42.217) 2010-02-02 11:52:31.000
Invalid Login Using Trusted Authentication
*** 2010-02-02 11:53:11.000
*** SESSION ID:(47.55) 2010-02-02 11:53:11.000
Invalid Login Using Trusted Authentication
*** 2010-02-02 11:53:56.000
*** SESSION ID:(37.42) 2010-02-02 11:53:56.000
Invalid Login Using Trusted Authentication
*** SESSION ID:(38.134) 2010-02-02 11:54:02.000
Invalid Login Using Trusted Authentication
*** 2010-02-02 11:55:33.000
*** SESSION ID:(38.222) 2010-02-02 11:55:33.000
Invalid Login Using Trusted Authentication
*** 2010-02-02 11:57:37.000
*** SESSION ID:(38.396) 2010-02-02 11:57:37.000
Invalid Login Using Trusted Authentication
*** SESSION ID:(38.398) 2010-02-02 11:57:42.000
Invalid Login Using Trusted Authentication
=====================================================
该表存在吗?
2、最好在表或视图上加上模式名称
3、查询下表是否被别的用户误操作删除掉了