Autoconfig On Db Tier Fails - failure to initialize timezone information (Doc ID 2067388.1)

Last updated on OCTOBER 21, 2015

Applies to:

Oracle Applications DBA - Version 11.5.10.0 to 12.2.4 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 12.2,
Autoconfig on the database tier fails with the following error:

afdbprf.sh started at Wed Oct 14 18:27:36 CDT 2015


The environment settings are as follows ...

     ORACLE_HOME : /oracle/afsfms/r12d/r12ddb/12.1.0
      ORACLE_SID : r12d
            PATH : /oracle/afsfms/r12d/r12ddb/12.1.0/perl/bin:/oracle/afsfms/r12d/r12dscr/bin:/oracle/afsfms/r12d/r12ddb/12.1.0/OPatch:/oracle/afsfms/r12d/r12ddb/12.1.0/perl/bin:/oracle/afsfms/r12d/r12dscr/bin:/oracle/afsfms/r12d/r12ddb/12.1.0/OPatch:/oracle/afsfms/r12d/r12ddb/12.1.0/perl/bin:/oracle/afsfms/r12d/r12dscr/bin:/oracle/afsfms/r12d/r12ddb/12.1.0/OPatch:/oracle/afsfms/r12d/r12ddb/12.1.0/perl/bin:/oracle/afsfms/r12d/r12ddb/12.1.0/bin:/usr/ccs/bin:/usr/sbin:/oracle/afsfms/r12d/r12ddb/12.1.0/appsutil/jre/bin:/oracle/afsfms/afsvdba/scripts:/oracle/afsfms/r12d/r12dscr/bin:/usr/local/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/lib:/opt/SUNWexplo/bin:/usr/sfw/bin:.:.:.:.
    Library Path : /oracle/afsfms/r12d/r12ddb/12.1.0/lib:/usr/dt/lib:/usr/openwin/lib:/oracle/afsfms/r12d/r12ddb/12.1.0/ctx/lib:/oracle/afsfms/r12d/r12ddb/12.1.0/lib32

Executable : /oracle/afsfms/r12d/r12ddb/12.1.0/bin/sqlplus

ERROR:
ORA-01804: failure to initialize timezone information


SP2-0152: ORACLE may not be functioning properly
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

 

The issue can be reproduced at will with the following steps:
1. Run Autoconfig on the database tier.

Changes

 Upgrade 11i to 12.2

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