Table of Contents

[HOWTO] Reset SYS password

Description

This is a very little document on howto reset the SYS password.

steps

select * from v$pwfile_users;
orapwd file=$HOME/orapw${ORACLE_SID} password=<PASSWORD> entries=4
cp $ORACLE_HOME/dbs/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}.BACKUP
cp -pfv $HOME/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}
create user DODGER identified by <PASSWORD>;
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)