I've recently installed Oracle 10g on my home laptop running Windows XP Home Edition. I'm a novice/beginner DBA, but a fairly experienced Oracle Developer. Unfortunately, no amount of knowledge of SQL and PL/SQL has helped me in trying to troubleshoot the various aspects of my installation that appear to have backfired on me.
Anyway, my latest issue may be a big deal, or it may not. I recently changed the startup type of both my dbconsole and oracle database services to be "Manual" rather than "Automatic". The reason for this is that I don't want Oracle running all the time on my home laptop, as it's a bit of a resource hog, particularly at Windows startup.
My understanding of the service type is that if it is set to "Automatic" in the Windows Services Menu, the service will start automatically at Windows startup. If it's set to "Manual", my understanding is that the service must be started manually by the Windows System Administrator, i.e. ME!
My Oracle 10g database service still seems to be starting automatically when I restart Windows XP, despite the fact that it now has the "Manual" rather than "Automatic" startup type.
Please can anyone tell me how I can prevent this from happening, or if I have a more significant issue to deal with that is causing this?