Highlighted
Daniele Bernazzi
New Member.
93 views

oracle8 rman-01031 insufficient privileges

Hi, I am trying to esthablish a new backup using dp 9.09 on a 2 nodes cluster oracle 11, so I configured cluster and repository credentials and created a backup job with no problems.

At running time everything looks good (counters, messages and so on) but in the final part I always encounter the message:

CREATE OR REPLACE DIRECTORY DATAPROTECTOR_TMP_EXP_31884 AS '/var/opt/omni/tmp'
*
ERROR at line 1:
ORA-01031: insufficient privileges

The utility util_oracle8.pl give me always retval 1002 (but the same for other sistems correctly running) with no more references.

Any clue?

Thank you

0 Likes
2 Replies
Knowledge Partner
Knowledge Partner

Re: oracle8 rman-01031 insufficient privileges

Hi, 

Check the permissions, they should be like this:

: / # su - oracle
> sqlplus / nolog
SQL * Plus: Release 12.1.0.2.0 Production on Thu  10:44:08 201
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect user / ******* @ services as sysdba
Connected.
SQL> select * from v $ pwfile_users;

USERNAME  SYSDB SYSOP
--------------  ---------------- ----- -----
SYS                  TRUE TRUE
SYSTEM         TRUE TRUE
USER               TRUE TRUE

I saw once that SYSBACKUP should be in True.

 

Please assign a kudo to this post, if you find it useful.
0 Likes
Daniele Bernazzi
New Member.

Re: oracle8 rman-01031 insufficient privileges

Hi, my oracle 11 gave me:

SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE

I did the check from a remote client to be sure connection as sysdba is possible also from remote.

Thank you

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.