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
- Delete pwdniku.ora from /$ORACLE_HOME/dbs folder
- Run command orapwd file=/$ORACLE_HOME/dbs/orapwniku.ora password=system entries=10
- Connect to Oralce using sqlplus /nolog
- Run command inside SQL prompt: connect sys/system as sysdba
- Run command: alter user system identified by system;
- At this point your user "system" password has been changed to system in this example
- Connect to SQLPLUS: sqlplus system/system
- Run command: alter user sys identified by system;
- Your sys password now has been changed
Feedback