I am currently facing a problem when trying to transforming a sequential text file and feeding it to a already-created table in Oracle. When I compiled evrything is OK but when I run a receive an error message
I am running Oracle9i client, DataStage 7.5 Client on Windows 2003 platform and connected to Oracle10g, DataStage 7.5 Server on FedoraCore3 on the same home network.
Sounds like the connection between DataStage and Oracle was interrupted between (because?) when the error occurred and when DataStage issed a query (effectively an oerr command) to retrieve the text associated with the error code.
Or it may be some incompatibility between the 9i client and the 10g server.
You can issue an oerr ORA 12154 command manually to determine what the error was, and this may help you to find a fix.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ORA 12154 is a 'TNS: could not resolve service name' message.
It appears that your TNSnames.ora in DataStage Server machine cannot be interpretted to your runtime Oracle Instances. Try to run sqlplus from DataStage server to connect to the 2 instances.
As you appear to connect to 2 Oracle Instances, check whether you have the corresponding TNS entries on the tnsnames.ora.
Unable to Initialize plugin is the general message for any library problems in dsenv. Does this happen for both or only one of the Oracle Instances? This can be because of version difference.
Also search for corresponding post as it will give more detail.
The problem that I am mostly concerning now is that the Plug-in MetaData Definitions function for Table Definitions is not working. It kept showing the message
As first, I thought I might have problem with the plug-ins themselves or might forgot to install them. However, as I observed the Plugins.ini file, it list all the plugins that i have installed
I also tried to TNSPing the Oracle 10g database from my 9i client (in case there is an issue of version incompatibility) but it worked fine. I still can use other applicaition such as Toad to connect to Oracle server.
All that advice is great, problem is it is only applicable to DataStage on a UNIX server. For a Windows server you have to play a different game, a game that I'm not familiar with or I would have chimed in earlier.
You do have a 'configuration' issue of some kind. I would think that the Configuration Guide for the various plugins would address what the requirements are for the OCI stages, have you read through that?
-craig
"You can never have too many knives" -- Logan Nine Fingers
Hi,
this sounds like a problem with your Oracle client configuration/installation.
go thru the docs for plugin install and install and upgrade manuals as Craig said.
At first I would like to thank all of your guys for your valuable advices.
TNS is not an issue I think. I have tried to run SQLPlus from DS server machine and it also worked fine. The thing is that not only the plug-in for Oracle didn't work but also other databases like Sybase and Informix (Unable to initialize plug-in).
The snapshot of the LD_LIBRARY_PATH in my dsenv file is below:
As in the first email, I did say that I am running DS and Oracle client on Windows machine, but the DS Server and Oracle Server are on the Linux machine.
i have cheked the ORACLE_HOME path with the one i have in dsenv, they are identical. And about making them loaded on runtime, could you show me how to do that?