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.
Character Set Problem in ORAOCIBL
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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 wrote:We see from the installation notes that NLS is not supported in version 6.0. What do we do now?
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.ar_shriks also wrote:Craig, can you ask Ascential support about this please?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.