on 07-28-2015 4:22 AM
Hello Expert,
I am trying to checkdb using DB13 but i am getting following error
Job started
Step 001 started (program RSDBAJOB, variant &0000000000008, user ID SAP*)
Execute logical command BRCONNECT On host majdev
Parameters: -jid CHECK20141010000000 -u / -c -f check
BR0801I BRCONNECT 7.40 (11)
BR0805I Start of BRCONNECT processing: ceravbgc.chk 2015-07-28 00:00:26
BR0484I BRCONNECT log file: /oracle/DV1/sapcheck/ceravbgc.chk
BR0477I Oracle pfile /oracle/DV1/112_64/dbs/initDV1.ora created from spfile /oracle/DV1/112_64/dbs/spfileDV1.ora
BR0280I BRCONNECT time stamp: 2015-07-28 00:00:27
BR0813I Schema owners found in database DV1:
APPQOSSYS, BRT$ADM, DBSNMP, DIP, OPS$DV1ADM, OPS$ORADV1, OPS$SAPSERVICEDV1, ORACLE_OCM, OUTLN, SAPSR3*,
SYS, SYSTEM
BR0280I BRCONNECT time stamp: 2015-07-28 00:00:34
BR0814I Number of tables in schema of owner SAPSR3: 88838
BR0836I Number of tables treated as info cubes for owner SAPSR3: 66
BR0814I Number of tables/partitions in schema of owner SYS: 886/232
BR0814I Number of tables/partitions in schema of owner SYSTEM: 151/39
BR0280I BRCONNECT time stamp: 2015-07-28 00:00:45
BR0815I Number of indexes in schema of owner SAPSR3: 106623
BR0815I Number of indexes/partitions in schema ofowner SYS: 965/242
BR0815I Number of indexes/partitions in schema ofowner SYSTEM: 212/52
BR0280I BRCONNECT time stamp: 2015-07-28 00:00:55
BR0816I Number of segments in schema of owner DBSNMP: 8
BR0816I Number of segments in schema of owner OUTLN: 9
BR0816I Number of segments/LOBs in schema of owner SAPSR3: 58209/3748
BR0816I Number of segments/LOBs in schema of owner SYS: 2650/144
BR0816I Number of segments/LOBs in schema of owner SYSTEM: 407/22
BR0825E Table/index 'SAPSR3.RFCKEYSS' not found in database
BR0825E Table/index 'SAPSR3.PLAN_TABLE' not foundin database
BR0182E Checking parameter/option 'check_exclude/-e' failed
BR0806I End of BRCONNECT processing: ceravbgc.chk2015-07-28 00:00:55
BR0280I BRCONNECT time stamp: 2015-07-28 00:00:55
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
how to correct this?
Kindly help me.
Hi Andre,
Seems check_exclude failed to find the tables (SAPSR3.RFCKEYSS, SAPSR3.PLAN_TABLE).
Please check initSID.ora and look for below entry and remove the tables.
check_exclude = (SAPSR3.RFCKEYSS,SAPSR3.PLAN_TABLE,xxx,xxx,xxx)
then re-execute checkdb.
R,
AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Andre,
Please check following SAP note for some insight on "check_exclude parameter or "-e" option"
445884 - New BRCONNECT 6.10 option and parameter values
Regards
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andre,
Table/index 'SAPSR3.RFCKEYSS' not found in database
Please follow SAP Note 1638829 - RFC: Removing unused RFC tables
database table RFCKEYSS was introduced. It is required for the support of secure RFC connections. This table is not required in any of the higher releases and can therefore be deleted.
After that re-execute database check to verify.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.