Oracle Database Basic Consepts (Start / Stop / Check Database Status)

🟢 Starting the Oracle Database

            SQL> STARTUP;

This command initiates the Oracle instance, mounts the database, and opens it for use. For environments using pluggable databases (PDBs), you may need to open them separately:

            SQL>  ALTER PLUGGABLE DATABASE ALL OPEN;

🔴 Shutting Down the Oracle Database

            SQL> SHUTDOWN IMMEDIATE;

This command performs a clean shutdown, rolling back uncommitted transactions and disconnecting users. For emergency situations where immediate shutdown is required, you can use:

            SQL> SHUTDOWN ABORT;

🔍 Checking Database Status

1. Verify Oracle Processes:

On Unix/Linux:

            ps -ef | grep pmon

If the pmon process is running, the database instance is active.

On Windows:

            tasklist | findstr /i oracle

2. Check Instance Status via SQL*Plus:

            SQL> SELECT instance_name, status FROM v$instance;

A status of OPEN indicates the database is operational.

3. Check Database Open Mode:

            SQL> SELECT name, open_mode FROM v$database;

An open_mode of READ WRITE confirms the database is open for read and write operations.

📝 Example Workflow

sqlplus / as sysdba

-- Start the database

STARTUP;

-- Check instance status

SELECT instance_name, status FROM v$instance;

-- Check database open mode

SELECT name, open_mode FROM v$database;

-- Shut down the database

SHUTDOWN IMMEDIATE;