Clear jsp cache in R12

1. Shutdown all services - adstpall.sh.

2. BACKUP the files in the following directories and then remove them :
Note: Once you complete these steps, all the above directories would still be
present, but will be empty.
$OA_HTML/cabo/images/cache
$OA_HTML/cabo/styles/cache

3. Remove all files under the $COMMON_TOP/_pages folder

4. Compile jsps:
cd $FND_TOP/patch/115/bin
      ./ojspCompile.pl --compile --flush -p 2

5. Clear browser cache on PC: Delete cookies, temp internet files, history from IE

6. Restart the services - adstrtal.sh

compile jsp in EBS R12

Compile a jsp page:
 cd $OA_HTML
 $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'xxxx.jsp' -log err.log --flush

Compile all jsp pages:
 $FND_TOP/patch/115/bin/ojspCompile.pl --compile  --flush -p 4

Enable Automatic Compilation of JSP pages in R12
edit the $CONTEXT_FILE
Change value for the entry s_jsp_main_mode from justrun to recompile

run AutoConfig, restart the web tier services.

How to get versions used by Oracle E-business suite.

1.Operating system
 uname -a

2. Database
 sqlplus apps/apps

3. Oracle applications
 select release_name from fnd_product_group;

4. Forms, sql, pls, reports
 strings file_name |grep $Header

or use this:
SELECT    'strings $'
       || DECODE (app_short_name,
                  'OFA', 'FA',
                  'SQLGL', 'GL',
                  'SQLAP', 'AP',
                  app_short_name
                 )
       || '_TOP/'
       || subdir
       || '/'
       || filename
       || ' | grep Header'
  FROM ad_files
 WHERE filename = '<your file name>';

5. Database objects
 select text
 from user_source
 where name='&package_name' and text like '%$Header%';

 select name, text
 from dba_source
 where text like '%.pls%' and line < 10;

 select VIEW_NAME, TEXT
 from USER_VIEWS
 where VIEW_NAME = '&VIEW_NAME';

6. Workflow
 select * from WF_RESOURCES where NAME='WF_VERSION';

Run R12 AutoConfig in Parallel Mode

Command to run parallel AutoConfig

Application Tier
perl $AD_TOP/bin/adconfig.pl contextfile=<absolute path to the context file> –parallel

Database Tier
perl $ORACLE_HOME/appssutil/bin/adconfig.pl contextfile=<absolute path to the context file> –parallel

R12 clone with shared appl_top(NFS mount)

