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

Hi, Ranco,

Besides the fact that both sqlplus and sqlldr should have read access to their respective error message files (?/sqlplus/mesg, ?/rdbms/mesg) and a lot of other "client" files and directories, there might be some issues with oracle executable as well.

Have you checked suid/sgid bits for ?/bin/oracle (HP-UX port sets some additional attributes for the executable via chattr, check ?/rdbms/lib/ins_rdbms.mk). Also the file system might be mounted with nosuid option. I mean, that when accessing db through the net, oracle executabe is activated by fork+fork+exec by the tnslsnr (usually started by oracle:dba) and thus inherits proper access rights. With local invocation, it is forked by sqlplus/sqlldr directly.

Otherwise you probably have found some interesting stuff. Why not switch from guessing to tracing? Oracle Net tracing in this case.

(*) ? in path to be substituted by $ORACLE_HOME, of course

-Andrey

Ranko Mosic 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.

--
http://www.freelists.org/webpage/oracle-l