cancel
Showing results for 
Search instead for 
Did you mean: 

DB13 - ORA-01031: insufficient privileges

0 Kudos

Hi experts,

I just move an oracle DB from one physical server to another and i also changed the DB SID.

Now I want to set up some jobs in db13, and i get some "insufficient privileges" errors.

Here is a part of the log from job "Check and update optimizer statistics"  :

Step 001 started (program RSDBAJOB, variant &0000000000419, user ID ADM-XXXX)

Parameters: -jid STATS20131120160828 -u / -c -f stats -t ALL

BR0801I BRCONNECT 7.20 (1)

BR0805I Start of BRCONNECT processing: cemosegb.sta 2013-11-20 16.08.29

BR0484I BRCONNECT log file: M:\oracle\TST\sapcheck\cemosegb.sta

BR0280I BRCONNECT time stamp: 2013-11-20 16.08.35

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

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20131120160829', 'sta', 'TST', 'ALL', '9999', '

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0280I BRCONNECT time stamp: 2013-11-20 16.09.05

BR0817I Number of monitored/modified tables in schema of owner SAPMTR: 81886/3075

BR0280I BRCONNECT time stamp: 2013-11-20 16.09.05

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

OPEN curs_1 CURSOR FOR'

'SELECT POS, LINE FROM SAP_SDBAD WHERE BEG = '00000000000002' AND FUNCT = 'DUR' ORDER BY SUBSTR(LINE, 9)'

ORA-01031: insufficient privileges

...................

What should I try ?

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

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

0 Kudos

Thanks Benjamin,

The note you proposed solved my problem.

Have a good day.

Best Regards

Answers (2)

Answers (2)

sunny_pahuja2
Active Contributor
0 Kudos

There are lot of threads related to this problem on SDN. Please check.

Thanks,

Sunny

Former Member
0 Kudos

Hello Csaba,

Follow the  SAP note ( Note 776505 ) as mentioned below:


su - root
cd /usr/sap/<SAPSID>/SYS/exe/run
chgrp dba brbackup brarchive
chmod 6754 brbackup brarchive

See if this fix your issue.

Regards,

Rakesh