Re: Auto Startup in NT?

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Fri, 19 Feb 1999 10:31:09 +0100
Message-ID: <36CD2F5D.41F85E44@t-online.de>

Sean Dolan schrieb:
>
> When my NT machine is restarted, the Oracle instance does not start with it. I have to run SVRMG23 and use the stratup pfile command. How do I get this instance to start automatically?
>
> Thank you,
> Sean Dolan
> sean_at_3si.com

Hi,

be shure that %oraclrhome%\database contains the file start<SID>.cmd. It should contain something like:

    %oraclehome%\bin\oradim73.exe -startup -sid ORCL -usrpwd <pwd>

                              -starttype srvc,inst
                              -pfile %oraclehome%\database\initorcl.ora

(in one line). This command file is called by the oracle services to start up the instance.

Check within the control paneel wether the OracleService<SID> and OracleStart<SID> are marked as to startup automatically. If they are to startup automatically you may have a problem with your password file. Then kill the mentioned services and recreate them. If you have neither of these service or one or the other lakes then recreate the services:

1. delete %oraclehome%\DATABASE\pwd<SID>.ora
2. open a DOS-box: DOS> set ORACLE_SID=<SID> DOS> oradim73 -delete -sid <SID> -srvc OracleService<SID>, OracleStart<SID> -- if existant

       DOS> oradim73 -new -sid <SID> -intpwd <secrect pwd> -maxusers <max_users> -startmode auto -pfile %oraclehome%\database\init<SID>.ora

    3. Take a look at %oraclehome%\rdbms73\oradim73.log for errors.     4. Then start the services

       DOS> net start OracleStart<SID>

HTH
Matthias
--
grema_at_t-online.de

Es gibt nichts Neues mehr.
Alles, was man erfinden kann, ist schon erfunden worden. Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899 Received on Fri Feb 19 1999 - 03:31:09 CST