In this tutorial, How to confirm Oracle automatic startup on Linux. How to make Oracle start automatic in Linux.
By default, Oracle software installation does not deploy automatic startup and shutdown init scripts on the platform.
How to confirm Oracle automatic startup on Linux.
The dbstart utility reads the oratab file. Confirm it in the example below
[HuuPV@DevopsRoles ~]$ sudo su - oracle [oracle@DevopsRoles ~]$ cat /etc/oratab DEVOPSROLES_SID:/opt/oracle/product/11.2.0/dbhome_1:Y DEVOPSROLES_SID02:/opt/oracle/product/10.2.03/dbhome_2:N
We see there are two instances on this server. Oralce 10.2.03 is marked “N” will not re-start when Linux OS reboot. Oracle 11.2.0 is marked “Y” will re-start when Linux OS reboot.
Auto Start Oracle on Linux
1. In the /etc/oratab file with autostart column to “Y”
[oracle@DevopsRoles ~]$ cat /etc/oratab DEVOPSROLES_SID:/opt/oracle/product/11.2.0/dbhome_1:Y
2. Create the file named “oracle” in /etc/init.d folder.
[root@DevopsRoles ~]# cd /etc/init.d [root@DevopsRoles init.d]# vi oracle #!/bin/sh ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1 ORACLE_OWNER=oracle case "$1" in 'start') # Start the Oracle databases and listeners su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME" ;; 'stop') # Stop the Oracle databases and listeners su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" ;; esac
3. Create symbolic link
[root@DevopsRoles ~]# ln -s /etc/init.d/oracle /etc/rc0.d/K10oracle [root@DevopsRoles ~]# ln -s /etc/init.d/oracle /etc/rc3.d/S99oracle
4. Change permissions
[root@DevopsRoles ~]# chmod 750 /etc/init.d/oracle
5. use chkconfig command to associate the dbora service
[root@DevopsRoles ~]# chkconfig --level 2345 oracle on
Test
restart oracle server. Then check the instance status
[oracle@DevopsRoles ~]$ ps -ef | grep smon | grep -v grep
Check the listener status
[oracle@DevopsRoles ~]$ lsnrctl status
Thank you for reading DevOpsRoles.com page