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.
Error loading "orchoracle" Permission denied
Moderators: chulett, rschirm, roy
Error loading "orchoracle" Permission denied
Leroy Gharis
Dallas, TX
Dallas, TX
Oracle modules located
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.
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
Dallas, TX