Connection probleb with Universe and Oracle

building semantic layer
1

Hi,
We are connecting Universe with SQL server 2005 and Oracle 10g. While connecting with SQL it is working fine. But while connecting the same woth Oracle 10g, it is throwing “DBD: ORA-12154: TNS:could not resolve the connect identifier specified”. I have googled and installed oracle client and modify the tnsnames.ora with proper credentials. I am able to log in and access data fromt he client to Server. But still, while I am trying to connect universe, I am getitng the same error.
I am using Boxi 3.1 and Win 7
Any help is greatly appreciated.
Regards,
Arup

arup_kc (BOB member since 2010-11-16)

2

Welcome to B:bob:B!

This sounds like your local machine doesn’t have the correct tnsnames entry? Tnsping it.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi,

Reg oracle everything is fine. tns entry is fine. Able to do tnsping properly. Even able to access oracle server data using this TNS. This error is giving only while I am trying to connect universe.

Please help.

arup_kc (BOB member since 2010-11-16)

4

Hi,

Will this help you.?

Regards,
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

5

Hi,

Thanks for the link. I have checked that. But there is also no solution proposed though I have the similar issue.

Could anybody help?

arup_kc (BOB member since 2010-11-16)

6

Hi Arup,

Please open TNSNAMES.ORA file on your client machine and replace the HOST name with IP address of Oracle Server machine.

I think Windows 7 is not supported supported with plane BOXI 3.1, please check the supported platform guide of BOXI 3.1, SP2 and SP3.

Window 7 is supported with BOXI3.1 SP3.

Hope it helps.

Thanks,

San

san1983 (BOB member since 2011-02-22)

7

Hi San1983,

I have installed BOXI 3.1 SP3 but still it is giving the same error. Also in tnsnames.ora, server ip address has been mentioned as host name, still no luch. Same error repeating.

Regards,
Arup

arup_kc (BOB member since 2010-11-16)

8

Have you installed Oracle client on the BO server as well?

9

I am using my system as bo server and there also I am getting the same prob. Also, while trying to connect other BO server (where oracle client is installed), getting the same error.

I think the problem is with Win 7.

arup_kc (BOB member since 2010-11-16)

10

Can you tnsping the target database from the machine that Webi is running on?

11

Hi Mark,
In Oracle side, everything is fine. I am able to tnsping, able to retrieve data from server and all :frowning:

arup_kc (BOB member since 2010-11-16)

12

OK, so, a summary of the architecture:

You’ve installed BOXI3.1 locally on a Windows 7 desktop then applied SP3?
Now you’re trying to connect to an Oracle database on a different server or the same server?

13

Hi Arup,

Take the back up of tnsnames.ora file on BO server.

Copy the tnsnames.ora file from Oracle server and and paste it on the BO Server.

You can take the back up by adding the extra characters in the name of the tnsnames.ora.(For eg. AAAAtnsnames.ora)

Also tell me what does happen when you run the same report through Webi Rich client, creating new report based on the same universe in deski.

Thanks,
San

san1983 (BOB member since 2011-02-22)

14

Try to reinstall Business Objects and check the connection of universe with oracle. I think this will work

surya_sudheer :india: (BOB member since 2006-11-01)

15

I have got a solution, though I have not tested it yet.
I need to reinstall BOXI to some different location (not in program files x86 folder), because Oracle has some problem with this.

Else, we need to install Oracle client fixpack 4(I have not found it in internet).

Will try and update you. If you will try, then please update me.

arup_kc (BOB member since 2010-11-16)

16

Were you able to identify the issue and find a solution? Would you please share?

kaavalan (BOB member since 2008-12-16)

17

I’m have the same problem, my client Boxi 3.1 SP3 in win 64bits 7 is not working, he can not connect to Oracle, but it’s mine IDE PLSQL Developer, works normally.

Have you solved your problem? Can you help-me?

Hugs
Porto Raphael

rjpepeu :brazil: (BOB member since 2011-06-03)

18

Do you have the 32-bit Oracle client installed or the 64-bit client? BOXI only works with the 32-bit client. What part of BOXI cannot connect? Designer? Webi?

jwhite9 :us: (BOB member since 2006-07-28)

19

I experienced the same TNS error when trying to create a universe -based query though the Rich Client.

I resolved the issue by:

  1. seting up the TNSNAMES.ORA file (maybe not necessary but I did it anyway).
  2. I was running Windows 7, so then under Computer–>Properties–> Advanced system settings–>Environment Variables, I created a ‘New…’ user defined environment variable

Variable: ORACLE_HOME
Value: C:\Oracle\11.2.0\client_1_x86 (or whatever the path is to your oracle client)

After I restarted the machine queries in Webi and Deski seem to be working. :smiley:

deccremin (BOB member since 2007-04-16)