JamesMcN
asked on
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?
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?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
"If you want to manually start the database set ORA_SID_AUTOSTART to FALSE in the REGISTRY, under HKEY_LOCAL_MACHINE\SOFTWAR
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?
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?
-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!
If I find something else I'll post it here..
Good luck!
After system startup open services and Check whcih all services are running....