7 Starting and Stopping Oracle Database Free

You can start and stop the database manually or set it to automatically start when the system shuts down or starts.

Shut Down and Start-Up Using SQL*Plus

You can shut down and start the database using SQL*Plus.

To shut down the database, log in as the oracle user with its environment variables set for access to Oracle Database Free, and run the following SQL*Plus command:

$ sqlplus / as sysdba
SQL> SHUTDOWN IMMEDIATE

To start the database:

SQL> STARTUP
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;

Automating Shutdown and Start-Up

Oracle recommends that you configure the system to automatically start Oracle Database Free when the system starts, and to automatically shut it down when the system shuts down. Automating database shutdown guards against incorrect database shutdowns.

To automate the start up and shutdown of the listener and database, run the following commands as root:

$ sudo -s

For Oracle Linux 8 and Oracle Linux 9:

# systemctl daemon-reload
# systemctl enable oracle-free-23ai

Shutting Down and Starting Up Using the Configuration Services Script

After you configure the listener, you can run the Configuration Services Script to check the status of the database and listener.

Log in as root using sudo.

# /etc/init.d/oracle-free-23ai status

The output of this command is similar to the following:

Status of the Oracle FREE 23ai service:

LISTENER status: RUNNING
FREE Database status: RUNNING

Run the following commands as root using sudo.

$ sudo -s

Oracle Linux 8 and Oracle Linux 9:

To start the listener and the database:

# systemctl start oracle-free-23ai

To stop the database and the listener:

# systemctl stop oracle-free-23ai

To stop and start the listener and the database:

# systemctl restart oracle-free-23ai