Solved

Oracle AddNode Question

Posted on 2014-03-03
4
823 Views
Last Modified: 2014-03-10
Hey Guys

due the business needs, they are asking to install Oracle 10 rac on a single node after of that; they want to perform the addNode process for a second node.

What is the propuse of that ? well they want us to have the exact steps for the addNode process for more coming nodes.

at the moment i was able to install Oracle CRS, then oracle database and finally upgrade to 10.2.0.5

The problem comes when i want to add the second node

doing something like this:
./addNode.sh -silent CLUSTER_NEW_NODES={quibebdsdp6} CLUSTER_NEW_PRIVATE_NODE_NAMES={bebd6} CLUSTER_NEW_VIRTUAL_HOSTNAMES={bebd6-vip}  -ignoreSysPrereqs

i'm getting this:

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.

Exception java.lang.NullPointerException occurred..
java.lang.NullPointerException
        at oracle.sysman.oii.oiic.OiicAddNodeSession.initialize(OiicAddNodeSession.java:568)
        at oracle.sysman.oii.oiic.OiicAddNodeSession.<init>(OiicAddNodeSession.java:135)
        at oracle.sysman.oii.oiic.OiicSessionWrapper.createNewSession(OiicSessionWrapper.java:860)
        at oracle.sysman.oii.oiic.OiicSessionWrapper.<init>(OiicSessionWrapper.java:186)
        at oracle.sysman.oii.oiic.OiicInstaller.init(OiicInstaller.java:481)
        at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:928)
        at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:866)
SEVERE:Abnormal program termination. An internal error has occured. Please provide the following files to Oracle Support :

"/export/oracle/app/oraInventory/logs/addNodeActions2014-03-03_05-28-53PM.log"
"Unknown"
"Unknown"


The addNodeActions2014-03-03_05-28-53PM.log file shown the last lines

INFO: Setting variable 'ROOTSH_STATUS' to '3'. Received the value from a code block.
SEVERE: Abnormal program termination. An internal error has occured. Please provide the following files to Oracle Support :

"/export/oracle/app/oraInventory/logs/addNodeActions2014-03-03_05-28-53PM.log"
"Unknown"
"Unknown"
INFO: User Selected: Yes/OK

I wonder if the problem is that Oracle 10g rac is installed on a single node and perhaps if i have two node it will work or no matter how many nodes i have i will get the same error

Any suggestion ?
0
Comment
Question by:Pepe2323
  • 3
4 Comments
 
LVL 15

Expert Comment

by:Franck Pachot
Comment Utility
Dio you have other files (.err .out) in the /export/oracle/app/oraInventory/logs/ directory generated at the same time as ddNodeActions2014-03-03_05-28-53PM.log ?
0
 
LVL 8

Author Comment

by:Pepe2323
Comment Utility
I have fixed part of the problem

i realized i missed to path clusterware to version 10.2.0.5, so i did, but the werid thing is that when i finish to update i'm not getting get message that run root102.sh; after some research i found that i need it to run.

Now addNode.sh work almost everything expect for when i have to run the root.sh on the new node, form some reason CSS is not starting correctly

This is the message:
Expecting the CRS daemons to be up within 600 seconds.
Failure at final check of Oracle CRS stack.
10

So right now i'm trying to figure out a workaround, i found something that is partially similar to my case.

pretty much says to instead to root.sh on the nodes, run CRS_HOME/installer/rootconfig  and modify the following values to be like this:

SILENT=false
ORA_CRS_HOME=/export/oracle/app/oracle/product/10.2.0/crs
CRS_ORACLE_OWNER=oracle
CRS_DBA_GROUP=oinstall
CRS_VNDR_CLUSTER=false
CRS_OCR_LOCATIONS=
CRS_CLUSTER_NAME=
CRS_HOST_NAME_LIST=quibebdsdp5,quibebdsdp6
CRS_NODE_NAME_LIST=quibebdsdp5,quibebdsdp6
CRS_PRIVATE_NAME_LIST=bebd5,bebd6
CRS_LANGUAGE_ID=
CRS_VOTING_DISKS=
CRS_NODELIST=quibebdsdp5,quibebdsdp6
CRS_NODEVIPS=bebd5-vip,bebd6-vip

This tip was used when a new clusterware installation was done and happened the same error as me,  when they ran root.sh; in my case is happening when i run it after addNode.sh

Any other idea ?
0
 
LVL 8

Accepted Solution

by:
Pepe2323 earned 0 total points
Comment Utility
Finally found the problem

The real problem was that my ocr  devices, even the second node is able to see those devices too and write on them

i did a test it was set my ocrs and my votes to an ocfs2 file system and when i ran the root.sh
this time all worked

So i'm taking a look to my luns on the SAN side to see what is the problem

Regards.
0
 
LVL 8

Author Closing Comment

by:Pepe2323
Comment Utility
I was able to fix the problem after a couple of tests and research
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now