ORA-07445 ORA-00108 報錯處理

        公司一套測試資料庫，最近一天oracle trace檔案不斷增多，導致檔案系統撐爆，從而影響到測試

 

  跟進處理:

  檢查資料庫日誌：

 

  報錯資訊如下:

 

 

Wed Apr 20 10:13:38 2011
Errors in file /oracle/app/oracle/admin/spm/bdump/spm_ora_23321.trc:
ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSEGV] [Address not mapped to object] [0x000000208] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Wed Apr 20 10:13:41 2011
found dead dispatcher 'D000', pid = (13, 203)
Wed Apr 20 10:13:41 2011
dispatcher 'D000' encountered error getting listening address
Wed Apr 20 10:13:41 2011
Errors in file /oracle/app/oracle/admin/spm/bdump/spm_ora_23326.trc:
ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSEGV] [Address not mapped to object] [0x000000208] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Wed Apr 20 10:13:44 2011
found dead dispatcher 'D000', pid = (13, 204)
Wed Apr 20 10:13:44 2011
dispatcher 'D000' encountered error getting listening address
Wed Apr 20 10:13:44 2011
Errors in file /oracle/app/oracle/admin/spm/bdump/spm_ora_23331.trc:
ORA-07445: exception encountered: core dump [kslgetl()+120] [SIGSEGV] [Address not mapped to object] [0x000000208] [] []
ORA-00108: failed to set up dispatcher to accept connection asynchronously
Wed Apr 20 10:13:47 2011

 

解決方法:

 

/etc/hosts表 ip地址與主機名不一致，重新修改成一致。

 

重新啟動資料庫即可