Database setup hangs while connecting to Oracle DB
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
Symptoms
When setting up a JIRA DB connection to an Oracle 11G server, the process hangs and the following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
2012-03-14 10:26:13,933 main INFO [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2012-03-14 10:26:13,977 main INFO [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory '/apps/jira-home' is validated and locked for exclusive use by this instance.
2012-03-14 10:26:13,977 main INFO [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2012-03-14 10:26:14,167 main INFO [jira.config.database.SystemTenantDatabaseConfigurationLoader] Reading database configuration from /apps/jira-home/dbconfig.xml
2012-03-14 10:26:14,250 main INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcherand there are no further messages in the logs.
Cause
On certain linux platforms the random number generation doesn't function correctly. This is a problem as the jdbc driver needs to encrypt the connect string and username/password when transmitting across the wire. If you don't have that the program just hangs and the driver never succeeds in creating the connection.
Resolution
The fix is to add this line to JAVA_OPTS:
-Djava.security.egd=file:/dev../dev/urandom
Then the connection will work. The issue is described in detail in these blog posts:
https://forums.oracle.com/forums/thread.jspa?messageID=3793101
Was this helpful?