Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle11g Express Edition SYSTEM schema is locked

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.

like image 496
Renga Avatar asked Dec 14 '12 21:12

Renga


1 Answers

> sqlplus / as sysdba
sql> alter user system identified by *newpassword* account unlock;
like image 109
Alexandr Gavrilov Avatar answered Oct 22 '22 18:10

Alexandr Gavrilov