≡ Menu

How Do I Start Oracle Service in UNIX or Linux?

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.

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.

Share this tutorial on:

Your support makes a big difference:
I have a small favor to ask. More people are reading the nixCraft. Many of you block advertising which is your right, and advertising revenues are not sufficient to cover my operating costs. So you can see why I need to ask for your help. The nixCraft, takes a lot of my time and hard work to produce. If you use nixCraft, who likes it, helps me with donations:
Become a Supporter →    Make a contribution via Paypal/Bitcoin →   

Don't Miss Any Linux and Unix Tips

Get nixCraft in your inbox. It's free:



{ 18 comments… add one }
  • Carros Brasília June 2, 2008, 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?

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

  • shrish awasthi April 5, 2009, 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

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

    su – oracle

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

    • yogendra November 12, 2013, 5:23 am

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

  • Mohammed Arif September 16, 2009, 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.

    • Anonymous May 12, 2010, 12:17 pm

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

    • wmohs May 12, 2010, 12:19 pm

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

  • Mohammed Arif September 17, 2009, 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.

  • rakesh January 6, 2011, 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

  • rohit July 28, 2012, 3:23 pm

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

  • vasu September 17, 2012, 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.

  • artificer July 10, 2014, 3:48 pm

    for the above procedure to work the environments variables should be set. (oraenv)

  • samuel July 30, 2014, 11:06 am

    Great article, thanks

  • J-Sequeiros December 18, 2014, 5:15 pm

    Manual is especially good for those who want to learn the management of a database in oracle

  • Mohammed December 31, 2014, 1:38 pm

    in my office Oracle dataBase and Oracle Application enable to start.can anyone tell me how to start And Stop the Oracle service in Linux O/S .its very Urgent. Do the needful .Thanks

  • sQze September 17, 2015, 4:52 pm

    Maybe “service oracle-xe restart”

  • surya January 8, 2016, 8:02 pm

    Hello,
    Thanks for this article.
    i have a doubt..?
    i’m able to start and stop by logging to oracle but my doubt is that when it got created after installing oracle ?

Security: Are you a robot or human?

Leave a Comment

You can use these HTML tags and attributes: <strong> <em> <pre> <code> <a href="" title="">


   Tagged with: , , , ,