Reset sys Oracle password in Linux

Products

• CA Identity Portal
• Clarity PPM On Premise

Issue/Introduction

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

Resolution

1. Delete pwdniku.ora from /$ORACLE_HOME/dbs folder
   
   
2. Run the command: orapwd file=/$ORACLE_HOME/dbs/orapwniku.ora password=system entries=10
   
   
3. Connect to Oracle using sqlplus /nolog
   
   
4. Run command inside SQL prompt: connect sys/system as sysdba
   
   
5. Run the command: alter user system identified by system;
   
   
6. Your user "system" password has now been changed to system (in this example)
   
   
7. Connect to SQLPLUS: sqlplus system/system
   
   
8. Run the command: alter user sys identified by system;
   
   
9. Your sys password now has been changed