0 Replies Latest reply: Aug 16, 2012 1:40 AM by he*422002*st RSS

    ovab introspection error on larger Oracle Single Instance Databases

    he*422002*st
      I do an introspection of a small Oracle Single Instance DB (aprox. 4 Gbyte Datafiles) without any Problem.
      Than i used the introspection on a 70 Gbyte DB and on a 355 Gb DB. Both of the larger DB failed.


      In all the cases on the remote Site with the database the Build of a Database Template was successfull
      and the DB is startet automatically after the "Mount". After some seconds there is a failure in the communication channel.
      (not to the ovab Instance Machine, the failure occurs on the remote Host with the DB)

      On a larger Database the built of the template is 3-4 hours and on the small one only some minutes.
      I suspect a timeout of the Java Secure Channel Mechanism. I can not install the ovab directly on
      the database machines (administrative reasons)

      Anyone was successfull in introspecting "larger" Databases ? or was the plugin only testet in Oracle Development
      with "small" databases with less time needed for generating the database template.

      Thanks for any reply or suggestions..

      I attach the assemblybuilder log of the remote machine: (where the DB is located)

      ###[2012-08-15T15:52:14.339+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.introspector] [tid: 10] IntrospectorServiceActivator - activated
      [2012-08-15T15:52:14.637+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.spif] [tid: 10] Loading Application: oracle.as.assemblybuilder.remoting.app.internal.spif.RemotingApplication
      [2012-08-15T15:52:14.644+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.remoting] [tid: 11] OAB-97200
      [2012-08-15T15:52:24.511+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: . Output: .
      [2012-08-15T15:52:24.591+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: select name from v$recovery_file_dest;. Output: /u02/oraarch/SUPTESTP.
      [2012-08-15T15:52:24.635+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: select version from v$instance;. Output: 11.2.0.3.0.
      [2012-08-15T15:52:24.754+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: select value from v$parameter where name = 'db_unique_name';. Output: SUPTESTP.
      [2012-08-15T15:52:24.803+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: select value from v$parameter where name = 'db_domain';. Output: .
      [2012-08-15T15:52:24.863+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: select name from v$datafile where file#='1';. Output: /u02/oradata/SUPTESTP/system01.dbf.
      [2012-08-15T15:52:24.906+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Query: select name from v$recovery_file_dest;. Output: /u02/oraarch/SUPTESTP.



      [2012-08-15T16:08:57.618+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.remoting] [tid: 13] Notifying method callers and listeners that we received an unexpected exception. This side is exiting.
      [2012-08-15T16:08:57.623+02:00] [as] [ERROR] [] [oracle.as.assemblybuilder.oracle.install.ovm.plugin.sidb.dehydrator] [tid: 12] Introspection failed.[[
      oracle.as.assemblybuilder.remoting.RemotingException: Exception from the underlying communication layer on local side.
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.ClientChannelImpl.makeMethodCall(ClientChannelImpl.java:415)
      at oracle.as.assemblybuilder.remoting.proxy.HandlerProxyHelperImpl$HandlerProxy.makeMethodCall(HandlerProxyHelperImpl.java:183)
      at oracle.as.assemblybuilder.remoting.proxy.HandlerProxyHelperImpl$HandlerProxy.invoke(HandlerProxyHelperImpl.java:134)
      at $Proxy3.createContentResource(Unknown Source)
      at oracle.as.assemblybuilder.remoting.app.internal.proxy.catalog.ApplianceProxyImpl.transferContentResource(ApplianceProxyImpl.java:490)
      at oracle.as.assemblybuilder.remoting.app.internal.proxy.catalog.ApplianceProxyImpl.createContentResource(ApplianceProxyImpl.java:449)
      at oracle.as.assemblybuilder.internal.metadata.appliance.InternalApplianceImpl.createContentResource(InternalApplianceImpl.java:96)
      at oracle.install.ovm.plugin.sidb.dehydrator.DBDehydrator.executeDBCA(DBDehydrator.java:426)
      at oracle.install.ovm.plugin.sidb.dehydrator.DBDehydrator.dehydrate(DBDehydrator.java:199)
      at oracle.install.ovm.plugin.sidb.dehydrator.DBDehydrator.dehydrate(DBDehydrator.java:137)
      at oracle.as.assemblybuilder.introspector.internal.job.DehydrateJobImpl.call(DehydrateJobImpl.java:122)
      at oracle.as.assemblybuilder.introspector.internal.job.DehydrateJobImpl.call(DehydrateJobImpl.java:34)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)
      Caused by: oracle.as.assemblybuilder.remoting.RemotingException: Error in reading from object stream.
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.ObjectChannelImpl.readObject(ObjectChannelImpl.java:133)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.CommunicationChannelImpl.readObject(CommunicationChannelImpl.java:319)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.CommunicationChannelImpl.run(CommunicationChannelImpl.java:239)
      ... 1 more
      Caused by: java.io.EOFException
      at java.io.ObjectInputStream$BlockDataInputStream.peekByte(ObjectInputStream.java:2553)
      at java.io.ObjectInputStream.skipCustomData(ObjectInputStream.java:1899)
      at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1580)
      at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
      at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1731)
      at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
      at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.ObjectChannelImpl.readObject(ObjectChannelImpl.java:128)
      ... 3 more

      ]]
      [2012-08-15T16:08:57.657+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.remoting] [tid: 13] Unable to send shutdown signal to other side. The connection will be closed anyway.
      [2012-08-15T16:08:57.663+02:00] [as] [NOTIFICATION] [] [oracle.as.assemblybuilder.remoting] [tid: 13] Error while closing ObjectChannel, continuing as we're closing anyway.[[
      java.net.SocketException: Socket closed
      at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)
      at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
      at java.io.ObjectOutputStream$BlockDataOutputStream.drain(ObjectOutputStream.java:1847)
      at java.io.ObjectOutputStream$BlockDataOutputStream.flush(ObjectOutputStream.java:1792)
      at java.io.ObjectOutputStream.flush(ObjectOutputStream.java:699)
      at java.io.ObjectOutputStream.close(ObjectOutputStream.java:720)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.ObjectChannelImpl.close(ObjectChannelImpl.java:150)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.CommunicationChannelImpl.stop(CommunicationChannelImpl.java:219)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.CommunicationChannelImpl.run(CommunicationChannelImpl.java:271)
      at java.lang.Thread.run(Thread.java:662)

      ]]
      [2012-08-15T16:08:57.663+02:00] [as] [WARNING] [] [oracle.as.assemblybuilder.remoting] [tid: 14] Exception thrown by method, DehydrateJobFutureHandler.get. Cause will be sent back to other side.
      [2012-08-15T16:08:57.668+02:00] [as] [WARNING] [] [oracle.as.assemblybuilder.remoting] [tid: 14] Unable to process Method request. Exception will be logged here and sent to caller.[[
      java.lang.IllegalStateException: CommunicationChannel has not been started, unable to continue.
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.CommunicationChannelImpl.sendObject(CommunicationChannelImpl.java:301)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.ClientChannelImpl.sendMethodResponse(ClientChannelImpl.java:308)
      at oracle.as.assemblybuilder.remoting.proxy.HandlerStubHelperImpl.invokeHandlerMethod(HandlerStubHelperImpl.java:150)
      at oracle.as.assemblybuilder.remoting.proxy.HandlerStubHelperImpl.invokeHandlerMethod(HandlerStubHelperImpl.java:68)
      at oracle.as.assemblybuilder.remoting.app.internal.proxy.introspector.DehydrateJobFutureStubImpl.onMethod(DehydrateJobFutureStubImpl.java:132)
      at oracle.as.assemblybuilder.remoting.internal.channels.method.callback.MethodCallbackThread.run(MethodCallbackThread.java:98)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)

      ]]
      [2012-08-15T16:08:57.668+02:00] [as] [ERROR] [] [oracle.as.assemblybuilder.remoting] [tid: 14] Remoting error thrown.[[
      java.lang.IllegalStateException: CommunicationChannel has not been started, unable to continue.
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.CommunicationChannelImpl.sendObject(CommunicationChannelImpl.java:301)
      at oracle.as.assemblybuilder.remoting.internal.channels.impl.ClientChannelImpl.sendMethodResponse(ClientChannelImpl.java:308)
      at oracle.as.assemblybuilder.remoting.proxy.HandlerStubHelperImpl.invokeHandlerMethod(HandlerStubHelperImpl.java:73)
      at oracle.as.assemblybuilder.remoting.app.internal.proxy.introspector.DehydrateJobFutureStubImpl.onMethod(DehydrateJobFutureStubImpl.java:132)
      at oracle.as.assemblybuilder.remoting.internal.channels.method.callback.MethodCallbackThread.run(MethodCallbackThread.java:98)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)