把oracle数据文件从一台电脑(c:\app\Administrator\oradata)转移到另一台电脑后(D:\app\Administrator\oradata),并且数据文件路径也发生了改变,其启动就发生了以下错误:

ORA-00603和ORA-00600错误,处理方法是:

1、启动到mount状态(startup mount),创建pfile文件:create pfile='d:\initOrcl.ora' from spfile;修改initOrcl.ora文件:

*.undo_tablespace='UNDOTBS1'

undo_management='MANUAL'

rollback_segments='SYSTEM'

 2、关闭数据库,利用新建立的pfile文件重启到mount状态:startup mount pfile='d:\initOrcl.ora'

 3、启动数据库,删除undo表空间,并且重建undo表空间

alter database open;

drop tablespace undotbs1 including contents and datafiles;

create undo tablespace undotbs1 datafile 'd:\app\administrator\oradata\undotbs1.dbf' size 100m;

4、关闭并重启数据库即可正常

shutdown immediate

startup