How Do I Start Oracle Service in UNIX or Linux?

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.

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin and a trainer for the Linux operating system/Unix shell scripting. He has worked with global clients and in various industries, including IT, education, defense and space research, and the nonprofit sector. Follow him on Twitter, Facebook, Google+.

Share this on (or read 19 comments/add one below):

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. su -oracle
    Here oracle is a user.
    you need to create a oracle user first,then try the above command,it works

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

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

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

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

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

    Have a question? Post it on our forum!