Running adpreclone.pl dbTier or Autoconfig fails with error ORA-01882 (Doc ID 1223243.1)

Symptoms

On E-Business Suite Release 12.0.6 the adpreclone.pl dbTier on the DB-Tier is failing with following error  (Same failure has been identified for the Autoconfig execution on the DB-Tier.) :

...
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : xxxxxxx
sDbDomain : xxxxxxx.com
sDbPort : xxxx
sDbSid : xxxxxxx
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@xxxxxxx.yyyyy.com:pppp:xxxxxxx
Exception occurred: java.sql.SQLException:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxx.yyyyy.com)(PORT=xxxx))(CONNECT_DATA=(SERVICE_NAME=xxxxxxx)))
Exception occurred: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxx.yyyyy.com)(PORT=xxxx))(CONNECT_DATA=(SERVICE_NAME=xxxxxxx.yyyyy.com)))
Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Connection could not be obtained; returning null
...

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.