select 

do.obj# d_obj,do.name d_name, do.type# d_type, 

po.obj# p_obj,po.name p_name, 

to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') "P_Timestamp", 

to_char(po.stime ,'DD-MON-YYYY HH24:MI:SS') "STIME", 

decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') X 

from sys.obj$ do, sys.dependency$ d, sys.obj$ po 

where P_OBJ#=po.obj#(+) 

and D_OBJ#=do.obj# 

and do.status=1 /*dependent is valid*/ 

and po.status=1 /*parent is valid*/ 

and po.stime!=p_timestamp /*parent timestamp not match*/ 

order by 2,1;

SQL> alter public synonym "SM$VERSION" compile;

alter public synonym "SM$VERSION" compile

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS

ORA-04064: not executed, invalidated

ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS"

ORA-06508: PL/SQL: could not find program unit being called:

"LBACSYS.LBAC_EVENTS"

ORA-06512: at line 2

ORA-06508: PL/SQL: could not find program unit being called:

"LBACSYS.LBAC_EVENTS"

SQL> col comp_name for a36;

SQL> col version for a30;

SQL> col version for a10;

col status for a8;

select comp_id, comp_name, version, status 

from dba_registry 

where comp_name='Oracle Label Security';

COMP_ID                        COMP_NAME                            VERSION    STATUS

------------------------------ ------------------------------------ ---------- --------

OLS                            Oracle Label Security                10.2.0.5.0 VALID

SQL> 

SQL>  select * from v$option where parameter = 'Oracle Label Security';

PARAMETER                                                        VALUE

---------------------------------------------------------------- --------------

Oracle Label Security                                            FALSE

SQL> 

Tue Jun 25 20:15:01 HKT 2019

Errors in file /u01/app/oracle/admin/xxx/udump/xxx_ora_11203.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS

ORA-04064: not executed, invalidated 

ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS"

ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"

ORA-06512: at line 2

ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"

ORA-06512: at line 2

[oracle@xxxxx bdump]$ more  /u01/app/oracle/admin/xxxx/udump/xxx_ora_11203.trc

/u01/app/oracle/admin/EPPS/udump/epps_ora_11203.trc

Oracle Database 10g Release 10.2.0.5.0 - 64bit Production

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

System name:    Linux

Node name:      xxxx

Release:        2.6.32-200.13.1.el5uek

Version:        #1 SMP Wed Jul 27 21:02:33 EDT 2011

Machine:        x86_64

Instance name: xxx

Redo thread mounted by this instance: 1

Oracle process number: 48

Unix process pid: 11203, image: oracle@xxxx (TNS V1-V3)

*** ACTION NAME:() 2019-06-25 20:15:01.745

*** MODULE NAME:(sqlplus@xxxx (TNS V1-V3)) 2019-06-25 20:15:01.745

*** SERVICE NAME:(SYS$USERS) 2019-06-25 20:15:01.745

*** SESSION ID:(113.2150) 2019-06-25 20:15:01.745

Error in executing triggers on connect internal

*** 2019-06-25 20:15:01.750

ksedmp: internal or fatal error

ORA-00604: error occurred at recursive SQL level 1

ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC_EVENTS

ORA-04064: not executed, invalidated 

ORA-04064: not executed, invalidated package body "LBACSYS.LBAC_EVENTS"

ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"

ORA-06512: at line 2

ORA-06508: PL/SQL: could not find program unit being called: "LBACSYS.LBAC_EVENTS"

ORA-06512: at line 2

shutdown immediate; 

startup migrate; 

alter view lbacsys.lbac$all_table_policies compile; 

alter package lbacsys.lbac_events compile body; 

shutdown immediate; 

startup;