求救：windows2003sp2下oracle9i服務(wù)自動(dòng)關(guān)閉

xpingtn

本人是個(gè)oracle的初學(xué)者，不知道怎么的，公司的oracle9i自動(dòng)關(guān)閉，查看alert_ora9i.log沒有關(guān)閉oracle的日志，但有個(gè)錯(cuò)誤如下
Thu Sep 18 20:31:36 2008
Errors in file d:\oracle\admin\ora9i\udump\ora9i_s000_1384.trc:
ORA-00942: table or view does not exist

Fri Sep 19 03:10:59 2008
Errors in file d:\oracle\admin\ora9i\udump\ora9i_s000_1384.trc:
ORA-00942: table or view does not exist

Fri Sep 19 06:16:11 2008
Errors in file d:\oracle\admin\ora9i\udump\ora9i_s000_1384.trc:
ORA-00942: table or view does not exist

Fri Sep 19 06:16:29 2008
Errors in file d:\oracle\admin\ora9i\udump\ora9i_s000_1384.trc:
ORA-00942: table or view does not exist

Fri Sep 19 06:54:38 2008
Errors in file d:\oracle\admin\ora9i\udump\ora9i_s000_1384.trc:
ORA-00942: table or view does not exist

查看ora9i_s000_1384.trc錯(cuò)誤如下：
*** 2008-09-18 15:21:17.000
*** SESSION ID13.34113) 2008-09-18 15:21:17.000
Invalid Login Using Trusted Authentication
*** 2008-09-18 20:31:36.000
*** SESSION ID13.37592) 2008-09-18 20:31:36.000
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-09-19 03:10:59.000
*** SESSION ID16.19524) 2008-09-19 03:10:59.000
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-09-19 06:16:11.000
*** SESSION ID13.41834) 2008-09-19 06:16:11.000
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-09-19 06:16:29.000
*** SESSION ID13.41839) 2008-09-19 06:16:29.000
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-09-19 06:54:38.000
*** SESSION ID13.41944) 2008-09-19 06:54:38.000
qmhGetHTTPError: Got unknown oracle error. Error stack is:
ORA-00942: table or view does not exist
*** 2008-09-19 12:30:44.000
*** SESSION ID15.26269) 2008-09-19 12:30:44.000
OPIRIP: Uncaught error 942. Error stack:
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-01004: default username feature not supported; logon denied

但重啟一下這個(gè)oracle這個(gè)服務(wù)器就行了，現(xiàn)在是一個(gè)星期發(fā)生一次左右。
不知道這個(gè)錯(cuò)誤是否會(huì)引起oracle自動(dòng)關(guān)閉，如果要跟蹤這個(gè)錯(cuò)誤，怎么跟蹤？跟蹤完成后如果查看所得的結(jié)果的日志，謝謝

dingning239

可能是一個(gè)bug，是否開了http服務(wù)

xpingtn

沒有開，跑了個(gè)tomcat.

liu1dx

樓主,這個(gè)問題有沒有解決啊,我也碰到這個(gè)問題了.好急啊!高手們教一下我啊,謝謝了啊

ly215197

貌似被攻擊了,關(guān)掉務(wù)器上面SMMP服務(wù)看看!實(shí)在不行建個(gè)查詢看看誰在訪問DB!
create or replace trigger log_errors AFTER SERVERERROR ON DATABASE
BEGIN
IF (IS_SERVERERROR (1017))
THEN insert into gdba_yanggua.logon_errors (Logon_Date_Time, Usr, OS_Usr, Machine, Process, Program, Err_Msg)
SELECT logon_time,sys_context('USERENV','IP_ADDRESS') ,osuser,username,program,process , 'ORA-1017 INVALID PASSWORD'
FROM v$session WHERE audsid = USERENV( 'sessionid' );
end if;
end;
/