I do not remember my oracle system password



  • I have watched many YouTube videos about how to unlock the password of an Oracle instance, where the user has forgotten there password. In these videos the DBAs used the additional command sys as dba as the username and then did not have to enter any password.

    Once they pressed ENTER, it showed them a sql > prompt, with which they could then alter the password(s), but when I follow these steps, it shows me the following error message:

    error, ORA-12560: TNS:protocol adapter error.

    Does anyone know how to fix this?



  • Make sure you have set ORACLE_SID to the database instance name, in my example it is XE. Your Windows user needs to be a member of local group "ORA_DBA".

    So, now you do not connect to the database by username and password. Instead "/" indicates authentication by the Operating System as sys user.

    C:\>set ORACLE_SID=XE
    C:\>REM login as the database root account "sys"
    C:\>sqlplus / as sysdba
    SQL>alter user system account unlock;
    SQL>exit
    

    Best of luck!


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2