Thursday, October 25, 2012

1 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 …



  1. Chez Rolex, fausses montres de luxe nous croyons au travail avec des personnes, fausses rolex datejust montres des organisations, des événements et des individus distingués dans divers domaines tels que l'aventure, le sport, l'art et la culture, la science et l'éducation, entre autres. et les organisations maintiennent un engagement à long terme.



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