Using Oracle parameters in Oracle stage

vinodlakshmanan · Post by **vinodlakshmanan** » Fri Nov 26, 2004 12:11 am

I'm tring to use the Oracle stage to connect to the Oracle database and read data from a table in a parallel job. I have specified the parameters ORACLE_HOME, ORAHOME and ORACLE_SID as job parameters. But, when I try to view data or when I run the job:
Error loading "orchoracle": Could not find "orchoracle" on the library search path defined by the environment variable SHLIB_PATH; path: <gives entire path>
It also specifies that the job parameters mentioned above are included, but not used in the stage.
How do I solve this problem?

ailuro · Post by **ailuro** » Fri Nov 26, 2004 12:32 am

Create a symbolic link to the appropriate library, i.e. for 10g on SunOS:

$ cd $DSHOME/../PXEngine/lib
$ ln -s liborchoracle10gsun4.so orchoracle.so

HTH

vinodlakshmanan · Post by **vinodlakshmanan** » Fri Nov 26, 2004 12:45 am

Could you please explain why this is needed? Also, I'm using HP Unix 11i server, so what would be the file-name. Are there any documents available on the same?

ailuro · Post by **ailuro** » Fri Nov 26, 2004 1:30 am

During the installation of DS EE, you probably did not specify the location of your Oracle installation.
The installation script would have also asked you to confirm which version of Oracle you have.

Anyhow, check out which libraries these symbolic links point to:
   orchoracle8i.so
   orchoracle9i.so
   orchoracle10g.so

Either create the symlink, orchoracle.so, pointing to the correct library
or rename one of three the symlinks as orchoracle.so.

vinodlakshmanan · Post by **vinodlakshmanan** » Fri Nov 26, 2004 1:56 am

I have 3 libraries and none of them are sym links as below:
/ascential/apt/Ascential/DataStage/PXEngine.700.1/lib > ll *oracle*
-rwxr-x--- 1 dsadm dstage 2088960 Aug 31 16:19 liborchoracle.so
-rwxr-xr-x 1 dsadm dstage 2088960 Sep 26 2003 liborchoracle8ihpux.sl
-rwxr-xr-x 1 dsadm dstage 2088960 Sep 26 2003 liborchoracle9ihpux.sl

The library liborchoracle.so is already there. Should I rename it to orchoracle.so?

ailuro · Post by **ailuro** » Fri Nov 26, 2004 2:11 am

Better just create a symbolic link to it

$ ln -s liborchoracle.so orchoracle.so

vinodlakshmanan · Post by **vinodlakshmanan** » Fri Nov 26, 2004 2:25 am

I tried the same, but its not working. Does it have something to do with the .odbc.ini file? But we are not specifying the DSN name in the stage.