Oracle Account locked workaround record

Today in a visit to an old project, the background error prompts Oracle account locked, has always been able to access the normal, do not know why this problem occurs, Baidu for a reason is probably multiple landing failure caused, the general database default is 10 attempts to lock the user after the failure, Find out the reason after the next is to solve the problem, the solution is very simple: to unlock the user on the line, but the problem appears in the search for users.

The structure of Oracle itself is not very familiar with, so in unlocking the user's time to go a lot of detours, the following one by one way to:

First, because the database has been long, forgot the SYS user password, so only remote to the server login, in the login is indeed encountered another error: insufficient privileges

After Baidu Discovery is Oracle DBA Group setup problem, then set up, add current user Jackvc.qin to ORA_DBA Group:

After Setup is complete successfully, SYS successfully links:

The next step is to unlock the user.

Second, the same is because of the Oracle instance, the user concept is not clear enough to unlock the user in the Dba_users table is not found to be locked users, baffled it. After viewing the Oracle profile finally found the problem, originally created on the server three DB instances: Databasea, ORCL, Databasec, and the locked user belongs to the instance ORCL, However, I did not specify which instance to connect to when I logged in with the SYS user (Databasea is connected by default), so I cannot find the locked user. A reason was found to log back in the SYS user and specify the connection to the ORCL instance:

Locate the locked user and unlock the user:

Restart the project, the database link is successful!