Re: stuck on Clone database creation step

From: jim <jhavero_at_gmail.com>
Date: Wed, 8 Oct 2008 10:23:07 -0700 (PDT)
Message-ID: <d7c4c2d7-7010-432c-8807-d9543ab86efa@d31g2000hsg.googlegroups.com>


On Oct 7, 12:16 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> "jim" <jhav..._at_gmail.com> schreef in berichtnews:175fb975-c23c-4d07-b294-f0b8d9522297_at_34g2000hsh.googlegroups.com...
> CloneRmanRestore.log is empty.
>
> On Oct 7, 12:16 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
>
>
>
> > "jim" <jhav..._at_gmail.com> schreef in
> > berichtnews:33fefbe8-1942-45be-8058-481160060de4_at_x41g2000hsb.googlegroups.com...
>
> > > I'm try installing Oracle 10g on a pSeries RHEL 4.
>
> > > I'm on the "Database Configuration Assistant" screen and the "Clone
> > > database creation in
> > > progress" bar shows 2% complete and is stuck there. I've waited a few
> > > hours and it hasn't moved. There no disk activity and no errors so I
> > > don' know what is going on.
>
> > > A tail of trace.log under cfgtoollogs/dbca shows,
>
> > > [Thread-3] [12:49:43:940] [Oratab.getTempFile:710] Temp oratab: /tmp/
> > > oratab
> > > [Thread-3] [12:49:44:480] [CloneRmanRestoreStep.executeImpl:217]
> > > Instance Creation went fine..........
> > > [Thread-3] [12:49:44:481] [CloneRmanRestoreStep.executeImpl:224]
> > > db_recovery_file_dest=/u01/app/oracle/flash_recovery_area
> > > [Thread-3] [12:49:44:481] [CloneRmanRestoreStep.executeImpl:227]
> > > db_recovery_file_dest_size=2147483648
> > > [Thread-3] [12:49:44:783] [SQLEngine.setSpool:1743] old Spool = null
> > > [Thread-3] [12:49:44:784] [SQLEngine.setSpool:1744] Setting Spool = /
> > > u01/app/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl/
> > > CloneRmanRestore.log
> > > [Thread-3] [12:49:44:789] [SQLEngine.setSpool:1745] Is spool
> > > appendable? --> true
> > > [Thread-3] [12:49:44:790] [CloneRmanRestoreStep.executeImpl:320]
> > > starting with pfile=/u01/app/oracle/admin/orcl/pfile/init.ora
>
> > Did you check the file
> > u01/app/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl/CloneRmanRestore.log
> > ?
>
> > Shakespeare
>
> Take a look at Note:188134.1 (metalink) to trace DBCA.
>
> Shakespeare

/u01/app/oracle/admin/orcl/pfile/init.ora does exist however I am seeing these "Fatal Error" lines higher up in my trace.log:

[Thread-3] [9:25:13:759] [StepContext$ModeRunner.run:2458] ---- Progress Needed:=true
[Thread-3] [9:25:17:39] [BasicStep.execute:201] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-3] [9:25:17:39] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-3] [9:25:17:41] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-3] [9:25:17:41] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-3] [9:25:17:41] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-3] [9:25:17:42] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-3] [9:25:17:309] [BasicStep.execute:201] Executing Step : INSTANCE_CREATION
[Thread-3] [9:25:17:337] [InitParamAttributes.sortParams:3525] m_sortOn:-1 sortOn:4
[Thread-3] [9:25:17:650] [Host.noEntryinOratab:5107] Check made for oratab arg passed............
[Thread-3] [9:25:17:651] [Oratab.getTempFile:710] Temp oratab: /tmp/ oratab
[Thread-3] [9:25:17:829] [CloneRmanRestoreStep.executeImpl:217] Instance Creation went fine..........
[Thread-3] [9:25:17:830] [CloneRmanRestoreStep.executeImpl:224] db_recovery_file_dest=/u01/app/oracle/flash_recovery_area [Thread-3] [9:25:17:831] [CloneRmanRestoreStep.executeImpl:227] db_recovery_file_dest_size=2147483648

[Thread-3] [9:25:18:60] [SQLEngine.setSpool:1743]  old Spool  = null
[Thread-3] [9:25:18:60] [SQLEngine.setSpool:1744]  Setting Spool  = /
u01/app/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl/
CloneRmanRestore.log
[Thread-3] [9:25:18:60] [SQLEngine.setSpool:1745] Is spool appendable? --> true
[Thread-3] [9:25:18:61] [CloneRmanRestoreStep.executeImpl:320] starting with pfile=/u01/app/oracle/admin/orcl/pfile/init.ora Received on Wed Oct 08 2008 - 12:23:07 CDT

Original text of this message