Hi All,
We are facing problems when trying to connect to Oracle Database using ODBC stage or ORAOCI8 stage. We did the following when trying to connect to the Oracle database using ODBC stage:-
1.)Created an ODBC on the Datastage machine by which it connects to Oracle. 2.)Using this DSN created we try to connect to the database. Now here we are facing problems as the tables present in the database should get reflected when trying to access them from manager, instead it just hangs and nothing happens. We do not get any particular error as such. We have tried to connect to DB2 using ODBC and it works perfectly ok.
When trying to connect using ORAOCI8, we get the following error when trying to view the data, "ds_loadlibrary: Win32 error in LoadLibrary of oraoci8.dll - The specified module could not be found". Any inputs will be a great help.
Viswanath.S
Connectivity to Oracle from Datastage:Urgent Help
Moderators: chulett, rschirm, roy
Hi,
How do I change the Plug-in? I have tried to Unregister and Register the plug-in and it does not work! Also once I unregister the plug-in when i try to register again I get the following message :-
Unable to register plugin (Path=E:ServerAscentialDataStageEnginebindsdb2.dll) Error Code=-2
Regards
Viswanath.S
How do I change the Plug-in? I have tried to Unregister and Register the plug-in and it does not work! Also once I unregister the plug-in when i try to register again I get the following message :-
Unable to register plugin (Path=E:ServerAscentialDataStageEnginebindsdb2.dll) Error Code=-2
Regards
Viswanath.S
Hi,
Can you please give me an example supporting this? Say I have a table named EMP under the username SCOTT. How do I specify DataStage to display the snapshot for just this table?
And the application was allowed to standby for more than an hour and still there was no change![?]
Thanks for the answers
Viswanath.S
Can you please give me an example supporting this? Say I have a table named EMP under the username SCOTT. How do I specify DataStage to display the snapshot for just this table?
And the application was allowed to standby for more than an hour and still there was no change![?]
Thanks for the answers
Viswanath.S
To use OCI for Oracle, you have to ensure that your "dsenv" file has the proper information required by the OCI plugins. The error you are getting implies you haven't done this step.
Find "dsenv", whose location changes depending on your version. The default for 6.0 is under "~dsadm/Ascential/DataStage/DSEngine". Edit the file and add your current $ORACLE_HOME. Add $ORACLE_HOME/lib to your library path. Do this in the PLATFORM SPECIFIC section, save your changes and then stop/restart the server for them to take effect. Only then will OCI work for you.
An example from my server, which is Compaq Tru64. You'll need to make sure you do this in an appropriate manner for yours!
ORACLE_HOME=/oracle/app/oracle/product/8.1.7.3; export ORACLE_HOME
LD_LIBRARY_PATH=$dshome/lib:/.dslibs:$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
Again, the ORACLE_HOME line will need to be added and the LIBRARY_PATH one will already exist and you'll need to add the '$ORACLE_HOME/lib' bit into the midst of it.
All of this is in the README for the server. The documentation for the OCI plugins contains this information as well I believe, all plugin docs are on the server cdrom in pdf format.
-craig
Find "dsenv", whose location changes depending on your version. The default for 6.0 is under "~dsadm/Ascential/DataStage/DSEngine". Edit the file and add your current $ORACLE_HOME. Add $ORACLE_HOME/lib to your library path. Do this in the PLATFORM SPECIFIC section, save your changes and then stop/restart the server for them to take effect. Only then will OCI work for you.
An example from my server, which is Compaq Tru64. You'll need to make sure you do this in an appropriate manner for yours!
ORACLE_HOME=/oracle/app/oracle/product/8.1.7.3; export ORACLE_HOME
LD_LIBRARY_PATH=$dshome/lib:/.dslibs:$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
Again, the ORACLE_HOME line will need to be added and the LIBRARY_PATH one will already exist and you'll need to add the '$ORACLE_HOME/lib' bit into the midst of it.
All of this is in the README for the server. The documentation for the OCI plugins contains this information as well I believe, all plugin docs are on the server cdrom in pdf format.
-craig
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: