Verify the database fails in the SYS and SYSTEM schemas

[Former Member]

Hi all,

When we execute a verify: brconnect -u / -c -f stats -v cascade -t all -p 8

we obtain some errors from some tables (NOT PARTITIONED) of SYS and SYSTEM schemas:

BR0996W Table/index SYS.UTL_RECOMP_SORTED does not exist anymore

and

BR0301E SQL error -14508 at location stats_tab_validate-2

ORA-14508: specified VALIDATE INTO table not found

BR0893E Validating structure failed for table/cluster SYSTEM.LOGMNR_TABPART$

but the tables exists.

any ideas??

Thanks in advance

[Former Member]

HI,

try this:

sqlplus system/password

@$ORACLE_HOME/rdbms/admin/utlvalid.sql

grant all on invalid_rows to public;

exit

sqlplus "/ as sysdba"

create synonym ops$ora<sid>.index_stats for sys.sap_index_stats;

exit

sqlplus system/password

create synonym ops$<sid>adm.invalid_rows for system.invalid_rows;

Thanks

[former_member296561]

I've done but doesn't work..

[Former Member]

Hello,

Have you resolved this issue, I am also getting similar error even after applying as perr SAP note 514178 .

Any help in this greatly appreciated

[Former Member]

Hi Juan Manuel

The other message BR0996W might be related to the bug mentioned in note 1010252, or be a real corruption.

Best regards

Alfonso

[former_member296561]

Hi Alfonso,

I've created the table INVALID_ROWS but the problem persist, in any case that for partitioned tables and this is not the case. The problem is with the SYS and SYSTEM schema.

[Former Member]

Juan Manuel,

You need to create the table INVALID_ROWS.

See SAP note 514178 for reference.

Good luck.

Alfonso