Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11gR1 RAC database creation(DBCA) hangs @ 52%.

654755Nov 21 2008 — edited Jan 20 2009
Hi experts,
My Oracle 11gR1 RAC database creation(DBCA) hangs @52% and i am getting the following error in "$ORACLE_BASE/cfgtoollogs/dbca/ORACLE_SID/trace.log" file.Please note that i didnt face any issues with Clusteraware and RAC binaries installion and it went fine.
Configuration:-
=> 2 Node SG 11.18 HP-UX11.31 IA Cluster.
=> Clusterware files(OCR and VOTE disk) are placed in shared raw LVM logical volumes.(/dev/vg_rac/rocr_400m & /dev/vg_rac/rvote_400m)
=> Clusterware and RAC binaries are installed on local file system.(/oc/app & /rac/app)
=> Trying to create a database on Shared raw LVM logical volumes.(Eg., /dev/vg_rac/rsysaux_900m).

Please let me know if you need any other details and help me in solving this issue.

Thanks in advance
--Raja

######################################################################################
[Thread-175] [11:1:38:263] [CloneRmanRestoreStep.generateRestoreScript:727] tablespace name:=USERS
[Thread-288] [11:1:38:416] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: 18027
[Thread-288] [11:1:48:419] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: 1210
[Thread-288] [11:1:58:429] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: -1
[Thread-288] [11:2:8:439] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: -1
[Thread-288] [11:2:18:449] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: -1
[Thread-288] [11:2:28:459] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: -1
[Thread-288] [11:2:38:469] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: -1
[Thread-288] [11:2:48:479] [CloneRmanRestoreStep$ProgressTracker.run:927] numBytesRead: 695
[Thread-175] [11:2:51:928] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@1898062f
[Thread-288] [11:2:51:928] [CloneRmanRestoreStep$ProgressTracker.run:947] java.lang.Thread.sleep(Native Method)
oracle.sysman.assistants.dbca.backend.CloneRmanRestoreStep$ProgressTracker.run(CloneRmanRestoreStep.java:935)
java.lang.Thread.run(Thread.java:595)
[Thread-175] [11:2:51:929] [StepContext$ModeRunner.run:2487] ---- Progress Needed:=true
[Thread-175] [11:2:52:399] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION
[Thread-175] [11:2:52:399] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01503
[Thread-175] [11:2:52:399] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-175] [11:2:52:399] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-12712
[Thread-175] [11:2:52:399] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00942
[Thread-175] [11:2:52:399] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-175] [11:2:52:824] [SQLEngine.spoolOff:1874] Setting spool off = /rac/app/oracle/cfgtoollogs/dbca/dbonraw/CloneRmanRestore.log
[Thread-175] [11:2:52:824] [SQLEngine.setSpool:1806] old Spool = null
[Thread-175] [11:2:52:824] [SQLEngine.setSpool:1807] Setting Spool = /rac/app/oracle/cfgtoollogs/dbca/dbonraw/cloneDBCreation.log
[Thread-175] [11:2:52:824] [SQLEngine.setSpool:1808] Is spool appendable? --> true
[Thread-175] [11:2:52:826] [CloneDBCreationStep.executeImpl:338] a.createCtlFileSql = Create controlfile reuse set database "dbonraw"
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'/dev/vg_rac/rsystem_900m',
'/dev/vg_rac/rsysaux_1500m',
[Thread-175] [11:2:52:826] [CloneDBCreationStep.executeImpl:342] b.createCtlFileSql = Create controlfile reuse set database "dbonraw"
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'/dev/vg_rac/rsystem_900m',
'/dev/vg_rac/rsysaux_1500m',
'/dev/vg_rac/rundotbs1_750m',
[Thread-175] [11:2:52:826] [CloneDBCreationStep.executeImpl:354] createCtl=Create controlfile reuse set database "dbonraw"
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'/dev/vg_rac/rsystem_900m',
'/dev/vg_rac/rsysaux_1500m',
'/dev/vg_rac/rundotbs1_750m',
'/dev/vg_rac/rusers_120m',
[Thread-175] [11:2:52:826] [CloneDBCreationStep.executeImpl:361] crtCtl=Create controlfile reuse set database "dbonraw"
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'/dev/vg_rac/rsystem_900m',
'/dev/vg_rac/rsysaux_1500m',
'/dev/vg_rac/rundotbs1_750m',
'/dev/vg_rac/rusers_120m'
[Thread-175] [11:2:52:827] [CloneDBCreationStep.executeImpl:376] Length of OriginalRedoLogsGrNames=2
[Thread-175] [11:2:52:827] [CloneDBCreationStep.executeImpl:384] 0th redoLogText = GROUP 1 ('/dev/vg_rac/rredo1_1_120m') SIZE 51200K
[Thread-175] [11:2:52:827] [CloneDBCreationStep.executeImpl:384] 1th redoLogText = GROUP 2 ('/dev/vg_rac/rredo1_2_120m') SIZE 51200K
[Thread-175] [11:2:52:827] [CloneDBCreationStep.executeImpl:405] createCTLSql=Create controlfile reuse set database "dbonraw"
MAXINSTANCES 32
MAXLOGHISTORY 1
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
Datafile
'/dev/vg_rac/rsystem_900m',
'/dev/vg_rac/rsysaux_1500m',
'/dev/vg_rac/rundotbs1_750m',
'/dev/vg_rac/rusers_120m'
LOGFILE GROUP 1 ('/dev/vg_rac/rredo1_1_120m') SIZE 51200K,
GROUP 2 ('/dev/vg_rac/rredo1_2_120m') SIZE 51200K RESETLOGS;
[Thread-175] [11:2:54:322] [CloneDBCreationStep.executeImpl:417] calling zerodbid
[Thread-175] [11:3:4:924] [CloneDBCreationStep.executeImpl:427] Shutdown database
[Thread-175] [11:3:4:926] [CloneDBCreationStep.executeImpl:449] Startup ......nomount......
[Thread-175] [11:3:20:370] [CloneDBCreationStep.executeImpl:468] Enabling restricted session.
[Thread-175] [11:3:23:822] [CloneDBCreationStep.executeImpl:470] alter database "dbonraw" open resetlogs;
[Thread-175] [11:4:9:714] [CloneDBCreationStep.executeImpl:555] Temp file to be added:=/dev/vg_rac/rtemp_400m
[Thread-175] [11:4:9:715] [CloneDBCreationStep.executeImpl:556] Temp file size in KB:=20480
[Thread-175] [11:4:10:922] [CloneDBCreationStep.executeImpl:586] Establish USERS as the default permanent tablespace of the database
[Thread-175] [11:4:10:957] [TemplateManager.isInstallTemplate:2226] Selected Template by user:=Data Warehouse
[Thread-175] [11:4:10:957] [TemplateManager.isInstallTemplate:2233] The Message Id to be searched:=DATA_WAREHOUSE
[Thread-175] [11:5:27:756] [CloneDBCreationStep.executeImpl:723] current NCHAR Set: AL16UTF16
[Thread-175] [11:5:29:227] [OsUtilsBase.deleteFile:1013] OsUtilsBase.deleteFile: /rac/app/oracle/cfgtoollogs/dbca/dbonraw/initdbonrawTemp.ora
[Thread-175] [11:5:29:851] [BasicStep.execute:202] Executing Step : CLONE_POST_CREATE_SCRIPTS
[Thread-175] [11:5:29:851] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00942
[Thread-175] [11:5:29:851] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-06512
[Thread-175] [11:5:29:851] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-20000
[Thread-175] [11:5:29:852] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01952
[Thread-175] [11:5:29:852] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01927
[Thread-175] [11:5:29:852] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-175] [11:5:35:105] [SQLEngine.spoolOff:1874] Setting spool off = /rac/app/oracle/cfgtoollogs/dbca/dbonraw/cloneDBCreation.log
[Thread-175] [11:5:35:106] [SQLEngine.setSpool:1806] old Spool = null
[Thread-175] [11:5:35:106] [SQLEngine.setSpool:1807] Setting Spool = /rac/app/oracle/cfgtoollogs/dbca/dbonraw/postScripts.log
[Thread-175] [11:5:35:106] [SQLEngine.setSpool:1808] Is spool appendable? --> true
[Thread-175] [11:5:39:731] [ClonePostCreateScripts.executeImpl:285] OraNLSLanguage: AMERICAN
[Thread-175] [11:5:39:823] [ClonePostCreateScripts.executeImpl:360] calling ORACLE_OCM.MGMT_CONFIG_UTL.create_replace_dir_obj
[Thread-175] [11:5:40:410] [SQLEngine.spoolOff:1874] Setting spool off = /rac/app/oracle/cfgtoollogs/dbca/dbonraw/postScripts.log
[Thread-175] [11:5:40:410] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@1898062f
[Thread-175] [11:5:40:410] [CloneDBCreationStep.executeImpl:824] create undo tbs SQL=CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '/dev/vg_rac/rundotbs2_750m' SIZE 25600K REUSE AUTOEXTEND ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
[Thread-175] [11:5:42:703] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@1898062f
[Thread-175] [11:5:42:703] [StepContext$ModeRunner.run:2487] ---- Progress Needed:=true
[Thread-175] [11:5:42:812] [BasicStep.execute:202] Executing Step : PARALLEL_SERVER
[Thread-175] [11:5:42:812] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00439
[Thread-175] [11:5:42:812] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00904
[Thread-175] [11:5:42:812] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00942
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00955
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01418
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01432
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01434
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01918
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01919
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01920
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01921
[Thread-175] [11:5:42:813] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-02260
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-02289
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-02303
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-04043
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-04080
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-06550
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29807
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29809
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29833
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01430
[Thread-175] [11:5:42:814] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29844
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29830
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-04042
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29816
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: PLS-00905
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-06512
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29515
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: PLS-00201
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: PL/SQL
[Thread-175] [11:5:42:815] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-29931
[Thread-175] [11:5:42:816] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-02024
[Thread-175] [11:5:42:816] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-175] [11:5:42:985] [SQLEngine.setSpool:1806] old Spool = null
[Thread-175] [11:5:42:985] [SQLEngine.setSpool:1807] Setting Spool = /rac/app/oracle/cfgtoollogs/dbca/dbonraw/CreateClustDBViews.log
[Thread-175] [11:5:42:985] [SQLEngine.setSpool:1808] Is spool appendable? --> true

######################################################################################
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2009
Added on Nov 21 2008
6 comments
5,485 views