ORA-01081: cannot start already-running ORACLE – shut it down first

This error is observed when you try to start already started instance

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size                  2924832 bytes
Variable Size            1157631712 bytes
Database Buffers          402653184 bytes
Redo Buffers               13848576 bytes

Already the database instance is up

SQL> startup nomount;
ORA-01081: cannot start already-running ORACLE - shut it down first

Shutdown the database and then try –Warning – use this command with caution. Think twice before execute the statement in production

SQL> shutdown immediate;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s