ORA-00600 alert log

I received the following errors on my alert log

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kghasp1], [0xFFFFFFFF781600B8], [], [], [], [], [], []


When i checked the tracefile i get following . Any Idea?

ORA-07445: exception encountered: core dump [0000000101D56B80] [SIGBUS] [Invalid address alignment] [0xFFFFFFFF7B50DFEA] [] []
Current SQL statement for this session:
select * from ( select row_.*, rownum rownum_ from ( SELECT pp.document_title as project_plan_name,UPPER(pp.document_title) as project_plan_name_u,pp.locked_flg as project_plan_locked,req.document_title as requisition_document_name,UPPER(req.document_title) as requisition_document_name_u,req.document_nbr as requisition_document_nbr,req.locked_flg as requisition_locked,pr.document_title as pr_document_name,UPPER(pr.document_title) as pr_document_name_u,pr.document_nbr as pr_document_nbr,pr.locked_flg as pr_locked,sol.document_title as solicit_document_name,UPPER(sol.document_title) as solicit_document_name_u,sol.document_nbr as solicit_document_nbr,sol.locked_flg as solicit_locked,awd.document_title as award_document_name,UPPER(awd.document_title) as award_document_name_u,awd.document_nbr as award_document_nbr,awd.locked_flg as award_locked,base.document_nbr as base_nbr,base.document_title as base_name,da.awd_typ_cd || base.document_nbr || awd.document_nbr as awd_piin,da.awd_typ_cd,da.gsa_fss_nbr,proc_doc_related.*,val_status.status_ds as proc_status_ds,shared_status,proc_group_level,proc_group_id,top_proc_id,user_profile.userid,user_profile.fname,user_profile.lname,upper(fname) as fname_u,upper(lname) as lname_u FROM procurement, proc_doc_related, document pp, document req, document pr, document sol, document awd, document_awd da, val_status val_status, procurement_group procurement_group, document base, user_profile WHERE project_plan_objct_id=pp.object_id(+)  AND req_objct_id=req.object_id(+)  AND pr_objct_id=pr.object_id(+)  AND sol_objct_id=sol.object_id(+)  AND awd_objct_id=awd.object_id(+)  AND awd_objct_id=da.object_id(+)  AND procurement.status_cd=val_status.status_cd(+)  AND procurement.proc_id=procurement_group.proc_id(+)  AND procurement_group.proc_group_type(+)=:1  AND base_contract_objct_id=base.object_id(+)  AND upper(gsa_fss_nbr)  like  :2 AND upper(awd.document_nbr)  not like  :3 AND user_profile.userid=procurement.userid AND procurement.status_cd  is not  null AND proc_doc_related.proc_id=procurement.proc_id   UNION SELECT pp.document_title as project_plan_name,UPPER(pp.document_title) as project_plan_name_u,pp.locked_flg as project_plan_locked,req.document_title as requisition_document_name,UPPER(req.document_title) as requisition_document_name_u,req.document_nbr as requisition_document_nbr,req.locked_flg as requisition_locked,pr.document_title as pr_document_name,UPPER(pr.document_title) as pr_document_name_u,pr.document_nbr as pr_document_nbr,pr.locked_flg as pr_locked,sol.document_title as solicit_document_name,UPPER(sol.document_title) as solicit_document_name_u,sol.document_nbr as solicit_document_nbr,sol.locked_flg as solicit_locked,awd.document_title as award_document_name,UPPER(awd.document_title) as award_document_name_u,awd.document_nbr as award_document_nbr,awd.locked_flg as award_locked,base.document_nbr as base_nbr,base.document_title as base_name,da.awd_typ_cd || base.document_nbr || awd.document_nbr as awd_piin,da.awd_typ_cd,da.gsa_fss_nbr,proc_doc_related.*,val_status.status_ds as proc_status_ds,shared_status,proc_group_level,proc_group_id,top_proc_id,user_profile.userid,user_profile.fname,user_profile.lname,upper(fname) as fname_u,upper(lname) as lname_u FROM procurement, proc_doc_related, document pp, document req, document pr, document sol, document awd, document_awd da, val_status val_status, procurement_group procurement_group, document base, user_profile WHERE project_plan_objct_id=pp.object_id(+)  AND req_objct_id=req.object_id(+)  AND pr_objct_id=pr.object_id(+)  AND sol_objct_id=sol.object_id(+)  AND awd_objct_id=awd.object_id(+)  AND awd_objct_id=da.object_id(+)  AND procurement.status_cd=val_status.status_cd(+)  AND procurement.proc_id=procurement_group.proc_id(+)  AND procurement_group.proc_group_type(+)=:4  AND base_contract_objct_id=base.object_id(+)  AND upper(base.document_nbr)  like  :5 AND upper(awd.document_nbr)  not like  :6 AND user_profile.userid=procurement.userid AND procurement.status_cd  is not  null AND proc_doc_related.proc_id=procurement.proc_id   UNION SELECT pp.document_title as project_plan_name,UPPER(pp.document_title) as project_plan_name_u,pp.locked_flg as project_plan_locked,req.document_title as requisition_document_name,UPPER(req.document_title) as requisition_document_name_u,req.document_nbr as requisition_document_nbr,req.locked_flg as requisition_locked,pr.document_title as pr_document_name,UPPER(pr.document_title) as pr_document_name_u,pr.document_nbr as pr_document_nbr,pr.locked_flg as pr_locked,sol.document_title as solicit_document_name,UPPER(sol.document_title) as solicit_document_name_u,sol.document_nbr as solicit_document_nbr,sol.locked_flg as solicit_locked,awd.document_title as award_document_name,UPPER(awd.document_title) as award_document_name_u,awd.document_nbr as award_document_nbr,awd.locked_flg as award_locked,base.document_nbr as base_nbr,base.document_title as base_name,da.awd_typ_cd || base.document_nbr || awd.document_nbr as awd_piin,da.awd_typ_cd,da.gsa_fss_nbr,proc_doc_related.*,val_status.status_ds as proc_status_ds,shared_status,proc_group_level,proc_group_id,top_proc_id,user_profile.userid,user_profile.fname,user_profile.lname,upper(fname) as fname_u,upper(lname) as lname_u FROM procurement, proc_doc_related, document pp, document req, document pr, document sol, document awd, document_awd da, val_status val_status, procurement_group procurement_group, document base, user_profile WHERE project_plan_objct_id=pp.object_id(+)  AND req_objct_id=req.object_id(+)  AND pr_objct_id=pr.object_id(+)  AND sol_objct_id=sol.object_id(+)  AND awd_objct_id=awd.object_id(+)  AND awd_objct_id=da.object_id(+)  AND procurement.status_cd=val_status.status_cd(+)  AND procurement.proc_id=procurement_group.proc_id(+)  AND procurement_group.proc_group_type(+)=:7  AND base_contract_objct_id=base.object_id(+)  AND upper(awd.document_nbr)  like  :8 AND user_profile.userid=procurement.userid AND procurement.status_cd  is not  null AND proc_doc_related.proc_id=procurement.proc_id   ORDER BY project_plan_name_u, requisition_document_name_u,pr_document_name_u, solicit_document_name_u, award_document_name_u ASC ) row_  ) where rownum_ >= :9 and rownum_ <= :10
ImanmalikAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Docteur_ZCommented:
Please provide the exact version of Oracle you're using.
0
mohammadzahidCommented:
YOu need to contact Oracle support. ora-0600 error messages are very critical and usually require assistance from Oracle Support to resolve this type of issue.

