New Installation Oracle Database Error

[Matt Uebel]

I have set up a new installation of Confluence 5.3 with an 11G Oracle DB. I have the driver in place, and seem to be able to connect to the DB, and to start configuring it at least in some way, but part-way through the process it fails with:

Error occurred during template rendering: Invocation of method 'getRenderedTemplateHtml' in class com.atlassian.confluence.plugins.soy.VelocityFriendlySoyTemplateRenderer threw exception com.google.template.soy.tofu.SoyTofuException: In template navlinks.templates.appswitcher.switcher: When evaluating "showAppSwitcher()": Error while computing function "showAppSwitcher()": could not read a hi value - you need to populate the table: hibernate_unique_key; nested exception is net.sf.hibernate.id.IdentifierGenerationException: could not read a hi value - you need to populate the table: hibernate_unique_key at /decorators/includes/common-header.vm[line 4, column 49]. Contact your administrator for assistance.

If I attempt to restart the Database process, it will advise me that tables already exist, and I ask that it overwrite the tables, but then I receive the same error. Does anybody know what could be going on here?

EDIT:
Troubling log entries in the Tomcat log:

SEVERE: The web application [] registered the JDBC driver [org.hsqldb.jdbc.JDBCDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [Timer-2] but has failed to stop it. This is very likely to create a memory leak.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] but has failed to stop it. This is very likely to create a memory leak.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] but has failed to stop it. This is very likely to create a memory leak.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] but has failed to stop it. This is very likely to create a memory leak.

[Matt Uebel · Accepted solution]

Worked with DBA and found that the problem was related to a quota limit set on the Confluence user. Removing this limit resolved the issue, and the database connection process was successful.

[catherine kylie]

Oracle is pushing its way harder in cloud software. It had growth of 24% from revenues in cloud and 60% growth in bookings. It will take time for transition from traditional licensing based software to cloud based software offerings, but company will catch up with its competitors. Posted By: http://bit.ly/1geCfP7

[Matt Uebel]

I got the driver from:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

in particular, the one for Oracle Database 11g Release 2 (11.2.0.1.0) JDBC Drivers

[PeterKoczan]

Also make sure that you schema is set up according to the requirements, pay extra attention to the all_objects view in the users' schema: https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle

[Matt Uebel]

log seems to be dominated by JDBC driver issues, I updated the question with a sample.

[Tiago Comasseto]

There are two log files that you can check, one is the application log atlassian-confluence.log and the other one is the Tomcat log. Tomcat log is catalina.out for linux or stdout.xxxx and stderr.xxx for windows.

You can see more details here: https://confluence.atlassian.com/display/DOC/Working+with+Confluence+Logs

[Matt Uebel]

Whats the best log to check for those sorts of errors?

[Tiago Comasseto]

Hi Matt,

It seems to me a side effect and not the root cause, is there any erro before that in your logs?

Cheers