Skip to Content
avatar image
Former Member

BRTOOLS; SQL error -1031

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 14, 2008 at 02:50 PM

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

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2008 at 02:54 PM

    HI Markus

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

    Matthias

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Feb 06, 2008 at 06:56 AM

    note 834917 was helpfull

    Add comment
    10|10000 characters needed characters exceeded