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.

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

19 comment

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

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

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

Leave a Comment