Thursday, October 25, 2012

3 ORA-00600 Internal error code …

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

image

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…

image

Let me recreate the spifle

create spfile from memory

… everything looks good now …

image

3 comments:

  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.

    ReplyDelete
  2. We've obtained the first pictures showing buy cheap soccer jerseys the authentic 'Match' version of the cheap player jerseys new Nike Euro 2020 template - the England home shirt to be exact. Thanks to NF for the pictures.

    ReplyDelete
  3. Alexander McQueen serves up a collection Cheap ALEXANDER MCQUEEN Shoes for men and women of elevated everyday styles, cheap ALEXANDER MCQUEEN shirt womenstailoring rich in tradition and singular pieces with a gothic-chic sensibility. Dramatic accessories – think leather and chains and skull-motif embellishments – top off the line that's a hit with all the critics.

    ReplyDelete

 

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