R12 RAC Implementation: Second RAC Node is Not Registered in FND_NODES (Doc ID 1568840.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to run autoconfig on a second RAC node,
AutoConfig is exiting with status 0 but the second RAC node is missing in FND_NODES table
The log of autoconfig (adconfig.log) outlines the following database connection error :
ERROR
-----------

adconfig.log (RAC Node 2)
***************************************************************************
Starting AutoConfig at Fri Jul 12 12:24:10 2013
Using adconfig.pl version 120.26.12010000.5
Starting Updates of Context file Fri Jul 12 12:24:14 GST 2013
...
Config Tool CVMHelper started at Fri Jul 12 12:24:14 GST 2013
Updating local context file variables for Database Tier
Reading listener port from /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/racsid2_RAC002/listener.ora
New Port: 1521
Old Port: 1521
Current Listener Name: RACSID
New Listener Name: racsid
New Port and existing port are the same.
The new listener name and existing listener name are the same.
No updates will be done.
Making database connection using DBUtil
---------------------------------------------------------------
                  ADX Database Utility                        
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
   APPS_JDBC_URL='null'
   Trying to get connection using SID based connect descriptor
getConnection() -->
   sDbHost    : RAC002
   sDbDomain  : rachost.racdomain
   sDbPort    : 1521
   sDbSid     : racsid2
   sDbUser    : apps
   Trying to connect using SID...
getConnectionUsingSID() -->
   JDBC URL: jdbc:oracle:thin:@RAC002.rachost.racdomain:1521:racsid2
   Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
   Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
   JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RAC002.rachost.racdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=racsid2)))
   Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
   Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
   JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RAC002.rachost.racdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=racsid2.rachost.racdomain)))
   Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
   Connection could not be obtained; returning null
...
...
AutoConfig is exiting with status 0

 

Changes

 On RAC Node 1, Autoconfig is running successfully

07121220/adconfig (RAC Node 1)

Config Tool CVMHelper started at Fri Jul 12 12:20:33 GST 2013
Updating local context file variables for Database Tier
Reading listener port from /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/racsid1_RAC001/listener.ora
New Port: 1521
Old Port: 1521
Current Listener Name: RACSID
New Listener Name: racsid
New Port and existing port are the same.
The new listener name and existing listener name are the same.
No updates will be done.
Making database connection using DBUtil
---------------------------------------------------------------
                  ADX Database Utility                        
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
   APPS_JDBC_URL='null'
   Trying to get connection using SID based connect descriptor
getConnection() -->
   sDbHost    : RAC001
   sDbDomain  : rachost.racdomain
   sDbPort    : 1521
   sDbSid     : racsid1
   sDbUser    : apps
   Trying to connect using SID...
getConnectionUsingSID() -->
   JDBC URL: jdbc:oracle:thin:@RAC001.rachost.racdomain:1521:racsid1
   Connection obtained
-------------------ADX Database Utility Finished---------------
Database connection successfully obtained

 

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