There are three ways to start/Shut down Oracle Services

There are three ways to start Oracle services:?
1 from the Control Panel?
2 using MS-DOS commands?
3 via Oracle Administration Assistant for WindowsNT

-Start Oracle Service from the control Panel?
1) Select Start > Control Panel management tools--〉 service?
2) Locate the Oracle service you want to start, click Start

-Start Oracle Service with MS-DOS command?
1) Open the DOS window?
2) In the window, enter: NET START oracleservicename

-Start Oracle Services with Oracle Administration Assistant for WindowsNT

1) Select Start Program 〉oracle-home_name > Configuration and Migration?
Tools > Oracle Administration Assistant for Windows NT.?
2) Locate and right-click the Oracle SID?
3) Select Start

??

There are also three ways to turn off Oracle services: ?
1 from the Control Panel?
2 using MS-DOS commands?
3 via Oracle Administration Assistant for WindowsNT

-Turn off Oracle services from the control Panel?
1) Select Start > Control Panel management tools--〉 service?
2) Locate the Oracle service you want to start, click Stop

-Turn off Oracle Services with MS-DOS commands?
1) Open the DOS window?
2) In the window, enter: NET STOP oracleservicename

-Turn off Oracle Services with Oracle Administration Assistant for WindowsNT

1) Select Start Program 〉oracle-home_name > Configuration and Migration?
Tools > Oracle Administration Assistant for Windows NT.?
2) Locate and right-click the Oracle SID?
3) Select Stop

??

How to start Sqlplus quickly:

Under the Start menu, click Run to enter:?
??? SQLPLUSW? /nolog? or SQLPLUSW User/password.

Start/Close database: Startup/shutdown

Start/Close listener: Lsnrctl start/lsnrctl Stop

?

Batch start and shut down Oracle 11g services

Server name and description used to start and shut down the database:
Service Name??????????????????????????????????????????????????? Description
Oracleoracle_hometnslistener?????????? Listener corresponding to the database
Oracleservicesid?????????????????????????????????????? A routine that corresponds to a database
Oracledbconsolesid???????????????????????????????? Corresponds to Oracle Enterprise Manager (OEM)

Where Oracle_home represents the Oracle home directory, such as Oracle11g_home1;sid, which represents the Oracle system identifier, such as Oracleserviceorcl ORCL.

Note: Although these 3 services can be started and shut down individually, they do not have dependencies as they do in Oracle 10g.

The better Boot sequence is: Oracleoracle_hometnslistener,oracleservicesid,oracledbconsolesid. Turn off in reverse order.

The following is a sequence of two batch files that have been ordered to start and stop a service:

Start Oracle 11g Service.bat

@echo off

Are you sure you want to start the Oracle 11g service?

Pause

net start Oracleoradb11g_home1tnslistener

net start ORACLESERVICEORCL

net start ORACLEDBCONSOLEORCL

Echo? Start the Oracle 11g service to complete, and verify that there are no errors.

Pause

?

Stop Oracle 11g Service.bat

@echo off

Echo? Are you sure you want to stop Oracle 11g service?

Pause

net stop ORACLEDBCONSOLEORCL

net stop ORACLESERVICEORCL

net stop Oracleoradb11g_home1tnslistener

Echo? Stop the Oracle 11g service to complete, and make sure that there are no errors.

Pause

There are three ways to start/Shut down Oracle Services