Wednesday, December 27, 2023

open database in write

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 27 21:44:29 2023

Connected to an idle instance.

------------------------

SQL> startup mount

ORACLE instance started.

Total System Global Area 1660944384 bytes

Fixed Size 8621376 bytes

Variable Size 1056965312 bytes

Database Buffers 587202560 bytes

Redo Buffers 8155136 bytes

Database mounted.

------------------------------------------

SQL> alter database open;

Database altered.

---------------------------------------------

SQL> select open_mode, name from v$database;

OPEN_MODE NAME

-------------------- ---------

READ WRITE ORCL

-------------------------------------------

s