How do I start the Oracle database server as a service under Linux operating systems?
Starting the Oracle database server is very easy under Linux:
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
Type the following 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 the chkconfig command to add script:
# chkconfig --add oracle
# chkconfig --list oracle
Please note that you can just use script directly, to start the Oracle type the following command:
# /etc/init.d/oracle start
To stop the Oracle type the following command:
# /etc/init.d/oracle stop
