This discussion is archived
0 Replies Latest reply: Feb 12, 2013 9:57 AM by LinusH RSS

OVM Manager 3.2.1 broken when using Oracle database

LinusH Newbie
Currently Being Moderated
When using an existing Oracle database schema during upgrade from 3.1.1 to 3.2.1 OVM Manager, the install hangs at step 9. The thread listening on port 54321 crashes with java.io.StreamCorruptedException: invalid type code: 01 and the installer never finishes.

If I install OVM Manager with included MySQL, the install completes normally. If I then use the ovm_admin command with --modifyds directive to change it to use the Oracle database, ovm_admin completes then issues a message stating the ovmm service must be restarted for the change to take effect. When I shut down and then start the service, again I get a hang and the log shows:

####<Feb 12, 2013 12:48:21 PM EST> <Warning> <JDBC> <vmmgr.domain.local> <AdminServer> <OracleVM Service-1> <<anonymous>> <> <0000JnFXJcd5IfWFLzmJOA1H6c1C000002> <1360691301125> <WL-001164> <Unable to initialize connection in pool "OVMDS". Initialization SQL = "SET SESSION tx_isolation='READ-COMMITTED'". Received exception: "java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option
".>
####<Feb 12, 2013 12:48:21 PM EST> <Info> <com.oracle.ovm.mgr.control.service.VirtualizationService> <vmmgr.domain.local> <AdminServer> <OracleVM Service-1> <<anonymous>> <> <0000JnFXJcd5IfWFLzmJOA1H6c1C000002> <1360691301130> <BEA-000000> <CRITICAL - Data source failure - Shutting down system!
java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException: 0:java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option

at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:457)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:342)
at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:329)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:417)
at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:324)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:94)
at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:63)
at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1677)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1475)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
at com.oracle.ovm.mgr.control.service.VirtualizationService$1.getConnection(VirtualizationService.java:480)
at com.oracle.odof.core.storage.RelationalStore.acquireConnection(RelationalStore.java:2143)
at com.oracle.odof.core.storage.RelationalStore.initSystemSchema(RelationalStore.java:1739)
at com.oracle.odof.core.storage.RelationalStore.startup(RelationalStore.java:2095)
at com.oracle.odof.core.storage.ObjectStore.startup(ObjectStore.java:851)
at com.oracle.odof.OdofDirector.initDirector(OdofDirector.java:264)
at com.oracle.odof.OdofMain.main(OdofMain.java:141)
at com.oracle.ovm.mgr.control.service.DatabaseTask.doTask(DatabaseTask.java:38)
at com.oracle.ovm.mgr.util.concurrent.RunnableTask.run(RunnableTask.java:26)
at java.lang.Thread.run(Thread.java:662)
at com.oracle.ovm.mgr.util.concurrent.OvmThread.run(OvmThread.java:151)

at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1484)
at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:446)
at weblogic.jdbc.jta.DataSource.connect(DataSource.java:403)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:364)
at com.oracle.ovm.mgr.control.service.VirtualizationService$1.getConnection(VirtualizationService.java:480)
at com.oracle.odof.core.storage.RelationalStore.acquireConnection(RelationalStore.java:2143)
at com.oracle.odof.core.storage.RelationalStore.initSystemSchema(RelationalStore.java:1739)
at com.oracle.odof.core.storage.RelationalStore.startup(RelationalStore.java:2095)
at com.oracle.odof.core.storage.ObjectStore.startup(ObjectStore.java:851)
at com.oracle.odof.OdofDirector.initDirector(OdofDirector.java:264)
at com.oracle.odof.OdofMain.main(OdofMain.java:141)
at com.oracle.ovm.mgr.control.service.DatabaseTask.doTask(DatabaseTask.java:38)
at com.oracle.ovm.mgr.util.concurrent.RunnableTask.run(RunnableTask.java:26)
at java.lang.Thread.run(Thread.java:662)
at com.oracle.ovm.mgr.util.concurrent.OvmThread.run(OvmThread.java:151)
>
####<Feb 12, 2013 12:48:21 PM EST> <Info> <com.oracle.ovm.mgr.control.service.VirtualizationService> <vmmgr.domain.local> <AdminServer> <OracleVM Service-1> <<anonymous>> <> <0000JnFXJcd5IfWFLzmJOA1H6c1C000002> <1360691301132> <BEA-000000> <Virtualization Service Abnormal Stop...>
(END)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points