This Site Create for Help Tech guys in Issues and fixes in Linux SAP and Oracle.

Search This Blog

Powered by Blogger.

Create Client in SAP

First Create Client via SCC4 THEN COPY Client via SCCL profile SAP_CUST After copy login into Client 000 and export default users t...

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



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

0 comments:

Post a Comment