Processes Started With srvctl does not Inherit Secondary Group Modifications (Doc ID 1953432.1)

Last updated on MARCH 09, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
This impacts the resources started using SRVCTL.

Symptoms

1. RDBMS owner is modified to have a new secondary group with a write permission to a specific directory.

2. DB and Listener are restarted on all RAC nodes using srvctl after the user modification.

3. Use of DBA directories and UTL_FILE returns the following error even after restarting the listener, when the connections made via sqlnet, eg through Listener,


Above shows 10005(oinstall) is not part of the groups for tnslsnr process.
This process and others spawned by it will NOT inherit the permissions granted for this group at OS level.

Changes

RDBMS owner was modified for new requirement to write to a directory object, belonging to a different UNIX user, by adding a group to RDBMS user. 

Cause

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