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], [], []
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博客 ” ,链接:https://blog.itpub.net/18841027/viewspace-1058323/ ,如需转载,请注明出处,否则将追究法律责任。