By cj on Jan 19, 2015
Here are the steps I have been using to enable autostarting of Oracle Datbase Enterprise Edition 10g, 11g or 12c during boot time of Oracle Linux 5 and 6. I also use these steps with Oracle Linux 7. These steps are useful for the kinds of demonstration and development setups that I typically need.
These steps are not needed for Oracle XE, since its install will prompt whether to autostart the DB and will configure the system automatically.
Create a new service script
Create a file
Set permissions on the script
# chmod 750 /etc/init.d/dbora
Tell Linux to autostart/stop the service
# chkconfig --add dbora # chkconfig dbora on
/etc/oratab, change the autostart field from
Yfor any databases that you want autostarted.
Starting / Stopping the DB
The DB will start and stop at machine boot and shutdown.
Or it can be manually controlled with:
# service dbora start
# service dbora stop
Starting Oracle Database 12c Multitenant PDBs
To also start all pluggable databases when the container database starts, you can do:
connect / as sysdba create or replace trigger sys.after_startup after startup on database begin execute immediate 'alter pluggable database all open'; end after_startup; /