Translate this Page

 

First concern when we need to migrate our EBS is because the End Of Support of our HP Servers, the cost for extension maintenance support is very high if we still use the old servers. It will be as same as we buy new server with 3 years warranty include.
There are many ways to do the migration :

  • If we don’t want to upgrade the original DB (EBS 11.5.9 using Oracle DB 9i)
    • Export-Import
    • Using CDC (Change Data Capture) tools
  • If we plan to upgrade to 10gR2 (10.2.0.2.0)
    • Export-Import
    • Convert Database (if migrate to the platform with same Endian)
    • Convert Tablespace (if migrate to the platform with different Endian)

In this document, I just discuss how to Migrate Application and Database using Convert Database options.
I will separate the process migration EBS 11.5.9 from HP-UX 11.11 to SUN Solaris 10 into 2 phase. The first phase, we can call the preparation phase. At this phase we upgrade the applications and database. This phase could be reference if we want Oracle E-Business Suite 11.5.9 with Oracle Database 10g. You can review NOTE 369693.1.

The second phase we will discuss the process migration from current platform (HP-UX) into new platform (SUN Solaris). Let’s get rock…. ;)


PHASE I : Upgrade Application and Database

We separate the steps for upgrade database of Oracle EBS into two steps.

First step, we upgrade the applications site to assure the compatibility of the applications with Oracle 10g. As we know, in the Oracle EBS 11i still use Oracle Developer 6i as a Forms Server and Reports Server.

Next step, we can upgrade the Oracle database of Oracle EBS as same as when it not used by Oracle EBS. So before we upgrade the Database, it’s better to verify the Applications Tier. NOTE 423056.1.

ATTENTION : Please try this in the Development Server first, testing it, If oke then you can apply to the Production Server.

A. Upgrade the Applications of Oracle EBS

There are some patches that need to be applied before we upgrade the database of Oracle EBS 11i. I separate the patches base on its functionality.

1. Upgrade Jinitiator if still using version 1.1.8 to 1.3.1.x. (This Doc covered Upgrade JInitiator 1.3.1.21)

  • Download Patch 4202354 and 6169479 from Metalink.
  • Extract Patch 4202354 in the server (eg. /tmp/patch)
  • Copy jinit13121.exe from /tmp/patch/4202354 to $COMMON_TOP/util/jinitiator
  • Stop the Applications Tier
  • Extract Patch 6169479 into /tmp/patch
  • Apply the patch 6169479 (using adpatch)
  • After patch applied, running script
/tmp/patch/6169479/fnd/patch/115/bin/jinit.sh 13121
  • Startup di Applications Tier, then the JInitiator already use version 1.3.1.21 (we can see the version from the java console on the client pc)

2. Upgrade the AD minipack version to minimum requirement (AD.I)

  • Download Patch 6502082 (AD.I-6) from Metalink
  • Extract Patch 6502082 into /tmp/patch
  • Apply the patch 6502082 (using adpatch)
adpatch options=nocompilejsp
  • To check the version, use adadmin. And you will find :
AD code level : [11i.AD.I.6]

3. Upgrade Developer 6i. NOTE : 125767.1 (Please check the latest update)

  • Download patch 6194129 (Developer6i Patchset 19 –> 6.0.8.28), 7423534, 8402746, 6125732, 6857221 and 7343387. Extract them.
  • Apply patch 6194129
./patch_install.sh
  • After apply patch 6194129, relink some lib
cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install
cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install
cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install
cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install
  • Apply Patch 7423534
mv $ORACLE_HOME/forms60/java $ORACLE_HOME/forms60/java.PRE_BUG7423534
mkdir -p $ORACLE_HOME/forms60/java
cp forms60java.tar $ORACLE_HOME/forms60/java
cd $ORACLE_HOME/forms60/java\
tar -xvf forms60java.tar
  • Apply Patch 8402746
    • Backup Files:
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class.PRE_BUG8402746
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class.PRE_BUG8402746
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class.PRE_BUG8402746
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class.PRE_BUG8402746
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class.PRE_BUG8402746
cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms0/java/oracle/forms/handler/UICommon.class.PRE_BUG8402746
cp -r ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class.PRE_BUG8402746
cp -r $ORACLE_HOME/forms60/java/oracle/forms/ui/VBean.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VBean.class.PRE_BUG8402746.
    • Apply the Patch
