[Solved]Upgrade Oracle Apps (EBS) to 12.2? ORA 01804: Failure To Initialize Timezone Information – Issue While Running AutoConfig

This post covers issues while running Autoconfig on DB Tier after upgrading the database.

If you are new to EBS, please check our previous posts:

• Steps to Download Oracle EBS R12 Software from edelivery site
• Oracle E-Business Suite (EBS) 12.2.9 Now Available & Its Upgrade Steps
• [1Z0-238] Oracle EBS R12 Certified Specialist Everything You Must Know About

Issue:

1. Running Autoconfig on Database tier as

$ORACLE_HOME>/appsutil/bin/adconfig.sh contextfile=$ORACLE_HOME/appsutil/PROD1211_iamdemo01.xml

Error Messages In AutoConfig logs: /u01/oracle/PROD1211_11204/db/tech_st/11.2.0/appsutil/log/

PROD1211_iamdemo01/12180900/adconfig.log

SQLPLUS Executable : /u01/oracle/PROD1211_11204/db/tech_st/11.2.0/bin/sqlplus

ERROR:
ORA 01804: failure to initialize timezone information

SP2-0152: ORACLE may not be functioning properly
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END

Check Out : How To Install Oracle E-Business Suite R12.2

Fix:

Apply patch 7651166 (as per ReadMe instructions ) to fix the above issue and run AutoConfig again as

$ORACLE_HOME/ appsutil/ bin/ adconfig.sh contextfile=$ORACLE_HOME/ appsutil/PROD1211_iamdemo01.xml

You should see a message “AutoConfig Completed Successfully”

Also Check: Our previous blog post on Oracle EBS File System. Click here

Related Further Readings

• [1Z0-238] Oracle EBS R12 Certified Specialist Everything You Must Know About
• 19c Database In Oracle EBS R12: Everything You Must Know
• Steps to Download Oracle EBS R12 Software from edelivery site
• Oracle E-Business Suite (EBS) 12.2.9 Now Available & Its Upgrade Steps
• EBS 12.1.1: Autoconfig Fails While Running Scripts “afdbprf.sh” and “adcrobj.sh” with 11GR2 Database (Doc ID 1336807.1)
• AutoConfig On Db Tier Fails With Error – SP2-1503: Unable to initialize Oracle call interface (Doc ID 1187616.1)
• Using Wget To Download Software/Patches From Oracle Support
• ADOP ( R12.2 Online Patching ) in Oracle EBS (R12) FAQ

Next Task For You

We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c  and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.

Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.