Reg ORA_NLS33 env variable

visvacfirvin · Post by **visvacfirvin** » Sun Nov 09, 2008 4:47 am

Hi,

When a job runs, the director lists the environmental variables used for initializing the job. It has one parameter called ORA_NLS33. Where does this value come from. We've not defined in dsenv. UNIX admin installed a patch in UNIX and this caused the value of ORA_NLS33 to be changed. This is causing is sqlldr error in datastage. When i echo the variable in unix, it shows the correct path. But datastage env settings in director shows incorrect path

Can you please tell me where does this variable come from.

ArndW · Post by **ArndW** » Sun Nov 09, 2008 7:37 am

Are you certain that the "dsenv" file doesn't call a script? If you source this file using ". ./dsenv" from a login session what setting do you get for the ORA_NLS33 environment variable?

visvacfirvin · Post by **visvacfirvin** » Sun Nov 09, 2008 9:00 pm

We are getting the following value.

ORA_NLS33=/home/oracle/ocommon/nls/admin/data

instead of

ORA_NLS33=/u01/app/oracle/product/9.2.0/ocommon/nls/admin/data

We never used to set this in dsenv. Yesterday UNIX admin installed a patch after which the value got changed and we had to explicitly define in dsenv. But prior to that where it was fetching the values?

chulett · Post by **chulett** » Mon Nov 10, 2008 7:03 am

That would be a question for your DBA.

visvacfirvin · Post by **visvacfirvin** » Mon Nov 10, 2008 10:47 am

Yea that is question for DBA. But my question is from where datastage is picking up this value. The thing is the value is different for dsadm user id alone. Is this something to do with user profile?

chulett · Post by **chulett** » Mon Nov 10, 2008 10:55 am

That would seem to be the case, yes, if what you are saying is true. Only you can compare the user profiles and tell, of course.