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
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]
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.
Software Minimum Version Tier Details Oracle Database Enterprise Edition N/A Database
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 18.104.22.168
Oracle E-Business Suite 12.0.4 or 12.1.1 with 9868229, 10163753 and 11071569 Application If you are on E-Business Suite Release 12.0, apply
- Patch 6435000 - Oracle E-Business Suite 12.0.4
- Patch 8623536 - 11g Release 2 interoperability patch for Release 12.0.4
- Patch 9868229
- Patch 7303030 - Oracle E-Business Suite 12.1.1
- Patch 9062910 - 11g Release 2 interoperability patch for Release 12.1
- Patch 8919489 - 12.1 TXK Delta 3 patch
- Patch 9868229
- Patch 10163753
- Patch 11071569
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 9182368 Application If 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) 22.214.171.124 with 9403153 Warehouse Builder Database If you are using Oracle Warehouse Builder (OWB) 11g Release 2, apply OWB 11g Release 2 (126.96.36.199) 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.
AutoConfig Latest version with 9852070, 9738085, 11692965, and 12686610 Application Implement 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 changes N/A Database 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.
DirectX 9.0b Windows 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.