Oracle Configuration
Posted: Fri Dec 17, 2004 12:31 pm
We are currently using the Oracle 9i client and accessing 8i and 9i databases. We have recently been asked to extract data from an Oracle 7 database.
First, a general question. Can DataStage access two Oracle homes simultaneously? Or, can we use the OCI8 and OCI9 stages within the same project? Perhaps using the 8i client?
Second, we've attempted to setup an ODBC DSN for the Oracle 7 database using the Oracle 8 ODBC driver. The issue is that there is no parameter for SID. Hence, when we test, we get the "ORA-12505: TNS:listener could not resolve SID given in connect descriptor" error message. How do you specify the database name?
Thanks in advance,
Rick Young
First, a general question. Can DataStage access two Oracle homes simultaneously? Or, can we use the OCI8 and OCI9 stages within the same project? Perhaps using the 8i client?
Second, we've attempted to setup an ODBC DSN for the Oracle 7 database using the Oracle 8 ODBC driver. The issue is that there is no parameter for SID. Hence, when we test, we get the "ORA-12505: TNS:listener could not resolve SID given in connect descriptor" error message. How do you specify the database name?
Thanks in advance,
Rick Young