Re: Manual database startup on WinXP

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