客户的Oracle 10.1.0.4环境碰到这个错误。
详细错误信息为:
Wed DEC 14 21:10:27 2005 Errors IN file /oracle/admin/ocrl/bdump/ocrl_smon_160060.trc: ORA-00600: internal error code, arguments: [KSSRMP2], [0x1102F0128], [0], [0], [], [], [], [] ORA-01157: cannot identify/LOCK DATA file 201 - see DBWR trace file ORA-01110: DATA file 201: '/dev/temp_ts01' Wed DEC 14 21:10:28 2005 Non-fatal internal error happenned while SMON was doing WORK ON sort segment. SMON encountered 1 OUT OF maximum 100 non-fatal internal errors. Wed DEC 14 21:10:29 2005 Starting background process QMNC QMNC started WITH pid=24, OS id=66362 Wed DEC 14 21:10:32 2005 replication_dependency_tracking turned off (no async multimaster replication found) Wed DEC 14 21:10:34 2005 Starting background process MMON Starting background process MMNL MMON started WITH pid=25, OS id=119736 MMNL started WITH pid=26, OS id=139406 Wed DEC 14 21:10:34 2005 Completed: ALTER DATABASE OPEN |
显然问题发生在数据库的打开阶段,Oracle没有找到临时表空间对应的临时文件。
查询MOS,这是10.1.0.4上的bug:Bug 4075231 OERI[kssrmp2] / startup fails,这个问题在10.1.0.5中被解决。