Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBCA stops while adding a new node to a two-node RAC

RE: DBCA stops while adding a new node to a two-node RAC

From: Fadi Hasweh <fhasweh_at_umniah.com>
Date: Sun, 15 Jul 2007 12:38:33 +0300
Message-ID: <0D6185A9D9983D41989858A479BFF3E315D83DA321@HQ-UM-EXMB.UMNIAH.COM>


Hi,
Have you checked note
Subject: Unable To Add A New Instance To Rac   Doc ID: Note:264643.1

Fadi

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Asif Momen Sent: Sunday, July 15, 2007 12:14 PM
To: oracle-l_at_freelists.org
Subject: DBCA stops while adding a new node to a two-node RAC

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.

[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
--
http://www.freelists.org/webpage/oracle-l



"This email is intended for the above named addressee (s) only and may contain confidential and/or privilege information and should not be used by anyone who is not the original intended recipient(s). Any review, print, copy, reliance or distribution by others or forwarding without express permission is strictly prohibited  If you have received this email in error, kindly notify the sender immediately by reply email and delete this email and any attachments from your mailbox or any other storage mechanism. Thank you.

Email transmission cannot be guaranteed to be secured or error free, as information could be intercepted, corrupted, lost, destroyed, received late or incomplete, or could contain viruses. The sender therefore does not accept liability for any error or omission in the contents of this message, which arises as a result of email transmission. Opinions, conclusions and other information in this message that do not relate to the official business of Umniah Mobile Company and is not its responsibility shall be understood as neither given nor endorsed by the organization."
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 15 2007 - 04:38:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US