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
Error with ORAOCI and ORAOCI8
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
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
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
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
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