Everytime you want to start or stop a database service you will have to either do this using sqlplus prompt or through windows services. There is a much simpler way of stopping or starting a database.
Follow the steps below.
Create a file with an extension .bat for example start.bat
Open this file and add the following line in it.
NET START OracleServiceORCL
Create another file as stop.bat, open this file and add the following line.
NET STOP OracleServiceORCL
Here I have 3 words,
1. NET helps start and stop services.
2. START/STOP -- Keyword means start or stop the services
3. OracleServiceORCL -- This is the service name of the database which has been installed on my windows.
To start the database just double click on start.bat and to stop the database double click on stop.bat.
To know the service name of the database on your machine, follow the steps below.
1. Go to Control Panel --> Administrative Tools --> Click on Services icon.
This will open a window show below.
Here scroll down to names starting with alphabet O check for anything starting with Oracle.
Highlighted service name is the one which has to be used. If you have installed only one Oracle database on your windows then if your database name is ORCL then you will have to start only one service and that service would be "OracleServiceORCL".
To know how to start/stop the database using SQLPLUS CLICK HERE
To know how to start/stop using services menu CLICK HERE