Re: For any Oracle Guru : multiinstance management under NT

Answers below.
"Marco Mapelli" <mapellim_at_usa.net> wrote in message news:9d70bd$h4n$1_at_galileo.it.ip-plus.net...
> Hello Oracle Gurus,
>
> I have the following problem.
> I need to start and stop many instances using a batch script under NT but
> ORADIM utility is of no use as it doesn't allow to have much control on
 the
> startup modes.

An aside. Checkout the startmode parameter to oradim. This may be all you need.

> The only way I suppose is using server manages but then here is another
> problem
> that is the when I start all my instaces up the only one I may connect to
 is
> the one for
> which the Registry ORACLE_SID entry is set.

To manually start Oracle services I'd probably use sqlplus assuming 8i or higher.

write a script startup.sql (for those manually started instances.)

connect / as sysdba;
startup;
exit;

similarly shutdown.sql

connect / as sysdba;
shutdown immediate;
exit;

you can then create a batch file along the lines of

net start oracleservice<sid1>
set oracle_sid=sid1
sqlplus @startup.sql
net start oracleservice<sid2>
set oracle_sid=sid2
sqlplus @startup.sql

etc.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK