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.
Leave a Reply