stuck on Clone database creation step [Oracle Help]

Prev: Complex crosstab query
Next: KTSMG_UPDATE_MQL() MMNL absent for 4294967293 secs; Foregrounds taking over

From: jim on 8 Oct 2008 12:32

On Oct 7, 12:16 pm, "Shakespeare" <what...(a)xs4all.nl> wrote:
> "jim" <jhav...(a)gmail.com> schreef in berichtnews:175fb975-c23c-4d07-b294-f0b8d9522297(a)34g2000hsh.googlegroups.com...
> CloneRmanRestore.log is empty.
>
> On Oct 7, 12:16 am, "Shakespeare" <what...(a)xs4all.nl> wrote:
>
>
>
> > "jim" <jhav...(a)gmail.com> schreef in
> > berichtnews:33fefbe8-1942-45be-8058-481160060de4(a)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

From: Shakespeare on 8 Oct 2008 12:47

"jim" <jhavero(a)gmail.com> schreef in bericht
news:24e4b775-454b-4ac9-88bf-be83f0dc2e93(a)w13g2000prm.googlegroups.com...
On Oct 7, 12:16 pm, "Shakespeare" <what...(a)xs4all.nl> wrote:
> "jim" <jhav...(a)gmail.com> schreef in
> berichtnews:175fb975-c23c-4d07-b294-f0b8d9522297(a)34g2000hsh.googlegroups.com...
> CloneRmanRestore.log is empty.
>
> On Oct 7, 12:16 am, "Shakespeare" <what...(a)xs4all.nl> wrote:
>
>
>
> > "jim" <jhav...(a)gmail.com> schreef in
> > berichtnews:33fefbe8-1942-45be-8058-481160060de4(a)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

===================================================
Looks as if some libraries are missing. Exactly the same sequence of errors
is in Metalink Note 374778.1

Shakespeare

From: jim on 8 Oct 2008 12:53

From: Shakespeare on 8 Oct 2008 13:10

Jim,

Looks as if some libraries are missing. Exactly the same sequence of errors
is in Metalink Note 374778.1

Shakespeare

From: jim on 8 Oct 2008 13:23

First | Prev | Next | Last
Pages: 1 2 3
Prev: Complex crosstab query
Next: KTSMG_UPDATE_MQL() MMNL absent for 4294967293 secs; Foregrounds taking over