BOBJ Cluster Installation

[Former Member]

Dear All,

We are installing BOBJ 4.1 Sp4 in Cluster environment for our Production setup with OS - AIX 7.1.

We have now installed BOBJ and DB in one node with selecting the following options.

Installation Type --  Custom /Expand

Select Features -- Instances ( Selected all instances for the first node )

Select New or Expand Installation -- Start a new SAP BusinessObjects BI platform deployment

and have completed the installation of CMS, Sybase SQL anywhere, Tomcat  in one node.

Now we want do installation in the second node.

We have installed Sybase SQL anywhere database Client in the second node.

And according to the installation guide,we want to

Create an ODBC DSN to the primary node SQL Anywhere CMS database using the SQL Anywhere 12 driver.

We are unable to proceed this step as we are unaware on how to do this.Kindly help us on how to proceed further.

Also kindly help on what are the options we need to select while doing installation in second node for the below,

Installation Type -- 

Select Features --

Select New or Expand Installation --

Expecting your valuable help and suggestions

Thanks and Regards,

Mathan A

[Former Member]

Hello Manthan,

There are 2 options to install BI 4.1 on the second node :

1. Install BI 4.1 with default DB.
2. Install BI 4.1 by providing the DB credentials of the primary node

With the first option, the SQL Anywhere client will be installed and the obdc.ini (<BIP_INSTALL_DIR>/sap_bobj/enterprise_xi40/odbc.ini) configured to connect to the local DB. You can then modify it to connect to the DB on the primary node.  For example,

[ODBC Data Sources]
BI4_CMS_DSN_DEV=SQLAnywhere 12.0
[BI4_CMS_DSN_DEV]
UID=dba
PWD=mypassword
DatabaseName=BI4_CMS
ServerName=BI4_DEV
Host=192.168.1.10:2638
Driver=/opt/sqlanywhere12/lib64/libdbodbc12.so

Modify it accordingly to have the right information for connecting to the primary node (servername, host, port, etc) . You can check the odbc.ini file on the primary node to confirm the same.

With the second option, you need to download and install the 64-bit SQL Anywhere client for AIX manually. Once done, modify the odbc.ini as mentioned above.

I would recommend the first option as this also gives us an idea if the product has been properly installed with the default DB.

Regards,
Kunal

[former_member185603]

If you want to use existing CMS DB of node1, select 'Expand' installation.And you will be prompted with CMS name, Username/password.

[Former Member]

Hi Jawahar,

Thanks for the reply.

Yes we want to use the existing DB only but when we provide the CMS Name User and Password of node 1 it is not able to connect.

CMS Name = Host name of node 1

User = Administrator    

pass = same provided during installation of node1

Tried telnet to hsotname and port 2638 it is able to connect.

Thanks and Regards,

Siva

[former_member185603]

Are both the servers in same domain?

[Former Member]

Hi Jawahar,

Yes in same domain with hacmp cluster

[onkarvelhals]

Login to CMC> Navigate to Settings> Expand Cluster Information> If machines are clustered both should be visible here.

Moreover, follow SAP KBA

1229417 - What are the requirements for a CMS cluster and how do you test to confirm cluster communi...

Hope this helps.

Regards,

Onkar