Assume your R12 has two nodes:
node1: apps(root+web_entry+web_application+batch_process)+db
  three mount point:
   /local (local mount, INST_TOP)
   /shared (SAN mount, and NFS out, stores application's APPL_TOP, ORACLE_HOME,      IAS_ORACLE_HOME, COMMON_TOP)
   /db (SAN for database)


node2: apps(root+web_entry+web_application)
   only one mount
   /local (local mount, INST_TOP)


Prepare the source system
Execute the following commands to prepare the source system for cloning:
a.Prepare the source system database tier for cloning
Log on to the source system as the ORACLE user, and run the following commands:
$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
$ perl adpreclone.pl dbTier


b.Prepare the source system application tier for cloning
Log on to the source system as the APPLMGR user, and run the following commands on each node that contains an APPL_TOP:
$ cd [INST_TOP]/admin/scripts
$ perl adpreclone.pl appsTier


Copy the application tier file system
you only need to copy the files in node1.

Copy the database node file system


Configure the target systemRun the following commands to configure the target system. You will be prompted for specific target system values such as SID, paths, and ports.
a.Configure the target system database server
Log on to the target system as the ORACLE user and enter the following commands
$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
$ perl adcfgclone.pl dbTier


b.Configure the target system application tier server nodes
Log on to the target system as the APPLMGR user and enter the following commands:
$ cd [COMMON_TOP]/clone/bin
$ perl adcfgclone.pl appsTier


Add nodes into apps server.
 1. in the node you mount the application(node1),
     cd [COMMON_TOP]/clone/bin
     perl adclonectx.pl addnode contextfile=$CONTEXT_FILE


 2. in node2
     cd [COMMON_TOP]/clone/bin
     mkdir -p /local/inst/apps/$CONTEXT_NAME (create the directory)
     perl [AD_TOP]/bin/adconfig.pl contextfile=<the xml file generated in step 1>

txkrun.pl errors in R12

txkrun.pl with following errors,
Failed to get connection using s_apps_jdbc_connect_descriptor=jdbc:oracle:thin:xxxxxx

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

The problem is at the jave version, people should use 1.6 wich came with the application(under the $IAS_ORACLE_HOME/appsutil/jdk/jre/bin/java).

to find out which java you are using
$which java

to find out the java version you are using
$java -version

if you current java environment is not set at version 1.6, then

export PATH=$IAS_ORACLE_HOME/appsutil/jdk/jre/bin:$PATH

and try txkrun.pl again

R12 form builder frmbld.sh problem.

The problem that I had with this frmbld.sh is, it can't open existing files.

Solutions:
Unset LANG environment or

Add the following in $ORACLE_HOME/bin/frmbld.sh   just before the line $ORACLE_HOME/bin/frmbld $*

## Check LANG variable for UTF character set
if echo $LANG | /bin/grep -i '\.utf.*8' > /dev/null
then
export LANG=`echo $LANG | /bin/sed 's#\.[u|U][t|T][f|F].*8.*##'`
fi

SSH for Oracle Apps dba

Assume you have two apps nodes, both files system own by operating system user applmgr.
1. generate public and private keys in you loacl host
-bash-3.2$ ssh-keygen
2. Copy the public key to remote server
-bash-3.2$ ssh-copy-id -i ~/.ssh/id_rsa.pub remotehost.mydomain
example to shutdown apps in remote server(from you localhost)
ssh remotehost.mydomain   '. .bash_profile; $ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps'

using ssh with rsync
rsync -av -e ssh /source user@remoteserver:/target

odf and xdf in Oracle E-Business Suite

odf - Object Description file, Oracle use this in EBS to create database objects, ie tables, views, indexes. The replacement for odf is called xdf.

useage of odf:
$AD_TOP/bin/adodfcmp odffile=<Filename> mode=<Objects to be checked/updated> changedb=NO \
userid=<User>/<Password> touser=<User>/<Password> priv_schema=SYSTEM/<Password>

useage of xdf:
$JAVA_TOP/oracle/apps/fnd/odf2/adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp <Oracle_Schema> <Oracle_Password> \
<apps_schema> <apps_password> <jdbc protocol> <JDBC_Connect_String> <Object Type> \
<full path to xdf file> <full path of $FND_TOP/patch/115/xdf/xsl>

More details in Oracle support notes:
How to verify or create a Database Object using a odf (adodfcmp) or xdf (FndXdfCmp) file ? [ID 551325.1]

How to clear mid-tiers cache in R12

Functional Administrator->Core Services->Caching Framework->Global Configuration->"clear All Cache" button

R12 Personalization Export and Import

Export from source instance
1. Set profile option "FND: Personalization Document Root Path", default is /tmp/custdocs
2. Functional Administrator->Personalization-> Import/Export
   select from the "Personalization Repository" then click the "Export to File System" button, it will create files in that "/tmp/custdocs" direcotry.


Import into target instance
1. Set profile option "FND: Personalization Document Root Path" in your target instance.
2. copy the export files to your target instance, put it under the "FND: Personalization Document Root Path" directory in your target instance.
3. Functional Administrator->Personalization-> Import/Export
   click on the "Exported personalizations" on the left, then select the personalizations you need, and click "Import from File System"

Addition information:

Get the Personalization Document info: run this as apps user:
SQL> set serveroutput on
SQL> exec jdr_utils.listCustomizations('<full document name>')


export/import translations:
export:
Functional Administrator->Personalization Tab -> Put the Document Path (under the "Application Catalog" tab not the "Import/Export" tab, the document path can be obtained by going to the page -> About This Page -> Personalization) -> Click on GO
Click on Manage Personalizations -> Check the Box for  Site -> Extract Translations -> Select your language and click on Apply button

import:
Functional Administrator->Personalization Tab -> Put the Document Path (same as used above) -> Click on GO
Click on Manage Personalizations -> Check the Box for  Site -> Upload Translations

R12 application tier install with shared appl_top for upgrade

This is only for people who would like to install R12 application tier with shared appl_top for application upgrade(11i to 12.1.x), and this is not for new system installation.
This is based on you are using NFS mount for your shared appl_top, you need to setup three mount points:
For other shared file system options, please see Steven Chan's blog
Choosing a Shared File System for Oracle E-Business Suite


1. local mount to hold your application $INST_TOP:
/apps/PROD

2. NFS mount for your shared appl_top, application $APPL_TOP, $COMMON_TOP, $ORACLE_HOME, $IAS_ORACLE_HOME:
/oracle/PROD

3. database(SAN mount) for your database:
/database/PROD

Steps:

1.       Click next

2.       Select “Upgrade to oracle Applications Release 12.1.1

3.       Click next

4.       Select  “Create Upgrade File System”

5.       Select  a port pool(the rule here are, if you choose pool 1, then the http port will be 8000+1, so http port is 8001, and database port is 1521+1, so the db port is 1522.)

6.       Fill in database information

      here, you database host is Primary, SID is PROD, the database $ORACLE_BASE is /database/PROD. Because this is an upgrade, so I assume that you already have this database installed with all your 11i data. (here I put my primary apps node and database node in the same server)

7.       fill in your apps password and Click next,

8.       Fill in Base directory, and instance directory, and click “Edit Services”. (here I put my primary apps node and database node in the same server)

       in the "Base directory" I put the direcotry under NFS mount, which will be your shared appl_top

       in the "Instance directory" I put my local mount, which will be your $INST_TOP for this node.

9.       Select services you want to run in this server.(This just an example here, usually in production instance, people may just want to put the "Batch processing services" into the same node as database, and leave all others to some low end servers(less CPUs). )

10.       Click “Add Server”

11.       Change the Host Name, and Check  “Shared file System”, and click the “Edit Services”

         in the "Instance directory" I put my local mount in apps1, which will be your $INST_TOP for this node.

12.       Disable both “Batch Processing Services” and “Other Services”

13. Repeat step 11-13 for other servers, and click “Next”

14.       Click “Next”

15.       Click “Next”

16.       when the installation finished, at the Linux window(not the Xwindow), you will see some lines like:

Configuration file written to: /apps/PROD/inst/apps/PROD_Primary/conf_PROD.txt

Copy this file to another directory, like somewhere under your NFS mount, here I copy it to /oracle/PROD/.  you will need it to configure other severs.

17.       start from this step, we will install apps on other servers.

        We may have to change the oraInventory on those apps servers,

   edit or create a file /etc/oraInst.loc

   put two lines in this oraInst.loc

     inventory_loc=/apps/oraInventory

     inst_group=dba

create a directory /apps/oraInventory

and chmod –R 777 /apps/oraInventory

start the installation

Click “next”

18.       select “Install Oracle Applications Release 12.1.1”

19.       click “next”

20.       select “Load the following saved configuration”, and put the file that we copied in step 17 in here. And click “next”

21.       click “next”

22.       click “next”

23.       repeat step 18 to 24 for all other servers.



"Logged in As" someone else in 11i and R12

On the OAHOMEPAG "Logged in As" string, in the upper right corner of the page, indicates you are logged in as someone else.

If you are using F5 BigIP to off load SSL, then try not use the RAM cache in your HTTP profile or exclude some URI like /OA_HTML/AppsLogin, /OA_HTML/OA.jsp  in your cache setting for HTTP profile.

mod_osso in httpd.config

when you get error in Apaceh error log like this(in R12) :
mod_oc4j: Response status=499 and reason=Oracle SSO, but failed to get mod_osso global context.
check your httpd.conf under $INST_TOP/ora/10.1.3/Apache/Apache/conf/

make sure this line looks like (not #include "\Apache\A.....)
include "\Apache\Apache\conf\mod_osso.conf"

Useful Articles for the Oracle E-Business Suite Technology Stack for Technical Consultant / DBA [ID 828157.1]

I hope this My Oracle support note can help EBS DBAs to save time. This note lists most Oracle EBS Technology stack related documents with ID. You may want to add this into your favorites in your my oracle support account.  Here is what's in the note.

Useful Articles for the Oracle E-Business Suite Technology Stack for Technical Consultant / DBA [ID 828157.1]
Applies to:
Oracle Applications Technology Stack - Version: 11.5.10.2 to 12.1.3 - Release: 11.5.10 to 12.1
Information in this document applies to any platform.
Goal
This note is to list the main Setup, Installation and Diagnostics notes available related to the Oracle E-Business Suite Technology stack.
Solution
Java
----------------------------------------------------------------------------------------------------
note 418664.1 Overview of Using Java with Oracle E-Business Suite Release 12
note 455492.1 Using Latest Update of Java 6.0 with Oracle E-Business Suite Release 12
note 384249.1 Using Latest Update of JDK 5.0 with Oracle E-Business Suite Release 12
note 300482.1 Overview of Using Java with Oracle E-Business Suite Release 11i
note 401561.1 Using J2SE Version 6 with Oracle E-Business Suite 11i
note 304099.1 Using J2SE Version 5.0 with Oracle E-Business Suite 11i, Release 11.5.10
note 246105.1 Upgrading to J2SE 1.4.2 with Oracle Applications 11i
note 130091.1 Upgrading Oracle Applications 11i to use JDK 1.3

JRE/Jinitiator/EBS Client Software
----------------------------------------------------------------------------------------------------
note 389422.1 Recommended Browsers for Oracle E-Business Suite Release 12
note 393931.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12
note 285218.1 Recommended Browsers for Oracle Applications 11i
note 290807.1 Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
note 124606.1 Upgrading JInitiator with Oracle E-Business Suite 11i
note 1155883.1 Oracle E-Business Suite Desktop Client Hardware and Software Requirements
Forms
----------------------------------------------------------------------------------------------------
note 437878.1 Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
note 750359.1 Upgrading to Previous Version of OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12
note 384241.1 Using Forms Socket Mode with Oracle E-Business Suite Release 12
note 438652.1 R12 Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications
note 125767.1 Upgrading Developer 6i with Oracle Applications 11i
note 232313.1 Information on Previous Versions of Developer 6i Patchsets
note 201340.1 Using Forms Listener Servlet with Oracle Applications 11i
note 150168.1 Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications 11i
note 760250.1 Diagnosing Forms Mouse Focus Problems Using JRE in Release 11i

note 1207184.1 Enhanced Signing of Oracle E-Business Suite JAR Files
OracleAS
----------------------------------------------------------------------------------------------------
note 454811.1 Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12
note 743518.1 Starting up AS10g services in an EBusiness Suite Release 12 environment

JDBC
----------------------------------------------------------------------------------------------------
note 557194.1 monitor_jdbc_conn.sql - Script to monitor JDBC connections in Apps eBusiness Suite
note 427759.1 How To Prevent Inactive JDBC Connections In Oracle Applications

JVM
----------------------------------------------------------------------------------------------------
note 362851.1 Guidelines to setup the JVM in Apps Ebusiness Suite 11i and R12
note 567551.1 Configuring various JVM tuning parameters for Oracle E-Business suite 11i and R12
note 370583.1 Basic troubleshooting of JVM consuming cpu or too many JDBC connections in Apps 11i

Apache/mod_jserv
----------------------------------------------------------------------------------------------------
note 230688.1 11i Basic Apache/mod_jserv Troubleshooting with Hello.class

Debug/Trace
----------------------------------------------------------------------------------------------------
note 422419.1 R12 - How To Enable and Collect Debug for HTTP, OC4J and OPMN
Note 443671.1 R12 - Collecting Configuration Information for HTTP, OC4J and OPMN
note 427848.1 How to Enable Execution Context ID (ECID) in the R12 access_log
note 455154.1 R12: How To Obtain A Thread Dump When OC4J is shutdown
note 603390.1 How To Create a User Event Trace in R11i / R12

OA Framework
----------------------------------------------------------------------------------------------------
note 391554.1 Oracle Application Framework Documentation Resources, Release 12
note 275880.1 Oracle Application Framework Release 11i Documentation Road Map
note 275875.1 Oracle Application Framework Troubleshooting Release 11i (11.5.10)
note 357597.1 How To Generate A SQL Trace In OA Framework For Oracle Applications

WebCache
----------------------------------------------------------------------------------------------------
note 380486.1 Installing and Configuring Web Cache 10g and Oracle E-Business Suite 12
note 306653.1 Installing and Configuring Web Cache 10.1.2 and Oracle E-Business Suite 11i

JDeveloper
----------------------------------------------------------------------------------------------------
note 330236.1 Configuring JDeveloper For Use With Oracle Applications 11i and R12
note 357218.1 Troubleshooting JDeveloper setup for Oracle Applications
note 416708.1 How to find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x

Performance
----------------------------------------------------------------------------------------------------
note 163208.1 bde_last_analyzed.sql - Verifies CBO Statistics
note 174605.1 bde_chk_cbo.sql - Reports Database Initialization Parameters related to an Apps 12 or 11i instance
note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
note 216205.1 Database Initialization Parameters for Oracle Applications 11i
note 744143.1 Tuning performance on eBusiness suite
note 169935.1 Troubleshooting Oracle Applications Performance Issues
note 244040.1 Oracle E-Business Suite Recommended Performance Patches

Security
----------------------------------------------------------------------------------------------------
note 738923.1 Oracle E-Business Suite Releases 11i and 12 Critical Patch Update note (January 2009)
note 403537.1 Best Practices for Securing Oracle E-Business Suite Release 12
note 189367.1 Best Practices for Securing the E-Business Suite Release 11i

Ihelp
----------------------------------------------------------------------------------------------------
Note 740834.1 R12: Troubleshooting iHelp

Advanced Configurations
----------------------------------------------------------------------------------------------------
note 380483.1 Oracle E-Business Suite Release 12 Additional Configuration and Deployment Options
note 384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12
note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
note 233428.1 Sharing the Application Tier File System in Oracle Applications 11i
note 233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
note 364439.1 Tips and Queries for Troubleshooting Advanced Topologies

DMZ
----------------------------------------------------------------------------------------------------
note 380490.1 Oracle E-Business Suite R12 Configuration in a DMZ
note 726953.1 Case History: Implementing a Reverse Proxy Alone in the DMZ Configuration - R12
note 287176.1 DMZ Configuration with Oracle E-Business Suite 11i
note 438744.1 Case History: Implementing a Reverse Proxy Alone in a DMZ Configuration - 11i
note 460564.1 Hints and Tips for Troubleshooting the URL Firewal

Loadbalancer
----------------------------------------------------------------------------------------------------
note 380489.1 Using Load-Balancers with Oracle E-Business Suite Release 12
note 727171.1 Implementing Load Balancing On Oracle E-Business Suite - Documentation For Specific Load Balancer Hardware
note 601694.1 How To Check Session Persistence On BigIP F5 And Cisco Ace Load Balancer Appliances
note 603325.1 Using Cisco ACE Series Application Control Engine with Oracle E-Business Suite Release 12

SSL
----------------------------------------------------------------------------------------------------
note 376700.1 Using SSL with Oracle E-Business Suite Release 12
Note 1330799.1 Login Page Fails To Render On SSL Terminated Application Tiers 
note 123718.1 11i A Guide to Understanding and Implementing SSL for Oracle Applications

Portal
----------------------------------------------------------------------------------------------------
note 380484.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 12
note 305918.1 Using Oracle Portal 10g with Oracle E-Business Suite Release 11i

SSO/OID
----------------------------------------------------------------------------------------------------
note 876539.1 Using the Latest Oracle Internet Directory 11gR1 Patchset with Oracle Single Sign-on and Oracle E-Business Suite
note 376811.1 Integrating Oracle E-Business Suite Release 12 with 10g AS Oracle Internet Directory and Oracle Single Sign-On
note 261914.1 Integrating Oracle E-Business Suite Release 11i with Oracle Internet Directory and Oracle Single Sign-On
note 444573.1 Basic checks for user integration when using Oracle E-Business Suite 11i with Oracle AS 10g

Orace Access Manager / AccessGate
----------------------------------------------------------------------------------------------------
note 975182.1 Integrating Oracle E-Business Suite with Oracle Access Manager using Oracle E-Business Suite AccessGate
note 1077460.1 Troubleshooting Oracle Access Manager and Oracle E-Business Suite AccessGate

Webcenter
----------------------------------------------------------------------------------------------------
note 1074345.1 Using WebCenter 11.1.1 with Oracle E-Business Suite Release 12
note 557221.1 Oracle WebCenter 10g Application Creation and Deployment Guide for Oracle E-Business Suite Release 12

Secure Enterprise Search
----------------------------------------------------------------------------------------------------
note.566097.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.1.1
note.744820.1 Oracle E-Business Suite Secure Enterprise Search Best Practices, Release 12
note.462377.1 Installing Oracle E-Business Suite Secure Enterprise Search, Release 12
note.740499.1 Oracle E-Business Suite Secure Enterprise Search Release Notes, Release 12.0.6
note 726239.1 Oracle E-Business Suite Secure Enterprise Search Troubleshooting Guidelines, Release 12

SOA/BPEL/Webservices
----------------------------------------------------------------------------------------------------
note 556540.1 Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1
note 565922.1 Oracle E-Business Suite Integrated SOA Gateway Release Notes, Release 12.1.1
note 815196.1 Oracle E-Business Suite Integrated SOA Gateway 12.1.1 Consolidated One-Off
note 726414.1 Oracle E-Business Suite Integrated SOA Gateway Troubleshooting Guide, Release 12
note 755067.1 Using Oracle BPEL 10g with E-Business Suite Release 12.1.1
Note 782455.1 How Can I Expose E-Business Suite Integration Interfaces as Web Services in Release 11i and R12.0

MWA
----------------------------------------------------------------------------------------------------
note 782162.1 MWA Troubleshooting Tips for Release 12
note 269991.1 MWA Troubleshooting Tips for Release 11i

Certified/Supported
----------------------------------------------------------------------------------------------------http://blogs.oracle.com/stevenchan/certifications.html
note 363827.1 Rebaselined Oracle Applications Technology Components for Releases 11.5.7, 11.5.8, 11.5.9, and 11.5.10
note 883202.1 Minimum Baseline Patch Requirements for Extended Support on Oracle E-Business Suite 11.5.10
note 1199724.1  E-Business Suite 11.5.10 Minimum Patch Level and Extended Support Information Center

WEBADI
----------------------------------------------------------------------------------------------------
note 417692.1 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
note 452452.1 R12 Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator)
note 294739.1 How to enable tracing for WEBADI
note 726989.1 List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12

Diagnostics
----------------------------------------------------------------------------------------------------
note 167000.1 E-Business Suite Diagnostics Installation Guide
note 421245.1 E-Business Suite Diagnostics References for R12
note 179661.1 E-Business Suite Diagnostics 11i Test Catalog

Installation
----------------------------------------------------------------------------------------------------
note 761564.1 Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86
note 402310.1 Oracle Applications Installation and Upgrade notes Release 12 (12.0) for Linux (32-bit)
note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone
note 559518.1 Cloning Oracle E-Business Suite Release 12 RAC-Enabled Systems with Rapid Clone
note 421409.1 Unbreakable Linux enviroment check before R12 install
note 458533.1 How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
note 603716.1 Using AS10g AS Control with eBusiness Suite Rel 12
note 452120.1 How to locate the log files and troubleshoot RapidWiz for R12
note 316806.1 Oracle Applications Installation Update notes, Release 11i (11.5.10.2)
note:230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
note 207296.1 How to Find out Linux Version Information?

Database
----------------------------------------------------------------------------------------------------
note:454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
note 735276.1 Interoperability notes E-Business Suite R12 with Oracle Database 11gR1
note 388577.1 Configuring Oracle Applications Release 12 with 10g R2 RAC
note 466649.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
note 452783.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0)
note 362135.1 Configuring Oracle Applications Release 11i with 10g R2 RAC and ASM
note 554539.1 Using Database Partitioning with Oracle E-Business Suite

