ORA-01031: insufficient privileges

[Former Member]

Hi Experts,

When I try to schedule all the database jobs in db13 i am getting the following error

2010.09.13 09:11:23 Job started

2010.09.13 09:11:23 Step 001 started (program RSDBAJOB, variant &0000000000100, user ID XAKBDEAW)

2010.09.13 09:11:23 Execute logical command BRCONNECT On host xs05093sap6

2010.09.13 09:11:23 Parameters: -u / -jid CHECK20100913091123 -c -f check

2010.09.13 09:11:49 BR0801I BRCONNECT 7.00 (32)

2010.09.13 09:11:49 BR0477I Oracle pfile /oracle/SOL/102_64/dbs/initSOL.ora created from spfile /oracle/SOL/102_64/dbs/spfileSOL.ora

2010.09.13 09:11:49 BR0805I Start of BRCONNECT processing: ceecotpz.chk 2010-09-13 09.11.23

2010.09.13 09:11:49 BR0484I BRCONNECT log file: /oracle/SOL/sapcheck/ceecotpz.chk

2010.09.13 09:11:49 BR0280I BRCONNECT time stamp: 2010-09-13 09.11.24

2010.09.13 09:11:49 BR0301W SQL error -1031 at location brc_dblog_open-1, SQL statement:

2010.09.13 09:11:49 'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20100913091123', 'chk', 'SOL', 'DATABASE', '9999

2010.09.13 09:11:49 ORA-01031: insufficient privileges

2010.09.13 09:11:49 BR0324W Insertion of database log header failed

Can you please help me to fix the issue.

Thanks in advance

Regards

[Former Member · Accepted solution]

Hello venkatesan,

did you execute the scripts sapconn_role.sql and sapdba_role.sql ?

Have a look inside the files for the exact calling syntax. Afterwards

please retry the DB13 transaction.

Simply executing

GRANT DBA TO OPS$SIDADM;

is not a good idea, because you might still get ORA-01031 under

some strange circumstances and it might impose a security risk.

Regards,

Mark

[Former Member]

Hi Mark Foerster

Thanks for your reply,

I have resolved the issue by granting CONNECT,SAPDBA,DBA,RESOURCE

Example

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

Thanks & Regards

[Former Member]

This message was moderated.