Upgrading to RDBMS 11g on an Oracle EBS R12 environment
Door Hans van Hoogstraten, Op 10-11-08 23:32
Tags:
ebs, rdbms, upgrade
Upgrading the Oracle RDBMS of an EBS-environment is generally a bit more complicated than a stand-alone upgrade, but the process is documented in great detail by Oracle. This blog will discribe the upgrade from RDBMS 10.2.0.3 to 11.1.0.6, and because Oracle has done a pretty good job in documenting this process in Metalink Document: 735276.1 only the non-documented deviations are described in more detail.
This upgrade was performed as a necessary preupgrade-step for the implementation of Advanced Compression. The next blog-entry will give a detailed overview of implementing AC, and describe some of the advantages and disadvantages.
Let's start with an overview of the situation:
- 12.0.4 US+NL EBS Vision installation
- RDBMS 10.2.0.3
- Platform Oracle Enterprise Linux 4 32-bit
Implementation-steps:
1. Install patch 6400501
. $APPL_TOP/APPS[context].env
export PATH=$PATH:$ORACLE_HOME/OPatch
cd 6400501
opatch apply -invPtrLoc $INST_TOP/admin/oraInst.loc
cd $ORACLE_HOME/forms/lib (not lib32 as stated in the InterOp note!)
make -f ins_forms.mk install
cd $ORACLE_HOME/reports/lib (not lib32 as stated in the InterOp note!)
make -f ins_reports.mk install
2. Install RDBMS-software 11.1.0.6.0 in a new directory, use a new oraInventory for this installation, follow Chapter 3 RDBMS installation-guide, use defaults
Make sure to install the following packages before continuing:
elfutils-libelf-devel-0.97 (not found)
unixODBC-devel-2.2.11
Adjust the following kernel-parameters:
kernel-parameter rmem_default=262144 should be 4194304
kernel-parameter rmem_max=262144 should be 4194304
Swapspace: 1932 MB, should be 4096 MB
3. Install the 11.1.0.6 Examples CD (formerly known as companion-CD) in the same 11g RDBMS-tree
4. Set environment for new installation:
- $ORACLE_BASE, $ORACLE_HOME, $PATH, LD_LIBRARY_PATH, $PERL5LIB
5. Run $ORACLE_HOME/nls/data/old/cr9idata.pl and make sure $ORA_NLS10 is set
6. Install OPatch 11.1.0.6.3 (p4898608)
7. Install additional RDBMS-patches:
- 6778860
- 6991626
- 7272286
- 7377378
8. Shutdown the application-tier
9. Install Timezone patch to old RDBMS before upgrade:
- 5632264
10. Gather stats for dictionary tables
exec dbms_stats.gather_dictionary_stats;
11. Run pre-upgrade information-tool and make adjustments as advised
12. With the environment set to the new RDBMS, start dbua
13. Complete the steps from chapter 3 and 4 of the RDBMS 11g upgrade manual
14. Modify the init.ora parameters with Metalink note 396009.1
15. Perform the database-related installation-parts of de RDBMS-patches (step 7)
16. Connected as sysdba, run $APPL_TOP/admin/adgrants.sql
17. Connected as sysdba, run $AD_TOP/patch/115/sql/adctxprv.sql
18. Implement AutoConfig on the 11g RDBMS-tier
From the old RDBMS copy $ORACLE_HOME/appsutil/jre and $ORACLE_HOME/appsutil/clone to the new $ORACLE_HOME/appsutil
19. Log in again and set the Apps-environment.
20. Adadmin: Recreate grants & Synonyms
21. Start the Application-tier and perform a test
The next blog will describe the implementation and usage of Oracle Advanced Compression with EBS in more detail.
Hans van Hoogstraten
hans@oraone.nl