Ramin Hossaini (blog)

14Apr/10

Cancel Oracle shutdown

You might want to cancel a shutdown if you issued the wrong command when there were connected users.

If you try to shutdown immediate from another session, you’ll get this:

SQL> shutdown IMMEDIATE
ORA-24324: service handle NOT initialized
ORA-24323: VALUE NOT allowed
ORA-01089: IMMEDIATE shutdown IN progress - no operations are permitted

When you issue a shutdown, only the SYS/SYSTEM user will be able to connect, so open another SQL*Plus session and type this:

CONNECT /AS sysdba
startup force

Related posts:

  1. Oracle: Recovering a Tablespace
  2. Oracle: List all database-links
  3. Oracle: Forcing a checkpoint
  4. Oracle: Basic user-logon auditing
  5. Basic Auditing in Oracle
Tagged as: Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.

Bear