0
ImanmalikAuthor Commented:
Oracle Database 9.2.0.4
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

TaygerCommented:
ORA-600 are very deep/hard error messages. Im not sure if you get big help from Oracle side. If you have Oracle installed on Windows then please try a scandisk and defrag. If the error wont go away, extract your schemas (if needed), drop the DB and create a new one - most simple way, instead of finding  helpfull hints.
Tayger
0
Docteur_ZCommented:
On Metalink :

Your ORA-900 error gives :
ERROR:
  ORA-600 [kghasp1] [a]
 
VERSIONS:
  version 8.1 to 10.1

DESCRIPTION:

  We are computing the total amount of allocated memory in a heap.

  If one of the chunks in the heap has a size of zero, then this internal
  error is raised.

ARGUMENTS:
  Arg [a] Pointer to the chunk

FUNCTIONALITY:      
  HEAP MANAGER

IMPACT:
  PROCESS FAILURE
  MEMORY CORRUPTION
  NON DATA CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

  Check to see if the problem will reproduce.

  Run system hardware checks on all memory.

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

  Known Issues:
  Bug# 1791258   See Note 1791258.8
      CONNECT BY on IOT can cause SGA memory corruption
      Fixed: 8.1.7.3, 9.0.1.1, 9.2.0.1
 
  Bug# 1744786   See Note 1744786.8
      Cursor work heap corruption from CONNECT BY PRIOR
      Fixed: 8.1.7.3, 9.0.1.1, 9.2.0.1
 



And try to ligthen your query, it's much too heavy.
0
TaygerCommented:
In case its a memory block error, try to "activate memory parity check" in BIOS. Otherwise and also very helpful are some memory bar checkers to check your memory. Having a bad memory bar in your PC can cause unpredictable errors.
Tayger
0
gattu007Commented:
ERROR:
  ORA-600 [kghasp1] [a]
 
VERSIONS:
  version 8.1 to 10.1

DESCRIPTION:

  We are computing the total amount of allocated memory in a heap.

  If one of the chunks in the heap has a size of zero, then this internal
  error is raised.

ARGUMENTS:
  Arg [a] Pointer to the chunk

FUNCTIONALITY:      
  HEAP MANAGER

IMPACT:
  PROCESS FAILURE
  MEMORY CORRUPTION
  NON DATA CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

  Check to see if the problem will reproduce.

  Run system hardware checks on all memory.

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

  Known Issues:
  Bug# 1791258   See Note 1791258.8
      CONNECT BY on IOT can cause SGA memory corruption
      Fixed: 8.1.7.3, 9.0.1.1, 9.2.0.1
 
  Bug# 1744786   See Note 1744786.8
      Cursor work heap corruption from CONNECT BY PRIOR
      Fixed: 8.1.7.3, 9.0.1.1, 9.2.0.1
0
Docteur_ZCommented:
Hi,
I don't want the feel like a "beggar", but I think my answer is the closest to the needed information.
In this case, the asker should be calling the Oracle support - that I think she did.

Regards
0
Computer101Commented:
PAQed with no points refunded (of 500)

Computer101
EE Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.