23c: Database has been previously opened and closed

By Wadhah DAOUEHI | February 12, 2024 - 2:52 pm |May 30, 2024 23ai, Oracle 19c

While the database is OPEN, we can close the database to the MOUNT status, and we can enable or diable the archivelog, but to OPEN the database we need to stop the instance and start it.

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL>
SQL> alter database close;

Database altered.

SQL>
SQL>
SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database close;

Database altered.

SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16196: database has been previously opened and closed