cp oracle/forms/handler/AlertDialog.class $ORACLE_HOME/forms60/java/oracle/forms/handler/AlertDialog.class
cp oracle/forms/handler/BlockScroller.class $ORACLE_HOME/forms60/java/oracle/forms/handler/BlockScroller.class
cp oracle/forms/handler/ComponentItem.class $ORACLE_HOME/forms60/java/oracle/forms/handler/ComponentItem.class
cp oracle/forms/handler/FormCanvas.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormCanvas.class
cp oracle/forms/handler/FormWindow.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormWindow.class
cp oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class
cp oracle/forms/handler/FormsMouseWheelHandler.class $ORACLE_HOME/forms60/java/oracle/forms/handler/FormsMouseWheelHandler.class
cp oracle/forms/ui/VBean.class $ORACLE_HOME/forms60/java/oracle/forms/ui/VBean.class
    • Apply ewt3.jar, to Apply this Jar file, please make sure the home of jar executable already set in the PATH environment.
cp -r $ORACLE_HOME/forms60/java/oracle/ewt \
$ORACLE_HOME/forms60/java/oracle/ewt.PREBUG8402746
jar xvf ewt3.jar
cp -Rp oracle/ewt $ORACLE_HOME/forms60/java/oracle
  • After apply patch 8402746, generate JAR from adadmin. Before generate jar, assure you already generate new java key.
adjkey -initialize
  • After that running adadmin
adadmin -> generate application menu -> generate product JAR
  • Apply Patch 6125732
./patch.sh
  • After apply patch 6125732, relink form server
adrelink.sh force=y "fnd f60webmx"
  • Apply Patch 6857221
./patch.sh
  • After apply patch 6857221, relink form server
adadmin
2. Maintain Applications Files menu
1. Relink Applications programs

AD Administration uses your Oracle Applications environment file
to set up the environment for relinking Applications.
Before proceeding with the relink, you may optionally want to:
- Go back to the menu by answering No below.
- Use an option on the Maintain Files menu
to generate your Applications environment file.
- Edit the file to add any customizations.
- Verify the list of executables in adlinkbk.txt which are saved
before relinking and add any additional executables as desired.
- Choose this option again, and proceed with the relink.
Do you wish to proceed with the relink [Yes] ?
Enter the name of your Oracle Applications environment file below.
File name [SID_hostname.env] :
Reading product executable information...
Enter list of products to link ('all' for all products) [all] : fnd
Generate specific executables for each selected product [No] ? Yes
AD Administration can relink your Oracle Applications programs with debug
information. Oracle recommends that you do not relink your programs
with debug information unless asked to do so by Oracle Support Services.
Relink with debug information [No] ?
Relinking selected modules in Application Object Library.
List of executables in Application Object Library :
ADCONV AFTBLGEN CMDCART.sl CONCSUB FDULONG
FNDAQCT FNDATUPD FNDCPASS FNDCPGLC FNDCPPUR
FNDCPRRF FNDCPSPN FNDCPTST FNDCPUCF FNDCRM
FNDEMON FNDFBPLS FNDFBUPG FNDFFCHY FNDFFRXR
FNDFFUPG FNDFFVGN FNDFS FNDGFH FNDGFU
FNDIMON FNDLIBR FNDLOAD FNDMDCVT FNDMDGEN
FNDPRESC FNDPSTAX FNDRTR45 FNDSCH FNDSLOAD
FNDSM FNDSVCRG FNDTMTST FNDWRR.exe WFLOAD
WFMAIL WFMLRGSM WFMLRXFR WFRESGEN WFTEST
ar60desb ar60run ar60runb ar60rund f60webmx
fdfcmp flint60 fndcpesr
Enter executables to relink, or enter 'all' [all] : f60webmx ar60run ar60runb ar60rund *
  • Running “$APPL_TOP/admin/adgrants.sql APPLSYS” as DB Owner’s ‘/as sysdba’
  • Apply Interoperability Patch (7343387)
adpatch options=hotpatch,nocompilejsp

4. Patch the latest version of Autoconfig (TXK)

  • Download Patch 7126196 (IZU_TOP GONE/LOST AFTER AUTOCONFIG UPGRADE) and 6372396 (TXK AUTOCONFIG AND TEMPLATES ROLLUP PATCH S (APRIL/MAY 2008))
  • Apply patch 7126196 if only have manually added product tops to preserve their manually added product tops
  • Apply patch 6372396 (Check Troubleshooting if you found problem)
adpatch options=hotpatch,noprereq,nocompilejsp
  • Apply patch 4282857 to handle Error when running Autoconfig (NOTE:316350.1)
adpatch options=hotpatch
  • Run Autoconfig
  • If $OA_HTML/bin/appsweb.cfg contains specialized configuration entries within its “BEGIN CUSTOMIZATION” and “END CUSTOMIZATION” section, copy that section to appsweb_<context name>.cfg
  • Generate JAR if we not use latest version (AD.I.4 up)
  • Remove the log file sec_audit.log from the following location(s) if it exists:
* [iAS_ORACLE_HOME]/Apache/Apache/logs/ .
* [iAS_CONFIG_HOME]/Apache/Apache/logs on installations where a Shared Oracle Home is configured.
  • Restart the Applications

