oci call <OCIServerAttach> for connection <...> failed <ora 12154 TNS could not resolve connect Identifier specified

[Former Member]

Hi,

We have Data services 4.0 on Redhat Linux 5.7 on Oracle 10g and I'm trying to connect to designer from the client machine which is 64 bit Windows server with 32 bit Oracle and 64 bit Data Services 4.0 .

I'm getting the above error.I tried installing 64 bit oracle it threw a different error that PATH and lib are not properly set asked to check whether Oracle is installed.

Did anyone have this issue.

Thanks,

Vinod

[Former Member]

Hi Vinod,

Funny you got the first error with a 32 bit client , 64 bit application... about that:

1) If an application is using binaries/libraries of another application, both applications have to match bit architecture.
2) Windows has an additional thing to pay attention: Windows 32 bit applications that run on Windows 64 have a different registry. WOW = windows on windows = how 32 bit applications run. is a little bit like a virtual machine on the 64 bit system. At registry level - there are two registries and two set of tools to access them. The ones in the WOW folder and the "normal 64 bit ones".

3) Did you check you changed the PATH and ORACLE_HOME for the bods user and restarted the server manager after that? <= admitedly this is a kind of guess, as I did not understand your configuration 100%

We have Data services 4.0 on Redhat Linux 5.7 on Oracle 10g  <= Job Servers here?
Designer: 64 Designer version on 64 Bit Windows and now 64 Bit Oracle client <= correct?

- When are you getting the error, in the designer data store definition
(so error on the windows server)  or when running the job (so error from the al_engine running on the RH)?
- Can you connect with SQLPLUS <bodsuser_here>@<connectionstring_here> from the command line?
- What is the output of TNSPING <connectionstring>

Regards

Norbert

[Former Member]

Hi Norbert,

To answer your questions:

1) we have job servers on the same machine on Linux box.

2) yes we have 64 bit Designer and 64 bit oracle installed.

3) we are facing when we try to logon to the Data Services Repository after the Repositories are displayed.

4) We are able to connect to the database using SQLPLUS

5) we are able to TNSPING the DB connection string.

let me know if you want me to check anything.

Thanks,

Vinod

[Former Member]

Hi Vinod,

I don't have a test system available, but this is what normally happens:

In the CMC console you define the database connections.

The CMC console connects and then creates a connection sting you can see at the bottom of the page (you can not edit).

Did you try create a Repo link inside the CMC using the database connection string? There is an option for that (yes/no) and then a field for clusters etc.

Try to pop in the connection string or the content of the TNS names into that box and see if it works.

Norbert

[vnovozhilov]

Dear Vinod,

Thank you for the answers provided.

Before you can connect with the Client to an Oracle database, make sure that the PATH environment variable specifies the directory that contains the Client libraries. By default, Oracle Universal Installer updates the PATH variable for you during the installation process. This directory is the Oracle home directory that you specified during installation.

Could you please share your PATH variable value with us?

Please also confirm you've installed FULL Oracle Client.

Thank you,

Viacheslav.

[Former Member]

There seems to be some problem with the TNS entry of the jobserver or client. Check the entry.