How to unlock the Oracle User (SYTEM)

In this post I  am going to explain how to unlock user oracle database server. here I am going to unlock 'SYTEM' User.

 

Step 1:- you should log as sysdba to  database via SQLPlus as below.

sqlplus sys as sysdba

 Step2 :- To unlock the user, you have to execute below command.

alter user system identified by "Admin1234" account unlock;

Then, you can log into SYSTEM user by using new credentials.

Thank You !!!!!

How to unlock the Oracle User (SYTEM) How to unlock the Oracle User (SYTEM) Reviewed by Pubudu Dewagama on 1:27:00 AM Rating: 5

No comments: