DB verify structure of tables and indexes job failed

[Former Member]

Hi,

DB verify tables and indexes job failed in our SAP system.The log details in DB14 shows as mentioned below:

BR0301E SQL error -980 in thread 2 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_DB_CACHE_ADVICE" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_DB_CACHE_ADVICE

BR0280I BRCONNECT thread 1: time stamp: 2010-11-07 23.15.57

BR0301E SQL error -980 in thread 1 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_DLM_MISC" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_DLM_MISC

BR0280I BRCONNECT thread 2: time stamp: 2010-11-07 23.16.04

BR0301E SQL error -980 in thread 2 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_FILESTATXS" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_FILESTATXS

BR0280I BRCONNECT thread 1: time stamp: 2010-11-07 23.16.08

BR0301E SQL error -980 in thread 1 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_INST_CACHE_TRANSFER" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_INST_CACHE_TRANSFER

BR0280I BRCONNECT thread 2: time stamp: 2010-11-07 23.16.15

BR0301E SQL error -980 in thread 2 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_LATCH" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_LATCH

BR0280I BRCONNECT thread 1: time stamp: 2010-11-07 23.16.19

BR0301E SQL error -980 in thread 1 at location stats_tab_validate-2, SQL statement:

'ANALYZE TABLE "SYS"."WRH$_LATCH_CHILDREN" VALIDATE STRUCTURE CASCADE ONLINE'

ORA-00980: synonym translation is no longer valid

BR0893E Validating structure failed for table/cluster SYS.WRH$_LATCH_CHILDREN

BR0280I BRCONNECT thread 2: time stamp: 2010-11-07 23.16.27....................................................

We are using Oracle 10.2.0.2 and SAP version ECC 6.0

Please help on this issue..

Thanks in advance

Veera

[Former Member · Accepted solution]

Have you checked the Note 650796 - Composite Note: ORA-00980 ?

BTW: your oracle is 10.2.0.2 read Note 1339724 - Oracle 10.2 Extended Support free until July 31, 2011. I strongly recommend plan your oracle upgrade to 11g ASAP.

[Former Member · Accepted solution]

Hi,

please update your oracle 10.2.0.4 Also run database statistics before running the db verify.

Here is command to update database statistics. login with orasid and give a try

orasid>brconnect -u -c / -f stats -t all

[Former Member · Accepted solution]

Hi ,

We scheduled the verification job after the Update stats and DB check job but still it is failed

[former_member227600 · Accepted solution]

Hi,

ORA-00980: synonym translation is no longer valid

Have you gone through SAP Note 650796 as mention in earlier post.

Thanks & Regards

Karan