Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 784
  • Last Modified:

Preventing the Oracle database service from starting up when Windows XP starts up

Hi there,

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?
0
JamesMcN
Asked:
JamesMcN
1 Solution
 
sajuksCommented:
have u disabled the OracleSID service... (or OracleServiceORCL)...
After system startup open services and Check whcih all services are running....
0
 
paquicubaCommented:
Use command line utility ORADIM:

http://download-west.oracle.com/docs/cd/B14117_01/win.101/b10113/create.htm#sthref284

Parameter: -SRVCSTART system | demand indicates whether to start the Oracle Database service on computer restart.

0
 
paquicubaCommented:
If you want to manually start the database set ORA_SID_AUTOSTART to FALSE in the REGISTRY, under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<HOME>.  The service will start but not the database.
Most DBAs think that the service is the database but that is not true.  The service can start/stop the database but it can also be started without starting the database.

0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
schwertnerCommented:
Do not stop the services.
Simply stop the listener and the database and you will free the RAM resorces:
SQL>connect sys/password@something  as sysdba
SQL>shutdown immediate
........
SQL>exit

Stop the Listener:
c:>lsnrctl stop

Thats all.
0
 
JamesMcNAuthor Commented:
"If you want to manually start the database set ORA_SID_AUTOSTART to FALSE in the REGISTRY, under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\<HOME>.  The service will start but not the database.
Most DBAs think that the service is the database but that is not true.  The service can start/stop the database but it can also be started without starting the database."

Hi Guys.

The above solution seems to have worked, which is absolutely fantastic. Member paquicuba, you're getting the points for this one. Ijust have a brief question to ask you about the ORADIM utility.

Bearing in mind that I'm a newcomer to the DBA side of Orace, if I'd used the "ORADIM -SRVCSTART system | demand" command at the DOS prompt to specify non-automatic startup of the database at Windows startup, what would I have set the "system" and "demand" parameters to?

I apologise for the lameness of this question, but I cannot find anything too specific on this in the document at URL http://download-west.oracle.com/docs/cd/B14117_01/win.101/b10113/create.htm#sthref284. I appreciate that the "ORADIM -SRVCSTART system | demand" command is included in the list here, but there are no examples of using it, and details of the values expected for the "system" and "demand" parameters do not seem to be there.

Would system be set to my Computer's name?

Are there any good books you know of that would provide a good entry level companion to the ORADIM utility?
0
 
paquicubaCommented:
-SRVCSTART is new in 10g. I use 10g at home but that's it. As you said, there is nothing in the docs explaining the options [ system | demand ] of this new parameter, that's why I adviced you to use the registry.

If I find something else I'll post it here..


Good luck!
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now