重建password file

Syntax:

 

ORAPWD FILE=filename [ENTRIES=numusers]

   [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]

-

先確定

alter system set remote_login_passwordfile=exclusive scope=spfile; (default : none)

-

The following command creates a password file named orapworcl that allows up

to 5 privileged users with different passwords.

 

orapwd file='/oracle/9.2/dbs/orapw"""<SID>"""' password=FXTWA100 entries=5

-

建完之後記得測試，看是否會寫到passwd file去。

SQL>

grant sysdba to sys;

 

-

Viewing Password File Members

select * from  V$PWFILE_USERS;

 

看到的是sysdba , sysoper權限的使用者