java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress

JIRA | Mark Symons | 2 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    It would be useful if the "Configure SQL for Confluence" screen offered a facility to test datasources as they are added or modified. eg, a test button per data source. The documentation does provide a mechanism for testing: {noformat} ..create a page and use Insert -> Markup to add the following wiki markup : {sql-query:dataSource=example} select 1 {sql-query} {noformat} ...but this necessitates switching back and forth, etc, and is a bit more fiddly, and (most importantly) does not display the actual error message. To explain, in my tests I get logged exceptions that are really useful but Confluence does not display this: {noformat} 2015-08-11 14:37:49,767 ERROR [http-bio-8090-exec-241] [swift.confluence.sql.SqlDataHelper] getDatabaseConnectionFromDriverManager Exception: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441) 2015-08-11 14:37:49,777 WARN [http-bio-8090-exec-241] [xhtml.view.macro.ViewMacroMarshaller] marshalInternal Exception executing macro: sql-query, with message: Unable to connect to database using jdbc:oracle:thin:@xxxxx:9999:XE with user YYYYY -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent {noformat} In other words, the "ORA-01033: ORACLE initialization or shutdown in progress" is *much* more interesting that the "Unable to connect to database..." that is displayed by the macro.

    JIRA | 2 years ago | Mark Symons
    java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
  2. 0

    It would be useful if the "Configure SQL for Confluence" screen offered a facility to test datasources as they are added or modified. eg, a test button per data source. The documentation does provide a mechanism for testing: {noformat} ..create a page and use Insert -> Markup to add the following wiki markup : {sql-query:dataSource=example} select 1 {sql-query} {noformat} ...but this necessitates switching back and forth, etc, and is a bit more fiddly, and (most importantly) does not display the actual error message. To explain, in my tests I get logged exceptions that are really useful but Confluence does not display this: {noformat} 2015-08-11 14:37:49,767 ERROR [http-bio-8090-exec-241] [swift.confluence.sql.SqlDataHelper] getDatabaseConnectionFromDriverManager Exception: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441) 2015-08-11 14:37:49,777 WARN [http-bio-8090-exec-241] [xhtml.view.macro.ViewMacroMarshaller] marshalInternal Exception executing macro: sql-query, with message: Unable to connect to database using jdbc:oracle:thin:@xxxxx:9999:XE with user YYYYY -- referer: http://foo.bar.com/pages/editpage.action?pageId=24283889 | url: /pages/rendercontent.action | userName: fred | action: rendercontent {noformat} In other words, the "ORA-01033: ORACLE initialization or shutdown in progress" is *much* more interesting that the "Unable to connect to database..." that is displayed by the macro.

    JIRA | 2 years ago | Mark Symons
    java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress

    Root Cause Analysis

    1. java.sql.SQLRecoverableException

      ORA-01033: ORACLE initialization or shutdown in progress

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      T4CTTIoauthenticate.processError
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
      4. oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441)
      4 frames