Re: Manual database startup on WinXP

Ralf Zwanziger 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
>
>
> --
> to contact me by email, please remove the "X" from the first part of
my
> mail address.

C:\> net start CompleteServiceName
is same as starting a service from Service Manager. C:\> net stop CompleteDServiceName
is the opposite of net start.
You can easily incorporate these into a batch file.

Regards
/Rauf Received on Thu Dec 02 2004 - 03:51:38 CST