This discussion is archived
3 Replies Latest reply: Jul 2, 2013 9:09 AM by user12187801 RSS

Upgrade plan for e business suite r12.0.6 on 10.2.0.3

user12187801 Expert
Currently Being Moderated

hello all,

i am planning to upgrade our existing set i.e. e business suite r12.0.6 running on 10.2.0.3.

i like to first apply on clone database to test and verify the procedure.

 

for that i have created close database on same machine.

 

machine 1:

/data1/PROD --- prod directory represent production database

/data1/DEV -- dev directory represent testing database.

 

my question are follow

1. it is ok if i upgrade 11gr2 on dev in same machine, will it effect my existing PROD database ???

2. please advice me action plan or document which help me with the step for upgrade.

 

OS: LINUX REDHAT 5

DB: 10.2.0.3

APPS: R12 12.0.6

 

thanks

  • 2. Re: Upgrade plan for e business suite r12.0.6 on 10.2.0.3
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated

    1. it is ok if i upgrade 11gr2 on dev in same machine, will it effect my existing PROD database ???

     

    Yes it would impact the performance of your production instance, and it's recommended you clone your target instance on a different server.

     

    2. please advice me action plan or document which help me with the step for upgrade.

     

    Please refer to:

     

    Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions [ID 752619.1]

     

    Oracle E-Business Suite Release 12.1.3 Now Available

    https://blogs.oracle.com/stevenChan/entry/ebs_1213_available

     

    Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 [ID 1058763.1]

    Interoperability Notes Oracle EBS 12 with Oracle Database 10gR2 (10.2.0) [ID 812362.1]

     

    Thanks,

    Hussein

  • 3. Re: Upgrade plan for e business suite r12.0.6 on 10.2.0.3
    user12187801 Expert
    Currently Being Moderated

    Thank you for your reply husain.,

     

    i don't have spare or another server., so i have to do testing the same machine., apart from performance is there any other impact on running production database.?

     

    and will you please help me where to start...

    i already read the notes and i have following doubts

     

    Verify software versions

    The following software component versions must exist in your environment.

     

    SoftwareMinimum VersionTierDetails
    Oracle Database Enterprise EditionN/ADatabase

    Read the "Determine the Upgrade Path" subsection in Chapter 2 of the Oracle Database Upgrade Guide 11g Release 2 (11.2). Make sure that direct upgrade is supported from your current release.

     

    --> This part i understood. I m going to use DBUA. from 10.2.0.3 to 11.2.0.3

    Oracle E-Business Suite12.0.4 or 12.1.1 with 9868229, 10163753 and 11071569ApplicationIf you are on E-Business Suite Release 12.0, apply

    If you are on E-Business Suite Release 12.1, apply

     

    ---> I m not clear with this part., do i need to do anything (i mean i need to apply any patches).

    because we already in 12.0.6. (Please advice).

    Demand Signal Repository (conditional)12.1.2 with 9182368ApplicationIf you are using Demand Signal Repository (DSR), apply

    --> We are not using DSR so i think i can ignore this part.

    Oracle Warehouse Builder (conditional)11.2.0.1 with 9403153Warehouse Builder DatabaseIf you are using Oracle Warehouse Builder (OWB) 11g Release 2, apply OWB 11g Release 2 (11.2.0.1) and Patch 9403153. The following E-Business Suite Release 12 products use OWB 11g Release 2:
    • Oracle Demand Signal Repository (DSR)
    • Oracle Manufacturing Operations Center (MOC)
    • Oracle Balance Scorecard (BSC)

    --> we are not using OWB., so i think we can ignore this part.

    AutoConfigLatest version with 9852070, 9738085, 11692965, and 12686610ApplicationImplement AutoConfig or upgrade to the latest version. See Using AutoConfig to Manage System Configurations with Oracle E-Business Suite Release 12 on My Oracle Support for instructions. If you are on Oracle E-Business Suite Release 12.1, apply patches Patch 9738085 and Patch 9852070.

    If you are on the IBM Linux on System Z platform and on Oracle E-Business Suite Release 12.1, apply Patch 11692965.

    Apply Patch 12686610 (for Oracle E-Business Suite Release 12.0 and 12.1).

    ---> I didn't understand this part completely, but what i understood is.. i need to apply PATCH 12686610 and to apply this patch i need to apply two more pre-req patch: (Patch R12.TXK.A.delta.7: R12.TXK.A.DELTA.7)

    Daylight Saving changesN/ADatabase tier

    See Complying with Daylight Saving Time (DST) and Time Zone Rule Changes in E-Business Suite 12 on My Oracle Support for instructions.

    --> i didn't understand this part completely.

    DirectX9.0bWindows customers ONLY - Database tier

    On Windows, run the DirectX diagnostics tool DxDiag.exe in c:\windows\system32. If you receive a generic error opening the display adapter information, use the Windows update tool to upgrade to DirectX 9.0b.

    ---we can ignore becuaes we are on linux.

     

     

    hope you reply.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points