Ciberterminal Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== [HOWTO] Reset SYS password ======

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

====== steps ======
  * verify the pwfile:
<code>select * from v$pwfile_users;</code>
  * 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:
<code>orapwd file=$HOME/orapw${ORACLE_SID} password=<PASSWORD> entries=4</code>
  * backup the actual pwd file:
<code>cp $ORACLE_HOME/dbs/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}.BACKUP</code>
  * And replace it:
<code>cp -pfv $HOME/orapw${ORACLE_SID} $ORACLE_HOME/dbs/orapw${ORACLE_SID}</code>
  * Now you can add more users to the pwd file so they can login without having oracle avalaible:
<code>create user DODGER identified by <PASSWORD>;
grant sysdba to DODGER;
</code>


====== 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.
<code bash>
pwget --dbuniquename BAVEL12SGDN
pwcopy --dbuniquename BAVEL12SGDN /home/oracle/orapwdBAVEL12SGDN +DG_DATA_01/BAVEL12SGDN
</code>


How to Restore ASM Password File if Lost ( ORA-01017 ORA-15077 ) (Doc ID 1644005.1)