How do I start Oracle service in UNIX?

by on July 29, 2006 · 10 comments· last updated at February 8, 2008

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



You should follow me on twitter here or grab rss feed to keep track of new changes.

Featured Articles:

{ 10 comments… read them below or add one }

1 Carros Brasília June 2, 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?

Reply

2 Markus June 5, 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

Reply

3 shrish awasthi April 5, 2009 at 7:18 am

hi
i am a system eng. and i missing some script so plz let me know i have a linur server and 10g 0racle databasse and its for flight information display system so i add a new display system and configured it after that i used a commend cd /solids/Disckonmodule/UPT_TFT then enter
after that i update the that one tft who is new one
#./TFTupd.sh PDD011 whatever name but display not come and befour it i updated same type display

so plz help me
thanks and waiting fo rrespons

Reply

4 Mohammed Arif September 16, 2009 at 4:40 pm

su – oracle

It is saying su-oracle not found. Please help in this.

Reply

5 Mohammed Arif September 16, 2009 at 7:01 pm

# su – oracle

I enter the above su – oracle in # prompt. then it’s giving message like this

3004-500 User “oracle” does not exist.

Reply

6 Anonymous May 12, 2010 at 12:17 pm

means your id your id in not in that group or may not in sudo fentry.

Reply

7 wmohs May 12, 2010 at 12:19 pm

hi
this means your id is not under oracle group or may be not in sudo entry.

Reply

8 Mohammed Arif September 17, 2009 at 8:52 pm

Thanks for this site. I got some help from this site. Last time I got error, I enter su – oracle.
Later I found the oracle installed oracle8 directory. su – oracle8 it success. Working fine.
Thanks.

Reply

9 rakesh January 6, 2011 at 12:23 am

su -oracle
Here oracle is a user.
you need to create a oracle user first,then try the above command,it works

Reply

10 rohit July 28, 2012 at 3:23 pm

i m trying to connect with oracle
su – oracle
-bash-3.00$
what can i do ?give this error..

Reply

Leave a Comment

You can use these HTML tags and attributes for your code and commands: <strong> <em> <ol> <li> <u> <ul> <kbd> <blockquote> <pre> <a href="" title="">

Tagged as: , , , , , , , , , , , , , ,

Previous Faq:

Next Faq: