ORA-01031: insufficient privileges and 'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ...

ORA-01031: insufficient privileges and 'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ...

Problem:

-------------

BR0051I BRBACKUP 7.20 (23)

BR0169W Value 'ibs=' of parameter/option 'dd_in_flags' ignored for 'Windows' - 'bs=' assumed

BR0055I Start of database backup: beizigjr.and 2012-07-14 22.00.27

BR0484I BRBACKUP log file: C:\oracle\ORCL\sapbackup\beizigjr.and

BR0280I BRBACKUP time stamp: 2012-07-14 22.00.27

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT sapsr3/****** AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

BR0280I BRBACKUP time stamp: 2012-07-14 22.00.27

BR0301W SQL error -980 at location BrbDbLogOpen-5, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20120714220027', 'and', 'ORCL', ' ', '9999', ' ', 'beizigjr', '7.20 (23)')'

ORA-00980: synonym translation is no longer valid

BR0324W Insertion of database log header failed

Solution:

--------------

1 ) The backup details are stored in the tables SDBAH and SDBAD . So create these tables first.

create table sapsr3.sdbah (beg varchar2(14) default ' ' not null, funct varchar2(3) default ' ' not null,sysid varchar2(8) default ' ' not null,obj varchar2(16) default ' ' not null,rc varchar2(4) default '0000' not null,ende varchar2(14) default ' ' not null,actid varchar2(16) default ' ' not null,line varchar2(254) default ' ' not null) tablespace psapdba storage (initial 64K next 64K pctincrease 0 minextents 1 maxextents 100);

create table sapsr3.sdbad (beg varchar2(14) default ' ' not null, funct varchar2(3) default ' ' not null,sysid varchar2(8) default ' ' not null,pos varchar2(4) default '0000' not null,line varchar2(254) default ' ' not null) tablespace psapdba storage (initial 256K next 256K pctincrease 0 minextents 1 maxextents 100);

create unique index sapsr3.sdbah__0 on sapsr3.sdbah (beg, funct) tablespace psapdba storage (initial 16K next 16K pctincrease 0 minextents 1 maxextents 100);

create unique index sapsr3.sdbad__0 on sapsr3.sdbad (beg, funct, pos) tablespace psapdba storage (initial 64K next 64K pctincrease 0 minextents 1 maxextents 100);

2 ) 'CONNECT sapsr3/****** AT PROF_CONN IN SYSOPER MODE' ORA-01031: insufficient privileges

Actually this error comes as this user SAPSR3 does not have the sysoper previlage.

SQL> connect sapsr3/abc@1234 as sysdba;

Connected.

SQL> grant sysoper to sapsr3;

Grant succeeded.

SQL> connect sapsr3/satish as sysoper;

Connected.

SQL>

3) Run the sapconn_role.sql and sapdba_role.sql

SQL>@sapconn_role.sql

SQL>@sapdba_role.sql <SAPSchemaID>

for SAPSR3 SAPSchemaID is SR3

for SAPDEV SAPSchemaID is DEV

It will create two roles sapconn and sapdba

And assign the two roles to sapsr3

SQL>grant sapconn to sapsr3

SQL>grant sapdba to sapsr3

4.Run the profiles sapuprof_profile.sql

Password expires after 180 days ,so Run the profiles sapuprof_profile.sql

SQL>@sapuprof_profile.sql

And the above error is resolved.

Please follow the below notes for some better understanding.

91216 - BRBACKUP-SAPDBA ORA-01031 Insufficient privileges

126248 - SAPDBA Check causes ora-01031

761745 - Oracle 9 ORA-01031 and ORA-06512 with DBMS_STATS

900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

1028220 - ORA-01031 Insufficient privileges despite SAPCONN role

834917 - Oracle Database 10g New database role SAPCONN

134592 - Importing the SAPDBA role (sapdba_role.sql)

320457 - Installing BR tools on a non-ABAP database

If after kernel upgradation, stats goes fail, then we can try also this...

Go under /usr/sap/SID/SYS/run/exe and run
sqlplus /nolog @sapdba_role.sql SR3 <- -- For ABAP sceham
sqlplus /nolog @sapdba_role.sql SR3DB <- - -For Java Schema
Check the sapdba_role.log outputfile ..

Hope it helps