admin User is blocked on Oracle

Hello,

After several times of trying to connect with wrong user password my Oracle admin user has been blocked. How can I unblock the user ?Please help me !!
ziya007Asked:
Who is Participating?
 
TolomirConnect With a Mentor AdministratorCommented:
Log in sqlplus on the server (this needs no password)

sqlplus / as sysdba

SQL> alter user system account unlock;

---

Tolomir
0
 
Ashish PatelCommented:
Please read the artical in below link. may be that can help you. A brief description is given but you can read more details after you register into the site.
http://searchsap.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid21_gci1254835,00.html
0
 
TolomirAdministratorCommented:
I guess you are talking about the system or also the sys user?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
ziya007Author Commented:
No not sys user. The user wich has admin privilages. We had enetered password several times, and the user is now locked. is there any way to unlock ?
I need help really..
0
 
TolomirAdministratorCommented:
...or replace "system" with the username that is locked.
0
 
Ashish PatelCommented:
Did you go through the link and artical in there.
0
 
ziya007Author Commented:
asvforce: -
Select all entries of table USR02 .. i am writing

select * from USR02 .. it gives error , table or view doesnt exist
0
 
TolomirAdministratorCommented:
Ziya007: Is you Adminuser meant for accessing oracle or SAP?

My solution is to unlock the user in the oracle context.

Asvforce seams to have SAP running on Oracle in mind, in case that user is locked, not affecting oracle but the logon to SAP.
0
 
ziya007Author Commented:
Thank you both for help.
0
 
TolomirAdministratorCommented:
Thank you.

Tolomir

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.