Confluence is unable to start because Oracle database user account is locked

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

Confluence will not start up or it will not be able to connect to the database and struggle to start up.

The following appears in the atlassian-confluence.log:

2016-04-28 04:20:00,754 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [mchange.v2.resourcepool.BasicResourcePool] run com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@686d06e1 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: 
java.sql.SQLException: ORA-28000: the account is locked

診断

環境

  • Confluence is running on an Oracle database

診断ステップ

  • Log into the Oracle database with the following commands to look at the account's status: sqlplus sys as sysdba
  • Run the following to print the status for all of your accounts:

    SELECT username, account_status FROM dba_users;
  • Search for the user that Confluence uses to connect to the database. In the following example, the confuser and confluence accounts are open and accessible, but the user scott is locked and would throw the error above:

    USERNAME
    --------------------------------------------------------------------------------
    ACCOUNT_STATUS
    --------------------------------
    CONFUSER
    OPEN
    
    CONFLUENCE
    OPEN
    
    SCOTT
    EXPIRED & LOCKED

原因

The Oracle database account was locked. This often happens when someone tries to log into that account repeatedly with an incorrect password.

ソリューション

  • Confluence をシャットダウンします。
  • Log into Oracle as follows: sqlplus sys as sysdba
  • Run the following to unlock the account:

    alter user scott account unlock;
    grant connect, resource to scott;
  • Ensure the password you are using to connect to that account is up to date and accurate.
  • Confluence を再起動します。

 

 

最終更新日 2016 年 5 月 11 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.