Starting Up Database Using Command Line
sqlplus / as sysdba
At the SQL Command Line prompt, enter the following command:
SQL> STARTUP
ORACLE instance started. Total System Global Area 599785472 bytes Fixed Size 1220804 bytes Variable Size 180358972 bytes Database Buffers 415236096 bytes Redo Buffers 2969600 bytes Database mounted. Database opened.
(Optional) Enter the following SQL query
SQL> select count(*) from hr.employees;
COUNT(*) ---------- 107
To exit the SQL Command Line
SQL> EXI
0 comments