How To Compile and Run Forms with a User Different from Oracle (Doc ID 561334.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Forms - Version 9.0.4.0.19 to 10.1.2.3.0 [Release 9.0.4.0 to 10.1.2.3]
Generic UNIX
Checked for relevance on 13-May-2014
Checked for relevance on 28-Oct-2015

Goal

 

NOTE: MAKING THE MODIFICATIONS IN THIS NOTE AFFECTS THE SECURITY PROFILE OF THE INSTALLATION.  ORACLE DOES NOT RECOMMEND THESE STEPS AS IT RELAXES THE PERMISSIONS ON THE INSTALLED BINARIES.   YOU SHOULD REVIEW THESE STEPS, CONSIDER THE IMPLICATIONS, AND TEST CAREFULLY BEFORE YOU DECIDE TO IMPLEMENT THEM.

 

Note: An alternative "unix' solution for this issue can be found in <note 427548.1> How To Compile Forms On iAS 10.1.2.x.x As Non Oracle User On Unix Platforms. This solution applies for all versions of Forms on UNIX.  Note that per unpublished bug 9791315 there are no documented steps for doing this on Forms 11g other than the UNIX solution presented in <note 427548.1> How To Compile Forms On iAS 10.1.2.x.x As Non Oracle User On Unix Platforms.



Starting with Forms version 9.0.4, when trying to compile forms as a non-oracle user (i.e. a user different from the one who performed the install) the following error occurs:

"Permission denied", "error while loading shared libraries: libig.so.0", FRM-91500, FRM-91108


This is the expected behavior and it is caused by a change in security rights:
In previous versions the default permission was 755 but starting in these new versions the default permission is 700 for the majority of binaries in the technology stack). This was also implemented by CPU patches

The goal of this article is to guide users in compiling forms with non-oracle users and this can achieved in two ways:
A.) Change permissions only to a small set of files
or
B.) Change permissions for all files in ORACLE_HOME

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms