Chapter 5: Starting and Stopping Oracle Database 23ai

To Shut Down Using SQL*Plus:

su - oracle

sqlplus / as sysdba

SHUTDOWN IMMEDIATE;

To start the database Using SQL*Plus:

STARTUP;

ALTER PLUGGABLE DATABASE ALL OPEN;

Automating Shutdown and Start-Up:

run the following commands as root:

systemctl daemon-reload

systemctl enable oracle-free-23ai

restart the server and test the commands

Shutting Down and Starting Up Using the Configuration Services Script

sudo -s

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

/etc/init.d/oracle-free-23ai stop

/etc/init.d/oracle-free-23ai start