dbTalk Databases Forums  

Re: Avoiding automatically starting Oracle

comp.database.oracle comp.database.oracle


Discuss Re: Avoiding automatically starting Oracle in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bagieta
 
Posts: n/a

Default Re: Avoiding automatically starting Oracle - 11-25-2004 , 04:05 AM






The best way is to make them disabled in services control like Hans said,
and make a *.bat file that will run all of those services when you want. I
can send you such a *.bat file when I be back home but I think it should be
easy to you too.
To start the service named 'XXX' you should call:

net start XXX

--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~



Reply With Quote
  #2  
Old   
Nathan Sokalski
 
Posts: n/a

Default Re: Avoiding automatically starting Oracle - 11-25-2004 , 02:11 PM






Thank you very much for that information. I tried stopping one of the
services using net stop XXX, and it worked fine except for one thing, which
is that the services must be stopped in a certain order (I believe that is
because of dependencies or something?). I assume this means that they must
be started in a specific order as well. If you could please tell me what
order they must be stopped/started in, I think I can take it from there (I
know how to make .bat files, and now that you have told me the command to
use for starting & stopping the services, I think the order is the only
other thing I need to know.) Here are the services that currently get
started automatically (I assumed the only ones associated with Oracle were
the ones that had Oracle in the service name, if there are any others please
let me know):

OracleMTSRecoveryService Started Automatic Local System
OracleORADEVAgent Manual Local System
OracleORADEVClientCache Manual Local System
OracleOraHome92Agent Started Automatic Local System
OracleOraHome92ClientCache Manual Local System
OracleOraHome92HTTPServer Started Automatic Local System
OracleOraHome92PagingServer Manual Local System
OracleOraHome92SNMPPeerEncapsulator Manual Local System
OracleOraHome92SNMPPeerMasterAgent Manual Local System
OracleOraHome92TNSListener Started Automatic Local System
OracleServiceORCL Started Automatic Local System

I have not yet changed the Startup Types to Manual yet because I wanted to
make sure I could remember which services I needed to start until after I
created the batch files. Thank you again for your help.
--
Nathan Sokalski
njsokalski (AT) hotmail (DOT) com
www.nathansokalski.com

"Bagieta" <bagieta21 (AT) poczta (DOT) onet.pl> wrote

Quote:
The best way is to make them disabled in services control like Hans said,
and make a *.bat file that will run all of those services when you want. I
can send you such a *.bat file when I be back home but I think it should
be
easy to you too.
To start the service named 'XXX' you should call:

net start XXX

--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~





Reply With Quote
  #3  
Old   
bagieta
 
Posts: n/a

Default Re: Avoiding automatically starting Oracle - 11-25-2004 , 04:39 PM



Like Hans said you must use windows services manager.
The best way is to disable all oracle services and create a *.bat file.
Then in the bat file you can start all the oracle services you need.
To start service manually you must call:
'net start NAME'

Here is the example file I have created for myself

net start OracleOraHome90Agent
net start OracleOraHome90HTTPServer
net start OracleOraHome90TNSListener
net start OracleServiceSERVERNAME

--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - Multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~



Reply With Quote
  #4  
Old   
Nathan Sokalski
 
Posts: n/a

Default Re: Avoiding automatically starting Oracle - 11-25-2004 , 06:37 PM



I am recieving an error when trying to stop OracleServiceORCL using the
command:

net stop OracleServiceORCL

Immediately after I booted my computer, I executed a batch file that
contains the following commands in the following order:

net stop OracleMTSRecoveryService
net stop OracleOraHome92Agent
net stop OracleOraHome92HTTPServer
net stop OracleOraHome92TNSListener

They all ran successfully with no errors. I then ran the following in a
command prompt window and received the following error:

C:\>net stop OracleServiceORCL
The OracleServiceORCL service is stopping........
The OracleServiceORCL service could not be stopped.

I then opened and refreshed the Services window, and it had stopped the
service. If I do the same thing but stopping the service from within the
Services window, I do not receive an error. What is the problem here?
Thanks.
--
Nathan Sokalski
njsokalski (AT) hotmail (DOT) com
www.nathansokalski.com

"bagieta" <bagieta21 (AT) poczta (DOT) onet.pl> wrote

Quote:
Like Hans said you must use windows services manager.
The best way is to disable all oracle services and create a *.bat file.
Then in the bat file you can start all the oracle services you need.
To start service manually you must call:
'net start NAME'

Here is the example file I have created for myself

net start OracleOraHome90Agent
net start OracleOraHome90HTTPServer
net start OracleOraHome90TNSListener
net start OracleServiceSERVERNAME

--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - Multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.