ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: Runnng data pump on ERP instance gave ORA-600 error


While running expdp on ERP instance, I am getting ORA-33272: Analytic workspace ZPB.ZPBANNOT cannot be opened
ORA-00600 internal error code , arguments [xschkmk:!dict]


Explanation:


set serverout on
call dbms_aw.execute('aw list');
call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list');
call dbms_aw.execute('shw statlen(name)');

SQL> set serverout on
SQL> call dbms_aw.execute('aw list');
EXPRESS R/O UNCHANGED SYS.EXPRESS

Call completed.

SQL> call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list');
call dbms_aw.execute('aw attach ZPB.ZPBANNOT ro; aw list')
*
ERROR at line 1:
ORA-33272: Analytic workspace ZPB.ZPBANNOT cannot be opened.
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],
[], []
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122


SQL> call dbms_aw.execute('shw statlen(name)');
call dbms_aw.execute('shw statlen(name)')
*
ERROR at line 1:
ORA-34496: The NAME dimension is available only when you have an active
analytic workspace.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
SQL>


The object affected is a so-called 'Analytical Workspace' (AW for short)
where the Oracle OLAP option is storing its data.
During the exp (either via exp or expdp) an OLAP routine is internally
triggered in order to perform the export for the AW's that are part of the objects
to be exported. When the system tries to open one of them, it is failing.
In order to see how bad the damage is, can you please perform the following steps
for me as SYS:


The AW affected is used by Enterprise Planning and Budgetting
which is in turn part of Oracle Financials.


Solution:


The Analytical Workspace (AW) ZPBANNOT owned by the user ZPB is
no longer accessible and therefor damaged beyond repair.


The AW is physicall stored in a table call AW$ZPBANNOT. So what I would suggest to do is
go for a backup and restore this table to another schema to see (using the commands
given blow) whether the AW can be opened. If this is the case, then restore to production
and then make sure that the users are made aware of that as there may be a discrepancy in the data
between what is lost and what is in the restored AW.
The other alternative is (to be discussed with the users) whether there is a possibility
to re-generate this AW by reloading the data . But I am no EPB specialist,
so this is not something that I am in a position to comment.

Get Oracle Certifications for all Exams
Free Online Exams.com