Re: How to startup oracle9i without using windows services

comments in line
On 7/11/05, Vlad Sadilovskiy <vlovsky@xxxxxxxxx> wrote: 
> 
> I wonder if you know why this person needs what he/she asks for? And
> of course you can and will use any undocumented means if you are in
> need. 

 Hmm, but I didn't see any note that said that your method ran
Oracle.exeunder different credentials to normal , at a different cpu
priority and
requires the server to be left logged on at the console for the database to 
continue. 

For instance, Oracle puts start up script/link in /etc/rc*.d
> folders on *ix boxes. Will you always consider starting/shutting
> Oracle instances with those scripts? Why is the Windows any different?

 I don't really care where the startup *scripts* go[1], but would you run 
oracle as root on unix? or as an end-user account. 
 
In this (software,hardware) world you can do anything if you know how
> it works. The only question whether it is really necessary to use
> undocumented means.

 Well I'd first ask the question does a documented and supported method 
allow for the business need to be met. I'd likely if the answer were no then 
ask questions about the business need before hacking around on a production 
system. Here there are at least two supported and documented ways of 
scripting service control in general and a further oracle specific utility 
for the task. 
  
- Vladimir
> 
> On 7/11/05, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> > I've been watching all this with some incredulity.
> >
> > services are the appropriate technological approach to use for 
> background
> > processes (like the Oracle.exe process) on the win32 platform. You 
> should
> > use them where provided, and encourage your third party vendors that 
> write
> > for the win32 platform to use them as well.
> >
> > thomas' approach is certainly the most common way to script the startup 
> and
> > shutdown of services on the windows platform.
> >
> > generically you have another approach which is to use the windows 
> management
> > instrumentation interface, start here for information
> > for oracle you also have the option of calling oradim.exe to start and 
> stop
> > the database.
> >
> >
> >
> > On 7/8/05, Vlad Sadilovskiy <vlovsky@xxxxxxxxx> wrote:
> > > Hi,
> > >
> > > Actually you can run it without the starting the service. If you can
> > > peek inside the service you'd see what command line it uses to start
> > > Oracle. The command is:
> > >
> > > %ORACLE_%HOME%\bin\ORACLE.EXE <ORACLE_SID>
> > >
> > > Wait for "Hit any key to exit server:"
> > >
> > > If it finds corresponding registry key and you have autostart
> > > configured, then it'll bring your DB up. Otherwise, you'll need to do
> > > following from the other CMD window.
> > >
> > > set ORACLE_SID=<ORACLE_SID>
> > > sqlplus "/ as sysdba"
> > > startup
> > > exit
> > >
> > > - Vladimir
> > >
> 



-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Other related posts: