ORAOCI8 connection problem
Posted: Tue Apr 03, 2001 9:44 am
Hi,
Im having problem using the DataStage plug-in Oracle 8 OCI stage
version 2.3 to connect to an Oracle database version 8.0.6.2 sitting on
a Sun machine with Solaris 2.6. The error message I received was "ORA-
12545: TNS:name lookup failure".
Both DataStage and the Oracle database are installed on the same Sun
box.
However, when using the Oracle 7 OCI stage version 1.4 the connection
was succesful.
I have checked the tnsnames.ora and the relevant Oracle Data Source
Name entry has already been added in the file. The connection to the
relevant Oracle Data Source Name using SQLPLUS from the UNIX prompt was
also successful.
Anybody knows or had experienced such a problem before?
Would there be any performance problem if the Oracle 7 OCI stage
version 1.4 plug-in is used to connect to the version 8.0.6.2 Oracle
database?
Appreciate it if anyone can shed some light. Thanks in advance.
Regards,
William Tan
Im having problem using the DataStage plug-in Oracle 8 OCI stage
version 2.3 to connect to an Oracle database version 8.0.6.2 sitting on
a Sun machine with Solaris 2.6. The error message I received was "ORA-
12545: TNS:name lookup failure".
Both DataStage and the Oracle database are installed on the same Sun
box.
However, when using the Oracle 7 OCI stage version 1.4 the connection
was succesful.
I have checked the tnsnames.ora and the relevant Oracle Data Source
Name entry has already been added in the file. The connection to the
relevant Oracle Data Source Name using SQLPLUS from the UNIX prompt was
also successful.
Anybody knows or had experienced such a problem before?
Would there be any performance problem if the Oracle 7 OCI stage
version 1.4 plug-in is used to connect to the version 8.0.6.2 Oracle
database?
Appreciate it if anyone can shed some light. Thanks in advance.
Regards,
William Tan