Skip to Content
0
Former Member
Jan 11, 2011 at 08:59 AM

Data Services ORA-12154 - TNS - Entries o.k.!

864 Views

Hi Experts!

There is a problem when executing a job:

- Windows Server Enterprise 2007 Service Pack2

- 64 - bit Operating - System (Business Objects Dataservices was installed in directory "C:\Programm Files (x86)" )

- Oracle Client ist installed on Server and Client

- all TNS - Entires are entered in tnsnames.ora - File (Client and Server)

- Source: Oracle 9i

- Target: Oracle 11g

- Designer 12.2.2.3

- JobServer 12.2.2.3

- JobEngine 12.2.2.3

- Repository 12.2.2.0000

In Designer - Tool we are able to preview Data (Source and Target) in Client AND Server, so TNS - Entries should be correct (Client and Server).

We have installed a Designer on Client AND Server, the problem and the behaviour is the same on both sides.

When executing the job this message appears:

"OCI call <OCIServerAttach> for connection <BOHAI_PROD> failed: <ORA-12154: TNS:could not resolve the connect identifier

specified>."

A TNSPing for TNS - Entries is o.k.! (Source and Target)

Any Help?

Thanks!