Windows: How to Modify OS User Privileges for 11gR2 Grid Infrastructure for Single Server a.k.a. Oracle Restart (Needed for Backup To Network Shares) (Doc ID 1363459.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)
This is an addition to Document 1339053.1 to reflect the specifics for Grid Infrastructure for Single Server a.k.a. Oracle Restart

Goal

Strong caution from Oracle Support: consider the potential consequences of the steps in this document, even though this procedure has been tested and does work, it must be implemented with extreme care and should be tested in a TEST environment before implementing in production.

It is absolutely essential that you make an export of your olr file before proceeding.

Example:

D:\app\11.2.0\grid\BIN>ocrconfig -local -manualbackup
For details about the ocrconfig utility see Appendix G "Oracle Cluster Registry Utility Reference" of:

Oracle® Clusterware Administration and Deployment Guide
11g Release 2 (11.2)

Finally, it is advisable to take a full system backup of each cluster node before beginning to implement this procedure.

 

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 OLR resources. Some reasons 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 OLR resources must be modified such that they are started with an OS user account with the necessary write privileges (on the network share).

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