How Do I Start Oracle Service in UNIX or Linux?

Posted on in Categories , , last updated February 28, 2014

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.

19 comment

  1. I’m traying to start oracle but it is consuming 90% of a quad core server.
    Any tip to solve this problem?

  2. 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

  3. 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

  4. # su – oracle

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

    3004-500 User “oracle” does not exist.

  5. 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.

  6. 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

  7. 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 ?

  8. i m new to linux can somebody help me out how to start oracle dba (12g m using) through shell script and m using bourne shell only, in ubuntu os.

Leave a Comment