Communication between Server and Oracle CMS database

system · January 15, 2009, 8:08pm

Hi,
I am trying to install Business Object XIR3 on windows server.
I have CMS database on Oracle Unix.

How will Business Object Windows Server communicate with Oracle CMS database?

Thanks
ketfos

ketfos (BOB member since 2004-07-01)

system · January 15, 2009, 8:14pm

Via Oracle client.

Oracle client needs to be installed on the BO server and properly configured (sqlnet.ora, tnsnames.ora) so the server “knows” the database.

Your Oracle DBA should help you with this installation and configuration if you are not sure about it.

Marek Chladny (BOB member since 2003-11-27)

system · January 15, 2009, 9:17pm

Hi mark,
Thanks for quick update.
I installed Oracle 10g client on Windows BO server.
After I provide CMS database name, user and password in the installation screen, I get an error message -
Installation error- cannot find data source checking utility dbcheck - STU00223.

Any clues on this message.

Thanks
Ketfos

ketfos (BOB member since 2004-07-01)

system · January 15, 2009, 9:29pm

After you installed the Oracle client, did you try whether the BO server can communicate with the Oracle database by for instance running

tnsping databasename

command from the command line?

Marek Chladny (BOB member since 2003-11-27)

system · January 15, 2009, 9:40pm

Hi Mark,

I do not find tsnping command in the windows server.

Using ping, I can ping to the Unix Box.

How do I get tnsping tool?

Ketfos

ketfos (BOB member since 2004-07-01)

system · January 15, 2009, 9:55pm

TNSPING is a command/utility, it’s not a tool. You run the tnsping command in the same way as you run ping command - from the command line.

If you have properly installed the Oracle client then the tnsping command should be available.

Marek Chladny (BOB member since 2003-11-27)

system · January 15, 2009, 11:53pm

Hi Mark,
I reinstalled Oracle client.
I could do tnsping to the database.
I can also connect using sqlplus from windows server.

However I am getting the same error message while i try to connect to CMS database during installtion.

Thanks

ketfos (BOB member since 2004-07-01)

system · January 16, 2009, 3:10am

I have no clue. However, the the xi3_error_message_guide says this:

So it looks that your BO installations is probably not complete.

Marek Chladny (BOB member since 2003-11-27)

system · January 25, 2009, 12:27am

Marek,

I am facing the same issue addressed in this discussion. Had done this installation before and did not face any errors. The installation went fine.

Trying to do this installation of XIR3 again (on a different machine) but it would return the error mentioned in this discussion. Dont know as to what is going wrong with it. Did the tnsping as mentioned and service name responds back.

Any insights on this would be of great help. Do please update.

Thanks,
Adnan.

boe_bods (BOB member since 2008-03-14)

system · February 16, 2009, 5:07am

I am also getting this error message,

In my case, i have done a Cold Clone of our Install Machine, chose to do a upgrade. but wanted to use SQL Server as the data store.

I get the same error as posted , I note that when i go back to the start of the install the option of mySQL is reselected.

Installation error: cannot find the data source checking utility

Update: Cold Clone meaning i have a duplicate box in our VMWare system but without network activity.

CowardlyChicken (BOB member since 2007-01-30)