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)
Reviewed by Pubudu Dewagama
on
1:27:00 AM
Rating:
No comments: