Error with ORAOCI and ORAOCI8

nvkravi · Post by **nvkravi** » Tue Jul 08, 2003 12:21 am

Hey,

Can anybody give Suggestions to the following Error.

Here Im using DataStage5.2 in Windows 2000 Professional. Both
Server and clients are in my system.

And Here Im using ORAOCI as Lookup Ref. Link to Transformer Stage
and Sequential file stage as target.
It Compiled successfully. But when I validate this I got this
error.

Project:Training (xxx)
Job name:Exercise7
Event #:18
Timestamp:7/7/2002 2:49:16 PM
Event type:Fatal
User:xxxAdministrator
Message:
Exercise7..ORAOCI814: Oracle Error - OCI_INVALID_HANDLE
ORA-12154: TNS:could not resolve service name

But Its working fine by using ODBC Stage this TNS Connection. Pls
let me know your suggestions or Solutions?

Regards
Ravi

tonystark622 · Post by **tonystark622** » Tue Jul 08, 2003 6:29 am

Sure looks like the Oracle drivers are not correctly configured on the system. Hard to imagine that the ODBC drivers work correctly when the Oracle driver doesn't.

The only thing I can think of is that the server name and the ODBC DSN are not the same and perhaps, you're using the same name in both. Look in the ODBC DSN and see what the Oracle server name is.

Good Luck,
Tony

kcbland · Post by **kcbland** » Tue Jul 08, 2003 6:29 am

ODBC and OCI are different creatures. Do you have access to the DataStage server and can verify the Oracle client installation and tnsnames.ora file? That's where your problem lies.

Kenneth Bland

chulett · Post by **chulett** » Tue Jul 08, 2003 7:04 am

The fact that ODBC works has no bearing on your OCI connectivity as ODBC is not using your TNS information, AFAIK. Use something like SQL*Plus to verify your ability to connect to Oracle on that machine, from that machine.

Have you setup whatever is required by the OCI stages on Windows? On the Unix side, environment variables need to be set in the 'dsenv' file and the server restarted before OCI will function... is there something similar that needs to be configured? It should be documented in the readme for the server.

-craig

nvkravi · Post by **nvkravi** » Wed Jul 09, 2003 11:47 pm

Hey All,
Thakx your Suggestions. Well Its worked Successfully to my Standalone system. But Its not working to my other Server. May be the problem they have not Initialized. Again Thanx to all your Suggestions.

Regards
Ravi