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
Comments
i have tried this and working fine .
but if we double click that .bat file ,it won't working ,after clicking run as administrator it works fine.
thank you
when i tried to start enterprize manager i got this massege...what should i do?
Error: java.lang.Exception: Exception in sending Request :: null
I am working in Oracle india pvt ltd .as business operation analyst.i want to go development side ,thats why i want to do Oracle DB course .have you teach oracle db course?Please suugest me
Thank you
Pega Training in Chennai
Pega Developer Training
Linux Training in Chennai
Tableau Training in Chennai
Spark Training in Chennai
Excel Training in Chennai
Corporate Training in Chennai
Oracle Training in Chennai
Oracle DBA Training in Chennai
Social Media Marketing Courses in Chennai
software testing class
selenium training in chennai
software testing course in chennai with placement
magento training course in chennai
Thanks for sharing.
mobile application development training online
web designing course with placement in chennai
web designing training institute in chennai
web design and development training
mobile app development course
mobile application development course
learn mobile application development
mobile app development training
Data Science Course in Chennai
Data Science Courses in Bangalore
Data Science Course in Coimbatore
Data Science Course in Hyderabad
Data Science Institute in Marathahalli
Data Science Training in Bangalore
Best Data Science Courses in Bangalore
Data Science Institute in Bangalore
Spoken English Classes in Bangalore
DevOps Training in Bangalore
Cloud Computing Training in Chennai
Cloud Computing Institutes in Chennai
cloud computing training institutes in chennai
DevOps certification in Chennai
VMware Training in Chennai
Cloud Computing Training in Porur
Cloud Computing Training in T Nagar
vé máy bay đi Mỹ giá rẻ
giá vé máy bay từ mỹ về việt nam tháng 12
từ nhật bản về việt nam bao nhiêu tiếng
mua vé máy bay từ đức về việt nam
vé máy bay từ canada về việt nam giá rẻ
vé máy bay từ hàn quốc về việt nam
Hey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work! FYI, please check these depression, stress and anxiety related articles.
Federal Bank Signet Credit Card 2021 Review , The High Five Habit Free pdf Download , Sadhguru Karma Book PDF Download
Non technical IT jobs
Tech jobs for non techies