Re: [Gusdev-gusdev] Permissions for running ga

[Jonathan C. <cra...@pc...>]

Hi Han-

Han Sang Rhee wrote:
> Hello,
> 
> I am a new gus user and am having some difficulties figuring some things 
> out.
> 
> I would like to know what the minimum OS level permissions are needed for 
> running "ga".  I seem to only beable to run it as root or my oracle user.  
> I get the following error message when I try to run it as anybody else:
> 
> RAD' --group 'dba' --user 'three' --commit
> Reading properties from /opt/gus_home/config/GUS-PluginMgr.prop
> Reading properties from /opt/.gus.properties
> install_driver(Oracle) failed: Can't load 
> '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' 
> for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object file: 

It looks like the Perl module DBD::Oracle is unable to access one of the
Oracle client libraries.  This could be due to the permissions on the file
(libclntsh.so.9.0) being set incorrectly, but is more likely because the
directory that contains this file is not in your "LD_LIBRARY_PATH" Unix
environment variable.  I would recommend taking the following steps:

1. Check that the directory $ORACLE_HOME/lib appears in the LD_LIBRARY_PATH
   environment variable of the user that's trying to run 'ga'.  The value of
   $ORACLE_HOME must also be set, of course, and its location will depend on
   where Oracle is installed on your machine.
2. If ga still does not work, look at the files in $ORACLE_HOME/lib and
   make sure that libclntsh.so.9.0 exists and is readable by the user that's
   trying to run 'ga'.

You can also just compare the environment variable settings for $ORACLE_HOME
and $LD_LIBRARY_PATH between a user that can run 'ga' successfully and one
that cannot.  Regards,

Jonathan