Beetal Oracle DB Startup - Revision history

Augustine at 04:55, 23 November 2017

2017-11-23T04:55:25Z

← Older revision		Revision as of 04:55, 23 November 2017
Line 24:		Line 24:

	SQL> startup		SQL> startup


	*************************************************************************************************************************************************************		*************************************************************************************************************************************************************


	Stop Oracle service		Stop Oracle service
Line 31:		Line 33:
	To stop Oracle service type following two commands:		To stop Oracle service type following two commands:
	lsnrctl stop		lsnrctl stop

	dbshut		dbshut

Line 41:		Line 44:


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

Augustine at 04:51, 23 November 2017

2017-11-23T04:51:25Z

← Older revision		Revision as of 04:51, 23 November 2017
Line 3:		Line 3:
	Login into the System where oracle is Installed		Login into the System where oracle is Installed

	~~###~~ su - oracle		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		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		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		sqlplus sys as sysdba

	(give the password of sysdba when prompt)		(give the password of sysdba when prompt)
Line 30:		Line 30:

	To stop Oracle service type following two commands:		To stop Oracle service type following two commands:
	~~###~~ lsnrctl stop		lsnrctl stop
	~~###~~ dbshut		dbshut

	OR you can login as sysdba user:		OR you can login as sysdba user:
	~~###~~ sqlplus sys as sysdba		sqlplus sys as sysdba

	At SQL> type shutdown command:		At SQL> type shutdown command:

	~~###~~ SQL> shutdown		SQL> shutdown


Line 46:		Line 46:

	Cause : Oracle server down		Cause : Oracle server down

	~~Steps to resolved the issue~~

Augustine: 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..."

2017-11-23T04:43:08Z

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

New page

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

*************************************************************************************************************************************************************

Stop Oracle service

To stop Oracle service type following two commands:
### lsnrctl stop
### dbshut

OR you can login as sysdba user:
### sqlplus sys as sysdba

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