Blog

Error :

ORA-01507: database not mounted

This error means the database is in no mount state. You can also check the status by issuing the below command :

select instance_name,status from v$instance;----------->it will show nomount state as below :
INSTANCE_NAME    STATUS       
---------------- ---------
TESTDB           NOMOUNT

Note : Database open is done in three stages :

So, to resolve this error you have to mount the database first and the have to open it. Lets go through the steps.

This error you can get in below scenarios :

Case 1 : While alter database open :

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted

Resolution :

Mount the database and then open it

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

Case 2 : In the Middle of Shutdown database :

SQL> shutdown immediate;
ORA-01507: database not mounted
...

Resolution :

The error message displayed as an infromation only, this is not an error. It tells us that the database now is dismounting, so no need to worry.

Related ORA-error related articles :

• ORA-01090: shutdown in progress – connection is not permitted

Also, you can check out Oracle Doc ID 2648600.1 for further reference.