BRBACKUP: ORA-01031: insufficient privileges

[Former Member]

Hello,

where I try to make a online control file backup test, with command "brback -u / -d disk -t online -m 0 -c", it comes always the error message:

root@odrt88:/oracle/IH3/102_64/cpu/CPUJul2006 > su - oraih3

odrt88:oraih3 51> brbackup -u / -d disk -t online -m 0 -c

BR0051I BRBACKUP 7.00 (11)

BR0055I Start of database backup: bdtsqfrg.pnd 2006-10-16 15.08.04

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0301W SQL error -1031 at location BrbDbLogOpen-5

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0319I Control file copy created: /oracle/IH3/sapbackup/cntrlIH3.dbf 12664832

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0301W SQL error -1031 at location BrDbfInfoGet-30

ORA-01031: insufficient privileges

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0301W SQL error -1031 at location BrDbfInfoGet-31

ORA-01031: insufficient privileges

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0301E SQL error -1031 at location BrComprDurGet-1

ORA-01031: insufficient privileges

BR0314E Collection of information on database files failed

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0301W SQL error -1031 at location BrbDbLogOpen-5

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0056I End of database backup: bdtsqfrg.pnd 2006-10-16 15.08.04

BR0280I BRBACKUP time stamp: 2006-10-16 15.08.04

BR0054I BRBACKUP terminated with errors

The system is Netweaver 2004s SR1 Enterprise Portal on Oracle 10.2.0.2.0 on SLES 9(SP3 x86_64).

I have check the user and group. <sapid>adm belongs to groups sapsys, oper, dba, sapinst and ora<dbsid> belongs to dba, oper, sapinst.

Is there anybody has idea? Any answer is appreciated!

Rongfeng

[Former Member · Accepted solution]

You might need to run the sapdba_role.sql.

I ran the scripts below as sidadm and it fixed my issue:

Go under /usr/sap/SID/SYS/run/exe and run

sqlplus /nolog @sapdba_role.sql SR3 <- -- For ABAP sceham

sqlplus /nolog @sapdba_role.sql SR3DB <- - -For Java Schema

Check the sapdba_role.log outputfile ..

Hope it helps

[Former Member · Accepted solution]

Hello Anup,

thank you very much. The problem is solved. By the way, the sql-script should run as:

sqlplus /nolog @sapdba_role.sql <SID> <- -- For ABAP sceham

sqlplus /nolog @sapdba_role.sql <SID>DB <- - -For Java Schema

Regards,

Rongfeng

[former_member296959 · Accepted solution]

I'm facing the same error when trying to backup the DB with brtools :

<i>BR0280I BRBACKUP time stamp: 2007-07-13 14.26.48

BR0301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance H40 failed

BR0280I BRBACKUP time stamp: 2007-07-13 14.26.49

BR0301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance H40 failed</i>

I used the sapdba_role.sql for oracle 9 and got same errors too:

<i>old 1: grant ALL on &User..DBAOBJL to sapdba

new 1: grant ALL on SAPR3.DBAOBJL to sapdba

grant ALL on SAPR3.DBAOBJL to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

old 1: grant ALL on &User..DBAPHAL to sapdba

new 1: grant ALL on SAPR3.DBAPHAL to sapdba

grant ALL on SAPR3.DBAPHAL to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

old 1: grant ALL on &User..DBAGRP to sapdba

new 1: grant ALL on SAPR3.DBAGRP to sapdba

grant ALL on SAPR3.DBAGRP to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

old 1: grant ALL on &User..DBAERR to sapdba

new 1: grant ALL on SAPR3.DBAERR to sapdba

grant ALL on SAPR3.DBAERR to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist

old 1: grant ALL on &User..DBATRIAL to sapdba

new 1: grant ALL on SAPR3.DBATRIAL to sapdba

grant ALL on SAPR3.DBATRIAL to sapdba

*

ERROR at line 1:

ORA-00942: table or view does not exist</i>

All other has Granted succeefully.

System info :

R/3 4.0B

Oracle9.0.1.0

Win2K3

Brtools 6.40

SIDadm user is in all important groups.

Any suggestions?

Thanks in advance,

Zacharias

[Former Member · Accepted solution]

Thanks this also helped me with Oracle 11.2 in 2015

[former_member463919]

Hi Team

when I am executing the SQL command

its showing SP2-0310: unable to open file "sapdba_role.sql"

can any body help me out of this problem.

thanks

maladri

[Former Member]

From 7.0 version, DBA role is also required apart from connect, resource and sapdba.

SQL> grant DBA to OPS$<SID>ADM;

SQL> select granted_role from dba_role_privs where grantee = 'OPS$<SID>ADM';

GRANTED_ROLE

-

---

CONNECT

SAPDBA

DBA

RESOURCE

[Former Member]

Hi Guys,

but it´s very important check if the script sapdba_role.sql is up to date to last version ....In my case it worked  only i download the last version  of this script

regards

Alessandro

[Former Member]

From 7.0 version, DBA role is also required apart from connect, resource and sapdba.

SQL> grant DBA to OPS$<SID>ADM;

SQL> select granted_role from dba_role_privs where grantee = 'OPS$<SID>ADM';

GRANTED_ROLE

-

---

CONNECT

SAPDBA

DBA

RESOURCE

[Former Member]

Hello,

Please use

"sqlplus /nolog @sapdba_role SR3" with oracle user..

I

[Former Member]

thanks my problem solved

[Former Member]

Thanks !!!

[Former Member]

Thanks....