User Tools

Site Tools


howto_change_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;
howto_change_sys_password.txt · Last modified: 2013/02/05 17:16 by dodger