dba:oracle:howtos:howto_change_sys_password
Table of Contents
[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=<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 <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)
dba/oracle/howtos/howto_change_sys_password.txt · Last modified: 2023/01/31 08:26 by dodger