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

JIRA | Mark Symons | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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