Error loading "orchoracle" Permission denied

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
lgharis
Premium Member
Premium Member
Posts: 56
Joined: Wed May 26, 2004 10:08 am
Location: Dallas, TX

Error loading "orchoracle" Permission denied

Post by lgharis »

When we run a DataStage parallel job with OCI stage we get the following error.
main_program: Error loading "orchoracle": Could not load "orchoracle": Permission denied. [api/opreg.C:278]
Could not locate operator definition, wrapper, or Unix command for "oraupsert"; please check that all needed libraries are preloaded, and check the PATH for the wrappers [sil/step_il.C:584]

I have done a search on "orchoracle" and "Error loading orchoracle" and read them. Also, looked at lstsaur detailed instructions. The ORACLE_HOME and APT_ORCHHOME directories are correct. We have verified LIBPATH and PATH to be correct and also compared to other working systems.

When the SA changed the owner of the ORACLE_HOME dir and files to dsadm, we were able to run jobs successfully. However, the non-dsadm users then get the same error. So, it seems that there is a module somewhere in ORACLE_HOME that we do not have permissions to. We are having a problem convincing the Oracle DBA this is not a DataStage problem, but rather a permissions issue with one or more Oracle modules.

Does anyone have any ideas as to what Oracle module it might be? I have already compared permissions to modules in the Oracle bin and lib32 directories to the same on another working system and they appear to be ok.

Edited to add: It was working prior to the Unix SA moving the ORACLE_HOME directories from local disk to SAN. So, we figure they changed permissions in the move. I suggested we reinstall the Oracle Client but the Oracle DBA and SA disagree on what version to install.
Leroy Gharis

Dallas, TX
lgharis
Premium Member
Premium Member
Posts: 56
Joined: Wed May 26, 2004 10:08 am
Location: Dallas, TX

Oracle modules located

Post by lgharis »

We found the perpetrating oracle modules with incorrect permissions.

The libclntsh.a and libclntst9.a modules in the $ORACLE_HOME/lib32 directory had permissions rw-rw----. Those modules had permissions of rw-r--r-- on our other server.

The SA changed the permissions for the two modules to rw-r--r--.

All is working now.
Leroy Gharis

Dallas, TX
Post Reply