====== [HOWTO] Reset SYS password ======
====== Description ======
This is a very little document on howto reset the SYS password.
====== steps ======
* verify the pwfile:
select * from v$pwfile_users;
* if there's any additional user, you must reset its passwd too.
* Its a good practice to initalice the Oracle environment variables.
* As oracle, create the file:
orapwd file=$HOME/orapw${ORACLE_SID} password= entries=4
* backup the actual pwd file:
cp $ORACLE_HOME/dbs/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}.BACKUP
* And replace it:
cp -pfv $HOME/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}
* Now you can add more users to the pwd file so they can login without having oracle avalaible:
create user DODGER identified by ;
grant sysdba to DODGER;
====== on ASM ======
you must use the password copy tools:
pwget
pwcopy
to know which passwordfile is using and for copying from/to asm to/from localdisks.
pwget --dbuniquename BAVEL12SGDN
pwcopy --dbuniquename BAVEL12SGDN /home/oracle/orapwdBAVEL12SGDN +DG_DATA_01/BAVEL12SGDN
How to Restore ASM Password File if Lost ( ORA-01017 ORA-15077 ) (Doc ID 1644005.1)