Re: Using DBCA to clone database structure, hangs at 60%

I opened a case very similar to this on *12-JUL-07 14:54:08** GMT*. The case was closed on *06-JUN-08 00:01:05** GMT* as bug 6211966, and Oracle Dev is "working on fixing this bug in release 11.2". One of the workaround states: " If you create DB alone or do script gen and db creation in different invocations of DBCA, you will
not hit this issue."

Which I have not tried yet.

On Wed, Jun 18, 2008 at 4:59 PM, Don Seiler <don_at_seiler.us> wrote:

> No, emctl isn't even configured for this instance.
>
> For what it's worth, there are 4 instances running on this machine.
>
> Don.
>
> On Wed, Jun 18, 2008 at 4:33 PM, April Sims <sims_at_suu.edu> wrote:
> > Don,
> >
> > Do you have an Intelligent Agent for Grid Control running on this node?
> >
> > Try turning it off if you do.
> >
> > emctl stop agent
> >
> >
> >
> > April Sims
> > SELECT IOUG Contributing Editor
> > http://aprilcsims.wordpress.com
> > OCP 8i, 9i, 10g DBA
> > Southern Utah University
> > sims_at_suu.edu
> > 940-484-4276
> >
> >
> >>>> "Don Seiler" <don_at_seiler.us> 6/18/2008 4:21 PM >>>
> > I'm trying to use DBCA to create a template from an existing database.
> > The existing database is Oracle 10.2.0.2 on sparc. I've used dbca
> > both remotely from my workstation (winxp 10.2.0.1), connecting over
> > sqlnet, and locally on that server via VNC. In both cases, DBCA hangs
> > at 60% on "Creating a template from the database". In both cases, the
> > $ORACLE_HOME/cfgtoollogs/dbca/trace.log ends with these messages
> > (thread number differs from time to time):
> >
> > [Thread-3] [16:6:7:854] [StepContext$ModeRunner.run:2458] ----
> > Progress Needed:=true
> > [Thread-3] [16:6:7:869] [BasicStep.execute:202] Executing Step :
> > GEN_TEMPLATE_FROM_DB
> > [Thread-3] [16:6:7:869] [BasicStep.configureSettings:304]
> > messageHandler being set=null
> > [Thread-3] [16:6:22:276]
> > [DatabaseAttributes.getTablespaceAttributes:684] bOMFMode=false
> >
> > Google and metalink have failed me (or I've failed them). I'm trying
> > to create templates for structure only, no data. I've tried with and
> > without OMF conversion, same results. There's nothing in the server's
> > alert logs relating to this.
> >
> > I've let this sit at 60% for over 2 hours at some points. I haven't
> > tried this before, but I would think it shouldn't take that long.
> > Additionally, hitting "Stop" just hangs as well.
> >
> > If anyone has any suggestions, I'll try nearly anything at this point.
> >
> > --
> > Don Seiler
> > http://seilerwerks.wordpress.com
> > ultimate: http://www.mufc.us
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
>
>
>
> --
> Don Seiler
> http://seilerwerks.wordpress.com
> ultimate: http://www.mufc.us
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Charles Schultz

--
http://www.freelists.org/webpage/oracle-l