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

JIRA | Mark Symons | 1 year ago
  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 | 1 year 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 | 1 year ago | Mark Symons
    java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
  3. 0

    Planning Application is not opening

    Oracle Community | 4 years ago | 889212
    java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Network Error: Error connecting to Essbase Studio server

    Oracle Community | 4 years ago | 967222
    com.hyperion.cp.catalog.exceptions.CatalogInitializationException: Cannot initialize data storage engine.
  6. 0

    druid1.0.15访问oracle rac,节点停掉后不能自动获取另一个节点的连接。

    GitHub | 2 years ago | dxxfire
    java.sql.SQLRecoverableException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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