Re: The internal password!

Hello world!
The exact procedure w/regards to internal passwords on NT is the following:

1.) create a passwordfile with orapwd73:

    orapwd73 file=<your_filename> password=<your_new_password>

             entries=<#of dbas to register here> 2.) let your Server's registry point to this passwordfile:

    add/modify ORA_PWFILE=<exact path and filename from step 1.)>     add/modify DBA_AUTHORIZATION=<different from BYPASS!>     perform these changes in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

3.) connect to your database as internal/<your_new_password>
4.) shutdown your database
5.) Set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in your INIT.ORA

    (alternatively, use the setting SHARED for Parallel Servers) 6.) Restart your DB

Steps 4.) to 6.) are not needed if you don't want to GRANT SYSDBA/SYSOPER to "normal" DB-users.

The Rest of the sequence works in *any* case on NT, you just have to know the Adminstrator's password.

Hope this helps, RGW
In article <35219F4C.CFE32092_at_hkusua.hku.hk>,   Man Yeung <h9207754_at_hkusua.hku.hk> wrote:
>
> Hi,
> Thank you for help. As I know, the internal passwd is created when the
> instance created by the oradimxx.exe. When the instance is created using the
 line
> mode of instance manager, there is a parameter -initpwd. If I forgot the
 passwd,
> how can I change the internal passwd. Do it work if I set the
> remote_login_passwordfile to null?
> TIA
>
> Man Yeung
> yngm_at_chowsangsang.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 03 1998 - 00:00:00 CEST