Re: How to startup oracle9i without using windows services

comments in line
On 7/11/05, Vlad Sadilovskiy <vlovsky_at_gmail.com> 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_at_gmail.com> 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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l