Autoconfig Complete With Error Listener Refused The Connection With The Following Error After RAC (Doc ID 2168901.1)

Last updated on AUGUST 05, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.0 to 12.2.5 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, RAC Setup Issues

When following document
Using Oracle 12c Release 1 (12.1) Real Application Clusters with Oracle E-Business Suite Release R12.2 (Doc ID 1626606.1),
Step 4 section 4.7

4.7. Establish the Oracle E-Business Suite Environment for Oracle RAC

the following error occurs.


Autoconfig Error:

Creating the DBC file...
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Database connection to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=pia-xd-scan)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PIAXDPD))) failed
ADD call failed with exit code 1

Updating Server Security Authentication
java.sql.SQLRecoverableException: IO Error: Invalid number format for port number
Database connection to jdbc:oracle:thin:@host_name:port_number:database failed
Updating Server Security Authentication failed with exit code 1
Restoring DBC file from backed up location /u01/oracle/PIAXDPD/fs2/inst/apps/PIAXDPD_vspiaerp01p/appltmp/TXK/PIAXDPD_Mon_Aug_01_06_49_2016.dbc

adgendbc.sh ended at Mon Aug 1 06:49:04 EDT 2016

adgendbc.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.


SQL*Plus connection gives below error:

[oracle@pia-xddbadm01 appsutil]$ sqlplus apps/(apps password)@PIAXDPD1

SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 1 21:15:44 2016

Copyright (c) 1982, 2014, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


TNSPING Error:

[oracle@vspiaerp01p PIAXDPD]$ tnsping PIAXDPD1

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 03-AUG-2016 06:19:43

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
/u01/oracle/PIAXDPD/fs2/inst/apps/PIAXDPD_vspiaerp01p/ora/10.1.2/network/admin/sqlnet_ifile.ora

TNS-03505: Failed to resolve name




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When following the RAC document as part of RAC setup
2. From application server all the DB connection is failing.
3. Listener is running fine.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot continue setup RAC

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