FNDLOAD during R12 upgrade

During the R12 upgrade, looks like Oracle upgrade program doesn't stop you when there are errors in FNDLOAD program. I really don't know if there is a better way to resolve this(please add comments, if you know how to resolve this), but here is what I do now.

1. go to the log directory, ie your $APPL_TOP/admin/xxxx/log

2. using the grep:
    grep "ORA-" *ldt.log > ora.txt

3. check this ora.txt file,and find out which fndload failed, fix the problem and try load it again, hope there are not too much.

More details for FNDLOAD, see Oracle support note:
Tips About FNDLOAD [ID 735338.1]

WSMPNTXN_XML not found

During the r12 upgrade, when apply the NLS 6678700 patch, it may fails for Template WSMPNTXN_XML not found.

The Oracle support solution is:
User is upgrading to 12.1.3, and this issue is occurring on the 12.1.1 NLS patch, 6678700 (Latin American Spanish)and has $WSM_TOP/patch/115/publisher/templates/US/WSMPNTXN_XML.rtf 120.0.12010000.2 installed.
To resolve apply Patch 7625851:R12.WSM.B to your test instance and then try applying 6678700


However, you may not want to stop your 6678700 patch, so here is something you can do:
Download this patch, both en and your NLS, copy .rtf to us and .xlf to your NLS. then run this:

