Last updated on MARCH 09, 2015
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2 to 12.1]
Information in this document applies to any platform.
This impacts the resources started using SRVCTL.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms