Character Set Problem in ORAOCIBL

ar_shriks · Post by **ar_shriks** » Mon Aug 09, 2004 1:57 am

We are getting the following error message while
trying to load data to an Oracle9i database using the
ORAOCIBL stage. We are on Datastage 6.1 on a Windows
2000 server.

Test9i..ORAOCIBL_3: Internal Error:Unable to
initialize the Direct Path Context
ORA-24329: invalid character set identifier.

We recently migrated from Oracle 8i to Oracle 9i and
the Oracle 9i database's character set is
WE8ISO8859P1. We have been loading data to the Oracle
8i database all these days and the character set
defined in the 8i database is US7ASCII. The DBA
refuses to change the newly defined character set and
is instructing us to make the necessary changes in the
Datastage server.

We followed the instructions is the Oracle
Documentation and modified the environment and
character set in the Datastage server (Windows 2000)
but still continue to get the same error message.

Would be happy to get support from people who have
faced this problem before and were able to rectify it.

badri · Post by **badri** » Mon Aug 09, 2004 3:25 am

Hi,

You have to specify a valid character set identifier in the OCI call and there is no other option for this.

- ) :

badri · Post by **badri** » Mon Aug 09, 2004 3:34 am

Hi,

Adding to my previous reply........

While logging to database change the NLS_CHARACTERSET and NLS_CHARACTERSET values in prop$ table to reqd. one

ar_shriks · Post by **ar_shriks** » Mon Aug 09, 2004 11:10 pm

We don't see any way of specifying a valid character set in the ORAOCIBL stage or anywhere else in data stage. Where in data stage can we specify the character set of our Oracle database?

chulett · Post by **chulett** » Tue Aug 10, 2004 5:38 am

Did you install NLS when you installed your DataStage server? If that optional step was not selected (and you probably had no reason to install it at the time) you won't have access to change that in DataStage.

I'd double-check with Ascential Support, but my assumption is that you'd have to re-install DataStage, this time choosing to install the NLS option.

ar_shriks · Post by **ar_shriks** » Mon Aug 16, 2004 12:00 am

Sorry! I made a mistake with our Datastage version. It is 6.0 and not 6.1. We see from the installation notes that NLS is not supported in version 6.0. What do we do now?

Craig, can you as Ascential support about this please?

Regards
Shrikanth

chulett · Post by **chulett** » Mon Aug 16, 2004 7:04 am

ar_shriks wrote:We see from the installation notes that NLS is not supported in version 6.0. What do we do now?

Your only option (other than ganging up on your DBA) is to upgrade. I'd suggest the highest version that supports NLS. 7.5 is available and I'm pretty sure it supports it.

ar_shriks also wrote:Craig, can you ask Ascential support about this please?

Sorry no, not really. Do you not have access to support there? Another place to post is at Ascential Developer Net. Ascential support folks are actually allowed to respond to posts there.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 16, 2004 3:45 pm

I have seen similar messages resulting from the LANG environment variable not being set correctly. Chances are that Oracle has its own LANG environment variable and that the two must agree.