How to startup oracle9i without using windows services 2005-07-11 - By Niall Litchfield
comments in line
On 7/11/05, Vlad Sadilovskiy <vlovsky@(protected)> 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@(protected)> 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@(protected)> 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
comments in line<br>
<div><span class="gmail_quote">On 7/11/05, <b class="gmail_sendername">Vlad
Sadilovskiy</b> <<a href="mailto:vlovsky@(protected)">vlovsky@(protected)</a>>
; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">I wonder if you know why this person needs
what he/she asks for? And<br>of course you can and will use any undocumented
means if you are in
<br>need. </blockquote>
<div> </div>
<div>Hmm, but I didn't see any note that said that your method ran Oracle
.exe under 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.
</div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">For instance, Oracle puts start up script
/link in /etc/rc*.d<br>folders on *ix boxes. Will you always consider starting
/shutting
<br>Oracle instances with those scripts? Why is the Windows any different?<
/blockquote>
<div> </div>
<div>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. </div>
<div> </div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">In this (software,hardware) world you can do
anything if you know how<br>it works. The only question whether it is really
necessary to use
<br>undocumented means.</blockquote>
<div> </div>
<div>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.
</div>
<div> </div>
<div> </div><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">- Vladimir<br><br>On 7/11/05, Niall
Litchfield <<a href="mailto:niall.litchfield@(protected)">niall.litchfield
@(protected)
</a>> wrote:<br>> I've been watching all this with some incredulity.<br>
><br>> services are the appropriate technological approach to use for
background<br>> processes (like the Oracle.exe process) on the win32
platform. You should
<br>> use them where provided, and encourage your third party vendors that
write<br>> for the win32 platform to use them as well.<br>><br>>
thomas' approach is certainly the most common way to script the startup and
<br>> shutdown of services on the windows platform.<br>><br>>
generically you have another approach which is to use the windows management<br
>> instrumentation interface, start here for information<br>> for oracle
you also have the option of calling
oradim.exe to start and stop<br>> the database.<br>><br>><br>><br>
> On 7/8/05, Vlad Sadilovskiy <<a href="mailto:vlovsky@(protected)">vlovsky
@(protected)</a>> wrote:<br>> > Hi,<br>> ><br>> > Actually
you can run it without the starting the service. If you can
<br>> > peek inside the service you'd see what command line it uses to
start<br>> > Oracle. The command is:<br>> ><br>> > %ORACLE_
%HOME%\bin\ORACLE.EXE <ORACLE_SID><br>> ><br>> > Wait for
"Hit any key to exit server:"
<br>> ><br>> > If it finds corresponding registry key and you have
autostart<br>> > configured, then it'll bring your DB up. Otherwise, you
'll need to do<br>> > following from the other CMD window.
<br>> ><br>> > set ORACLE_SID=<ORACLE_SID><br>> >
sqlplus "/ as sysdba"<br>> > startup<br>> > exit<br>>
><br>> > - Vladimir<br>> ><br></blockquote></div><br>
<br><br>-- <br>Niall Litchfield<br>Oracle DBA<br><a href="http://www.niall
.litchfield.dial.pipex.com">http://www.niall.litchfield.dial.pipex.com</a>
|
|
