Upgrade Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

Upgrade Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12

Oracle recommends that Oracle E-Business Suite 12 customers move to the latest and therefore most secure certified version of the Sun JRE Native Plug-in on either stream (JRE 5.0.x or JRE 6.0.x).

1. Check Version.

D:\oracle\PROD\apps\apps_st\appl>grep plugin %CONTEXT_FILE%
[!-- JDK plugins --]
[sun_plugin_ver oa_var="s_sun_plugin_ver"]1.5.0_13[/sun_plugin_ver]


2.Download the JRE Plug-in Interoperability Patch

Download the JRE Plug-in Oracle E-Business Suite interoperability patch 4377566

3.Download the Java Runtime Environment (JRE) 6 plug-in from

http://java.sun.com/javase/downloads/index.jsp

Select the Java Runtime Environment (JRE) 6 Update X ( where X is the current latest version)
Download the Windows Offline Installation version of the Plug-in.
If an earlier version of the JRE 6 Plug-in is required, it can be downloaded from the Sun archive site from http://java.sun.com/products/archive/ .

Select the required release from the drop down menu under, Java 2 Platform Standard Edition (J2SE) -> JDK/JRE - 6 .
Select the Download JRE.
Download the Windows Offline Installation, Multi-language version of the Plug-in.

4.Rename the JRE 6 Plug-in

Rename the downloaded JRE Native Plug-in file from jre-6_uxx-windows-i586-p.exe to j2se160xx.exe

(Where xx = the version number. Using jre-6_u13-windows-i586-p.exe as an example this would be j2se16013.exe).

5.Place the JRE 6 Plug-in on Web Application Tier

Move the j2se1600X.exe file to the web application tier and place it in %[COMMON_TOP]%\webapps\oacore\util\jinitiator..

6.Stop Apps or Shutdown Apache

Shutdown Apache (on normal mode) by running adapcctl.sh stop or by running adstpall.sh /

7.Enable 'Maintenance Mode' from adadmin

Enable 'Maintenance Mode' from adadmin, (Select menu option 5 > Change Maintenance Mode >Select menu option 1 > Enable Maintenance Mode)

7.Apply the patch driver in the interop patch using AutoPatch.

Apply the patch 4377566

8.Run the txkSetPlugin.cmd Script

Run the %FND_TOP%\bin\txkSetPlugin.cmd script against the web application tier node.

txkSetPlugin.cmd [appsora_path] [apps_pwd] [jversion]

9.Disable 'Maintenance Mode' through adadmin

Disable 'Maintenance Mode' from adadmin, (Select menu option 5 > Change Maintenance Mode > Menu option 2 > Disable Maintenance Mode)

10.Restart Apache or Start Apps

Restart Apache (on normal mode) by running adapcctl.sh start or adstrtal.sh /

txkSetPlugin.cmd D:\oracle\PROD\apps\apps_st\appl\APPSSIT_sitartha.cmd xxxxxx 16013

11.Check version Now.
D:\oracle\PROD\inst\apps\SIT_sitartha>grep plugin %CONTEXT_FILE%
[!-- JDK plugins --]
[sun_plugin_ver oa_var="s_sun_plugin_ver"]1.6.0_13[/sun_plugin_ver]

Oracle Application Express Upgrade 3.1.1 to 3.1.2

APEX Upgrade 3.1.1 to 3.1.2 Steps

SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.1.00.09

1.Download from metalink p7313609_11106_GENERIC.zip
2.Unzip and extract p7313609_11106_GENERIC.zip
3.Stop Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl stopproc ias-component=HTTP_Server
4.Login Oracle Database
sqlplus "/as sysdba"
5.Run apxpatch.sql
SQL>@patch\apxpatch.sql
6.Copy image folder.
cp -rf patch/images ORACLE_HTTPSERVER_HOME/Apache/Apache
7.Start Oracle HTTP Server
ORACLE_BASE\ORACLE_HTTPSERVER_HOME\opmn\bin\opmnctl startproc ias-component=HTTP_Server


SQL> select COMP_NAME,VERSION from dba_registry where COMP_NAME like 'Oracle%Application%Express%';
COMP_NAME VERSION
------------------------------ ------------------------------
Oracle Application Express 3.1.2.00.02

Upgrading of Java 6.0 with Oracle E-Business Suite Release 12

Upgrading Latest Update of JDK 6.0 on all Application Tier Nodes

Step 1 Download Latest Update of JDK 6.0
http://java.sun.com/javase/downloads/index.jsp
Note : Download the 32-bit JDK, and not the Java Runtime Environment (JRE). Do not use the 64-bit version, which is not supported.

Step 2 Stop all Application Tier Server Processes

cd %INST_TOP%\admin\scripts\
adstpall.cmd

Step 3 Replace the JDK Home Used with Oracle EBS Release 12

