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
Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
Related Other Helpful FAQs:
- How do I start Oracle service in UNIX?
- ORA-12154: TNS:could not resolve the connect identifier specified Error and Solution
- Ubuntu Linux Install Oracle Database XE Server
- How do I start and stop NFS service?
- How do I enable SQL *Plus Up and down arrow keys?
Discussion on This FAQ
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
May 7th, 2008 at 10:56 am
Thanks a lot