Problem in lab128 with Oracle 10.2.0.5

[Samir Sánchez R]

Hi Sergei,

Our Enterprise buy the product more less 5 or 6 months ago and was
working perfect in our oracle instances with versions 10.2.0.4, but
after installing new databases with 10.2.0.5 we realize that lab128
does not show some of the graphics.

I send you the log of lab128:

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Server version: 10.2.0.5.0, Client version: 11.2.0.1.0 Production
4/17 10:33:12 - ORA-00980: synonym translation is no longer valid
SQL:
--lab128
select a.kslednam,a.indx,a.ksledp1,a.ksledp2,a.ksledp3 from x$ksled
a
,x$kslei b where a.indx=b.indx order by a.indx
4/17 10:33:12 - Query ID=912, Name='v$system_event', recoverable error
103: Query execution attempt failed.
4/17 10:33:13 - ORA-00980: synonym translation is no longer valid
SQL:
--lab128
select a.kslednam,a.indx,a.ksledp1,a.ksledp2,a.ksledp3 from x$ksled
a
,x$kslei b where a.indx=b.indx order by a.indx
4/17 10:33:13 - OCI statement execute error.
4/17 10:33:13 - Query ID=912, Name='v$system_event' has been
disabled.
4/17 10:33:58 - ORA-00980: synonym translation is no longer valid
SQL:
--lab128
select ts# ts_id, segfile# header_rfn, segblock# header_block,
file# rfn, block# bl, length blocks
from sys.uet$
union all
select ktfbuesegtsn ts_id, ktfbuesegfno header_rfn, ktfbuesegbno
header_block,
ktfbuefno rfn, ktfbuebno bl, ktfbueblks blocks
from x$ktfbue
4/17 10:33:58 - Query ID=931, Name='dba_extents', recoverable error
103: Query execution attempt failed.
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Thank you so much for you help
Samir

[Sergei - Lab128]

Hi Samir,

There was another message on this forum reporting same problem. I am
re-sending my reply:

The ORA-00980 means that the synonym exists, but the table or view it
is based on - doesn't exist.

Recreate the view and synonym (just in case):

-- This part needs to be executed by SYS.
-- In case when you are re-creating these views, use "create or
replace view" variation:

-- X$KSLED
create view sys.x_$ksled as select * from x$ksled;
grant select on sys.x_$ksled to PUBLIC;
create public synonym x$ksled for sys.x_$ksled;

-- X$KSLEI
create view sys.x_$kslei as select * from x$kslei;
grant select on sys.x_$kslei to PUBLIC;
create public synonym x$kslei for sys.x_$kslei;

Regards,
Sergei