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!