Oracle Solution for Error ora-01531

Solution for Oracle Error ORA-01531

ORA-01531: a database already open by the instance

What triggered the Error:

During ALTER DATABASE, an attempt was made to open a database on an instance for which there is already an open database.

What should we do to fix it:

If you wish to open a new database on the instance, first shutdown the instance and then startup the instance and retry the operation.