Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031: insufficient privileges using brbackup with rman in SAP

user11987810Dec 7 2012 — edited Dec 9 2012
hi,
We are getting error ORA-01031: insufficient privileges in SAP when running the below command on Solaris 10 and we have run sapdba_role.sql sapconn_role.sql

/usr/sap/BQ2/SYS/exe/run/brbackup -u /

and below are the BR files permission

-rwsrwxr-x 1 orabq2 dba 6524528 Mar 5 2012 brarchive
-rwsrwxr-x 1 orabq2 dba 6763216 Mar 5 2012 brbackup
-rwsrwxr-x 1 orabq2 sapsys 8966536 Mar 5 2012 brconnect
-rwxr-xr-x 1 bq2adm sapsys 7271040 Mar 5 2012 brrecover
-rwxr-xr-x 1 bq2adm sapsys 2766184 Mar 5 2012 brrestore
-rwxr-xr-x 1 bq2adm sapsys 9665480 Mar 5 2012 brspace
-rwxr-xr-x 1 bq2adm sapsys 3345016 Mar 5 2012 brtools

and below are the id groups

orabq2 is under below groups
dba oper sapsys sapinst cmplr

bq2adm is under below groups
sapsys oper dba

and we can connect fine with sqlplus using sysdba and below is the log of the error and if any one have any idea causing the issue


BR0280I BRBACKUP time stamp: 2012-12-05 01.03.53
BR0505I Full database backup (level 0) using RMAN successful


BR0280I BRBACKUP time stamp: 2012-12-05 01.03.55
BR0530I Cataloging backups of all database files to database BQ2/PRIMARY ...
BR0278E Command output of 'SHELL=/bin/sh /oracle/BQ2/112_64/bin/rman nocatalog':


Recovery Manager: Release 11.2.0.2.0 - Production on Wed Dec 5 01:03:55 2012


Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


RMAN>
RMAN> connect target *
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges


RMAN> **end-of-file**


RMAN>
host command complete

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2013
Added on Dec 7 2012
2 comments
3,223 views