Wednesday, April 09, 2008

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....

16 comments:

Patrick said...

The patches you mention are they specific for EBS use of the 11g database?

Bas Klaassen said...

yes, those patches are EBS specific. I adjusted the post..
Thnx

ng2000 said...

Newdatabases.com hosts free msaccess databases look-alikes for windows. Might offer something helpful.

Shopping Cart said...

Thanks for sharing such a nice feed back,The next step of your Installing 11g database software is very appreciable.

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Peter parker said...

free new software downloads

marysummer said...

Installing 11g database software is very helpful and really good. thanks for good sharing.
full version softwares free download with crack

Dylan Mark said...

software center downloading with key, patch and full version software.

Adobem Acrobat Xi said...

I need only the serial keys off 11g database....
Software Download Free | Ummy Video Downloader

Thomas Anderson said...

Thanks for informing. Keep it more updated with Cracked PC Software

Rodney Waters said...

Great post and Topic i glad to see this thanks admin....
Crack Download

Sara Williams said...

Thank you for making this awesome and wonderful works of yours!!keep it up!
crack software download | vipre internet security 2015 crack

ellie san said...

its very helpful, thanks for sharing this
panda internet security 2015 activation code

Alie Madison said...

A large piece of information for consultants.
nano antivirus activation key | arcsoft photostudio activation code

Tina Tin said...

oh wow!! this is really nice, such a nice piece of work,........
r-studio serial

Debbie Negron said...

its very interesting...thanks for this article.
idealshare videogo license name and code free