BRTOOLS insufficoent privileges after update

[Former Member]

Hi everybody,

I am currently facing the situation that I get the error "ORA-01031: insufficient privileges" while running Backup or even while making a Database system check with BRTOOLS (BRBACKUP and BRCONNECT).

This error occurs since the update of the SAP System, from Solution Manager 7.1 SPS 08 to Solution Manager 7.1 SPS 10

DB = Oracle 11g

OS = Windows 2003 x64

Error message while backup

BR0280I BRBACKUP time stamp: 2014-01-10 09.53.13
BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:
'PREPARE stmt_1 FROM'
'SELECT TABSPACE FROM "SAPSR3".TSORA UNION SELECT INDSPACE FROM "SAPSR3".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

Error message while Database system check

BR0280I BRCONNECT time stamp: 2014-01-10 09.20.35
BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement:
'PREPARE stmt_5 FROM'
'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYPE = 'TABL' A
ND DIFFKIND IN ('02', '61', '99') ORDER BY OBJNAME'

ORA-01031: insufficient privileges

I have already found an old discussion with a similar error, but this was not really answered.

Kind regards,

Niklas

[Former Member · Accepted solution]

It seems you tried the wrong keywords for searching.
Actually it is a frequently asked question,
and the answer is sapdba_role.sql:

http://service.sap.com/sap/support/notes/134592

[Former Member · Accepted solution]

Hi,

Before asking question, Kindly find your question and answer from scn.

http://scn.sap.com/thread/1650682

Thank you

Mahendran

[Former Member · Accepted solution]

Thanks for the quick answer.

But this seemed unlogical to me because I did no changes to the DB what so ever.

I only updated the SAP System. But right now it seems that this is the case.

Regards,

Niklas

[Former Member · Accepted solution]

I have seen this on many SAP ugrades before, and I don't consider it unlogical any more.

With new versions of SAP there will come new Oracle objects (tables, views, ...), and brtools will need access to it.
And that is what sapdba_role.sql is for.

regards

[Former Member · Accepted solution]

It's really strange because TSORA and DBDIFF are not new objects.

[Former Member · Accepted solution]

Subtle observation, Roman!

But it seems that even old tables may be recreated during SAP upgrades.
I just had a look in one of our ERP systems, and both TSORA and DBDIFF have a creation date when the last enhancement package has been applied, whereas most other tables are much older.

This query btw:
select object_name, created from user_objects
where object_name in ( 'DBDIFF', 'TSORA')
/

[Former Member · Accepted solution]

Subtle observation, Josef!

[Reagan]

Hello

Run the sapdba_rol.sql as mentioned in this SAP note

134592  - Importing the SAPDBA role (sapdba_role.sql)

Also update the BRTools to the latest patchset of 720

Regards

RB