ORA-00600: internal error code, arguments: [729], [4280], [space leak]
前幾天一朋友給我發了個ORA-00600,出錯的原因是將10.2.0升級到10.2.0.3的過程中,前面升級一直都是很順利的,但當執行了utlrp.sql後,第二次又執行了utlrp.sql(不知道他怎麼搞的?)後,情況出現了。當shutdown時,出現ORA-00600: internal error code, arguments: [729], [4280], [space leak], [], [],[], [], []
之後他退出SQLPLUS,等再次sqlplus / as sysdba後,出現如下資訊:
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> show parameter spfile;
ORA-01012: not logged on
這時候他無法做任何操作,於是讓他發alert過來。開啟alert看到檔案最後的資訊是:
ORA-00600: internal error code, arguments: [729], [4280], [space leak], [], [], [], [], []
Wed Apr 30 14:47:50 2008
Errors in file /oracle/admin/ora10g/udump/ora10g_ora_450792.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
在METALINK上查詢,這個錯很多時候發生在低版本的ORACLE中,而且發生的原因也大不相同,於是問朋友這是否是生產庫,回答說是個測試庫,我說那你就重啟下OS,因為我以前遇到過內類的莫名的7445就這樣解決的。果然在他重啟OS後,ORACLE一切正常。
這樣解決問題的方法似乎是windows對問題的終極解決方案啊,居然也發生在AIX上了。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17997/viewspace-261538/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載:ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- 處理Oracle記憶體洩露 ORA-00600 [729] [space leak]Oracle記憶體洩露
- ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]Error
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46]Error
- ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [ktecgeb-2], (一)Error
- ORA-00600: internal error code, arguments: [kcblasm_1], [103], []ErrorASM