DBCA Fails When Adding An Instance To a RAC Database if the undo_tablespace parameter is set to a lowercase value. (Doc ID 1543080.1)

Last updated on APRIL 09, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Attempting to add an instance to a RAC database using the following command:

      $ dbca -silent -addInstance -nodeList Node2 -gdbName orcl -instanceName orcl2 -sysDBAUserName sys -sysDBAPassword testsys

DBCA Log messages:
null
Adding instance
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 13%
DBCA_PROGRESS : 20%
ORA-01276: Cannot add file +FRA_DG/orcl/onlinelog/group_1.1086.767281787.  File has an Oracle Managed Files file name.

DBCA_PROGRESS : 27%
DBCA_PROGRESS : 28%
ORA-01612: instance orcl1 (thread 1) is already enabled

DBCA_PROGRESS : 34%
DBCA_PROGRESS : 41%
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 54%
DBCA_PROGRESS : 66%
Completing instance management.
DBCA_PROGRESS : 76%
PRCR-1013 : Failed to start resource ora.orcl.db
PRCR-1064 : Failed to start resource ora.orcl.db on node Node2
CRS-5017: The resource action "ora.orcl.db start" encountered the following error:
ORA-29760: instance_number parameter not specified
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/product/11.2.0.3/log/Node2/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.orcl.db' on 'Node2' failed
DBCA_PROGRESS : 100%


The related dbca trace file will show that an exception happened when getting undo tablespace attribute information:

 

DBCA trace file ($ORACLE_HOME/assistants/dbca):

