Could not connect to Oracle DB through Designer

dataservices administration
1

Hi All,

I have installed DI 3.1 server setup in windows 7 machine. I have installed Oracle client setup 10g in the same machine. I have added the tnsnames file in the oracle folder and I am able to connect to the database using SQLplus. Means I am able to connect to the database from this machine. But when i try to create a datastore for one of the oracle database, I am getting the ORA:12154 error.

Could anyone please suggest a solution for this? I have reinstalled both couple of times, but does not seem to be working.

Thanks in advance.

rookie86 :india: (BOB member since 2009-09-11)

2
  1. DI 3.2 Designer is a 32bit application, so you need to 32bit Oracle Client installed and configured.
  2. When you run SQL*Plus you implicitly selected the ORACLE_HOME as well. There might be two ORACLE_HOMEs, the one DI is using (the first in the path) might not be configured properly. Is a typical situation, you ran the installer of Oracle twice. see regedit -> local_machine -> software -> Oracle
  3. There might be an oci.dll left over somewhere, e.g. in the Windows directory? We use this Oracle library in DI.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thanks for the quick reply Werner! :smiley:

  1. The Oracle client I have installed is also 32 bit. DI is a 32 bit and have installed it in 32 bit mode only in windows 7.
  2. Previously there were 2 ORACLE_HOMEs. One was not uninstalled properly. So, I uninstalled and deleted all the entries (in regedit also) related to the Oracle installation. Then, I installed Oracle again. Now when I check regedit and I could see only one Oracle home1.
  3. oci.dll file is present in the bin folder of the oracle installed folder. In my case, I have installed it in D:/oracle/

The thing is, I am able to open the Designer in any other machines, connect to the repository and then am able to create datastores without any problem. The database connectivity problem appears only in windows 7 machine.
There must be some small problem only I guess, which I am not able to find.

rookie86 :india: (BOB member since 2009-09-11)

4

You know that Win 7 is supported with DS Version 4.0 only?

Werner Daehn :de: (BOB member since 2004-12-17)

5

:oops: The windows 7 machine has got i7 processor and 8GB RAM. Windows XP will use a maximum of 4GB RAM, other 4GB will be wasted. Hence we went for W7. Also, we want the machine to be more powerful, for that only we have 8GB. if XP can accept 8GB then I don’t have any problems.

ok suppose I download DI 4.0. Will there be any problem exporting jobs between DI 4.0 repository to DI 3.2 repository(both by direct export or .atl file export) and vice versa? Please suggest.

rookie86 :india: (BOB member since 2009-09-11)

6

Upgrade is possible but using DS 4.0 with a 3.2 repo will not work.

I just recalled, there will be a service pack for DS 3.2 as well supporting Windows 7 for the Designer.

Werner Daehn :de: (BOB member since 2004-12-17)

7

Thanks for the information Werner. :smiley:

Currently we have planned to install DS4.0, but I went thru the link https://bobj-board.org/t/165271 where you have posted that only for the customers nominated for 4.0, will be given the installation. My question here is, has DS4.0 released? cos u had mentioned it will be released around December. If not, I will have to nominate to get it?

My other doubt is, our test and production environments run on Unix solaris server. Will 4.0 install in them without any issues?

rookie86 :india: (BOB member since 2009-09-11)

8

Good point, we have Linux and Win64bit versions of DS 4.0 only yet.

Werner Daehn :de: (BOB member since 2004-12-17)

9

Quick question… My company does not have windows XP 64bit version.
Will BODS 3.1 work in Windows Vista 64 bit version? Please let me know.

rookie86 :india: (BOB member since 2009-09-11)

10

Hi,

We are planning to download the DS 3.2. Will it support windows 7?

Thanks in Advance.

rookie86 :india: (BOB member since 2009-09-11)