java oracle.apps.xdo.oa.util.XDOLoader \
UPLOAD \
-DB_USERNAME apps \
-DB_PASSWORD apps \
-JDBC_CONNECTION host:port:SID \
-LOB_TYPE TEMPLATE_SOURCE  \
-LOB_CODE WSMPNTXN_XML \
-APPS_SHORT_NAME WSM \
-XDO_FILE_TYPE RTF \
-TEMPLATE_CODE WSMPNTXN_XML \
-TRANSLATE Y \
-FILE_NAME $WSM_TOP/patch/115/publisher/templates/US/WSMPNTXN_XML.rtf

-TRANSLATE Y is the key

The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publisher database tables. Use this utility to download files from one instance and load to another.

More details for XDOloader, see Oracle support note:
How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1]

Database adconfig.sh error

If you run into error "adchknls.pl INSTE8_SETUP" at database adconfig.sh after you did database upgrade or migrate OS.

then try this:

• The PERL5LIB environment variable points to the directories where the new perl libraries are located (usually $ORACLE_HOME/perl/lib/[perl version] and   $ORACLE_HOME/perl/lib/site_perl/[perl version])
• run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory.  export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

Oracle E-Business Suite R12.2 secondary file system.

We all know that Oracle EBS R12.2 is coming soon, there are two useful documents for the R12.2, “Glimpses of E-Business Suite 12.2: WebLogic Server and Online Patching” from Steven Chan’s blog (http://blogs.oracle.com/stevenChan/entry/glimpses_of_e_business_suite)

And the MOS note “Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)”

The well known changes are using Weblogic server to replace the current OC4J (10.1.3 or IAS_ORACLE_HOME) and the Online Patching. And that MOS note has additional information for both changes.

“Additionally, Oracle E-Business Suite Release 12.2 will have a secondary file system for the application tier. The secondary file system facilitates the online patching functionality for Oracle E-Business Suite patches and follows the best practices recommendations of Oracle technologies for minimal patching disruption.”

So The secondary file system?

Just add more information for R12.2, this also from Steven Chan's blog"Summary of Oracle E-Business Suite Technology Webcasts and Training " looking for the #7 "Oracle E-Business Suite Directions: Deployment and System Administration " this presentation has more details on R12.2