Announcement

Collapse
No announcement yet.

Relaxing Oracle Permissions

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Relaxing Oracle Permissions

    During OTM installs, I commonly hit issues where the file permissions on the Oracle DB client directory was too restrictive. This prevents the OTM server from using the Oracle client and causes certain functions to fail - such as the Python integration scripts and CSV uploads using sqlloader.

    A quick fix or this is to run the changePerm.sh script like so:

    Code:
    [[email protected] ~]# su - oracle
    [[email protected] ~]$ cd $ORACLE_HOME/install
    [[email protected] install]$ ./changePerm.sh 
    
    -------------------------------------------------------------------------------
    Disclaimer: The purpose of this script is to relax permissions on some of the
    files in the database Oracle Home so that all clients can access them.
    Please note that Oracle Corporation recommends using the most restrictive file
    permissions as possible for your given implementation.  Running this script
    should be done only after considering all security ramifications.
    -------------------------------------------------------------------------------
    
    Do you wish to continue (y/n) [n]: y
    
    Finished running the script successfully
    Please see /tmp/changePerm_err.log for errors and /tmp/changePerm.log for the log of events
    [[email protected] install]$
    That's it!

    I hope this helps!

    Thanks,
    Chris
    Chris Plough
    twitter.com/chrisplough
    MavenWire
Working...
X