Wednesday, May 17, 2017

Remote password file


Source your db profile . .SID

enter orapwd


Usage: orapwd file= entries= force= ignorecase= nosysdba=

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
   

  There must be no spaces around the equal-to (=) character.



orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID entries=5 force=y ignorecase=y nosysdba=n

Enter password for SYS:xxxxxxx

after completed.

you can see the orapwSID file find in ORACLE_HOME/dbs/orapwSID

shutdown your database   and add the entry in your initSID.ora

remote_login_passwordfile='EXCLUSIVE'


to check 
select * from v$pwfile_users;



No comments: