| SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #226164] |
Thu, 22 March 2007 12:49  |
poratips
Messages: 262
Registered: April 2005
Location: IL |
Senior Member |
|
|
Hi,
I am trying to load data using sql*loader into my table and when loading through sql*laoder straight it's loading fine but
when I am trying to load through my Unix shell script i am gettiing following error.
SQL*Loader-282: Unable to locate character set handle for character set ID (871).
I have set my unix shell script which calls sql*loader and it gives me above error.
Only the different it's i am using file name as either .txt or .dat and it's works fine but in Unix i am using file name without
any file extension and that's the way i am running my another loader.
We have just upgraded client on our apps server where i am running my unix and sql*loader.(both versions are matching).
Thanks,
[Updated on: Tue, 05 February 2008 00:59] by Moderator
|
|
|
| Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #227294 is a reply to message #226164 ] |
Tue, 27 March 2007 22:23  |
poratips
Messages: 262
Registered: April 2005
Location: IL |
Senior Member |
|
|
|
Thanks, it's resolved.
|
|
|
| Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #298041 is a reply to message #226164 ] |
Mon, 04 February 2008 14:23 |
orable_bar
Messages: 1
Registered: February 2008 |
Junior Member |
|
|
We are having a similar problem.
What solved the issue for you?
Thanks for any help you can give.
B.
|
|
|
| Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #298049 is a reply to message #298041 ] |
Mon, 04 February 2008 15:43 |
joy_division
Messages: 1978
Registered: February 2005
Location: NY |
Senior Member |
|
|
This is why it is important to always post your solution even if you solve it on your own.
One thing to check for is that you version of sqlldr is the same as the version of your database. Also your NLS settings.
Don't expect an answer from the original poster as they have not been around in months.
[Updated on: Mon, 04 February 2008 15:43]
|
|
|
| Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #318365 is a reply to message #298049 ] |
Tue, 06 May 2008 10:25 |
rodpd
Messages: 2
Registered: May 2008 |
Junior Member |
|
|
Hi -- This problem was caused for me by using the wrong Oracle env settings. For development and compiling, our department points to 3p Oracle; for sqlldr it's necessary to switch to the Oracle client.
I did this and sqlldr worked.
The main setting to change was ORACLE_HOME and then amend paths accordingly:
setenv ORACLE_HOME /home/oracle/product/10.2.0.1
#setenv ORACLE_HOME /usr1/arbor/3poracle/HPUX
setenv PATH ${ORACLE_HOME}/bin:${PATH}
setenv SHLIB_PATH ${ORACLE_HOME}/lib:${SHLIB_PATH}
setenv LD_LIBRARY_PATH ${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
You then switch back to 3p after you're done with slqldr!
-- Rod
|
|
|
| Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #318379 is a reply to message #318365 ] |
Tue, 06 May 2008 12:31 |
joy_division
Messages: 1978
Registered: February 2005
Location: NY |
Senior Member |
|
|
| rodpd wrote on Tue, 06 May 2008 11:25 | For development and compiling, our department points to 3p Oracle;
|
What is 3p Oracle?
|
|
|
| Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871). [message #318617 is a reply to message #318379 ] |
Wed, 07 May 2008 05:50 |
rodpd
Messages: 2
Registered: May 2008 |
Junior Member |
|
|
I misunderstood the explanation I was given for this error. But the solution is still valid, even though the explanation of what was happening is a little vague.
3p oracle is our company-internal alternative view of the same Oracle client software. Changing the view removed the error.
I've been advised that the error occurred because sqlldr presumably opens some internal Oracle processes and permissions for these were inadequate in the '3p' view, leading to the misleading character set error. Switching to the alternative view solved the permissions problem and sqlldr worked.
Hope this helps point others in the direction of a possible fix when this error occurs.
|
|
|
]
Members
Search
Help
Register
Login
Home
