Site icon IT Tutorial

ORA-01155: the database is being opened, closed, mounted or dismounted

I got ” ORA-01155: the database is being opened, closed, mounted or dismounted ”  error in Oracle database.

 

ORA-01155: the database is being opened, closed, mounted or dismounted

 

Details of error are as follows.

ORA-01155: the database is being opened, closed, mounted or dismounted

Cause: The requested operation needs the instance to be in a particular state but the state is being changed.

Action: Wait for the open, close, mount, or dismount to complete then retry the operation. 
If necessary, a SHUTDOWN ABORT will always work.



 

 

the database is being opened, closed, mounted or dismounted

This ORA-01155 error is related to the requested operation needs the instance to be in a particular state but the state is being changed.

Wait for the open, close, mount, or dismount to complete then retry the operation. If necessary, a SHUTDOWN ABORT will always work.

 

Then try to switchover again with the following command.

SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version