星期五, 11月 25, 2011

重建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權限的使用者

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...