OBIEE 11g Getting Started

After a long gap I am looking into OBIEE 11g. After completing Datacenter Migration Project and Database 11g Upgrade Project, I am now set to go for Fusion Middleware 11g Upgrade early next year.

But this December it is OBIEE 11g.
Early this year I created a OBIEE 10g Environment with BI Publisher 10g. But I see that there has been a lot(a lot) of enhancement done with OBIEE 11g.

As a preparation I created the Database that is required for the Repository. In OBIEE 11g we have to build a repository. I am building it on a 11g R1 database. I made a Oracle Home Cloning and created a database on it.

Oracle Home cloning is pretty simple.

1. Copy a healthy Oracle Home

2. Source the environment variables

3. Run the clone scripts

perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE=$ORACLE_BASE ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=test11_1

In three simple steps the Oracle Home is Ready and now it is the time for DBCA to take care of the rest in creating the database.

Between I have downloaded the following

- Repository Creation Utility.

- Softwares necessary for OBIEE 11g.

You can find more details here (this link might change in the future )

Will keep posting on the developments.

11g Upgrade Failed with Incorrect Deduction of Vault

DBUA reported on a database where I have not configured Oracle Database Vault when upgrading from 10.2.0.4 to 11.1.0.7.

Here is a workaround that will enable you to get rid of this error.

Please make a note that this is possible only if you do not have enabled Oracle Database Vault and that is verified.

To verify

Check is if Data Vault is enabled or not. Data Vault is disabled if following is TRUE
$ cd $ORACLE_HOME/rdbms/lib
$ ar -t libknlopt.a | grep dv
kzvndv.o <<<<<< Shows DV is disabled

In my case the above was verified and I did not have Vault.

Workaround

1. Cleanly shutdown and take complete cold backup of the 10.2 database
2. Startup (in upgrade mode) and shutdown the 10.2 database (prior to upgrade) using 11.1 binaries
-- login to 11.1 Oracle Home environment
% export ORACLE_SID=<10.2 database SID>
% sqlplus / as sysdba
SQL> startup upgrade pfile="<10.2 database pfile>"
SQL> select * from v$option where PARAMETER='Oracle Database Vault';
-- ensure that DV option is FALSE
SQL> shutdown immediate

3. Now retry the DBUA
% dbua

Once database is opened (in upgrade mode) and closed using 11.1 binaries, DBUA stops showing this error.

Note: The above action plan was provided by Oracle Support. So before executing it please cross check with Support.