Wednesday, December 15, 2010

OBIEE 11g - Manually Upgrade Catalog from 10g to 11g

This allows for catalog upgrade from 10g to 11g version without having to run the GUI tool - UA. 


1. Copy 10g catalog to a temp location
2. Stop 11g BIPS
3. Update instaceconfig.xml to the 10g catalog location i.e. <CatalogPath>10g_Location</CatalogPath>
4. Add these flags to instanceconfig.xml –
<Catalog>
<UpgradeAndExit
>true</UpgradeAndExit>
</Catalog>

5. Start BIPS – This will upgrade the catalog and shutdown automatically
6. Remove the flag true from the instanceconfig.xml
7. Start BIPS again



Sachin
Architect - Oracle Engineered Systems
Exalytics/Exalogic/Exadata
BuzzClan LLC

BuzzClan is a business consulting company collaborating to provide Oracle software advisory services & implementation services. BuzzClan LLC is committed to providing substantive business value on each and every client engagement. We do this through a combination of industry-specific business expertise, technical skills, proven project management methods and our “onsite - off site - offshore” delivery model. We strive to work in partnership with our customers to build high-performance teams and create business solutions that will last.

No comments:

What is Zero Trust Architecture?