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

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/satish 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