ORA-01031: insufficient privileges

[Former Member]

I am getting this error when trying to backup my database using SAPSERVICE<SID>:

BR0051I BRBACKUP 7.00 (16)

BR0055I Start of database backup: bdyjvuag.anf 2008-07-18 09.42.38

BR0280I BRBACKUP time stamp: 2008-07-18 09.42.38

BR0301E SQL error -1031 at location BrLicCheck-12, SQL statement:

'SELECT MAX(SYSTEMNAME), MAX(SYSID) FROM SAP_MLICHECK WHERE EXPIRATION_DATE = (SELECT MAX(EXPIRATION_DATE) FROM SAP_MLICHECK)'

ORA-01031: insufficient privileges

BR0280I BRBACKUP time stamp: 2008-07-18 09.42.38

BR0301W SQL error -1031 at location BrbDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20080718094238', 'anf', 'RD2', ' ', '9999', ' ', 'bdyjvuag', ' ')'

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0056I End of database backup: bdyjvuag.anf 2008-07-18 09.42.38

BR0280I BRBACKUP time stamp: 2008-07-18 09.42.38

BR0054I BRBACKUP terminated with errors

I have updated the sapconn role and the sapdba role:

GRANTEE GRANTED_ROLE

-

---

-

---

SAPERP SAPCONN

OPS$WFT\SAPSERVICERD2 SAPDBA

SYS SAPCONN

SYS SAPDBA

OPS$WFT\RD2ADM SAPDBA

OPS$ORARD2 SAPDBA

SYSTEM SAPDBA

Can anybody help me?

[Former Member]

Sachin,

I am running Windows 2003.

Thanks,

Jackie

[Former Member]

Hi Jackie,

Your problem is resolved or not ?

If not please try to use following statement,

grant connect, resource, SAPDBA to OPS$OPS$WFT\SAPSERVICERD2 with admin option;

Thanks,

Sachin

[Former Member]

Hi McCarty Jackie,

Please let me know on which operating system your server is running ?

Thanks,

Sachin

[Former Member]

Hey Oliver:

I think everything is fine with my OPS$sapserviceRD2 account, but how do I double check?

Thanks,

-- Jackie

[Former Member]

Hi,

check Note 912969 - BR*Tools 7.00 fails due to license problems

and Import the SAPDBA role as per Note 134592 - Importing the SAPDBA role ( sapdba_role.sql)

also check Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA

regards,

kaushal

Edited by: Kaushal Malavia on Jul 21, 2008 7:47 PM

[Former Member]

Hello Jackie,

What's your SAP system version?

In sqlplus you can try the following:

grant connect, resource, dba, sapdba to OPS$SAPSERVICE<SID>;

It seems that it's is a user problem. Everything allright with OPS$ ?

Best regards,

Olivier