Error with ORAOCI and ORAOCI8
Posted: 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
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