I have been asked many times by several people that why does our
windows system start-up get slow after Installing Oracle Database
Enterprise Edition. Well guys, you are not alone!
I also had to face this problem while I was learning Oracle.
In order to find a solution, I started tweaking my system and
due to which sometimes I lend myself to bigger problems such as -
Oracle Not working and system crash.
So a word of advice beforehand - Please be careful while working with your system and oracle.
If something goes wrong with your system and data then I will not be responsible for that.
YOU HAVE BEEN WARNED!
Basically when you install Oracle EE then oracle creates several windows services for its
proper working. Some of these services are set to manual mode meaning you have to start
them manually and the rest are set on Automatic mode which means your system will start
these services with the windows start-up (at the time of boot). The latter part is responsible
for your slow system boot up.
So what is the solution to this problem?
The solution for this problem is that you either set all your Oracle related
window’s service to manual mode and start them when you need them or Install
Oracle on a Virtual machine.
Note here: This solution is for learning and practice environments only not for real environment. In real environment we have dedicated high capacity server for oracle which keeps running 24x7.
Once you have made your choice and want to learn how to set these windows services on Manual Mode then here are the steps for tweaking oracle related windows service.
But Before That
Access your window’s services panel. You can do this by two methods
Now you will notice the slight boost in the start-up of your windows but now your oracle EE is not working because all the Oracle EE server services are not yet started so to make your oracle server up and running you have to start all those services MANUALLY.
Similarly you can repeat this step for all the services.
That’s all you have to do.
But you have to do this thing every time you boot your system and now it becomes a painful job.
Don’t worry. There is always a solution for every problem and the solution for this problem is windows batch file script aka batch script.
Read on to know about - How you can create batch script for starting Oracle related windows service.
If you are a beginner or just want to use Oracle to learn or practice the concepts
then I highly recommend installing it on a virtual machine. And if you are looking for a
light weight version of oracle then you should read my Google plus post.
I hope you enjoyed reading.
Help me by sharing this article with your friends and on your social media. And subscribe to my YouTube channel for Oracle/SQL tutorials.
You can DOWNLOAD SQL script and presentation used in the Video and in this article.