Oracle Enterprise Stage Error
Posted: Tue Nov 25, 2008 8:41 am
Hi
I have installed DS PX 7.5x2 on windows. Database is Oracle 11g.
I am trying to use Oracle Enterprise Stage to read data directly from oracle db and get the required rows in a dataset.
I get the following error, when I try to view data.
##I TFCN 000001 14:30:49(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 14:30:49(001) <main_program> orchgeneral: loaded
##I TOSH 000002 14:30:49(002) <main_program> orchsort: loaded
##I TOSH 000002 14:30:49(003) <main_program> orchstats: loaded
>##E TOSH 000205 14:30:49(004) <main_program> PATH search failure:
>##E TOSH 000000 14:30:49(005) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
>##E TOSH 000000 14:30:49(006) <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 14:30:49(007) <main_program> Creation of step finished with status = FAILED
Read Method: Table
DB Options: Auto-Generated
If I replace the stage with ODBC stage, and give the same DB Options it works fine.
I went through the documentation, and realised that I have to set ORACLE_HOME and ORACLE_SID as user defined environment variables. Also, I have to specify PATH as ORACLE_HOME/bin directory. I did all that, but no luck.
Next was to give appropriate privileges to the db username, hence I followed the steps as mentioned in documentation and granted the privileges as well, but I still get the same problem.
When I try to run the job with Oracle Enterprise Stage following is the log I get in fatal error messages.
main_program: PATH search failure:
main_program: Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
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
main_program: Creation of step finished with status = FAILED
Contents of phantom output file =>
DataStage Job 11 Phantom 304
And the job is aborted.
I tried to search through the forum with similar issues, but could not find one. Could someone please tell me what specifically I have to do to get this working? Thanks in advance.
Regards
Rupesh
I have installed DS PX 7.5x2 on windows. Database is Oracle 11g.
I am trying to use Oracle Enterprise Stage to read data directly from oracle db and get the required rows in a dataset.
I get the following error, when I try to view data.
##I TFCN 000001 14:30:49(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 14:30:49(001) <main_program> orchgeneral: loaded
##I TOSH 000002 14:30:49(002) <main_program> orchsort: loaded
##I TOSH 000002 14:30:49(003) <main_program> orchstats: loaded
>##E TOSH 000205 14:30:49(004) <main_program> PATH search failure:
>##E TOSH 000000 14:30:49(005) <main_program> Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
>##E TOSH 000000 14:30:49(006) <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 14:30:49(007) <main_program> Creation of step finished with status = FAILED
Read Method: Table
DB Options: Auto-Generated
If I replace the stage with ODBC stage, and give the same DB Options it works fine.
I went through the documentation, and realised that I have to set ORACLE_HOME and ORACLE_SID as user defined environment variables. Also, I have to specify PATH as ORACLE_HOME/bin directory. I did all that, but no luck.
Next was to give appropriate privileges to the db username, hence I followed the steps as mentioned in documentation and granted the privileges as well, but I still get the same problem.
When I try to run the job with Oracle Enterprise Stage following is the log I get in fatal error messages.
main_program: PATH search failure:
main_program: Error loading "orchoracle": Could not load "orchoracle": The specified module could not be found.
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
main_program: Creation of step finished with status = FAILED
Contents of phantom output file =>
DataStage Job 11 Phantom 304
And the job is aborted.
I tried to search through the forum with similar issues, but could not find one. Could someone please tell me what specifically I have to do to get this working? Thanks in advance.
Regards
Rupesh