When connecting to Oracle using Java, the following error occurs: theaccountislocked.

Source: Internet
Author: User
Connect Oracle with Java, after running for a period of time, program error, connection failed, ora-28000theaccountislocked, this reason occurs because the user is locked

Connect to Oracle with Java. After running for a while, the program reports an error, connection failed, ora-28000 the account is locked. This occurs because the user is locked

Connect to Oracle with Java, run a period of time, the Program reported an error, connection failed, ora-28000 the account is locked, this reason occurs, because the user is locked, generally this situation, there are several reasons:

1. The reason is that the number of database connections by the program exceeds the configured number of connections;

2. the user has been connected to the database with an incorrect key code during the online process. As a result, the Oracle database considers that someone is cracking the password and will lock the user more than a certain number of connections.

Solution:

1. log on to Oracle as a super administrator, and then execute the unlock statement: alter user username account unlock; (Note: username is the Locked user Name)

2. Increase the number of connections in the connection pool.

3. log on to Oracle with another user name --> select myjob --> View users --> Find the locked user name, right-click "edit" --> remove "account locked" --> click "application" and then click "close" --> log on again --> OK.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.