Fixing the Configuration Error in the Oracle BI (OBIEE) Administration Tool on 64-bit Windows 7

Rick HarrisTechnical Tips2 Comments

Fixing the Configuration Error in the Oracle BI (OBIEE) Administration Tool on 64-bit Windows 7

After completing a client-only installation of the Oracle BI (OBIEE) tools on a 64-bit Windows 7 computer, people frequently report getting a “Configuration Error” dialog box every time they launch the Administration Tool.

This is what the dialog box looks like:

OBIEE Configuration Error

Hitting OK just closes the tool. There are no log files. You appear to be stuck.

Here is how you can resolve the problem:

Go to the

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin

directory.

Look for the bi_init.bat file. This is the file that is executed when you run the Administration Tool.

Make a copy (just in case!)

Open the bi_init.bat file Properties, go to the Security tab, and hit Edit. You want to give yourself Modify permissions to the file and hit OK.

OBIEE bi_init.bat Permissions

Edit the bi_init.bat file.

OBIEE bi_init.bat Contents

Look for the line that begins “set ORACLE_INSTANCE=

The issue is that the Administration Tool is looking for the directory

%ORACLE_INSTANCE%\bifoundation\OracleBIServerComponent\coreapplication\repository

Even though by default ORACLE_INSTANCE is set to

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst

and there is a

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\bifoundation\OracleBIServerComponent\coreapplication\repository

directory created by default, the tool still complains.  If you create the directory anyplace else, it’s fine.  So we’ll do that.

Comment-out the set ORACLE_INSTANCE line by changing it to:

rem set ORACLE_INSTANCE=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst

That will by default change the ORACLE_INSTANCE value to

C:\Users\[your username]\AppData\Local\Temp\oracle\instance

and the system already has the full path you need except for the very last directory!

OBIEE bi_init.bat Fixed

Go to

C:\Users\[your username]\AppData\Local\Temp\oracle\instance\bifoundation\OracleBIServerComponent\coreapplication

and create a “repository” directory there. You may need to change your Folder Options (under the Organize menu)  to “Show hidden files, folders, and drives” to see the AppData directory under your user-specific directory.

That will eliminate the “Configuration Error” dialog, and the Administration Tool will run without a complaint. In fact, the tool will open the directory

C:\Users\[your username]\AppData\Local\Temp\oracle\instance\bifoundation\OracleBIServerComponent\coreapplication\repository

by default when you try to open an .rpd file.

2 Comments on “Fixing the Configuration Error in the Oracle BI (OBIEE) Administration Tool on 64-bit Windows 7”

  1. I followed your steps but got more troubles – for some reason in my case, the instance folder in user docs does not have all the required config files such as database defaults features.

    After hours of struggling, I left the original line in biinit, but I granted full access permissions to all user groups for all folders underneath
    C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client

    And this worked great! So the only thing you need to do is to change permissions and you are done.

Leave a Reply to matt Cancel reply

Your email address will not be published. Required fields are marked *