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
ORAOCI8 connection problem
Hi,
I think that the problems resides on the Oracle Client which you have installed on your server.
Bye
Armando Cattedra
acatte@datamat.it
----- Original Message -----
From: William Tan
To:
Sent: Tuesday, April 03, 2001 11:44 AM
Subject: ORAOCI8 connection problem
> 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
>
>
>
>
I think that the problems resides on the Oracle Client which you have installed on your server.
Bye
Armando Cattedra
acatte@datamat.it
----- Original Message -----
From: William Tan
To:
Sent: Tuesday, April 03, 2001 11:44 AM
Subject: ORAOCI8 connection problem
> 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
>
>
>
>
As you are running Oracle on the same server, I guess it is a reasonable assumption that you have the Oracle 8.0.6 on the server. The fact that the Oracle 7 OCI stage works proves that you also have the Oracle 7 client.
Some things to check...
You mentioned that SQL*Plus works. Is that sqlplus33 or sqlplus80? (sqlplus33 is going to use the Oracle 7 client)
Are Oracle 7 and 8 clients installed in the same Oracle home? (they can
coexist) If not, are the bin directories for both Oracle homes on the path for the user which runs DataStage?
Did you remember that the Oracle 7 and 8 clients look for TNSNAMES.ORA in different directories? Oracle 7 looks in $oracle_home/net/admin while oracle 8 looks in $oracle_home/net80/admin. You need to make sure that both of these are set up.
As for connecting to Oracle 8 using the Oracle 7 client. I wouldnt be surprised if sooner or later you ran into some compatibility problems. Id persevere and get the Oracle 8 client working.
Actually, Id question why you need the Oracle 7 client on the server at all. It is OK to access an Oracle 7 database with the Oracle 8 client, but I wouldnt do it the other way around. You only need the Oracle 8 client to access all your Oracle 7 and 8.0.x databases. (Compare, I have run into problems trying to access Oracle 8.1.7 database with the Oracle 8.0.5 client).
David Barham
Information Technology Consultant
InformAtect Pty Ltd
Brisbane, Australia
-----Original Message-----
From: William Tan [mailto:tanwill@adtel.esb.com.my]
Sent: Tuesday, 3 April 2001 19:45
To: informix-datastage@oliver.com
Subject: ORAOCI8 connection problem
Importance: High
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
Some things to check...
You mentioned that SQL*Plus works. Is that sqlplus33 or sqlplus80? (sqlplus33 is going to use the Oracle 7 client)
Are Oracle 7 and 8 clients installed in the same Oracle home? (they can
coexist) If not, are the bin directories for both Oracle homes on the path for the user which runs DataStage?
Did you remember that the Oracle 7 and 8 clients look for TNSNAMES.ORA in different directories? Oracle 7 looks in $oracle_home/net/admin while oracle 8 looks in $oracle_home/net80/admin. You need to make sure that both of these are set up.
As for connecting to Oracle 8 using the Oracle 7 client. I wouldnt be surprised if sooner or later you ran into some compatibility problems. Id persevere and get the Oracle 8 client working.
Actually, Id question why you need the Oracle 7 client on the server at all. It is OK to access an Oracle 7 database with the Oracle 8 client, but I wouldnt do it the other way around. You only need the Oracle 8 client to access all your Oracle 7 and 8.0.x databases. (Compare, I have run into problems trying to access Oracle 8.1.7 database with the Oracle 8.0.5 client).
David Barham
Information Technology Consultant
InformAtect Pty Ltd
Brisbane, Australia
-----Original Message-----
From: William Tan [mailto:tanwill@adtel.esb.com.my]
Sent: Tuesday, 3 April 2001 19:45
To: informix-datastage@oliver.com
Subject: ORAOCI8 connection problem
Importance: High
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
Hi,
Thanks for all the info.
After some thorough checking through the DataStage server machine and
inquiries with the DBA, we found that we were actually using sqlplus33
and not sqlplus80.
We were able to import table definitions through Oracle OCI8 after the
DBA installed the Oracle 8 client.
Thanks again,
William Tan
----- Original Message -----
From: "David Barham"
Date: Friday, April 6, 2001 6:27 am
Subject: RE: ORAOCI8 connection problem
> As you are running Oracle on the same server, I guess it is a
> reasonableassumption that you have the Oracle 8.0.6 on the server.
> The fact that the
> Oracle 7 OCI stage works proves that you also have the Oracle 7
> client.
> Some things to check...
>
> You mentioned that SQL*Plus works. Is that sqlplus33 or sqlplus80?
> (sqlplus33 is going to use the Oracle 7 client)
>
> Are Oracle 7 and 8 clients installed in the same Oracle home?
> (they can
> coexist) If not, are the bin directories for both Oracle homes on
> the path
> for the user which runs DataStage?
>
> Did you remember that the Oracle 7 and 8 clients look for
> TNSNAMES.ORA in
> different directories? Oracle 7 looks in $oracle_home/neoracle 8
> looks in $oracle_home/net8of these are set up.
>
> As for connecting to Oracle 8 using the Oracle 7 client. I
> wouldnt be
> surprised if sooner or later you ran into some compatibility
> problems. Id
> persevere and get the Oracle 8 client working.
>
> Actually, Id question why you need the Oracle 7 client on the
> server at
> all. It is OK to access an Oracle 7 database with the Oracle 8
> client, but
> I wouldnt do it the other way around. You only need the Oracle 8
> client to
> access all your Oracle 7 and 8.0.x databases. (Compare, I have
> run into
> problems trying to access Oracle 8.1.7 database with the Oracle 8.0.5
> client).
>
>
> David Barham
> Information Technology Consultant
> InformAtect Pty Ltd
> Brisbane, Australia
>
>
>
> -----Original Message-----
> From: William Tan [mailto:tanwill@adtel.esb.com.my]
> Sent: Tuesday, 3 April 2001 19:45
> To: informix-datastage@oliver.com
> Subject: ORAOCI8 connection problem
> Importance: High
>
> 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
>
>
>
>
>
Thanks for all the info.
After some thorough checking through the DataStage server machine and
inquiries with the DBA, we found that we were actually using sqlplus33
and not sqlplus80.
We were able to import table definitions through Oracle OCI8 after the
DBA installed the Oracle 8 client.
Thanks again,
William Tan
----- Original Message -----
From: "David Barham"
Date: Friday, April 6, 2001 6:27 am
Subject: RE: ORAOCI8 connection problem
> As you are running Oracle on the same server, I guess it is a
> reasonableassumption that you have the Oracle 8.0.6 on the server.
> The fact that the
> Oracle 7 OCI stage works proves that you also have the Oracle 7
> client.
> Some things to check...
>
> You mentioned that SQL*Plus works. Is that sqlplus33 or sqlplus80?
> (sqlplus33 is going to use the Oracle 7 client)
>
> Are Oracle 7 and 8 clients installed in the same Oracle home?
> (they can
> coexist) If not, are the bin directories for both Oracle homes on
> the path
> for the user which runs DataStage?
>
> Did you remember that the Oracle 7 and 8 clients look for
> TNSNAMES.ORA in
> different directories? Oracle 7 looks in $oracle_home/neoracle 8
> looks in $oracle_home/net8of these are set up.
>
> As for connecting to Oracle 8 using the Oracle 7 client. I
> wouldnt be
> surprised if sooner or later you ran into some compatibility
> problems. Id
> persevere and get the Oracle 8 client working.
>
> Actually, Id question why you need the Oracle 7 client on the
> server at
> all. It is OK to access an Oracle 7 database with the Oracle 8
> client, but
> I wouldnt do it the other way around. You only need the Oracle 8
> client to
> access all your Oracle 7 and 8.0.x databases. (Compare, I have
> run into
> problems trying to access Oracle 8.1.7 database with the Oracle 8.0.5
> client).
>
>
> David Barham
> Information Technology Consultant
> InformAtect Pty Ltd
> Brisbane, Australia
>
>
>
> -----Original Message-----
> From: William Tan [mailto:tanwill@adtel.esb.com.my]
> Sent: Tuesday, 3 April 2001 19:45
> To: informix-datastage@oliver.com
> Subject: ORAOCI8 connection problem
> Importance: High
>
> 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
>
>
>
>
>