stylesheets not loaded correctly (META DATA Error)

Error :

when you try retrieve METADATA of some SYS object it gives you this error


for E.g.

SQL> exec SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS;
BEGIN SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS; END;


*
ERROR at line 1:
ORA-00600: internal error code, arguments: [7999], [9], [1], [12], [], [], [],
[], [], [], [], []
ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 2435
ORA-06512: at line 1

and further ...


Oracle XML Database
.   ORA-39212: installation error: XSL stylesheets not loaded correctly
.   ORA-06512: at "SYS.DBMS_METADATA", line 5088
.   ORA-06512: at "SYS.DBMS_METADATA", line 7589
.   ORA-06512: at line 1


and

You will find a reference to 'SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS' in the incident trace file.


all you need to do is


SQL> exec dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.


SQL> Analyze table METASTYLESHEET validate structure cascade;

Table analyzed.

now it should list you the meta data you are trying to retrieve.