I currently have the Oracle 8 & 9 clients installed on my pc (and therefore when I go to the Import Plug-in for Meta Data in DS those two are available to be selected in the drop-down menu).
I now have some Oracle 10 table definitions I need to import. Do I need have to have the Oracle 10 client installed to be able to import these definitions, or should they be backwards-compatible? Currently when I try to import them (after selecting Oracle 9 in the Import Plug-in) I get a "TNS:Could not resolve service name" error.
Thanks for any input!
Tom
Meta Data Plug-in and Oracle version compatibility question
Moderators: chulett, rschirm, roy
Re: Meta Data Plug-in and Oracle version compatibility quest
I think you can import them in Datastage without a problem as long as your Oracle client can read them.
The error "TNS: Could not resolve service name" has nothing to do with the database being Oracle 10 though. It means that it cannot connect to the database because it cannot find the database you specified in the connection parameters in the Oracle stage.
Check if you spelled the database source name correctly and if you can connect to the Oracle 10 database with the same credentials using your Oracle client.
The error "TNS: Could not resolve service name" has nothing to do with the database being Oracle 10 though. It means that it cannot connect to the database because it cannot find the database you specified in the connection parameters in the Oracle stage.
Check if you spelled the database source name correctly and if you can connect to the Oracle 10 database with the same credentials using your Oracle client.
hobocamp wrote:I currently have the Oracle 8 & 9 clients installed on my pc (and therefore when I go to the Import Plug-in for Meta Data in DS those two are available to be selected in the drop-down menu).
I now have some Oracle 10 table definitions I need to import. Do I need have to have the Oracle 10 client installed to be able to import these definitions, or should they be backwards-compatible? Currently when I try to import them (after selecting Oracle 9 in the Import Plug-in) I get a "TNS:Could not resolve service name" error.
Thanks for any input!
Tom