Linux start oracle as a service

Starting Oracle database server is very easy on Linux oses. You need to following steps to start oracle as a service:

a) Login as an oracle user
b) First start the Oracle listener processes using lsnrctl utility
c) Next start the Oracle database using dbstart utility that reads the oratab file (/etc/oratab)
d) Connect to server using sql plus client or isql pluse web based client

Here are all commands:

$ su - oracle
$ lsnrctl start
$ dbstart

To make the entire process easy we have a shell script that starts and stops Oracle database.

Download script to /tmp directory and rename it as oracle

Copy script to /etc/init.d directory:

# cp /tmp/oracle /etc/init.d/oracle

Create a soft link (Run level 3):

# cd /etc/rc3.d/
# ln -s ../init.d/oracle S100oracle
# ln -s ../init.d/oracle K100oracle

Alternatively use chkconfig command to add script:

# chkconfig --add oracle
# chkconfig --list oracle

Please note that you can just use script directly, to start Oracle type command:

# /etc/init.d/oracle start

To stop Oracle type command:

# /etc/init.d/oracle stop