Saturday, March 12, 2011

ORA-24324: service handle not initialized

So heres a Bug:

$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 10 09:19:17 2011

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected.

====================================================

Above is what i had even after i killed the pmon process.

Ideally it should have conected as an Idle Instance.

Anything you try to do further would have the following errors:

$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Mar 10 09:19:17 2011

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected.
SQL> shutdown abort;
ORA-03113: end-of-file on communication channel
SQL> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

=========================================================================

However Oracle suggests to raise a tar for this.

I tried a simpler way -

Kill -9 all ps -ef | grep ora procs.

OR A server bounce would help too.

NOW try to reconnect.....

$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Mar 11 09:30:54 2011

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to an idle instance.
Worked well enough...!

2 comments:

  1. Hi eveгyone, it's mу fіrѕt paу a ѵiѕit at thіs website, and post is аctually fruіtful in suppoгt of mе, keep up ρosting
    thesе tyρes of articles or гevieωs.

    Feel free to suгf to my site: http://xfire.com/blog/lisettemf/4713933

    ReplyDelete
  2. Helped me... Thanks a lot

    ReplyDelete