More on High Availability: BI Publisher and BI Server authentication

April 3rd, 2009 by

I recently wrote up the various steps involved in setting up OBIEE in a cluster, here and here

I was recently asked by a client to outline the steps for setting up BI Publisher with a cluster. If you installed BI Publisher during the OBI installation you most likely have the default BIP security model of BI Server; BIP delegates user authentication to the BI Server. If a user is known by the BI Server then the same user is allowed to log in to BI Publisher. If you have now configured your OBI environment to make use of the robust high availability (and load balancing) Cluster Controller, the next step is to make sure that the BIP security model is changed to reflect this different scenario.

I am assuming that our primary cluster controller is called aravis2 and the secondary is aravis3 and both cluster controllers are running on the default port of 9706. If you are not sure on which port the cluster controllers are running, look at the OracleBI/server/Config/NQClusterConfig.INI file. Now, log in to the BI Publisher with administrative rights and navigate to the Security Configuration on the Admin tab. Locate the Connection String in the Security Model section and replace the default value (which tells BIP to connect directly to the BI Server) from

to this

Take care to include the last semi-colon. Took me a little time to track that little fellow down ;)


Restart the BIP application and you should now be logging in via the Cluster Controller. Looking at the log we can see that all is well:


  1. Jay Says:


    I need some clarification on BI Publisher.

    1. Is it possible to make BI Publisher to work with two presentation services?

    Primary reason for the question is, I got two PS running for two different RPD’s and want to have one BI publisher to work with them?

    Please share your thoughts on this.

  2. Borkur Steingrimsson Says:

    Hi Jay,

    You can only set BI Publisher to use one BI Server for the authentication. however, you can set up as many Data Sources you want to connect to each instance of your BI servers.

    It is easy enough to deploy the xmlp server again with a different URL as well, to get a completely separated installation.

  3. Jay A Says:

    Hi Sir,

    I configured my two BI server to be clustered. I followed steps from your article last 21, Dec 2008: OBIEE High Availability – The BI Server.

    My problem is I was able to start cluster ( start) but when I run this command, run-sa.start, I am getting an error;

    Invalid Oracle BI Repository directory: /u01/oracle/product/

    In my NQSConfig.INI, i put this value:


    I am wondering why eventhough I put set the correct path for REPOSITORY_PUBLISHING_DIRECTORY , the program is still looking for the old directory (/u01/oracle/product/

    Did I miss something in the configuration? Or is there any initialization file that I need also to update?

    Because you only mention 4 files to edit in your article: NQSconfig.INI, NQClusterConfig.INI , instanceconfig.xml and odbc.ini

    Hope you could help me figure the problem and thank you for your post.

    Best Regard,

    Jay a

Website Design & Build: