ORA-00600: internal error code, arguments: [kspsetpao1], [462], [415], [*]

kuqlan發表於2012-05-23

C:>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on 星期二 5月 22 10:18:15 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

已連線到空閒例程。

SQL> create spfile from pfile;
create spfile from pfile
*
第 1 行出現錯誤:
ORA-00600: internal error code, arguments: [kspsetpao1], [462], [415], [*],
[user_dump_dest], [27], [], []

[@more@]

SQL> create spfile from pfile;
create spfile from pfile
*
第 1 行出現錯誤:
ORA-00600: internal error code, arguments: [kspsetpao1], [462], [415], [*],
[user_dump_dest], [27], [], []

檢視原因發現引數檔案的core_dump_dest='D:oracleadmindupdbcdump' 少了一個單引號

*.db_name='dupdb'
*.control_files='D:oracleoradatadupdbcontrol01.ctl','D:oracleoradatadupdbcontrol02.ctl','D:oracleoradatadupdbcontrol03.ctl'
*.user_dump_dest='D:oracleadmindupdbudump'
*.audit_file_dest='D:oracleadmindupdbadump'
*.background_dump_dest='D:oracleadmindupdbbdump'
*.core_dump_dest='D:oracleadmindupdbcdump'
*.pga_aggregate_target=149946368
*.sga_target=450887680
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'

修改完,就好了,如下:

SQL> create spfile from pfile;

檔案已建立。

SQL>

SQL> startup nomount;
ORACLE 例程已經啟動。

Total System Global Area 452984832 bytes
Fixed Size 1291120 bytes
Variable Size 134220944 bytes
Database Buffers 310378496 bytes
Redo Buffers 7094272 bytes
SQL>

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/18841027/viewspace-1058323/,如需轉載,請註明出處,否則將追究法律責任。

相關文章