how to stop oracle database

[231166]

Hi,

I have installed oracle database 8.1 on my post but i don't use it a lot.
I know it takes a lot of ressources( in memory) even if i don't use it and i need theses ressources to permit me to work more rapidely.
could you tell me what i have to do to stop oracle database ( i think it is in the register ).

Thanks a lot for your help.

Regards.

Nathalie

 

[KenCunningham]

Nathalie - can we clarify whether you a) want to stop the service (in which case use services in Control Panel after shutting your database down), or b) simply delete the whole thing - in which case close the database then delete all files associated with it and clear out the registry.

I don't mind people who aren't what they seem. I just wish they'd make their mind up.

 

[231166]

Hi,

Yes this is what i need: to stop the service.
What means exactly :'use services in control panel after shuting your database down'
Does it mean i need to start the database first?

Thanks for your help.
Regards.

Nathalie

 

[SantaMufasa]

Nathalie,

On a Windows machine, to disable (but not remove) an Oracle database from running (and consuming Windows resources), you "Stop" the Oracle Service. The steps to stop your database's Windows service can differ slightly from Windows version to Windows version (and since you didn't confirm which Windows version you are using, I'll just provide the steps I use on my Windows XP machine):

Start -> Control Panel -> Administrative Tools -> Services -> (Scroll down to, and right-click, your "OracleService<SID>" Service name) -> Stop.

After you "Stop" your Oracle database service, the Status of your service changes from Started" to a Null status.

And to ensure that your Oracle Service does not automatically start next time you re-boot your Windows system, do the following from the same service drop-down menu that you used to Stop the service:

...(Scroll down to, and right-click, your "OracleService<SID>" Service name) -> Properties -> (Start-up properties): change from "Automatic" to either "Manual" or "Disabled".

Let us know how this works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[231166]

Hi and thanks a lot for your help.
I work with windows2000 os; if you could give me explanation with this os it would be very kind from you.

Thanks a lot again.

Regards.
Nathalie

 

[SantaMufasa]

Nathalie,

I should have mentioned, above, that the only difference between Windows versions in shutting down a service is that older versions of Windows do not have the "Administrative Tools" step...you go straight to "Services" from the "Control Panel" menu:

Start -> Control Panel -> Services...

Let us know how things go for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[231166]

[resolved]Hi and thanks a lot; i will note this because i need to know it.

Thanks alot to you.

Regards.

Nathalie