Oracler stages not working after upgrade to 8.1
Moderators: chulett, rschirm, roy
Oracler stages not working after upgrade to 8.1
Our old server configuration was this -
Aix 5.3
Datastage 7.5.1
using Oracle 10G 32 bit client to connect to oracle 10G database.
We just did an In-place upgrade to the below server configuration -
AIX 6.1
Datastage 8.1
using oracle 11G 64 bit client to connect to oracle 11G database.
After the upgrade all oracle stages across all jobs (except the ODBC stage) are misbehaving -
Oracle OCI stage - hangs when we do a "View Data"
Oracle Enterprise stage - gives the following error when we do a View Data -
##I IIS-DSEE-TFCN-00001 13:24:24(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 13:24:24(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=qastg2; -m=00CAFD324C00
>##F IIS-DSEE-TFIR-00003 13:24:24(002) <main_program> Fatal Error: Duplicate class registration for: APT_HostFileNameImpl
Any idea what is causing this ? Did we mess up during the upgrade process ? Unlikely because we did the exact same kind of upgrade on another server and that server is working without any issues.
Aix 5.3
Datastage 7.5.1
using Oracle 10G 32 bit client to connect to oracle 10G database.
We just did an In-place upgrade to the below server configuration -
AIX 6.1
Datastage 8.1
using oracle 11G 64 bit client to connect to oracle 11G database.
After the upgrade all oracle stages across all jobs (except the ODBC stage) are misbehaving -
Oracle OCI stage - hangs when we do a "View Data"
Oracle Enterprise stage - gives the following error when we do a View Data -
##I IIS-DSEE-TFCN-00001 13:24:24(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 13:24:24(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=qastg2; -m=00CAFD324C00
>##F IIS-DSEE-TFIR-00003 13:24:24(002) <main_program> Fatal Error: Duplicate class registration for: APT_HostFileNameImpl
Any idea what is causing this ? Did we mess up during the upgrade process ? Unlikely because we did the exact same kind of upgrade on another server and that server is working without any issues.
vishal
Is Oracle on the same machine? If not, since you also upgraded the OS, can you still do a tnsping to the Oracle instance? Can you connect to Oracle from the command line?
Perhaps there are still 32-bit drivers installed. Could your paths, after sourcing the dsenv file, still be pointing to 32-bit drivers?
Perhaps there are still 32-bit drivers installed. Could your paths, after sourcing the dsenv file, still be pointing to 32-bit drivers?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
No. Oracle is on a different machine.
I can tnsping from the datastage machine to oracle machine and I can also connect to oracle with sqlplus.
I used the command below to confirm that we are using 64 bit client.
dump -ah -X64 /app/product/oracle/DBBASE/11.2/lib/libclntsh.so
Also, ODBC stage can view data. It's just the OCI and enterprise stages that have some issue.
I can tnsping from the datastage machine to oracle machine and I can also connect to oracle with sqlplus.
I used the command below to confirm that we are using 64 bit client.
dump -ah -X64 /app/product/oracle/DBBASE/11.2/lib/libclntsh.so
Also, ODBC stage can view data. It's just the OCI and enterprise stages that have some issue.
vishal
LOL @ Chulette
I too have not been able to get a definitive answer to this 64/32 bit story but just so you know
We have another server that was upgraded to AIX 6.1 / DS 8.1. It had the oracle 10G 32 bit client which did not work but as soon as we upgraded to oracle 10G 64 bit client things started working. Now ofcourse we have 11G client on it.
Currently we have atleast 3 servers running AIX 6.1 + DS 8.1 + Oracle 11G 64 bit client without any issues.
I too have not been able to get a definitive answer to this 64/32 bit story but just so you know
We have another server that was upgraded to AIX 6.1 / DS 8.1. It had the oracle 10G 32 bit client which did not work but as soon as we upgraded to oracle 10G 64 bit client things started working. Now ofcourse we have 11G client on it.
Currently we have atleast 3 servers running AIX 6.1 + DS 8.1 + Oracle 11G 64 bit client without any issues.
vishal
Then if you've done this combination before and it works but things are not working on this particular server then it seems like we're back to a configuration problem, most likely in your "shared library" environment variable I would think. As Arnd noted, I would triple-check your dsenv file and make sure everything is pathed correctly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers