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. [donotprint][/donotprint]

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: SXI ADMIN

The author is the creator of SXI LLC and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.