Page 1 of 1
Surrogate Key Generator using Oracle 11g
Posted: Tue Jul 28, 2015 11:24 am
by jweir
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.
Posted: Tue Jul 28, 2015 12:00 pm
by rkashyap
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?
Posted: Tue Jul 28, 2015 12:09 pm
by jweir
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...
Posted: Tue Jul 28, 2015 12:42 pm
by jweir
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
Posted: Tue Jul 28, 2015 1:07 pm
by rkashyap
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.
Posted: Tue Jul 28, 2015 5:54 pm
by jweir
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.
Posted: Tue Jul 28, 2015 11:24 pm
by priyadarshikunal
is it a new installation? Did SKG or oracle connector ever work on the system?
Posted: Wed Jul 29, 2015 8:42 am
by jweir
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.
Posted: Wed Jul 29, 2015 9:49 am
by jweir
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.
Posted: Wed Jul 29, 2015 10:13 am
by chulett
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.
Posted: Thu Jul 30, 2015 7:11 am
by jweir
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.
Posted: Thu Jul 30, 2015 3:38 pm
by jweir
Admin created soft links and this is no longer an issue. Said they will get to a full install later.