How Do I Start Oracle Service in UNIX or Linux?

by on July 29, 2006 · 12 comments· LAST UPDATED February 28, 2014

in , ,

I am using a Solaris UNIX based server. How can I start a Oracle service / server in UNIX from a shell prompt? How can I start and stop Oracle database on a Linux based server?

In order to start Oracle service in a UNIX or Linux based system you need to login as a Oracle user.
Tutorial details
DifficultyEasy (rss)
Root privilegesNo
RequirementsNone
Estimated completion time5m

How To Startup Oracle Database on a Unix/Linux

Use the su - username command to login as oracle user. Open the Terminal or login using ssh and type the following command to login
$ su - oracle

Start Oracle server in UNIX/Linux

Now, use the 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
If above is not working try to login as sysdba:
$ sqlplus '/ as sysdba'
At SQL> type startup command:

SQL> startup

Stop Oracle service in UNIX/Linux

To stop Oracle service type following two commands:
$ lsnrctl stop
$ dbshut

If above failed login as sysdba user:
$ sqlplus '/ as sysdba'
At SQL> type shutdown command:

SQL> shutdown

See "Stopping and Starting Oracle Software" for information.

TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 12 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 yogendra November 12, 2013 at 5:23 am

First make oracle user and also add this user to group.

Reply

6 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

7 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

8 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

9 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

10 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

11 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

12 vasu September 17, 2012 at 8:08 am

Hi rohit,you r in oracle promt.but os shaows bash promt.dont worry about in that issue.already u r in oracle promt.

Reply

Leave a Comment

Tagged as: , , , ,

Previous Faq:

Next Faq: