NLS_LANG

[Lali_swam]

In my Oracle Database the NLS_LANG is set to AMERICAN_AMERICA.AL32UTF8.

In dsenv, after setting the LD_LIBRARY_PATH, I am also writing these lines:
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_LANG
After this, I have a .bash_profile where I mention most PATHs and I add this also
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8.

In this way, I make sure that all the NLS Characterset is the same(or compatible). But for some reason, I am still getting the error ORA-12705.
I am not able to figur out why this NLS statement is not valid...
I am not able to connect to the database from DS bcoz of this error. Any help is appreciated. Let me know if you need more info.

Thanks.

[Eric]

What is the default NLS map for your DataStage Project?
(assuming you have not changed the default within the stage)

[Amos.Rosmarin]

Hi,

Never heard of this char set but if it works for other applications than it must be right.
Do you have problems only in PX jobs or in server jobs as well ?

For PX jobs you have to modify this file : oracle_cs.txt
located in you PXEngine/etc directory.
To associate the external name to the datastage map.


HTH,
Amos

[Lali_swam]

Hi,
I re-installed Oracle Plug in and stopped the DS server and ran the dsenv and then again started the DS Server. With this, I now got rid of the problem. I am able to use Oracle Tables in my jobs as source.

Thanks everyone who replied for all your efforts. Though, I am not in a position to say exactly what was wrong and how it got fixed, I thght I would still post my reply. Maybe someone facing this can do exactly what I did.

Thanks,
Lalitha