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