Re: Oracle 8 Shutting Down

Ferran Foz wrote:

> My problem is different but related, i want to start 2 oracle instances
> at boot time, i have told it to boot AUTO with ORADIM80, but it
> does not work.
>
> Can you help me? Thank you!

<snip>

Suppose you have two instances, called INS1 and INS2.

Try this: (one line only!)
oradim80 -NEW -sid INS1 -starttype(inst, srvc) -startmode=automatic -intpwd=oracle -pfile=f:\orant\database\initINS1.ora

oradim80 -NEW -sid INS2 -starttype(inst, srvc) -startmode=automatic -intpwd=oracle -pfile=f:\orant\database\initINS2.ora

If the services exist, you could issue:
oradim80 -EDIT -sid INS1 -startmode=automatic -intpwd=oracle -pfile=d:\databases\initINS1.ora
Same for INS2, of course.
Alternatively, go to the control panel, services, find the OracleStartINS1 service, and use the Startup... button to change the mode from Manual to Automatic. Of course, the services must exist - see the first command ;)

I have had some 8 instances running off an NT box, and used three command files to do this:

cre_srvc.bat:
if '%1' == '' goto use
oradim80 -NEW -sid %1 -starttype(inst, srvc) -startmode=automatic -intpwd=oracle -pfile=f:\orant\database\init%1.ora
goto end
:use
echo Usage of this command:
echo cre_srvc SID_NAME
:end

mod_srvc.bat:
if '%1' == '' goto use
oradim80 -EDIT -sid %1 -startmode=automatic -intpwd=oracle -pfile=d:\databases\init%1.ora
goto end
:use
echo Usage of this command:
echo mod_srvc SID_NAME
:end

del_srvc.bat:
oradim80 -DELETE -sid %1

You could then create a creallsvrc.bat, containing:

call (directory)\cre_srvc.bat INS1
call (directory)\cre_srvc.bat INS2

HTH,
frank Received on Mon Mar 22 1999 - 00:00:00 CET