Imtiaz, I have verified DBA_REGISTRY already and everything seems
alright.

Azeem and for all. The following changes I made to SGA

ALTER SYSTEM SET shared_pool_size= 524288000 SCOPE=MEMORY;
ALTER SYSTEM SET shared_pool_size= 524288000 SCOPE=SPFILE;

ALTER SYSTEM SET sort_area_size= 52428800 SCOPE=MEMORY;
ALTER SYSTEM SET sort_area_size= 52428800 SCOPE=SPFILE;

ALTER SYSTEM SET shared_pool_reserved_size= 52428800 SCOPE=MEMORY;
ALTER SYSTEM SET shared_pool_reserved_size= 52428800 SCOPE=SPFILE;

ALTER SYSTEM SET session_max_open_files=20 SCOPE=MEMORY;
ALTER SYSTEM SET session_max_open_files=20 SCOPE=SPFILE;

ALTER SYSTEM SET session_cached_cursors= 5242880 SCOPE=MEMORY;
ALTER SYSTEM SET session_cached_cursors= 5242880 SCOPE=SPFILE;

ALTER SYSTEM SET db_cache_size=167772160 SCOPE=MEMORY;
ALTER SYSTEM SET db_cache_size=167772160 SCOPE=SPFILE;

ALTER SYSTEM SET processes= 600 SCOPE=MEMORY;
ALTER SYSTEM SET processes= 600 SCOPE=SPFILE;

ALTER SYSTEM SET max_sga_size= 1.6 GB SCOPE=SPFILE;


I have already bounced my instance. I increased VM of the server. My
server is 4-processor with 4GB RAM.

Regards



-----Original Message-----
From: Sheikh Imtiaz
[mailto:oracledba-ezmlmshield-x89924199.[Email address protected]
Sent: Friday, April 27, 2007 6:19 PM
To: LazyDBA Discussion
Subject: 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.
**********************************************************************


---------------------------------------------------------------------
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




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.

Oracle LazyDBA home page