RE: ORA-37002 please help

RE: ORA-37002 please help

 

  

I would verify my DBA_REGISTRY objects first.
Select comp_name,version,status from dba_registry where status='INVALID';

If you see any invalid objects then run the catlog.sql and catproc.sql
against the database and then utlrp.sql

Imtiaz

-----Original Message-----
From: Mir Aijaz A
[mailto:oracledba-ezmlmshield-x29453952.[Email address protected]
Sent: Friday, April 27, 2007 12: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


**********************************************************************
The company reserves the right to amend statements made herein in the event of a mistake. Unless expressly stated herein to the contrary, only agreements in writing signed by an authorized officer of the Company may be enforced against it.
**********************************************************************

Oracle LazyDBA home page