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.
Reg ORA_NLS33 env variable
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 49
- Joined: Fri Dec 14, 2007 1:43 pm
-
- Premium Member
- Posts: 49
- Joined: Fri Dec 14, 2007 1:43 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?
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?
-
- Premium Member
- Posts: 49
- Joined: Fri Dec 14, 2007 1:43 pm