Surrogate Key Generator using Oracle 11g
Moderators: chulett, rschirm, roy
Surrogate Key Generator using Oracle 11g
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.
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.
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
The error is:
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...
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.
Not sure yet on dsenv settings...
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
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.
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.
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.
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.
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers