DBCA stops while adding a new node to a two-node RAC
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 15 Jul 2007 02:13:57 -0700 (PDT)
Hi,
OS: Windows 2003 Enterprise Edition SP1
Database: Oracle Database 10g (10.2.0.3.0)
Home: CRS_HOME (10.2.0.3)
ORACLE_HOME (ASM + Database)
(10.2.0.3)
Nodes in RAC: 2
While adding a new (third) node, we successfully
completed the following steps:
1) Adding the third node to the Oracle Cluster.
2) Configuring Oracle Home on the third node.
We followed "Oracle Clusterware and Oracle Real
Application Clusters
Administration and Deployment Guide" document to add
new node.
After completing the above steps, we started DBCA in
an interactive mode to "Add Database Instance to New
Node".
On Step 4 (where DBCA displays the List of Cluster
Databases page that shows the databases and their
current status), when we press the "Next" button,
nothing happens and DBCA doesn't get to the next
screen and following error is reported in the DBCA
log.
================== start of trace.log
==================
NAME=ora.RACDB.RACDB2.inst
[AWT-EventQueue-0] [13:40:29:519]
[RuntimeExec.runCommand:150] TYPE=application
[AWT-EventQueue-0] [13:40:29:519]
[RuntimeExec.runCommand:150] TARGET=ONLINE
[AWT-EventQueue-0] [13:40:29:519]
[RuntimeExec.runCommand:150] STATE=ONLINE on rac3
[AWT-EventQueue-0] [13:40:29:519]
[RuntimeExec.runCommand:150]
[AWT-EventQueue-0] [13:40:29:519]
[RuntimeExec.runCommand:155] RunTimeExec: error>
[AWT-EventQueue-0] [13:40:29:519]
[RuntimeExec.runCommand:175] Returning from
RunTimeExec.runCommand
[AWT-EventQueue-0] [13:40:29:519]
[HAOperationImpl.runCommand:1275] set status OK
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:127] Returned from executing
the HA Operation
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:132] OUTPUT>
NAME=ora.RACDB.RACDB2.inst
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:132] OUTPUT> TYPE=application
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:132] OUTPUT> TARGET=ONLINE
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:132] OUTPUT> STATE=ONLINE on
rac3
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:132] OUTPUT>
[AWT-EventQueue-0] [13:40:29:519]
[HAStatusOperation.run:138] ERROR>
[AWT-EventQueue-0] [13:40:29:519]
[LocalCommand.execute:56] LocalCommand.execute:
Returned from run method
[AWT-EventQueue-0] [13:40:29:519]
[HAResourceStatus.parseHAStatusOutput:293] got
status: resource=ora.RACDB.RACDB2.insttarget=ONLINE
status=ONLINE on rac3 host=rac3
[AWT-EventQueue-0] [13:40:29:519]
[ParallelServerHA.isRunningInternal:513]
isRunning(inst) returning with true
[AWT-EventQueue-0] [13:41:24:597]
[OPSInstanceListPage.doNext:470] Database is not
registered in OID or dir service not configured.
[AWT-EventQueue-0] [13:41:24:597]
[OPSInstanceListPage.doNext:525]
clusterNodeNames.length=3
[AWT-EventQueue-0] [13:41:24:597]
[OPSInstanceListPage.doNext:526]
opsNodeNames.length=2
[AWT-EventQueue-0] [13:41:24:597]
[OPSInstanceListPage.doNext:556] vAvailable=[rac1,
rac3, rac5]
[AWT-EventQueue-0] [13:41:24:597]
[OPSInstanceListPage.doNext:571] vAvailable=[rac1,
rac3, rac5]
[AWT-EventQueue-0] [13:41:24:597]
[OPSInstanceListPage.doNext:576] Length of available
nodes 3
java.lang.ArrayIndexOutOfBoundsException: 3
at
oracle.sysman.assistants.dbca.ui.OPSInstanceListPage.doNext(OPSInstanceListPage.java:587)
at
oracle.sysman.assistants.util.wizard.WizardExt.doNext(WizardExt.java:235)
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:4897)
at
java.awt.Container.processEvent(Container.java:1569)
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:3615)
at
java.awt.Container.dispatchEventImpl(Container.java:1627)
at
java.awt.Component.dispatchEvent(Component.java:3477)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at
java.awt.Container.dispatchEventImpl(Container.java:1613)
at
java.awt.Window.dispatchEventImpl(Window.java:1606)
at
java.awt.Component.dispatchEvent(Component.java:3477)
at
java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at
java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
================== end of trace.log ==================
Eventually, we created the ASM Instance manually on
the third node and registered it with the Cluster. To
create a database instance on the new node, we need to
have a separate redologs for the third node. How do we
create Redo Logs for the new database instance.
I searched the Metalink/Internet for a document
describing manual procedure to add a database instance
on a new node, but all the documents use DBCA to
create the third database instance.
Questions that remain open are:
1) Why DBCA is stopping at that point and how do we
proceed?
2) How to manually add a database instance to a new
node and register it with RAC.
Thanks for sharing your views.
Regards
Momen.
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
--
//www.freelists.org/webpage/oracle-l
Other related posts:
