Difference between Oracle Apps R12 and 11i
August 28, 2009 at 5:34 pm 5 comments
Techstack
R12 is certified to be compatible with 10g and 11g databases
Two Oracle Homes have been introduced in R12 ( ie 10.1.2 and 10.1.3) (Difference between 2 application oracle home coming soon)
Webserver in R12 is version 10.1.3 whereas in 11i it is 1.0.2.2.2
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v
Forms version in R12 is 10.1.2.0.2
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
Forms in R12 by default run in servlet mode , whereas in 11i it runs in socket mode.
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
serverURL=/forms/lservlet
R12 Java proccesses use version > 1.5.0 whereas in 11i it is 1.3 or 1.4
sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print $2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;
“java version “1.6.0_10”
Java(TM) SE Runtime Environment (build 1.6.0_10-b33)
Java HotSpot(TM) Server VM (build 11.0-b15, mixed mode)
New Instance top ($INST_TOP) has been introduced in R12 , it stores configuration and log files and even context file is located in inst_top . Below table should provide more information. Please note inst_top is recommended to be local on the server and not on san box storage.
Filesystem
File |
Oracle Applications 11i |
Release 12 |
Environment Source file | APPSORA.env | APPS<SID>_<hostname>.env |
Context File (middle tier) | $APPL_TOP/admin/$TWO_TASK.xml | $INST_TOP/appl/admin/$TWO_TASK_<hostname>.xml |
tnsnames.ora (OH) | $ORACLE_HOME/network/admin/<CONTEXT> | $INST_TOP/ora/10.1.2/network/admin |
listener.ora | $ORACLE_HOME/network/admin/<CONTEXT> | $INST_TOP/ora/10.1.2/network/admin |
appsweb.cfg | $OA_HTML/bin | $INST_TOP/ora/10.1.2/forms/server |
tnsnames.ora (Apache) | $IAS_ORACLE_HOME/network/admin/<CONTEXT> | $INST_TOP/ora/10.1.3/network/admin |
zone.properties | $IAS_ORACLE_HOME/Apache/Jserv/etc | $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/application-deployments/oacore/oa_servlets/orion-web.xml and …/oacore/html/orion-web.xml (Same file located in both directories) |
httpd.conf | $IAS_ORACLE_HOME/Apache/Apache/conf | $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf |
apps.conf | $IAS_ORACLE_HOME/Apache/Apache/conf | $ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf |
formservlet.ini | $IAS_ORACLE_HOME/Apache/Jserv/etc | $ORACLE_HOME/forms/server/default.env |
topfile.txt | $APPL_TOP/admin | $APPL_CONFIG_HOME/admin |
adovars.env | $APPL_TOP/admin | $APPL_CONFIG_HOME/admin |
adjborg2.txt | $APPL_TOP/admin | $APPL_CONFIG_HOME/admin |
SSL Certificates | $COMMON_TOP/admin/certs | $INST_TOP/certs |
AD scripts logs | $COMMON_TOP/admin/log/<SID_hostname> | $LOG_HOME/appl/admin/log |
Concurrent Request logs | $APPLCSF | $APPLCSF |
Apache logs | $IAS_ORACLE_HOME/Apache/Apache/logs | $LOG_HOME/ora/10.1.3/Apache |
Jserv logs | $IAS_ORACLE_HOME/Apache/Jserv/logs | $LOG_HOME/ora/10.1.3/j2ee |
javacache.log | $COMMON_TOP/rgf/<SID_Hostname> | $LOG_HOME/appl/rgf |
Look and Feel
R12 has a different look as compared to 11i , however the navigation and key strokes remain same . There is not much difference that i could see.
Configurations.
Configuration related to techstack remains same other than filesystem structure however custom tops that we add in jserv.properties in 11i now goes in default.env located on $INST_TOP/apps/<SID>_<HOSTNAME>/ora/10.1.2/forms/server/default.env
All entries related to custom top needs to be added in default.env file
Environment Varaibles
Variable |
Oracle Applications 11i |
Release 12 |
APPL_TOP | $HOME/<SID>appl | $HOME/apps/apps_st/appl |
COMMON_TOP | $HOME/<SID>comn | $HOME/apps/apps_st/comn |
ORACLE_HOME (applmgr) | $HOME/<SID>ora/8.0.6 | $HOME/apps/tech_st/10.1.2 |
IAS_ORACLE_HOME | $HOME/<SID>ora/iAS | $HOME/apps/tech_st/10.1.3 |
ORACLE_HOME (oracle) | $HOME/<SID>db/10.2.0 | $HOME/db/tech_st/10.2.0 |
ORADATA | $HOME/<SID>data | $HOME/db/apps_st/data |
JAVA_TOP, OA_JAVA | $COMMON_TOP/java | $COMMON_TOP/java/classes |
OA_HTML | $COMMON_TOP/html | $COMMON_TOP/webapps/oacore/html |
FND_SECURE | $FND_TOP/secure/<SID> | $INST_TOP/appl/fnd/12.0.0/secure |
ADMIN_SCRIPTS_HOME | $COMMON_TOP/admin/scripts/<SID> | $INST_TOP/admin/scripts |
LOG_HOME | – | $INST_TOP/logs |
FORMS_WEB_CONFIG_FILE | – | $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg |
AF_JLIB | – | $COMMON_TOP/java/lib |
JAVA_BASE | – | $COMMON_TOP/java |
INST_TOP | – | $HOME/inst/apps/<CONTEXT> |
ORA_CONFIG_HOME | – | $INST_TOP/ora |
APPLCSF | $COMMON_TOP/admin | $LOG_HOME/appl/conc |
Have tried to consolidate information available in parts and pieces , please feel free to share more information so that same can be added to maintain information at single location. Have a great day ahead…
Entry filed under: Oracle Apps DBA Useful Information. Tags: Apps DBA, Oracle Apps DBA, R12 DBA, R12 vs 11i.
5 Comments Add your own
Leave a reply to baji Cancel reply
Trackback this post | Subscribe to the comments via RSS Feed
1. John | August 30, 2009 at 5:50 am
thanks for sharing sharing ..
2. Rahul | December 29, 2009 at 5:24 am
Hi,
Excellent posting. Thanks a lot for sharing such very good article.
3. baji | August 16, 2010 at 7:20 am
Thaks for the above posting
4. Vedika Munshi | January 12, 2013 at 6:46 pm
Woah! I’m really enjoying the template/theme of this site. It’s simple, yet effective.
A lot of times it’s difficult to get that “perfect balance” between superb usability and appearance. I must say you’ve done a superb
job with this. Also, the blog loads super quick for me on Safari.
Excellent Blog!
5. R12 Implementation | August 29, 2013 at 10:47 am
Its very tough to share unique information and quality content, Really you’ve done the great job! Thanks for sharing the information…