RC-00118

' adcfgclone dbTier' fails with error 'RC-00118' Error occurred during creation of database - 'Raised by oracle.apps.ad.clone.ApplyDatabase' [ID 1299429.1]

Applies to:

Oracle Applications Manager - Version: 11.5.9 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.

Symptoms

When you are starting the DB-Tier Configuration script during an E-Business Suite Clone, you see following failure :
...
getConnectionUsingAppsJDBCConnector() -->
  APPS_JDBC_URL='null'
  Trying to get connection using SID based connect descriptor
getConnection() -->
  sDbHost    : <hostname>
  sDbDomain  : <Domain>
  sDbPort    : <PORT>
  sDbSid     : <SID>
  sDbUser    : APPS
  Trying to connect using SID...
getConnectionUsingSID() -->
  JDBC URL: jdbc:oracle:thin:@<hostname.domain:<PORT>:<SID>
  Exception occurred: java.sql.SQLException: Io exception: 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=<hostname.domain>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<DIS>)))
  Exception occurred: java.sql.SQLException: Io exception: 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=<hostname.domain>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<SID>.<DOMAIN>)))
  Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
  Connection could not be obtained; returning null
RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase
...

This failure can be seen on a E-Business Suite Release 11.5.x, on Release 12.0.x and on Release 12.1.x - it is a generic and common failure !

Cause

During the execution of the Cloning Configuration script 'adcfgclone.pl' a nslookup is performed. If there is a problem with the DNS Service (Domain Name System) it results in a timeout failure. This indicates that the machine is not properly registered in the DNS Service, which results in a JDBC connection issue.

The following command is used to check the machine in the DNS : 

nslookup <hostname>.<domain>

for example :

nslookup EBS_Linux.oracle.com

Solution

To implement the solution please execute the following steps :

1. If you are not the person who maintains the Network Configuration, please contact the Network team to get the DNS issue fixed.

2. Verify, if the DNS Service is now reposrting your host correct :

nslookup <hostname>.<domain name>

3. Start the Clone on the target again.

Attention :

It could happen, that you need to copy the Database files again - therefore it is a good idea to have a backup of the DB-Tier files available, until your DB-Tier Clone finished successfully.