I’ve had to do something similar with various applications. If you want to create a usable directory in /opt
that user oracle can access and still maintain the permission/security integrity of /opt, do the following:
oracle$ su – # become root
# cd /opt
# mkdir oradir # hypothetical directory name
# chown –R oracle
racle oradir # make user oracle the owner
# ls –la
-rwx-r—r-- oracle oracle oradir
# exit # get out of root
oracle$ cd /home/oracle # cd to whatever directory to create a link (optional) but suggested
oracle$ ln –s /opt/oradir oradir # create a link as the user needing access to the directory
It’s worked for me pretty well. The good thing is that you don’t have to compromise the permissions for the entire /opt
directory, just the directory within /opt that you need to access.