Page 1 of 1
Migration to 8.7 + Oracle connectivity
Posted: Wed May 16, 2012 3:39 am
by ponzio
Hi.
I'm planning to migrate to Datasatge 8.7.
I need a hint to choose Oracle Client to install.
In my old datastage server I connect both to Oracle 10g and Oracle 11g using
Oracle Client 9i (32 bit).
This is my production environment and this scenario works well except for a little problem with numeri character described here:
viewtopic.php?t=142796&highlight=
My new server is Windows 2008 R2 Standa 64 bit.
Which Oracle client should I install ?
Thanks,
Andrea
Re: Migration to 8.7 + Oracle connectivity
Posted: Wed May 16, 2012 9:32 am
by rprajput
See the special configuration advice for Windows 2008 and 64 Bit systems - The DataStage job stages are 32 bit on both Windows 32 bit and Windows 64 bit installations. Consequently, all client libraries needed for connectivity (for example Oracle client support) must be 32 bit.
Hope this helps!
Re: Migration to 8.7 + Oracle connectivity
Posted: Thu May 17, 2012 2:03 am
by ponzio
Thanks !
I'm using Oracle Client 9 ... do you think I should use 10 or 11 ?
Andrea
Re: Migration to 8.7 + Oracle connectivity
Posted: Fri May 18, 2012 3:53 am
by ponzio
I tryed to install Oracle 9i on Windows 2008 but it prevented me to end this task.
I've found
this that seems to confirm rprajput (even if this article is not related to OCI).
I try to install Oracle Client 32bit (win32_11gR2_client).
Andrea
Posted: Fri May 18, 2012 7:49 am
by PaulVL
We're upgrading our shop to Oracle Client 11ish. Found a bug in 10g. Mind you my client is on Linux database server is AIX.
Posted: Wed May 23, 2012 12:40 am
by ponzio
I've Installed Oracle Client 11g.
I'm using OCI9 to connect to DBs and I'm connecting to Oracle 10g and 11g DBs.
I have some problems loading an unicode Oracle 11g using OCI:
- italian data are loaded fine
- bulgarian data are not loaded properly
If use "Oracle Connector" instead of OCI the bulgarian dta are loaded fine.
IBM support is helpig me ... I let you know.
Andrea
Posted: Wed May 23, 2012 4:27 pm
by ray.wurlod
Help us to help you. What's different about Bulgarian data - accented characters perhaps?
Posted: Wed May 23, 2012 4:55 pm
by PaulVL
I'm guessing this is the same issue as your NLS thread...
if so, please close one and only have one open to help drive it to root cause.
Posted: Thu May 24, 2012 1:32 am
by ponzio
ray.wurlod wrote:Help us to help you. What's different about Bulgarian data - accented characters perhaps? ...
Bulgarian is Cyrillic (see
http://en.wikipedia.org/wiki/Cyrillic_script) quite different from italian ...
PaulVL wrote:I'm guessing this is the same issue as your NLS thread...
if so, please close one and only have one open to help drive it to root cause.
You're right ... To be precise the solution could be the same but I've understood this at the end.
The problem with Oracle OCI is that the Client Oracle itself was installed with
ITALIAN_ITALY.WE8MSWIN
1252 (as you can see in Windows Registry)
and when I try to load data in a different language it try to do the conversion to this 1252 anyway ... even if I use the right NLS 1251 in my OCI stages.
Setting up the environment variable
NLS_LANG=BULGARIAN_BULGARIA.CL8MSWIN
1251, that for my purposes I've created at project level (in Datastage Administrator Client), solved the problem.
You said the problem could be the same with my DB2 (see
viewtopic.php?p=423298#423298)
IBM DB2 support told me that the problem could be a difference between server and client fix version ...
I'm going to check this and let you know!
Following the same logic of Oracle Client,
creating the environment varibale
DB2CODEPAGE=1251 makes my db2 extract query run ok .. so this is the same solution.
Andrea
Posted: Thu May 24, 2012 1:50 am
by ponzio
Now my ultimate problem is
Windows System Locale of Datasatage Server.
I'm going on my other thread
viewtopic.php?p=423390#423390
with widows system locale issue and to show my checks with db2 fix test.
Many thanks,
Andrea