[AWT-EventQueue-0] [ 2013-02-19 09:34:32.734 CST ] [Host.setUpForInstanceMgmt:4328]  orcl1 ==> 1
[AWT-EventQueue-0] [ 2013-02-19 09:34:32.735 CST ] [Host.setUpForInstanceMgmt:4347]  newInstanceName=orcl2
[AWT-EventQueue-0] [ 2013-02-19 09:34:38.242 CST ] [Host.setUpForInstanceMgmt:4354]  DB threadNum.length =1
[AWT-EventQueue-0] [ 2013-02-19 09:34:38.244 CST ] [Host.setUpForInstanceMgmt:4383]  New threadNum=2
[AWT-EventQueue-0] [ 2013-02-19 09:34:38.244 CST ] [SQLEngine.done:2189]   Done called
[main] [ 2013-02-04 13:21:44.808 CST ] [DatabaseAttributes.getRedoLogGroupAttributes:1127]  thread query SQL = SELECT THREAD# FROM V$THREAD WHERE UPPER(INSTANCE) = UPPER('orcl1')
[main] [ 2013-02-04 13:21:45.135 CST ] [DatabaseAttributes.getRedoLogGroupAttributes:1134]  orcl1==>1
[main] [ 2013-02-04 13:21:45.241 CST ] [StorageAttributes.setAttribute:241]  IN threadID:1 group#=1
[main] [ 2013-02-04 13:21:45.281 CST ] [StorageAttributes.setAttribute:241]  IN threadID:1 group#=2
[main] [ 2013-02-04 13:21:45.282 CST ] [StorageAttributes.setAttribute:250]  Current threadID=1
[main] [ 2013-02-04 13:21:45.283 CST ] [StorageAttributes.setAttribute:257]  Current threadID=1 ==> redoGroups[0]=1
[main] [ 2013-02-04 13:21:45.283 CST ] [StorageAttributes.setAttribute:267]  vRedoGroups:[1]
[main] [ 2013-02-04 13:21:45.284 CST ] [StorageAttributes.setAttribute:297]  setAttribute: bExists=false
[main] [ 2013-02-04 13:21:45.307 CST ] [StorageAttributes.setAttribute:241]  IN threadID:1 group#=3
[main] [ 2013-02-04 13:21:45.308 CST ] [StorageAttributes.setAttribute:250]  Current threadID=1
[main] [ 2013-02-04 13:21:45.309 CST ] [StorageAttributes.setAttribute:257]  Current threadID=1 ==> redoGroups[0]=1
[main] [ 2013-02-04 13:21:45.309 CST ] [StorageAttributes.setAttribute:257]  Current threadID=1 ==> redoGroups[1]=2
[main] [ 2013-02-04 13:21:45.309 CST ] [StorageAttributes.setAttribute:267]  vRedoGroups:[1, 2]
[main] [ 2013-02-04 13:21:45.310 CST ] [StorageAttributes.setAttribute:297]  setAttribute: bExists=false
[main] [ 2013-02-04 13:21:45.331 CST ] [StorageAttributes.setAttribute:241]  IN threadID:1 group#=4
[main] [ 2013-02-04 13:21:45.331 CST ] [StorageAttributes.setAttribute:250]  Current threadID=1
[main] [ 2013-02-04 13:21:45.332 CST ] [StorageAttributes.setAttribute:257]  Current threadID=1 ==> redoGroups[0]=1
[main] [ 2013-02-04 13:21:45.332 CST ] [StorageAttributes.setAttribute:257]  Current threadID=1 ==> redoGroups[1]=2
[main] [ 2013-02-04 13:21:45.333 CST ] [StorageAttributes.setAttribute:257]  Current threadID=1 ==> redoGroups[2]=3
[main] [ 2013-02-04 13:21:45.333 CST ] [StorageAttributes.setAttribute:267]  vRedoGroups:[1, 2, 3]
[main] [ 2013-02-04 13:21:45.334 CST ] [StorageAttributes.setAttribute:297]  setAttribute: bExists=false
[main] [ 2013-02-04 13:21:45.334 CST ] [DatabaseAttributes.getAllRedoLogGroupNames:1242]  Trying to execute sqlQuery = SELECT distinct group# FROM v$logfile order by group#
[main] [ 2013-02-04 13:21:45.341 CST ] [StorageAttributes.setAllExistingRedoLogs:1668]  All Existing Redo Logs length: 4
[main] [ 2013-02-04 13:21:45.375 CST ] [DatabaseAttributes.getUndoTablespaceAttributes:763]  bOMFMode=true
oracle.sysman.vbo.VboInitFailureException        
        at oracle.sysman.vbo.VboObjectImpl.initExisting(VboObjectImpl.java:397)        
        at oracle.sysman.vbo.VboDBObjectImpl.initExisting(VboDBObjectImpl.java:289)        
        at oracle.sysman.assistants.dbca.backend.ServerObjectFactory.getExistingObject(Se rverObjectFactory.java:551)        
        at oracle.sysman.assistants.dbca.backend.DatabaseAttributes.getUndoTablespaceAttr ibutes(DatabaseAttributes.java:769)        
        at oracle.sysman.assistants.dbca.backend.Host.createOPSConfiguration(Host.java:10 12)        
        at oracle.sysman.assistants.dbca.ui.OPSInstanceAddPage.validate(OPSInstanceAddPage.java:528)        
        at oracle.sysman.assistants.util.wizard.WizardPageExt.wizardValidatePage(WizardPageExt.java:214)
        at oracle.ewt.wizard.WizardPage.processWizardValidateEvent(Unknown Source)
        at oracle.ewt.wizard.WizardPage.validatePage(Unknown Source)
        at oracle.ewt.wizard.BaseWizard.validateSelectedPage(Unknown Source)
        at oracle.ewt.wizard.BaseWizard.doNext(Unknown Source)
        at oracle.sysman.assistants.util.wizard.WizardExt.doNext(WizardExt.java:265)
        at oracle.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
        at oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
        at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
        at oracle.ewt.button.PushButton.activate(Unknown Source)
        at oracle.ewt.lwAWT.AbstractButton.processMouseReleased(Unknown Source)
        at oracle.ewt.lwAWT.AbstractButton.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Component.java:5297)
        at java.awt.Container.processEvent(Container.java:1966)
        at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)
        at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)
        at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Component.java:3999)
        at java.awt.Container.dispatchEventImpl(Container.java:2024)
        at java.awt.Component.dispatchEvent(Component.java:3834)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
        at java.awt.Container.dispatchEventImpl(Container.java:2010)
        at java.awt.Window.dispatchEventImpl(Window.java:1791)
        at java.awt.Component.dispatchEvent(Component.java:3834)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:501)
        at java.awt.EventQueue.access$000(EventQueue.java:80)
        at java.awt.EventQueue$1.run(EventQueue.java:462)
        at java.awt.EventQueue$1.run(EventQueue.java:461)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:84)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:95)
        at java.awt.EventQueue$2.run(EventQueue.java:476)
        at java.awt.EventQueue$2.run(EventQueue.java:475)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:84)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:473)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

 


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms