Subscribe YouTube Channel For More Live Tutorials

In 23ai 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

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.

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

After you configure the listener, log in as root using sudo and run the Configuration Services Script to check the status of the database and listener.

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

The output of this command is similar to the following:

CopyStatus 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