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
Subscribe to our free e-mail newsletter or RSS feed to get all updates. You can Email this page to a friend.
