Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Manual database startup on WinXP

Re: Manual database startup on WinXP

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 02 Dec 2004 15:48:22 -0800
Message-ID: <1102031202.582729@yasure>


Sybrand Bakker wrote:

> On Thu, 02 Dec 2004 07:44:24 +0100, Ralf Zwanziger
> <goldenXsurfer_at_gmx.de> wrote:
> 
> 

>>I installed an oracle 9.2 database for testing purposes on WinXP.
>>Because I don't need it very often, I switched all the oracle services
>>to "manual start".
>>I'm not the mouse-clicking-fan, so I'm looking for a script "batch file
>>or vb-script" like dbstart / dbshut on Unix installations. The script
>>should do:
>>
>>- start the listener
>>- startup the database
>>- start the http server
>>
>>Starting the listener is easy in a dos box. But when I try to connect
>>to the idle database by doing:
>>sqlplus "/ as sysdba"
>>I only get an "ORA-28009: Generic protocol adapter error"
>>
>>Is there a possibility to start up and shutdown database, listener and
>>http server by script on WinXP or is it just not supported?
>>
>>Thanks in advance,
>>Ralf
> 
> 
> 
> it is supported AND documented. 
> oradim -startup -sid <your sid> etc
> (see oradim -? for parameters)
> 
> please do not treat usenet as a replacement for the docs
> 
> 
> --
> Sybrand Bakker, Senior Oracle DBA

I agree with your comment to the OP about using usenet as a replacement for reading the docs ... but wouldn't netstart be better than oradim?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Dec 02 2004 - 17:48:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US