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

Last updated on DECEMBER 07, 2015

Applies to:

Oracle Applications Manager - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Oracle Applications Technology Stack - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 22-Oct-2013***

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
...

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