BRTOOLS; SQL error -1031

[Former Member]

Hi,

I'm getting following error while executing db-checks with brtools:

BR0484I BRCONNECT log file: G:\oracle\PMT\sapcheck\cdxarbyz.chk

BR0280I BRCONNECT time stamp: 2008-01-14 14.58.19

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 ('20080114145813', 'chk', 'PMT', 'DATABASE', '9999', ' ', 'cdxarbyz', '7.00 (26) check')'

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

I have already run sapdba_role.sql and sapconn_role.sql on the database for the SAPSID

for sapdba_role.sql

sqlplus /nolog @sapdba_role SAPR3

for sapconn_role.sql

sqlplus /nolog @sapconn_role

Can somebody please help?

[Former Member]

note 834917 was helpfull

[Former Member]

HI Markus

I used sqlplus /nolog @sapdba_role SAPSR3 not sqlplus /nolog @sapdba_role SAPR3.

Matthias

[markus_doehr2]

well - you wrote SAPR3

You can use note 834917 - Oracle Database 10g: New database role SAPCONN to check, which permissions are missing.

Markus

[Former Member]

Hi Markus

I check everything as its written in the note 834917. With this note I could solve the problem.

thanks Matthias

[Former Member]

I thought the format for running sapdba_role.sql was to uise only the suffix.

So if you schema is SAPSR3 then you only need to give SR3.

View the sapdba_role.sql and you will see the proper format.

Also be sure the permissions on the br* binaries are correct and they have different owners/ sticky bits set.

[markus_doehr2]

Are you sure SAPR3 is right? If that system was new installed, the user is most likely SAPSR3

Markus