cd [IAS_ORACLE_HOME]\appsutil\
rename jdk jdk_old
mkdir jdk
cd jdk
Install the downloaded latest update of JDK 6.0 here, i.e., [IAS_ORACLE_HOME]\appsutil\jdk
Move all files and subdiectories under /* to the folder of [IAS_ORACLE_HOME]\appsutil\jdk
After moving all files and subdirectories under one level up under [IAS_ORACLE_HOME]\appsutil\jdk, you can safely remove the empty folder of

Step 4 Restart all Application Tier Server Processes

cd %INST_TOP%\admin\scripts\
adstrtal.cmd

Step 5 AutoConfig running on the Application tier.

Upgrading To Latest Update of JRE 6.0 for AutoConfig on Database Tier Nodes

Step 1 Download Latest Update of JRE 6.0

http://java.sun.com/javase/downloads/index.jsp
Note : Download the 32-bit JRE only, and not the Java SE Development Kit (JDK).

Step 2 Replace the JRE Home Used with Oracle EBS Release 12

cd [ORACLE_HOME]\appsutil\
rename jre jre_old
mkdir jre
cd jre
Install the downloaded latest update of JRE 6.0 here, i.e., [ORACLE_HOME]\appsutil\jre
Move all files and subdiectories under /* to the folder of [ORACLE_HOME]\appsutil\jre
After moving all files and subdirectories under one level up under [ORACLE_HOME]\appsutil\jre, you can safely remove the empty folder of

Step 3 AutoConfig running on the Database tier.

Verify the Application Tier Node Configurations

Step 3.1.1. Change to the OA_HTML directory on the Web server.
Step 3.1.2. Create a file called JDKtest.jsp
Using a text editor, create a file called JDKtest.jsp under [OA_HTML] with the following line:

The JDK version is:<%= System.getProperty("java.version") %> :[%= System.getProperty("java.version") %]

Step 3.1.3. Compile the JDKtest.jsp script
Use the command to compile the jsp file:

perl -x $FND_TOP/patch/115/bin/ojspCompile.pl --compile -s 'JDKtest.jsp'

Step 3.1.4. Run the JDKtest.jsp script from a web browser
Access the JSP file from a web browser, using the URL:
http://[web server]:[port]/OA_HTML/JDKtest.jsp

The version should display "1.6.0_x", where x is the number of the installed JDK 6.0 latest update.

%ADJVAPRG% -version
echo %CLASSPATH%

%AFJVAPRG% -version
echo %AF_CLASSPATH%


Doc Id : 455492.1

Upgrade Oracle Financial Services Applications (OFSA) 4.5.2 to Oracle Financial Services Applications (OFSA) 4.5.39

Upgrade Oracle Oracle Financial Data Manager(Oracle FDM) 4.5.2 and Oracle Financial Services Applications(OFSA) 4.5.2 to Oracle Oracle Financial Data Manager(FDM) 4.5.39 and Oracle

Upgrade Oracle Oracle Financial Data Manager(Oracle FDM) 4.5.2 to Oracle Oracle Financial Data Manager(FDM) 4.5.39
1.Download Discoverer Administration Edition, Version 4.1.37

http://download.oracle.com/otn/nt/discoverer/10241_admin.zip

2. Install Discoverer Administration Edition, Version 4.1.37

3.Download Patch Discoverer Administration Edition, Version 4.1.48 (3201601)

4.Upgrade Discoverer Administration Edition Version 4.1.37 to 4.1.48

5.Download Patch 2902123 (OFSA 4.5.39 DATABASE DCP) Selecting a Platform of "Linux x86"

unzip p2902123_450_LINUX.zip

run dbs/patch_4538/patch_4538.sql

6.Download Patch Oracle Financial Services Applications (OFSA) 4.5.39 (2902123) Selecting a Platform of "MicroSoft Windows"

Oracle Financial Services Applications (OFSA) 4.5.2 to Oracle Financial Services Applications (OFSA) 4.5.39

7.Install 16 Bit and 32 Bit Oracle Financial Services Applications (OFSA) 4.5.39

Upgrade Oracle E-Businees Sutie R12.0.6

Upgrade ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6)

The 12.0.6 Release Update Pack (RUP6) combines patches created across the E-Business Suite after the initial release of Oracle Applications 12.0 into a thoroughly tested, high-quality release pack. You apply it only to an existing Release 12.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, or FIN and HRMS family RUP5 system. Note that RUP6 is cumulative and delivers error corrections and system updates included in RUP1 (12.0.1), RUP2 (12.0.2), and RUP3 (12.0.3), RUP4 (12.0.4), FIN and HRMS family RUP5, along with those included in RUP6 (12.0.6), to bring your 12.0 system to the full 12.0.6 Release Update level.

1.OFF-CYCLE PRODUCTS ===> 6767273

2.R12.AD.A.DELTA.6 (7305220)
3.ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) (6728000)
4.CONSOLIDATED ONLINE HELP FOR 12.0.6(7109200)


Patch Applying Steps

Pre-install Tasks
1.Apply the Patch R12.AD.A.DELTA.6
R12.AD.A.DELTA.6 (7305220)
Pre-install Tasks for R12.AD.A.DELTA.6
Run perl $AD_TOP/bin/admsi.pl -patch_top=/home/applmgr/patch/7305220 -appspass=apps

[applmgr@sys38 patch]$ perl $AD_TOP/bin/admsi.pl -patch_top=/home/applmgr/patch/7305220 -appspass=apps
Gathering Information..
Logfile for this session is located at admsi.log
Generating installation instructions for patch 7305220..
Updating database....
install_7305220.html generated successfully
install_7305220.txt generated successfully

You must shut down all Application tier services before performing the tasks in this section. Instructions for running AD Grants Run the adgrants.sql script as a user that can connect as
SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Usage:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
Or, copy adgrants_nt.sql (Windows) from this patch directory to
%ORACLE_HOME%\appsutil\admin.
3. Set the environment to point to ORACLE_HOME on the database server.
4. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
Windows:
C:\> sqlplus /nolog
SQL> connect / as sysdba
SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql

Apply The Patch 7305220

Patch Apply
2. Apply the Patch RUP6
ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) (6728000)
i)Apply the Patch 6728000
ii)Run Autoconfig.

Post-install Tasks
3. Apply the Patch CONSOLIDATED ONLINE HELP FOR 12.0.6
CONSOLIDATED ONLINE HELP FOR 12.0.6(7109200)
Apply the Patch 7109200

4. Update database tier nodes with the RUP6 code level.
After you have updated to Release 12.0.6, perform the following post-update steps to update all database tier nodes with the code level provided by RUP6:

Application tier:
Run AutoConfig on the APPL_TOP.
Run the admkappsutil.pl utility to create the file appsutil.zip in the /admin/out directory.
perl /bin/admkappsutil.pl

Database tier:
Copy or FTP the appsutil.zip file to the .
Uncompress appsutil.zip under the .
cd unzip -o appsutil.zip
Run AutoConfig on the .

Upgrade Oracle iAS 10.1.3.1.0 to 10.1.3.4

Upgrade Oracle iAS Steps 10.1.3.1.0 to 10.1.3.4

Download Oracle iAS 10.1.3.4

Run Setup.exe

Click Next
Select 10.1.3.1 ORACLE HOME

Click Install

Click Exit

http://sys50/

http://sys50.doyen.in/

Oracle Enterprise Manager

http://sys50/em

Startup iAS Console
%ORACLE_HOME%\bin\runstartupconsole.bat start
or
%ORACLE_HOME%\opmn\bin\opmnctl startall
Stop iAS Console
%ORACLE_HOME%\bin\runstartupconsole.bat stop
or
%ORACLE_HOME%\opmn\bin\opmnctl stopall
iAS Status
%ORACLE_HOME%\opmn\bin\opmnctl status
%ORACLE_HOME%\opmn\bin\opmnctl status -l

Oracle E-Business Suite Release 11i with Oracle Database 10g Release 2 (10.2.0)

Upgrading Oracle Apps 11i Database to Oracle Database 10g Release 2 (10.2.0)
1.Upgrade Oracle Application(11i)

• 11.5.9 E-Business Suite Consolidated Update 2 .
• 10g Release 2 interoperability patch for 11.5.9 (4653217) .

or

• 11.5.10 E-Business Suite Consolidated Update 2 10g Release 2 .
• interoperability patch for 11.5.10 (4653225) .

2.Upgrading Developer 6i with Oracle Applications 11i (Minimum patchset 17).

3.Upgrade Oracle 10g Database (9i to 10g).

4.Post Database Upgrade Steps.


Compatibility Matrix

Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2
8.1.7.4 -> 10.2.X.X.X
9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X
9.2.0.4 or higher -> 10.2.X.X.X
10.1.0.2 or higher -> 10.2.X.X.X

The following database version will require an indirect upgrade path.

7.3.3 (or lower) -> 7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
8.0.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
8.1.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X

Upgrade Oracle E-Business Suite (EBS) R12 to R12.0.4

Upgrade R12 to R12.0.4
12.0.0.0 ===> 12.0.4.0
SQL> select RELEASE_NAME from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.0.0
Upgrade R12 to R12.0.4 Steps
1.INSTALLING R12.AD.A.DELTA.4 FAILS FOR OFF-CYCLE PRODUCTS ===> 6767273
2.R12.AD.A.DELTA.4 ===> 6510214
3.ORACLE E-BUSINESS SUITE 12.0.4 RELEASE UPDATE PACK (RUP4) ===> 6435000
4.CONSOLIDATED ONLINE HELP FOR 12.0.4 ===> 6400100
5.Loading Forms pages ===> 6742236

SQL> select RELEASE_NAME from fnd_product_groups;
RELEASE_NAME
--------------------------------------------------
12.0.4