How to reset password for user "sys" in Oracle?
How
to reset password for user "sys" in Oracle?
Solution:
- 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
0 comments:
Post a Comment