Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Could not Shutdown or Startup the DB

Knidhi-OracleApr 1 2009 — edited Apr 2 2009

Hello Experts,
i stutdown the oracle instace, before complete the process i came out of the command prompt. after that if i try to connect the db, i am getting the following error. Please help me.

C:\Documents and Settings\gkalanid>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 1 17:40:07 2009

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

SQL> conn sys/oracle as sysdba
Connected to an idle instance.
SQL> startup
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01090: shutdown in progress - connection is not permitted
SQL>

Edited by: knidhi on Apr 1, 2009 5:46 PM

Edited by: knidhi on Apr 2, 2009 11:22 AM

This post has been answered by 678145 on Apr 1 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2009

Added on Apr 1 2009

#general-database-discussions

3 comments

305 views