≡ 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:

Like this? Follow us on Twitter OR support us by using Patreon

{ 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

    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

      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.

  • 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
    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

    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: , , , ,