又见 2662

Oracle  11.2.0.2.0  ,     Linux  AS  5.4   64bit  ,   一同事在线对temp文件空间进行调整， offline 倒是可以， drop的时候报错 ， 同事又将 temp02.dbf  文件online  .    online 成功，  但是就可以是报错了 。 详见下面的报错信息： 

 

Archived Log entry 30086 added for thread 2 sequence 6548 ID 0x4fa453a7 dest 1:
Tue Aug 23 13:56:11 2011
alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' offline
Completed: alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' offline
Tue Aug 23 13:57:25 2011
alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' drop
ORA-25152 signalled during: alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' drop...
Tue Aug 23 13:58:01 2011
alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' online
Completed: alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' online
Tue Aug 23 13:58:41 2011
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_10748.trc  (incident=72665):
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442551004], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_72665/wsjdell2_ora_10748_i72665.trc
Tue Aug 23 13:58:41 2011
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_10278.trc  (incident=72889):
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442551144], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_72889/wsjdell2_ora_10278_i72889.trc
Tue Aug 23 13:58:43 2011
Dumping diagnostic data in directory=[cdmp_20110823135843], requested by (instance=2, sid=10748), summary=[incident=72665].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Aug 23 13:58:43 2011
Sweep [inc][72665]: completed
Sweep [inc2][72665]: completed
Tue Aug 23 13:58:43 2011
Sweep [inc][72889]: completed
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_10748.trc  (incident=72666):
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442551494], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_72666/wsjdell2_ora_10748_i72666.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_10748.trc  (incident=72667):
ORA-00603: ORACLE 浼烘湇鍣ㄩ殠娈典綔妤?洜鍤撮噸閷??鑰岀祩姝?
                                                                ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442551494], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_72667/wsjdell2_ora_10748_i72667.trc
Dumping diagnostic data in directory=[cdmp_20110823135845], requested by (instance=2, sid=10748), summary=[incident=72666].
opiodr aborting process unknown ospid (10748) as a result of ORA-603
Dumping diagnostic data in directory=[cdmp_20110823135847], requested by (instance=2, sid=10748), summary=[incident=72667].
Use ADRCI or Support Workbench to package the incident.
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_10278.trc  (incident=72890):
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442552342], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442551144], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_72890/wsjdell2_ora_10278_i72890.trc
Dumping diagnostic data in directory=[cdmp_20110823135849], requested by (instance=2, sid=10278), summary=[incident=72889].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/trace/wsjdell2_ora_10278.trc  (incident=72891):
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442552600], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442552342], [32772], [103887673], [876099122], [], [], [], [], [], []
ORA-00600: 鍏ч儴閷??浠ｇ⒓, 寮曟暩: [2662], [2], [1442551144], [32772], [103887673], [876099122], [], [], [], [], [], []
Incident details in: /u01/product/oracle/diag/rdbms/wsjdell/wsjdell2/incident/incdir_72891/wsjdell2_ora_10278_i72891.trc
Dumping diagnostic data in directory=[cdmp_20110823135850], requested by (instance=2, sid=10278), summary=[incident=72890].
Tue Aug 23 13:58:51 2011
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.                                              41726,3       86

 

分析下面的错误， 结合以前处理  2662 错误的经验 。

ORA-00600: internal error code, arguments: [2662], [2], [1443046983], [32772],
[103887673], [876099122], [], [], [], [], [], []

Arg [c] *4 = 32772 * 4 = 131088
Arg [d] = 103887673 < 1073741824
所以level = 131088 + 1 = 131089

应该执行 
alter session set events  'IMMEDIATE trace name ADJUST_SCN level 131089 '  ;  

看看行不行，  不行就再创建一个temp空间，删除现有的 。 

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-705632/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-705632/