5

Recently I installed oracle 11g Express Edition in my windows 7 (64 bit) OS. I have set the password for SYSTEM schema while installing Oracle. I have tried to login SYSTEM schema. But I failed to login because of wrong password. Now the account is locked. I could not find the password as i didn't unlock any other schema.

Please help me to re-set or find the password.

Renga
  • 119
  • 1
  • 3
  • 12
  • See this question for how to reset password: http://stackoverflow.com/questions/740119/default-passwords-of-oracle-11g - generally you shouldn't log in directly as sys or system in recent Oracle versions, but "... as sysdba" – Lord Peter Dec 14 '12 at 21:30

1 Answers1

12
> sqlplus / as sysdba
sql> alter user system identified by *newpassword* account unlock;
Jeffrey Kemp
  • 59,135
  • 14
  • 106
  • 158
Alexandr Gavrilov
  • 151
  • 1
  • 3
  • for me `sqlplus / as sysdba` resulted in a TNS Protocol Error. Instead, `sqlplus SYSTEM@PM as sysdba` worked. SYSTEM is the user that was locked out. And PM is a database. – septerr Feb 26 '16 at 01:12
  • Thank you Alexadr... I was searching the correct answer for a day. – ÖMER TAŞCI Feb 16 '17 at 05:34