Beetal Oracle DB Startup: Difference between revisions
Created page with " Login into the System where oracle is Installed ### su - oracle To Start Oracle server Now, use the lsnrctl command to start service (located at /home/oracle/oracle/produ..." |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
Login into the System where oracle is Installed | Login into the System where oracle is Installed | ||
su - oracle | |||
To Start Oracle server | 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): | Now, use the lsnrctl command to start service (located at /home/oracle/oracle/product/10.2.0/db_1/bin directory): | ||
lsnrctl start | |||
You can replace "start" with "status" to check the current status | You can replace "start" with "status" to check the current status | ||
| Line 14: | Line 14: | ||
Next start database | Next start database | ||
dbstart | |||
If above is not working try to login as sysdba using below command | If above is not working try to login as sysdba using below command | ||
sqlplus sys as sysdba | |||
(give the password of sysdba when prompt) | (give the password of sysdba when prompt) | ||
| Line 24: | Line 24: | ||
SQL> startup | SQL> startup | ||
************************************************************************************************************************************************************* | ************************************************************************************************************************************************************* | ||
Stop Oracle service | Stop Oracle service | ||
To stop Oracle service type following two commands: | To stop Oracle service type following two commands: | ||
lsnrctl stop | |||
dbshut | |||
OR you can login as sysdba user: | OR you can login as sysdba user: | ||
sqlplus sys as sysdba | |||
At SQL> type shutdown command: | At SQL> type shutdown command: | ||
SQL> shutdown | |||
User may report that they are not able to connect to database using their application(Toad is an application they | User may report that they are not able to connect to database using their application(Toad is an application they are using to connect to their database at the time of writing this article). 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 | Error : ORA-12505, TNS:listener does not currently know of SID given in connect descriptor | ||
Cause : Oracle server down | Cause : Oracle server down | ||
Latest revision as of 04:55, 23 November 2017
Login into the System where oracle is Installed
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):
lsnrctl start
You can replace "start" with "status" to check the current status
Next start database
dbstart
If above is not working try to login as sysdba using below command
sqlplus sys as sysdba
(give the password of sysdba when prompt)
At SQL> type startup command:
SQL> startup