We are not able to connect to Oracle using ORACLE or DRS stage. Following is the error message:
##I TFCN 000001 17:36:36(000) <main_program>
DataStage XE Parallel Extender V7.0.1
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TUTL 000031 17:36:36(001) <main_program> The open files limit is 60; raising to 1024.
##I TOSH 000002 17:36:37(000) <main_program> orchgeneral: loaded
##I TOSH 000002 17:36:37(001) <main_program> orchsort: loaded
##I TOSH 000002 17:36:37(002) <main_program> orchstats: loaded
##I TFSC 000001 17:36:37(003) <main_program> APT configuration file: /ascl/dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 17:36:38(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOSH 000205 17:36:38(001) <main_program> PATH search failure:
>##E TOSH 000000 17:36:38(002) <main_program> Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable SHLIB_PATH; path: /ascl/dsadm/Ascential/DataStage/Projects/ERDM_Dev/buildop:/ascl/dsadm/Ascential/DataStage/DSCAPIOp:/ascl/dsadm/Ascential/DataStage/RTIOperators:/ascl/dsadm/Ascential/DataStage/DSParallel:/ascl/dsadm/Ascential/DataStage/PXEngine/java/jre/lib/PA_RISC2.0/server:/ascl/dsadm/Ascential/DataStage/PXEngine/java/jre/lib/PA_RISC2.0:/ascl/dsadm/Ascential/DataStage/PXEngine/user_lib:/ascl/dsadm/Ascential/DataStage/PXEngine/lib:/usr/lib:/ascl/dsadm/Ascential/DataStage/branded_odbc/lib:/ascl/dsadm/Ascential/DataStage/DSEngine/lib:/ascl/dsadm/Ascential/DataStage/DSEngine/uvdlls:/ascl/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC/hotspot:/ascl/dsadm/Ascential/DataStage/DSEngine/java/jre/lib/PA_RISC:/appl/ora9i/lib32:/appl/ora9i/bin:/appl/ora9i/lib:/appl/ora9i/rdbms/lib
>##E TOSH 000000 17:36:38(003) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 17:36:38(004) <main_program> Creation of step finished with status = FAILED
>
Let me know who faced this problems and solution needed.
By,
RAJa
Oracle Connection
Moderators: chulett, rschirm, roy
Hi,
Have you installed any of the Oracle Plugins while installing DataStage ?
Not sure if this is installed without installing any oracle plugins (I'm also new to DS...). If not try adding an Oracle Plugin and check for that file...It should come along with that.
What version of Oracle are you having ?
Is there any other "*orchoracle*" in your server ?
In my server orchoracle.so is a symbolic link to liborchoraclei686.so
check for this file after adding an oracle plugin. If you get only this file then create a symbolic link orchoracle and add the path into your LD_LIBRARY_PATH.
cheers.
Have you installed any of the Oracle Plugins while installing DataStage ?
Not sure if this is installed without installing any oracle plugins (I'm also new to DS...). If not try adding an Oracle Plugin and check for that file...It should come along with that.
What version of Oracle are you having ?
Is there any other "*orchoracle*" in your server ?
In my server orchoracle.so is a symbolic link to liborchoraclei686.so
check for this file after adding an oracle plugin. If you get only this file then create a symbolic link orchoracle and add the path into your LD_LIBRARY_PATH.
cheers.
check the docs ...
You will have to have given the oracle client install directory when installing DataStage on the Unix box.
Then there are a few things you need to set in you environment about the oracle clients you have installed on the server
i.e
Add ORACLE_HOME/lib to SHLIB_PATH
Add ORACLE_HOME/bin to PATH
Add $ORACLE_HOME
Add $ORACLE_SID
You will have to have given the oracle client install directory when installing DataStage on the Unix box.
Then there are a few things you need to set in you environment about the oracle clients you have installed on the server
i.e
Add ORACLE_HOME/lib to SHLIB_PATH
Add ORACLE_HOME/bin to PATH
Add $ORACLE_HOME
Add $ORACLE_SID