Difference between revisions of "Auto Start Oracle Database Server and Listener"
Jump to navigation
Jump to search
Line 9: | Line 9: | ||
Create a file called "/etc/init.d/dbora" as the root user, containing the following code. | Create a file called "/etc/init.d/dbora" as the root user, containing the following code. | ||
− | < | + | <pre> |
#!/bin/sh | #!/bin/sh | ||
# chkconfig: 345 99 10 | # chkconfig: 345 99 10 | ||
Line 48: | Line 48: | ||
;; | ;; | ||
esac | esac | ||
− | </ | + | </pre> |
Revision as of 11:48, 22 December 2016
The following represents the Oracle recommended method for automating database startup and shutdown of Oracle 11g, 12c instances on Linux, but it works fine for Oracle other versions as well. It can be used on any RHEL-style distribution, including Oracle Linux, CentOS and etc.
Once the instance is created, edit the "/etc/oratab" file setting the restart flag for each instance to 'Y'.
<source lang="python"> TSH1:/u01/app/oracle/product/9.2.0:Y </source>
Create a file called "/etc/init.d/dbora" as the root user, containing the following code.
#!/bin/sh # chkconfig: 345 99 10 # description: Oracle auto start-stop script. # # Set ORA_HOME to be equivalent to the $ORACLE_HOME # from which you wish to execute dbstart and dbshut; # # Set ORA_OWNER to the user id of the owner of the # Oracle database in ORA_HOME. ORA_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 ORA_OWNER=oracle if [ ! -f $ORA_HOME/bin/dbstart ] then echo "Oracle startup: cannot start" exit fi case "$1" in 'start') # Start the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values # Remove "&" if you don't want startup as a background process. su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" & su $ORA_OWNER -c $ORA_HOME/bin/dbstart & touch /var/lock/subsys/dbora ;; 'stop') # Stop the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su $ORA_OWNER -c $ORA_HOME/bin/dbshut su $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" rm -f /var/lock/subsys/dbora ;; esac