Re: Autostart Oracle Server on NT

There's alledgedly three ways to do it without supplying the password, two of which I know work:

1. Under the ORACLE registry key, add a sub-key called DBA_AUTHORIZATION. For Oracle7.3, set the value to "BYPASS". For Oracle8, set it to the INTERNAL password.
2. Add the user that the OracleStartSID service runs under to the OSDBA group (??? or is it DBA???, can't remember). You'll probably have to manually create the group. Check the "Getting Started" to be sure on the group name.
3. Supposedly, you can do this using a password file (plus a specific setting in the init.ora), but I don't believe I've ever actually gotten that to work.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Yat-Fan wrote in message <7necvh$s7c_at_ustsu10.ust.hk>...
>Hi all,
>
>I am using Oracle 7.3 and 8.0 on NT. With Oracle server set to automatic
>start, I see that there is a file
>strtTEL1.cmd (where TEL1 is the SID) under orant\database\ with content
>similar to the following:
>
>c:\orant\bin\oradim80.exe -startup -sid TEL1 -usrpwd password -starttype
>srvc,inst -pfile c:\orant\database\inittel1.ora
>
>The password "password" of Oracle internal is exposed! I wonder what should
>be done to avoid this while still enjoying autostart.
>
>For manual startup and shutdown, we are using an operator ID granted with
>SYSOPER privilege.
>
>Many thanks.
>
>Rgds.,
>fan (Yat-Fan HO).
>(KCRC, Hong Kong)
>ps. Best is if a copy of your reply can be cc: to my email address at
>fan.ho_at_alumni.ust.hk
>
>
>
Received on Mon Jul 26 1999 - 21:25:21 CDT