This post covers issue running Autoconfig on DB Tier after upgrading database reported in our Oracle EBS Upgrade R12.2 training (next batch starts on 20th Feb and only limited seats are available . We limit number trainees to 15 and where we cover Architecture, Overview of R12.2 & Major features in Upgrading to R12.2, Different upgrade paths available to R12.2, Best practices for R12.2 Upgrade, How to minimize down time for R12.2 Upgrade, Difficulties/Issues while upgrading to R12.2)
One of the trainee from our previous batch, encountered issue “ORA-01804: failure to initialize timezone information” in Post Database upgrade 18.104.22.168 step while running AutoConfig.
Note: There are total 9 stages in 12.2 Upgrade where database upgrade to 11gR2 or 12c is one of the step.
1. Running Autoconfig on Database tier as
Error messages in AutoConfig logs: /u01/oracle/PROD1211_11204/db/tech_st/11.2.0/appsutil/log/
SQLPLUS Executable : /u01/oracle/PROD1211_11204/db/tech_st/11.2.0/bin/sqlplus
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
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”
If you want to learn more about Oracle EBS Upgrade to R12.2 then click the button below and register for our Oracle Upgrade 12.2 (next batch starts on 20th February, 2016 )
Note: We are so confident on our workshops that we provide 100% Money back guarantee, in unlikely case of you being not happy after first sessions, just drop us a mail before second session and We’ll refund FULL money
Stay Tuned for more Information on Oracle Apps 12.2 Upgrade!!
Oracle Consultant at K21 Technologies - Oracle Gold Partner specialising in Design, Implement, and Support.