Windows: How to Modify OS User Privileges for 11gR2 Grid Infrastructure and RAC Services (Needed for Backup To Network Shares)
Last updated on FEBRUARY 21, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Microsoft Windows x64 (64-bit)
Microsoft Windows Server 2003 (64-bit AMD64) Microsoft Windows Server 2008 (64-bit AMD64)
Oracle Server Enterprise Edition - Version: 22.214.171.124 and up.
The method described in this document only modifies the OS privileges of certain OCR managed resources such as for the purposes specified. The only supported method to modify the software install owner of Oracle Clusterware is to uninstall / reinstall Oracle Clusterware.
Starting in 12c there is the concept of Oracle Home User (for the DB home) that makes the need for the modifications described in this note unnecessary. Therefore, the changes described in this note are not supported for 12c.
For details about the Windows Oracle Home User introduced in 12c see the Oracle® Database - Platform Guide - 12c Release 1 (12.1) for Microsoft Windows - Chapter 3 - "Supporting Oracle Home User on Windows"
This note details the step by step instructions for modifying Windows Grid Infrastructure 11.2 services and corresponding OCR resources.
Some example of why one might want to make this change are:
- to generate backups in a Windows environment to a network share
- to use UTL_FILE_DIR to a network share
- use of External tables
In short, certain services and corresponding OCR resources must be modified such that they are started with an OS user account with the necessary write privileges (on the network share).
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