[ How To] Upgrade EBS from 12.0.4 to 12.1.1

Hello All,

Recently we upgraded our current system from 12.0.4 /10.2.0.3 to 12.1.1/10.2.0.4 .


Below is the overview of what all steps we performed.

Database Upgrade : 10.2.0.3 to 10.2.0.4

A] Applying 10204 patchset 3 on existing oracle home.
1] Set the inventory in /etc/oraInst.loc .
2] unzip 6810189 patch with owner of database.
3] cd Disk1 >> ./runInstaller
4] Source the oracle home path which needs to be upgraded.
>> Post Patches [5868257 , 5386204] on upgraded home. [ using opatch]

B] Upgrade Steps
1] Login as database user. [ and sqlplus "/as sysdba"]
2] startup upgrade.
3] cd $OH/rdbms/admin
@utlu102i.sql
4] @catupgrd.sql
5] Run utlrp.sql for compiling invalid objects.
6] Check dba_registry for status [ must be VALID for all Components ]
7] Shutdown immediate.
8] Startup.

C] Post Steps
1] Run adgrants.sql [$ORACLE_HOME/appsutil/admin ]
sqlplus "/as sysdba" @adgrants.sql applsys
2] Run adstats.sql [ database should be restrict mode ]

Applications Upgrade : 12.0.4 to 12.1.1

Prereq :
>> Check for Invalid objects
>> Bring down the Application.
>> Enable Maintenance Mode.

A] Upgrade OracleAS 10g Release 3 (10.1.3) to Patchset 4 (10.1.3.4) :
1] Apply patches : 7237313, 7359933 + opatches [ review from document mentioned below]

B] Upgrade Oracle E-Business Suite Release 12 JDK to Java 6.0 latest update.
Download Java SE Development Kit 6u13 (jdk-6u13-linux-i586-rpm.bin) from http://java.sun.com/javase/downloads/index.jsp

C] Upgrade OracleAS 10g Release (10.1.2) for Forms and Reports to Patchset 3 (10.1.2.3)
1] Apply patch 5983622
2] Post Patches [opatch ] reviewed from Metalink note-id mentioned below.
3] Apply Interop patch 7120543 on 10.1.2.3 Home

D] Apply the AD Minipack : 6767273 , 7461070

E] Apply EBS Maintenance Pack : 7303030

Follow Post steps from 752619.1

Hurray !! You have successfully upgraded your EBS from 12.0.4 to 12.1.1

[Issue] Too Many Open Files Error

Hi All,
We faced an issue during Request Set run of DBI Initial load .

Current setup :
Database :10.2.0.3
Application : 12.0.4
OS : Redhat Advanced server 5 (Tikanga)


Error:
APP-FND-01564: ORACLE error - 1116 in SUBMIT: others
Cause: SUBMIT: others failed due to ORA-01116: error in opening database file 13
ORA-01110: data file 13: '.dbf' '
ORA-27041: unable to open file
SVR4 Error: 24: Too many open files
Additional information: 3
The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.


Cause :
Refer metalink Note-id :397119.1 for more details


Solution :
(before proceeding with the solution , we should always check for the following parameter at OS level)
cat /etc/security/limits.conf
* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536


If you do not have these parameters required values ; then make the changes accordingly ; followed by server bounce.

1) Apply the opatch 5257698 on to ur Application database. [Make sure all your Application/Database services are down]
2) cd $ORACLE_HOME/nls/data/old
3) perl cr9idata.pl [This will recreate the *.nlb file in $ORACLE_HOME/nls/data] Set the environment as mentioned.
4) Start your database and applications services.
5) Retest your issue.

Happy Reading !! :)