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...!
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
ReplyDeletethesе tyρes of articles or гevieωs.
Feel free to suгf to my site: http://xfire.com/blog/lisettemf/4713933
Helped me... Thanks a lot
ReplyDelete