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
Mithun Ashok's Experience, Summary, Trainings and Knowledge Sharing on Oracle Database, Oracle Applications, Fusion Middleware, SQL, PL/SQL and Database Testing