Beetal Oracle DB Startup

Login into the System where oracle is Installed

1. 1. su - oracle

To Start Oracle server

Now, use the lsnrctl command to start service (located at /home/oracle/oracle/product/10.2.0/db_1/bin directory):

1. 1. lsnrctl start

You can replace "start" with "status" to check the current status

Next start database

1. 1. dbstart

If above is not working try to login as sysdba using below command

1. 1. sqlplus sys as sysdba

(give the password of sysdba when prompt)

At SQL> type startup command:

SQL> startup

Stop Oracle service

To stop Oracle service type following two commands:

1. 1. lsnrctl stop
  2. dbshut

OR you can login as sysdba user:

1. 1. sqlplus sys as sysdba

At SQL> type shutdown command:

1. 1. SQL> shutdown

User may report that they are not able to connect to database using their application(Toad is an application they will be using to connect to their database). If they get error given below. You can try and use the steps given above.

Error : ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Cause : Oracle server down

Steps to resolved the issue