DB13 error for checkdatabase job

[Former Member]

Hi all,

Our system has been working fine for db13 autoscheduled jobs , but suddenly from last 4 weeks checkdb and other jobs are failing , though our backups through DB13 is working fine , but other jobs are failing .

below are logs for your reference

Job log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000005, user ID DDIC)

Execute logical command BRCONNECT On host micprd1

Parameters: -u / -c -f check

BR0801I BRCONNECT 6.40 (12)

BR0280I BRCONNECT time stamp: 2007-10-15 18.00.35

BR0301E SQL error -1031 at location BrLicCheck-12

ORA-01031: insufficient privileges

BR0280I BRCONNECT time stamp: 2007-10-15 18.00.36

BR0301W SQL error -1031 at location brc_dblog_open-5

ORA-01031: insufficient privileges

BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cdwjnkaa.log2007-10-15 18.00.35

BR0280I BRCONNECT time stamp: 2007-10-15 18.00.36

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

[Former Member · Accepted solution]

Have you done any changes recently ?

Run sapdba_role.sql role according to note 134592

Thanks

Prince Jose

[Former Member · Accepted solution]

Thanks prince for reply but sapdba_role.sql is require when we perform any system copy , here problem is in my Production system .

Unix and Oracle 9.2.0.6 platform , secondly why my online and offline backups are running fine then ?

will sapdba_role.sql will do some harm to my backup jobs ? as they are at least ones which are running fine.

[Former Member · Accepted solution]

Also please let me know procedure and inputs for running sapdba_role.sql on unix background

system copy on windows includes

on windows procedure is

sqlplus /nolog @oradbusr.sql SAPSR3

then proceed with inputs like hostname , NT value and ......

sqlplus /nolog @sapdba_role.sql SAPSR3

[Former Member · Accepted solution]

sapdba_role.sql will give/adjust the database authorizations.So i dont think it will break anything. It might be due to a br tools updates ( usually part of kernel upgrade). Before running the sql , check the permission of brtools , especially check whether s bits are set properly. you can check note 113747 for more info

Thanks

Prince Jose

[Former Member · Accepted solution]

permissions on brtools is fine , i have checked in my Quality system and DB13 works fine over there , all settings for ops$ users and sapuser tables on PRD system is same as QA system , still error occured

i also fired query

SQL> grant select , update on ops$db1adm.sapuser to ops$db1adm;

Grant succeeded.

but no gain ... is sapdba_role.sql need to be run then let me know ,

[Former Member · Accepted solution]

Error solved after running sapdba script

thanks points rewarded

[Former Member · Accepted solution]

Thanks