Clarity PPM: Reset sys Oracle password in Linux

book

Article ID: 51061

calendar_today

Updated On:

Products

CA Identity Governance 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 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