Tuesday, June 12, 2018

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"

Error

DB Autoconfig failed with below error:

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /s01/app/oracle/db_tech_st/12.1.0.2/appsutil/TEST1_linx32
      afdbprf.sh              INSTE8_PRF         1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /s01/app/oracle/db_tech_st/12.1.0.2/appsutil/TEST1_linx32
      adcrobj.sh              INSTE8_APPLY       1

AutoConfig is exiting with status 2


afdbprf.sh started at Sun Jun 10 00:00:26 EDT 2018


The environment settings are as follows ...

       ORACLE_HOME : /u01/app/orad1i/db/tech_st/12.1.0.2
        ORACLE_SID : TEST1

Executable : /u01/app/orad1i/db/tech_st/12.1.0.2/bin/sqlplus

ERROR:

ORA-01804: failure to initialize timezone information

Cause

It is not able to find the TimeZone parameter  value in the specified path

[oracle@linx32  ~]$ echo $ORA_TZFILE
/u01/app/orad1i/db/tech_st/12.1.0.2/oracore/zoneinfo/timezlrg.dat

[oracle@linx32 ~]$ ls -ltr /u01/app/orad1i/db/tech_st/12.1.0.2/oracore/zoneinfo/timezlrg.dat
ls: cannot access /u01/app/orad1i/db/tech_st/12.1.0.2/oracore/zoneinfo/timezlrg.dat.: No such file or directory

Solution

Create a soft link to existing Time zone file

oracle@linx32 ~]$ cd /u01/app/orad1i/db/tech_st/12.1.0.2/oracore/zoneinfo

[oracle@linx32 ~] ln -s timezlrg_25.dat timezlrg.dat

[orad1i@nchlamsdb01 zoneinfo]$ ls -ltr timezlrg.dat
lrwxrwxrwx 1 oracle dba 11 Jun 11 10:24 timezlrg.dat -> timezlrg_25.dat

Re-run  Autoconfig, it shoud work.




No comments:

Enabling SSL or TLS in Oracle E-Business Suite Release 12.2

Enabling TLS in Oracle Apps R12.2 Here  we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...