Installing 11g database software

Next step is to install the 11g database software. Be sure to install the 11g software in a new ORACLE_HOME. Also, only install the software ! Do not create a new database and do not choose to upgrade the database during the install.

After installing the software, create nls/data/9idata directory..

[oracle@ebs2 old]$ perl cr9idata.plCreating directory /ebs/proddb/11.1.0/nls/data/9idata ...Copying files to /ebs/proddb/11.1.0/nls/data/9idata...Copy finished.Please reset environment variable ORA_NLS10 to /ebs/proddb/11.1.0/nls/data/9idata!

Now apply some additional 11.1.0.6 RDBMS patches. Apply the following patches using Opatch :

1. 6778860, 11.1.0.6 BUNDLED PATCH FOR EBS 11I

2. 6501565, APPSST11G:11510CU2:+11G INTEGRATION ENVIRONMENT IS HAVING ISSUES IN DATABASE

3. 6670485, 11.5.10(TK11GR6E):POPULATE MEASURES WORKFLOW FAILING

4. 6636451, OLAP_TABLE - QUERIES FAIL IN 11G

Before running the first patch, be sure to apply patch 4898608, OPatch 10.2.0.1.6. Without this patch the opatch napply -skip_subset -skip_duplicate will fail...

After downgrading the excisting opatch utility, you can start the patches..

[oracle@ebs2 6778860]$ opatch napply -skip_subset -skip_duplicateInvoking OPatch 10.2.0.1.6
Oracle Interim Patch Installer version 10.2.0.1.6Copyright (c) 2007, Oracle Corporation. All rights reserved.
Setting N-Apply implicit patch base-directory to /ebs/patches/11g/6778860UTIL session
Oracle Home : /ebs/proddb/11.1.0Central Inventory : /etc/oraInventory from : /etc/oraInst.locOPatch version : 10.2.0.1.6OUI version : 11.1.0.6.0OUI location : /ebs/proddb/11.1.0/ouiLog file location : /ebs/proddb/11.1.0/cfgtoollogs/opatch/opatch2008-04-09_13-59-41PM.log
Invoking utility "napply"Checking conflict among patches...Checking if Oracle Home has components required by patches...Checking skip_duplicateChecking skip_subsetChecking conflicts against Oracle Home...OPatch continues with these patches: 6318357 6353873 6412375 6417271 6431470 6454237 6530141 6617137 6633314 6633347 6735167 6744214
Do you want to proceed? [yn]

When the 11g ORACLE_HOME is patched, the database (10gr2) must be upgraded to 11g. I choose the manual upgrade instead of using DBUA....