ORA-01031: insufficient privileges

[Former Member]

Hello All,

I have scheduled a Check Database from DB13 in our system.

The job completes but with the following warning message:

BR0977I Checking database profile...

BR0280I BRCONNECT time stamp: 2009-09-24 16.18.55

BR0980I Number of changed database profile parameters: 0

BR0280I BRCONNECT time stamp: 2009-09-24 16.18.55

BR0301W SQL error -1031 at location rz20_info_save-1, SQL statement:

'PREPARE stmt_1 STATEMENT FROM'

'UPDATE "SAPSR3DB"."SDBAD" SET LINE = :line WHERE BEG = :beg AND FUNCT = :funct AND POS = :pos'

ORA-01031: insufficient privileges

BR0280I BRCONNECT time stamp: 2009-09-24 16.18.55

BR0955I Number of signaled error/warning/exception alerts for database administration: 0/0/0

BR0956I Number of signaled error/warning/exception alerts for database operations: 0/0/0

BR0957I Number of signaled error/warning/exception alerts for database messages: 0/0/0

BR0958I Number of signaled error/warning/exception alerts for database profile: 0/0/0

BR0806I End of BRCONNECT processing: cebnqugt.chk 2009-09-24 16.18.55

BR0280I BRCONNECT time stamp: 2009-09-24 16.18.55

BR0803I BRCONNECT completed successfully with warnings

From the previous post, I have tried to applied/execute the following

- sqlplus /nolog @sapdba_role.sql <SID>

- I have verified that the OPS$ users have been granted SAPDBA, CONNECT and RESOURCE

- I have checked the br* tools have a 4775 permission, owned by ora<sid>:dba

- I have verified that the owner of the SAPUSER table belongs to OPS$<SID>ADM

What else should be taken into consideration?

Appreciate your assitance on this matter.

Best Regards

Edited by: Julius Baron Manuel on Sep 24, 2009 10:42 AM

Edited by: Julius Baron Manuel on Sep 24, 2009 10:44 AM

[sunny_pahuja2]

Hi Julius,

Check SAP Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

Thanks

Sunny

[Former Member]

Hi,

Follow the suggested oss note.

select grantee, granted_role, default_role from dba_role_privs where grantee = 'SAPR3';

If Default role is not active then

alter user SAPSR3 default role all;

Thanks

[Former Member]

Hello,

I have executed the following:

SQL> select * from dba_role_privs where grantee in ('SAPSR3', 'SAPSR3DB');

GRANTEE GRANTED_ROLE ADM DEF

-

---

-

---

--- ---

SAPSR3 CONNECT NO YES

SAPSR3DB CONNECT NO YES

SAPSR3DB SAPCONN NO YES

SAPSR3DB SELECT_CATALOG_ROLE NO YES

SAPSR3 RESOURCE NO YES

SAPSR3DB RESOURCE NO YES

SAPSR3 SAPCONN NO YES

7 rows selected.

We are currently at Oracle 10.2 which makes the CONNECT and RESOURCE role obsolete. However, SAPCONN has been assigned the SAP users and is a DEFAULT role.

How do I proceed?

Best Regards