How to reset sys Oracle password in Linux?

Document ID : KB000051061
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How to reset password for user "sys" in Oracle?

Solution:

  1. Delete pwdniku.ora from /$ORACLE_HOME/dbs folder

  2. Run command orapwd file=/$ORACLE_HOME/dbs/orapwniku.ora password=system entries=10

  3. Connect to Oralce using sqlplus /nolog

  4. Run command inside SQL prompt: connect sys/system as sysdba

  5. Run command: alter user system identified by system;

  6. At this point your user "system" password has been changed to system in this example

  7. Connect to SQLPLUS: sqlplus system/system

  8. Run command: alter user sys identified by system;

  9. Your sys password now has been changed