Confluence not able to startup due to expiry Oracle User Password
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
The Confluence startup fails and the following appears in the atlassian-confluence.log
1
2
2015-09-03 11:00:25,141 WARN [main] [sf.hibernate.cfg.SettingsFactory] buildSettings Could not obtain connection metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28001: the password has expired)Cause
The Oracle user password used by Confluence has expired
Resolution
You will need to change the password for the Confluence Oracle user and then modify the password in the Confluence configuration. Here's the detailed steps to achieve this:
Shutdown the Confluence.
Reset the Oracle user password.
Change the Oracle user password from the configuration:
For datasource connection:
Open the <confluence-install>/conf/server.xml and look for the line similar to the one below:
1 2 3<Resource name="jdbc/confluence" auth="Container" type="javax.sql.DataSource" username="yourusername" password="yourpassword"Modify the value for the password parameter to the new password.
For direct JDBC connection:
Open the <confluence-home>/confluence-cfg.xml
Look for the following parameter
1<property name="hibernate.connection.password">password</property>Modify the value 'yourpassword' to the new password accordingly.
Restart Confluence.
Was this helpful?