Surrogate Key Generator using Oracle 11g

jweir · Post by **jweir** » Tue Jul 28, 2015 11:24 am

Hi all,

I am using the Surrogate Key Generator stage in many of my jobs using an Oracle database sequence with client version 11g. However, when I run, it throws an error complaining about 10g client libraries not installed.

Is there a way to default the stage to use 11g? Or can it only use 10g?

Thanks in advance.

rkashyap · Post by **rkashyap** » Tue Jul 28, 2015 12:00 pm

What is the exact error/warning message? Are you getting any messages in other 'Oracle' stages?

What are values of following Oracle DB Configuration in dsenv ... ORACLE_HOME, TNS_ADMIN, PATH, LD_LIBRARY_PATH?

jweir · Post by **jweir** » Tue Jul 28, 2015 12:09 pm

The error is:

Code: Select all

SK_Generator,2: Library orchoracle could not be loaded; Could not load "orchoracle": libclntsh.so.10.1: cannot open shared object file: No such file or directory.

I was getting same error for Oracle Connector stages when using 10g version, but when specified to use 11g, it worked.

Not sure yet on dsenv settings...

jweir · Post by **jweir** » Tue Jul 28, 2015 12:42 pm

ORACLE_HOME=/usr/lib/oracle/11.2/client64

TNS_ADMIN=/usr/lib/oracle/11.2/client64/lib

LD_LIBRARY_PATH=:/usr/lib/oracle/11.2/client64/lib

rkashyap · Post by **rkashyap** » Tue Jul 28, 2015 1:07 pm

Are these values from DS job log / from dsenv / echoed in a Unix shell?

dsenv is located in DSHOME (usually /opt/IBM/InformationServer/Server/DSEngine). Path of DSHOME is also in " /.dshome"'s value. Share the section where Oracle environment variables values are being set in dsenv.

Also share values of these variables from the 'failing' DataStage job.

Environment variable CC_ORACLECONNECTOR_DEFAULT_CONNECTION_VERSION can be added to change default Oracle client version in the Oracle connector stage.

jweir · Post by **jweir** » Tue Jul 28, 2015 5:54 pm

These were taken from the failing job from the Director using 'Full Report'.

And the environment variable you mentioned, will it only change the version on the Oracle Connector stage? Because my problem lies within the Surrogate Key Gen stage.

priyadarshikunal · Post by **priyadarshikunal** » Tue Jul 28, 2015 11:24 pm

is it a new installation? Did SKG or oracle connector ever work on the system?

jweir · Post by **jweir** » Wed Jul 29, 2015 8:42 am

I don't believe its a new install but I believe the did perform some patch work recently. Not sure if the SK stage ever worked on this box before, this is the first time we are using it in the environment.

jweir · Post by **jweir** » Wed Jul 29, 2015 9:49 am

I don't see anywhere I can specify using a client version in the SK stage. So I don't know if I am using 10g or 11g but it seems like it defaults to 10g.

chulett · Post by **chulett** » Wed Jul 29, 2015 10:13 am

This issue looks familiar, perhaps this discussion might shed some light on the subject. Several people, myself included, have solved problems like this by using a symbolic link from where it is looking to where it actually lives.

jweir · Post by **jweir** » Thu Jul 30, 2015 7:11 am

Thanks chulett.

The admin got back to me and said the Oracle client library is not a full install and is missing some of the soft links.

Will update after fixes have been made and tests have been completed.

jweir · Post by **jweir** » Thu Jul 30, 2015 3:38 pm

Admin created soft links and this is no longer an issue. Said they will get to a full install later.