5. Patch the latest Rapid Clone

  • Download Patch 3453499 (11i.ADX.F) and 5225940 (POST ADX-F FIXES)
  • Apply patch 3453499
adpatch options=hotpatch,nocompilejsp
  • Apply patch 5225940
adpatch options=hotpatch
  • Create the appsutil.zip
    • On the Application Tier (as the APPLMGR user):
-  Source the environment file.Create the appsutil.zip file by executing:
    $ADPERLPRG $AD_TOP/bin/admkappsutil.pl
    (On Windows: %ADPERLPRG% %AD_TOP%\bin\admkappsutil.pl)
-  This will create appsutil.zip in $APPL_TOP/admin/out.
    • On the Database Tier (as the ORACLE user):
- Copy or FTP the appsutil.zip file to the <RDBMS ORACLE_HOME>
    cd <RDBMS ORACLE_HOME>
    unzip -o appsutil.zip
- Build <CONTEXT_NAME>.xml file
    cd <RDBMS_ORACLE_HOME>/appsutil/bin
    perl adbldxml.pl tier=db appsuser=<APPSuser>
- Run AutoConfig by executing:
    cd <RDBMS ORACLE_HOME>/appsutil/bin
    adconfig.sh contextfile=<CONTEXT_NAME>.xml
    (On Windows use adautocfg.cmd).

Note: If you are using an E-Business Suite release prior to 11.5.10 on a Unix platform and do not find adautocfg.sh at the location specified above, then run adconfig.sh from <RDBMS_ORACLE_HOME>/appsutil/bin to generate the adautocfg.sh script. Customers running on Windows should run adconfig.cmd to generate adautocfg.cmd.

6. Patch for Index Creation table FND_LOBS

  • Download Patch 3599540 (AFLOBBLD.SQL FAILS WITH ORA-00922 MISSING OR INVALID OPTION)
  • Apply patch 3599540.
adpatch options=hotpatch,nocompilejsp

7. Patch for bug 11.5.9 using Oracle DB 10g

  • When you find this error (this error will find after upgrade to 10g is done)– this is preventive actions:
#############################################################################
# APP-FND-01564: ORACLE error 4063 in fdmgorigsys
#
# Cause: fdmgorigsys failed due to ORA-04063: package body "APPS.FND_LOG" has errors
# ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_LOG"
# ORA-06512: at "APPS.FND_DATA_SECURITY", line 329
# ORA-06512: at line 1.
#
#############################################################################
And you’ll find
#############################################################################
#
#SQL> alter package fnd_log compile;
# Warning: Package altered with compilation errors.
# SQL> show error
# No errors.
# SQL> alter package fnd_log compile body;
# Warning: Package Body altered with compilation errors.
# SQL> show error
# Errors for PACKAGE BODY FND_LOG:
# LINE/COL ERROR
# -------- -----------------------------------------------------------------
# 139/8 PL/SQL: Statement ignored
# 139/16 PLS-00371: at most one declaration for
# 'FND_LOG.G_TRANSACTION_CONTEXT_ID' is permitted
#
############################################################################

Then you need to apply this patch (Note:458807.1)

  • Download Patch 4653217(11.5.9 INTEROP PATCH FOR 10GR2).

Warning : For Oracle E-Business Suite 11.5.10 don’t use this patch. Replace this patch with patch 4653225.

  • Apply patch 4653217 (11.5.9) or 4653225 (11.5.10)
adpatch options=hotpatch

8. If you have module Receivable, then you must apply patch 5753621.

adpatch options=hotpatch,nocompilejsp

9. Apply Patch 3377508

adpatch options=hotpatch,nocompilejsp

10. Apply Patch 4139957

adpatch options=hotpatch,nocompilejsp

11. Compile JSP

perl $JTF_TOP/admin/scripts/ojspCompile.pl --compile --fast --quiet

12. Maintain Snapshot information from adadmin

Continue ….

  3 Responses to “MIGRATION Oracle EBS 11.5.9 with Database 10g Part I”

  1. Hello,

    Please i am doing a similar project but in this case i need to migrate only the application node to linux from HP-UX PA-RISC. I am having a problem with all my ad utility, i get this error whenever i try to run the ad utility (e.g. adadmin,adpatch, etc.).

    Error Message: “cannot execute binary file”.

    Please how can i resolve this problem

  2. Helo Wale,
    Sorry for late reply, to handle such problem, first you need to fresh install Oracle Application 11i for Linux. Then you will get the AD_TOP,APPL_TOP/admin and FND_TOP for linux. After that you should apply the same patch as the source system (see Phase I ; Upgrade Applications). others TOP (GL_TOP,AP_TOP,etc) that contains forms and reports can copy directly. Good Luck.

    Fahmi

  3. [...] MIGRATION Oracle EBS 11.5.9 with Database 10g Part II By Fah, on June 10th, 2009 Continue from previous posting. [...]

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

   
© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha