Difference between Oracle Apps R12 and 11i

August 28, 2009 at 5:34 pm 5 comments


 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  
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Forms version in R12 is 
$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=

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. 



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.


 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


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
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
FORMS_WEB_CONFIG_FILE $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg



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…

About these ads

Entry filed under: Oracle Apps DBA Useful Information. Tags: , , , .

New method for managing customizations in Oracle Apps

5 Comments Add your own

  • 1. John  |  August 30, 2009 at 5:50 am

    thanks for sharing sharing ..

  • 2. Rahul  |  December 29, 2009 at 5:24 am


    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…


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

Recent Posts



Get every new post delivered to your Inbox.

%d bloggers like this: