How to start and stop Oracle database service in Windows.

Suppose your instance name of Oracle is ORA.

You will be having 2 services which need to be started.

Step 1:
You can configure Windows service to start this service at startup, if it is not started.

  i. Press window key + R to open run dialog. type services.msc and press enter.
 ii. Search for service OracleServiceOra.
iii. Right click on it and click on properties from popup menu.
iv.From the startup type select Automatic if you want to start the service when windows start, or select
   manual if you want to start the service manually, this will save you windows loading time and save memory
  also.
v. Click on start button if you want to start the service now.
vi. Click on apply.
vii/ Search for Oracle[OracleHomeName]TNSListener (Oracle home name is your oracle installed path).
viii. Do the same process as you have done with OracleServiceORA.

Step 2.

If you have set your service as mentioned above to be started manually then you can use command prompt
to start your service.

  i.  Create a batch file named say StartOracleService.bat
 ii.  In the batch file add these following line.
      @echo off
       net start OracleServiceOra
       net start Oracle[OracleHomeName]TNSListener
       REM OracleHomeName is you Oracle installed path
       exit
iii.   To stop the service create a batch file named say StopOracleService.bat
       In the file add these following line.
      @echo off
       net stop OracleServiceOra
       net stop Oracle[OracleHomeName]TNSListener
       REM OracleHomeName is you Oracle installed path
       exit