3 Replies Latest reply: Nov 26, 2012 7:33 AM by Osama_Mustafa RSS

    dbca occur ORA-00600:internal error code, arguments: [16305]

    976203
      i have installed linux_11gR2_database in my arch linux. i thought it's well intalled.But, when i use dbca to create a new datebase, the wrong happened.
      now give the log of dbca:
      [TaskScheduler timer] [ 2012-11-26 19:56:18.591 CST ] [Host.executeSteps:4887] Executing steps....
      [TaskScheduler timer] [ 2012-11-26 19:56:18.596 CST ] [Host.setUpForOperation:3473] setUpForOperation: Mode = 128
      [TaskScheduler timer] [ 2012-11-26 19:56:18.609 CST ] [OsUtilsBase.copyFile:1413] OsUtilsBase.copyFile:
      [TaskScheduler timer] [ 2012-11-26 19:56:18.628 CST ] [Host.executeSteps:5054] setupForOperation returned: true
      [TaskScheduler timer] [ 2012-11-26 19:56:18.629 CST ] [Host.createStepSQLInterface:6949] sid =mydb
      [TaskScheduler timer] [ 2012-11-26 19:56:18.629 CST ] [Host.createStepSQLInterface:6950] sidOrConnectString mydb
      [TaskScheduler timer] [ 2012-11-26 19:56:18.629 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: null
      [TaskScheduler timer] [ 2012-11-26 19:56:18.632 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
      [TaskScheduler timer] [ 2012-11-26 19:56:18.636 CST ] [OracleHome.getVersion:896] Homeinfo /oracle/product/db,1
      [TaskScheduler timer] [ 2012-11-26 19:56:18.892 CST ] [OracleHome.getVersion:922] OracleHome.server.getVersion Version: 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.893 CST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.893 CST ] [OracleHome.getVersion:948] using sqlplus: /oracle/product/db/bin/sqlplus
      [TaskScheduler timer] [ 2012-11-26 19:56:18.893 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.893 CST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.894 CST ] [OracleHome.getVersion:948] using sqlplus: /oracle/product/db/bin/sqlplus
      [TaskScheduler timer] [ 2012-11-26 19:56:18.894 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.894 CST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.895 CST ] [OracleHome.getVersion:948] using sqlplus: /oracle/product/db/bin/sqlplus
      [TaskScheduler timer] [ 2012-11-26 19:56:18.895 CST ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.1.0
      [TaskScheduler timer] [ 2012-11-26 19:56:18.895 CST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
      [TaskScheduler timer] [ 2012-11-26 19:56:18.902 CST ] [SQLEngine.getEnvParams:547] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
      [TaskScheduler timer] [ 2012-11-26 19:56:18.903 CST ] [SQLEngine.getEnvParams:557] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
      [TaskScheduler timer] [ 2012-11-26 19:56:18.909 CST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
      [TaskScheduler timer] [ 2012-11-26 19:56:18.943 CST ] [SQLEngine.initialize:354] m_bReaderStarted: false
      [TaskScheduler timer] [ 2012-11-26 19:56:18.956 CST ] [SQLEngine.initialize:358] Starting Reader Thread...
      [Thread-31] [ 2012-11-26 19:56:19.119 CST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
      [Thread-31] [ 2012-11-26 19:56:19.119 CST ] [InventoryUtil.getHomeName:111] homeName = OraDb11g_home1
      [Thread-31] [ 2012-11-26 19:56:19.149 CST ] [StepManager.getSteps:426] StepManager isHARegitrationRequired : false
      [Thread-31] [ 2012-11-26 19:56:19.183 CST ] [StepContext$ModeRunner.run:2657] ---- Progress Needed:=true
      [Thread-31] [ 2012-11-26 19:56:19.262 CST ] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
      [Thread-31] [ 2012-11-26 19:56:19.262 CST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
      [Thread-31] [ 2012-11-26 19:56:19.262 CST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
      [Thread-31] [ 2012-11-26 19:56:19.280 CST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
      [Thread-31] [ 2012-11-26 19:56:19.280 CST ] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
      [Thread-31] [ 2012-11-26 19:56:19.281 CST ] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
      [Thread-31] [ 2012-11-26 19:56:19.285 CST ] [BasicStep.configureSettings:304] messageHandler being set=null
      [Thread-31] [ 2012-11-26 19:56:19.360 CST ] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION
      [Thread-31] [ 2012-11-26 19:56:19.368 CST ] [BasicStep.configureSettings:304] messageHandler being set=null
      [Thread-31] [ 2012-11-26 19:56:19.368 CST ] [InstanceStep.createInitFile:479] Checking registerWithHAListener
      [Thread-31] [ 2012-11-26 19:56:19.369 CST ] [Host.registerWithHAListener:8544] m_cmdArgs.m_listenersnull
      [Thread-31] [ 2012-11-26 19:56:19.369 CST ] [Host.registerWithHAListener:8545] isHARegistrationRequired false
      [Thread-31] [ 2012-11-26 19:56:19.389 CST ] [InitParamAttributes.sortParams:3774] m_sortOn:-1 sortOn:4
      [Thread-31] [ 2012-11-26 19:56:19.570 CST ] [InitParamAttributes.createInitFile:1808] Processing init param db_block_size
      [Thread-31] [ 2012-11-26 19:56:19.570 CST ] [InitParamAttributes.createInitFile:1813] The value is 8192
      [Thread-31] [ 2012-11-26 19:56:19.571 CST ] [InitParamAttributes.createInitFile:1808] Processing init param open_cursors
      [Thread-31] [ 2012-11-26 19:56:19.571 CST ] [InitParamAttributes.createInitFile:1813] The value is 300
      [Thread-31] [ 2012-11-26 19:56:19.571 CST ] [InitParamAttributes.createInitFile:1808] Processing init param db_domain
      [Thread-31] [ 2012-11-26 19:56:19.584 CST ] [InitParamAttributes.createInitFile:1813] The value is ""
      [Thread-31] [ 2012-11-26 19:56:19.585 CST ] [InitParamAttributes.createInitFile:1808] Processing init param db_name
      [Thread-31] [ 2012-11-26 19:56:19.585 CST ] [InitParamAttributes.createInitFile:1813] The value is mydb
      [Thread-31] [ 2012-11-26 19:56:19.605 CST ] [InitParamAttributes.createInitFile:1808] Processing init param control_files
      [Thread-31] [ 2012-11-26 19:56:19.616 CST ] [InitParamAttributes.createInitFile:1813] The value is ("/home/oracle/oradata/mydb/control01.ctl", "/home/oracle/oradata/mydb/control02.ctl")
      [Thread-31] [ 2012-11-26 19:56:19.617 CST ] [InitParamAttributes.createInitFile:1808] Processing init param compatible
      [Thread-31] [ 2012-11-26 19:56:19.617 CST ] [InitParamAttributes.createInitFile:1813] The value is 11.2.0.0.0
      [Thread-31] [ 2012-11-26 19:56:19.617 CST ] [InitParamAttributes.createInitFile:1808] Processing init param diagnostic_dest
      [Thread-31] [ 2012-11-26 19:56:19.618 CST ] [InitParamAttributes.createInitFile:1813] The value is /oracle
      [Thread-31] [ 2012-11-26 19:56:19.618 CST ] [InitParamAttributes.createInitFile:1808] Processing init param memory_target
      [Thread-31] [ 2012-11-26 19:56:19.618 CST ] [InitParamAttributes.createInitFile:1813] The value is 314572800
      [Thread-31] [ 2012-11-26 19:56:19.619 CST ] [InitParamAttributes.createInitFile:1808] Processing init param processes
      [Thread-31] [ 2012-11-26 19:56:19.619 CST ] [InitParamAttributes.createInitFile:1813] The value is 150
      [Thread-31] [ 2012-11-26 19:56:19.619 CST ] [InitParamAttributes.createInitFile:1808] Processing init param audit_file_dest
      [Thread-31] [ 2012-11-26 19:56:19.623 CST ] [InitParamAttributes.createInitFile:1813] The value is /oracle/admin/mydb/adump
      [Thread-31] [ 2012-11-26 19:56:19.624 CST ] [InitParamAttributes.createInitFile:1808] Processing init param audit_trail
      [Thread-31] [ 2012-11-26 19:56:19.624 CST ] [InitParamAttributes.createInitFile:1813] The value is db
      [Thread-31] [ 2012-11-26 19:56:19.626 CST ] [InitParamAttributes.createInitFile:1808] Processing init param remote_login_passwordfile
      [Thread-31] [ 2012-11-26 19:56:19.627 CST ] [InitParamAttributes.createInitFile:1813] The value is EXCLUSIVE
      [Thread-31] [ 2012-11-26 19:56:19.627 CST ] [InitParamAttributes.createInitFile:1808] Processing init param dispatchers
      [Thread-31] [ 2012-11-26 19:56:19.633 CST ] [InitParamAttributes.createInitFile:1813] The value is "(PROTOCOL=TCP) (SERVICE=mydbXDB)"
      [Thread-31] [ 2012-11-26 19:56:19.634 CST ] [InitParamAttributes.createInitFile:1808] Processing init param undo_tablespace
      [Thread-31] [ 2012-11-26 19:56:19.634 CST ] [InitParamAttributes.createInitFile:1813] The value is UNDOTBS1
      [Thread-31] [ 2012-11-26 19:56:19.827 CST ] [InstanceStep.executeImpl:246] Checking Register with HA Listener
      [Thread-31] [ 2012-11-26 19:56:19.827 CST ] [Host.registerWithHAListener:8544] m_cmdArgs.m_listenersnull
      [Thread-31] [ 2012-11-26 19:56:19.827 CST ] [Host.registerWithHAListener:8545] isHARegistrationRequired false
      [Thread-31] [ 2012-11-26 19:56:19.830 CST ] [Host.noEntryinOratab:6006] Check made for oratab arg passed............
      [Thread-31] [ 2012-11-26 19:56:19.831 CST ] [Oratab.getTempFile:803] Temp oratab: /tmp/oratab
      [Thread-31] [ 2012-11-26 19:56:19.856 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
      [Thread-31] [ 2012-11-26 19:56:19.867 CST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
      [Thread-31] [ 2012-11-26 19:56:19.868 CST ] [OracleHome.getVersion:948] using sqlplus: /oracle/product/db/bin/sqlplus
      [Thread-31] [ 2012-11-26 19:56:19.868 CST ] [OracleHome.getVersion:877] OracleHome.getVersion called. Current Version: 11.2.0.1.0
      [Thread-31] [ 2012-11-26 19:56:19.868 CST ] [OracleHome.getVersion:943] Current Version From Inventory: 11.2.0.1.0
      [Thread-31] [ 2012-11-26 19:56:19.868 CST ] [OracleHome.getVersion:948] using sqlplus: /oracle/product/db/bin/sqlplus
      [Thread-31] [ 2012-11-26 19:56:19.973 CST ] [CommonUtils.createPasswordFile:604] calling new orapwd for 11.1 or higher
      [Thread-31] [ 2012-11-26 19:56:19.975 CST ] [OsUtilsBase.execProg:2032] beginning execProg with input array.
      [Thread-31] [ 2012-11-26 19:56:20.462 CST ] [OsUtilsBase.execProg:2068] finished execProg with input array. Status:0
      [Thread-31] [ 2012-11-26 19:56:20.467 CST ] [InstanceStep.setASMAdminGID:329] isWindows: false Storage Type: 0
      [Thread-31] [ 2012-11-26 19:56:20.468 CST ] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@1d688e2
      [Thread-31] [ 2012-11-26 19:56:20.468 CST ] [CloneRmanRestoreStep.executeImpl:221] Instance Creation went fine..........
      [Thread-31] [ 2012-11-26 19:56:20.468 CST ] [CloneRmanRestoreStep.executeImpl:228] db_recovery_file_dest=null
      [Thread-31] [ 2012-11-26 19:56:20.474 CST ] [CloneRmanRestoreStep.executeImpl:231] db_recovery_file_dest_size=null
      [Thread-31] [ 2012-11-26 19:56:20.672 CST ] [SQLEngine.setSpool:1940] old Spool = null
      [Thread-31] [ 2012-11-26 19:56:20.672 CST ] [SQLEngine.setSpool:1941] Setting Spool = /oracle/cfgtoollogs/dbca/mydb/CloneRmanRestore.log
      [Thread-31] [ 2012-11-26 19:56:20.672 CST ] [SQLEngine.setSpool:1942] Is spool appendable? --> true
      [Thread-31] [ 2012-11-26 19:56:20.673 CST ] [CloneRmanRestoreStep.executeImpl:324] starting with pfile=/oracle/admin/mydb/pfile/init.ora
      [Thread-29] [ 2012-11-26 19:56:27.048 CST ] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@1d688e2:messageHandler
      [Thread-29] [ 2012-11-26 19:56:27.048 CST ] [BasicStep.handleNonIgnorableError:431] ORA-00600: internal error code, arguments: [16305], [], [], [], [], [], [], [], [], [], [], [