Windows: How to Modify OS User Privileges for 11gR2 Grid Infrastructure and RAC Services (Needed for Backup To Network Shares) (Doc ID 1339053.1)

Last updated on FEBRUARY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [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: 11.2.0.1 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.

Goal

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

AND/OR
-  to use UTL_FILE_DIR to a network share

AND/OR

-  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).  
 

A strong word of caution from Oracle Support: This procedure HAS been tested and DOES work, however, it SHOULD be tested in a TEST environment and MUST be executed with extreme care when implementing in production.

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