Oracle Connection
Posted: Tue Sep 07, 2004 11:31 pm
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
##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