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 MARCH 05, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation 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 <nodename2> -gdbName <dbname> -instanceName <instancename2> -sysDBAUserName sys -sysDBAPassword <syspassword>
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 <instancename1> (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.<dbname>.db
PRCR-1064 : Failed to start resource ora.<dbname>.db on node <nodename2>
CRS-5017: The resource action "ora.<dbname>.db start" encountered the following error:
ORA-29760: instance_number parameter not specified
. For details refer to "(:CLSN00107:)" in "$GRID_HOME/log/<nodename2>/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<dbname>.db' on '<nodename2>' failed
DBCA_PROGRESS : 100%
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 <instancename1> (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.<dbname>.db
PRCR-1064 : Failed to start resource ora.<dbname>.db on node <nodename2>
CRS-5017: The resource action "ora.<dbname>.db start" encountered the following error:
ORA-29760: instance_number parameter not specified
. For details refer to "(:CLSN00107:)" in "$GRID_HOME/log/<nodename2>/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.<dbname>.db' on '<nodename2>' 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=<instancename2>
[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('<instancename1>')
[main] [ 2013-02-04 13:21:45.135 CST ] [DatabaseAttributes.getRedoLogGroupAttributes:1134] <instancename1>==>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)
[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=<instancename2>
[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('<instancename1>')
[main] [ 2013-02-04 13:21:45.135 CST ] [DatabaseAttributes.getRedoLogGroupAttributes:1134] <instancename1>==>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)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |