Hi
This could be the tentative solution of the error
Azeem
When attempting to export the OLAP catalog schema, errors occur when doing
the export backup via RMAN, when exporting 9.2.0.5 to a 10.1.0.3 catalog
database created manually. This also errors out when doing the export
without RMAN.
The following error messages occur:
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 37002 encountered
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
technical support.
ORA-33262: Analytic workspace EXPRESS does not exist.
ORA-06512: at "SYS.DBMS_AW", line 27
ORA-06512: at "SYS.DBMS_AW", line 115
ORA-06512: at "SYS.DBMS_AW_EXP", line 325
ORA-06512: at line 1
Cause
OLAP was never installed in this database. The database was manually created
from a script without OLAP. Also, general purpose databases created by
scripts have some underlying basic OLAP components built in automatically.
The export would falter looking for some catalog components related to the
underlying components.
This can also happen after database upgrades.
Solution
To implement the solution, please execute the following steps:
1. To Perform Relational Exports (schema/database) without Analytic
Workspaces.
SQL> conn / as SYSDBA
SQL> delete from sys.exppkgact$ where package = 'DBMS_AW_EXP';
To restore this run the following
SQL> conn / as sysdba
SQL> @ ?/rdbms/admin/dbmsaw.plb
-----Original Message-----
From: Mir Aijaz A
[mailto:oracledba-ezmlmshield-x29453952.[Email address protected]
Sent: Friday, April 27, 2007 1:36 AM
To: LazyDBA Discussion
Subject: ORA-37002 please help
Hi,
I changed some of the SGA parameters and since then I am getting this
error. This error is thrown only when I run export. I contacted oracle
support, they say that I have to disable OLAP (which I am not using),
but my question is why such error is generated now only as I have this
database up and running since one year (this is produciton database
24X7). Please help as this error is being generated since last 10 days
ORA-00600: internal error code, arguments: [kghfrf1], [0x0], [], [], [],
[], [], []
ORA-37002: Oracle OLAP failed to initialize, please contact Oracle
Support.
Regards
Aijaz
DISCLAIMER:
Notice : This e-mail and any attachments may contain information which is
confidential to the addressee and may also be privileged. If you are not the
intended recipient of this e-mail, you may not copy, forward, disclose or
otherwise use it in any way whatsoever. If you have received this e-mail by
mistake, please e-mail the sender by replying to this message, and deleting
the original and any printout thereof.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page