This discussion is archived
0 Replies Latest reply: Aug 15, 2012 11:40 PM by he*422002*st RSS

ovab introspection error on larger Oracle Single Instance Databases

he*422002*st Newbie
Currently Being Moderated
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)

Legend

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