Re: Installer bug:Message 2100 not found when running sqlldr 10.2.0.2;

Ranko.Mosic_at_gmail.com <Ranko.Mosic_at_gmail.com> wrote:
>>> Getting above error when running sqlldr as user not belonging to dba
>>> group.
>>> ORACLE_HOME, SID, PATH etc are set correctly.
>>> Had similar problem with sqlplus which I resolved by chmod 755 to files
>>> accessed ( as disovered by truss ).
>>> Same trick doesn't work for sqlldr. Must be permissions problem though,
>>> because sqlldr works for users belonging to dba group.
>>>
>>
>> Yep, must be.
>>
>> Try as the user:
>> cd $ORACLE_HOME
>> ll|grep rdbms
>> ll rdbms |grep mesg
>> ll rdbms/mesg|grep ulus
>>
>> I'm guessing one or more of those will need a 755. You might as well
>> check all mesg directories while you are at it.

> 
> Did 755 on all the files/dirs affected as found by truss, still no
> luck.

Please refrain from top posting.

For an effective Metalink research you should provide your operating system and Oracle version.

Have you changed the permissions using
chmod -R o+rx $ORACLE_HOME
or something similar (I mean, have you down it right)?

There are several Metalink notes concerning SQL Loader and 'Message 2100 not found', maybe you can research it yourself.

Yours,
Laurenz Albe Received on Wed Aug 16 2006 - 03:52:57 CDT