Thursday, October 25, 2012

0 ORA-00600 Internal error code …

After I shutdown my oracle instance and restart, I got the ORA-00600…


This is the Oracle internal error, the error message only can interoperate by Oracle support. The another error ORA-02097 looks specious. It seems to me some parameter in the spfile is not correct cause the database fail to mount.

In order to figure out what is wrong in my spfile, I have to recreate it to pfile.

  • Startup nomount
  • create pfile from memory;
  • startup pfile=’path of the pfile’

Ah… the database mount fine…


Let me recreate the spifle

create spfile from memory

… everything looks good now …



Post a Comment


SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates