How do I start Oracle service in UNIX?
Q. I am using Solaris UNIX. How can I start Oracle service / server in UNIX from a shell prompt?
A. In order to start Oracle service in UNIX you need to login as a Oracle user.
Use su - command to login as oracle user.
Start Oracle server in UNIX
Type the following command, enter:
$ su - oracle
Now use lsnrctl command to start service (usually located at /home/oracle/oracle/product/10.2.0/db_1/bin directory):
$ lsnrctl start
Next start database:
$ dbstart
Stop Oracle service in UNIX
To stop Oracle servuice type following two commands:
$ lsnrctl stop
$ dbshut
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:
- Linux start oracle as a service
- ORA-12154: TNS:could not resolve the connect identifier specified Error and Solution
- How do I start and stop NFS service?
- How do I enable SQL *Plus Up and down arrow keys?
- Ubuntu Linux Install Oracle Database XE Server
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!
Tags: bin directory, dbshut_command, lsnrctl_command, oracle, oracle product, oracle server, oracle service, oracle user, oracle_service, oracle_user, service server, shell, solaris_unix, start_oracle, stop_oracle, su_command, UNIX
June 2nd, 2008 at 5:21 pm
I’m traying to start oracle but it is consuming 90% of a quad core server.
Any tip to solve this problem?
June 5th, 2008 at 7:09 pm
I ran these commands in Fedora 9 (Oracle 11g), but it’s saying:
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.1.0/db_1/bin/dbstart ORACLE_HOME