BRBACKUP FAILED WITH ORA-01031: insufficient privileges

[Former Member]

Dear Experts,

when i am trying to take the online backup,I am getting below error ,please advice me.

BR0051I BRBACKUP 6.40 (52)

BR0055I Start of database backup: beoqasbx.ant 2014-08-29 21.00.01

BR0484I BRBACKUP log file: F:\oracle\SID\sapbackup\beoqasbx.ant

BR0280I BRBACKUP time stamp: 2014-08-29 21.00.

BR0301E SQL error -1031 at location BrInitOracreate-2

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0056I End of database backup: beoqasbx.ant 2014-08-29 21.00.19

BR0280I BRBACKUP time stamp: 2014-08-29 21.00.

BR0054I BRBACKUP terminated with errors.

Thanks&Regards

nani

[Former Member]

Dear

i have faced this issue and fix the issue.

After executing Oracle sapdba_role.sql which is provided in sapdba_role_ora10.SAR

Please execute manaully from sql prompt below statemets to assign the privileges to the owner SAPSr3 for the following tables which will fix the issue.

grant ALL on SAPSR3.SDBAH to sapdba;

grant ALL on SAPSR3.SDBAD to sapdba;

grant ALL on SAPSR3.DBAML to sapdba;

grant ALL on SAPSR3.DBARCL to sapdba;

grant ALL on SAPSR3.DBAFID to sapdba;

grant ALL on SAPSR3.DBAEXTL to sapdba;

grant ALL on SAPSR3.DBAREOL to sapdba;

grant ALL on SAPSR3.DBABARL to sapdba;

grant ALL on SAPSR3.DBADFL to sapdba;

grant ALL on SAPSR3.DBAOPTL to sapdba;

grant ALL on SAPSR3.DBASPAL to sapdba;

grant ALL on SAPSR3.DBABD to sapdba;

grant ALL on SAPSR3.DBABL to sapdba;

grant ALL on SAPSR3.DBATL to sapdba;

grant ALL on SAPSR3.DBAOBJL to sapdba;

grant ALL on SAPSR3.DBAPHAL to sapdba;

grant ALL on SAPSR3.DBAGRP to sapdba;

grant ALL on SAPSR3.DBAERR to sapdba;

grant ALL on SAPSR3.DBATRIAL to sapdba;

grant ALL on SAPSR3.DBSTATC to sapdba;

grant ALL on SAPSR3.DBSTATTORA to sapdba;

grant ALL on SAPSR3.DBSTATIORA to sapdba;

grant ALL on SAPSR3.DBSTATHORA to sapdba;

grant ALL on SAPSR3.DBSTAIHORA to sapdba;

grant ALL on SAPSR3.DBMSGORA to sapdba;

grant ALL on SAPSR3.DBCHECKORA to sapdba;

grant ALL on SAPSR3.MLICHECK to sapdba;

grant SELECT on SAPSR3.TGORA to sapdba;

grant SELECT on SAPSR3.IGORA to sapdba;

grant SELECT on SAPSR3.TSORA to sapdba;

grant SELECT on SAPSR3.TAORA to sapdba;

grant SELECT on SAPSR3.IAORA to sapdba;

grant SELECT on SAPSR3.SVERS to sapdba;

grant SELECT on SAPSR3.CVERS to sapdba;

grant SELECT on SAPSR3.DD02L to sapdba;

grant SELECT on SAPSR3.DD09L to sapdba;

grant SELECT on SAPSR3.DDNTT to sapdba;

grant SELECT on SAPSR3.DDART to sapdba;

grant SELECT on SAPSR3.DARTT to sapdba;

grant SELECT on SAPSR3.DBCHK to sapdba;

grant SELECT on SAPSR3.DBDIFF to sapdba;

grant ALL on SAPSR3.SAPLIKEY to sapdba;

grant SELECT on SAPSR3.RSNSPACE to sapdba;

grant SELECT on SAPSR3.RSPSPACE to sapdba;

The cause is sapdba role script existing owner is SAPR3 but from SR3 release default owner is SAPSR3 so which is causing this issue so when grant the above tables to the SAP DB owner SAPSR3 where they can access the tables.The similar issue you will when you try to execute DBCheck also and even Update in this thread after this action whether your issue has been solved

Regards

[Former Member]

Also check http://service.sap.com/sap/support/notes/1173159

[Reagan]

There are similar thread available on SCN. Have you triggered the sapdba_role.sql script ?

Download the script from this SAP note 134592 or use the one available in the kernel location.

Eg: sqlplus /nolog @/Path_of_the_file/sapdba_role.sql R3

Regards

RB

[divyanshu_srivastava3]

Hi Nani,

Share kernel, dbatools and oracle version with backup log file.

Regards

Message was edited by: Divyanshu Srivastava

[divyanshu_srivastava3]

Meanwhile, to check more on this read

700548 - FAQ: Oracle authorizations and linked notes.

134592 - Importing the SAPDBA role (sapdba_role.sql)

Regards