Check Oracle Database in Read/Write Mode

You can use below query to check is your Oracle database in read/write mode or not.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE