Strange errors in logfile lab128

[Anco Huiberts]

Hi guys,

I tried to startup LAB128 for a database and I see the following
errors in the log :

2/21 10:18:45 - Lab 1.5.9.10 connected as AHUIBERTS to LSMTST, Host:
boltdb1, DB: LSMTST:1.
Server version: 10.2.0.4.0, Client version: 11.2.0.1.0 Production
2/21 10:18:50 - 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
2/21 10:18:50 - Query ID=912, Name='v$system_event', recoverable error
103: Query execution attempt failed.
2/21 10:18:51 - X$KTSSO view is not available. Will use V$SORT_USAGE
instead.
2/21 10:18:59 - Query not supported in this Oracle version:
2/21 10:18:59 - Query ID=961, Name='v$ges_stat' has been disabled.
2/21 10:18:59 - Query not supported in this Oracle version:
2/21 10:18:59 - Query ID=969, Name='v$block_server' has been
disabled.

The Activity Explorer is not sending any output to me ...

Any idea ?

Anco

[David Crowson]

A wild stab in the dark..... :)

> Server version: 10.2.0.4.0, Client version: 11.2.0.1.0 Production

>Query not supported in this Oracle version:

[Sergei - Lab128]

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

[Sergei - Lab128]

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

On Feb 21, 6:11 am, Anco Huiberts <ahuibe...@gmail.com> wrote: