X_$KGLLK and X_$KSLEI after upgrade to 11G

Invalid X_$ Views & Synonyms After Upgrading to 11g [ID 878623.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.1.0 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Goal

Why are the synonyms and views under SYS schema for $kslei invalid and not getting validated after upgrading to 11g?

Solution

Those views and synonyms should be dropped in 11g as they do not exist.

This can be shown in a testcase using DBCA to create a new 11.1.0.7 database instance.
The new instance shows:

SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS FROM DBA_OBJECTS WHERE
OBJECT_NAME LIKE '%$KSLEI%';
no rows selected

So drop the views and any synonyms related to $kslei as they are not used in 11g.

* Also the same when upgrading to 11GR2 here is an example:

After upgrading from 10.2.0.3 to 11.2.0.1, the following objects are invalid

Owner Object Name Object Type

SYS X_$KGLLK VIEW
PUBLIC X$KGLLK SYNONYM


2) we tried to compile the view X_$KGLLK

SQL> alter view SYS.X_$KGLLK compile;

Warning: View altered with compilation errors.

SQL> select text from dba_errors where name='X_$KGLLK';

ORA-00904: "KGLLKHTB": invalid identifier

the column KGLLKHTB no longer exists in the table X$KGLLK as of 11g.

SQL> desc sys.X$KGLLK;
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDR RAW(8)
INDX NUMBER
INST_ID NUMBER
KGLLKADR RAW(8)
KGLLKUSE RAW(8)
KGLLKSES RAW(8)
KGLLKSNM NUMBER
KGLLKHDL RAW(8)
KGLLKPNC RAW(8)
KGLLKPNS RAW(8)
KGLLKCNT NUMBER
KGLLKMOD NUMBER
KGLLKREQ NUMBER
KGLLKFLG NUMBER
KGLLKSPN NUMBER
KGLNAHSH NUMBER
KGLLKSQLID VARCHAR2(13)
KGLHDPAR RAW(8)
KGLHDNSP NUMBER
USER_NAME VARCHAR2(30)
KGLNAOBJ VARCHAR2(60)
KGLLKEST DATE
KGLLKEXC NUMBER
KGLLKCTP VARCHAR2(64)


SQL> select owner,synonym_name,table_name from all_synonyms where synonym_name='X$KGLLK';

no rows selected


Both public synonym X$KGLLK and invalid SYS.X_$KGLLK view can be dropped in 11G.