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

Shutting Down and Starting Up Using the Configuration Services Script