Oracle RMAN Netvault windows user login requirements (4047599)

Date: 17th June 2005
NV Version: N/A
OS Version: Windows
Application version: Oracle RMAN 4.0
plugin version:All

Description: Netvault fails to login to Oracle during RMAN backup

The windows operating system user that the NetVault client or server process runs as must have the appropriate Oracle permissions.

Symptoms: If the correct permissions are not set on the system then a backup with fail with an 'ORA-01031: insufficient privileges' error message

The user who is logged into the local system must be the Netvault user. This user must also be a member of the ORA_DBA group. I.E.

If I am logged in to a system as Administrator in Windows then Administrator must be a member of ORA_DBA. Administrator must also be the Netvault user for the backups to succeed.
You have to restart the netvault service on the oracle machine for any group membership change to take effect.

If the user is definitely a member of the ORA_DBA group and still has the login problem the check the sqlnet.ora file and ensure you have the following set -

SQLNET.AUTHENTICATION_SERVICES= (NTS)
This enables windows and NT native authentication which is required for the ORA_DBA group to work

If the entry is set to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
then you will need to change this.

To verify this ability independently of NetVault you must attempt to log on to the oracle service within a dos cmd shell window -

to do this -

#1 log on the windows machine -
from the windows login screen as the user that is running netvault

#2 open a dos cmd window

#3 set the environment variable ORACLE_SID to target the oracle instance running on that machine
(check OracleService entry within the wndows services - the sid name will be listed as OracleService

set ORACLE_SID=
e.g. for an oracle database instance named TEST

the oracle service will be listed as OracleServiceTEST
the sid name is TEST

so the oracle environmemt variable should be set as below
set ORACLE_SID=TEST

to check this type set and you should see the oracle sid listed
e.g.
ORACLE_SID=TEST

#4 type the following to logon to oracle -
sqlplus /nolog

#5 this will result in a sql prompt then type
connect / as sysdba

e.g.
SQL> connect as sysdba

You should then receive a connected message and be able to perform dba privileged commands
e.g. select * from dba_tablespaces.

If you are prompted for a password then the windows user does not have the permissions required to access oracle without a password and the GUI backup will continue to report the error.