Solved

ORA-00600 alert log

Posted on 2007-03-23
11
934 Views
Last Modified: 2013-12-19
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
0
Comment
Question by:Imanmalik
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 7

Expert Comment

by:Docteur_Z
ID: 18781241
Please provide the exact version of Oracle you're using.
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 18781244
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
 

Author Comment

by:Imanmalik
ID: 18782610
Oracle Database 9.2.0.4
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Expert Comment

by:Tayger
ID: 18783960
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
 
LVL 7

Expert Comment

by:Docteur_Z
ID: 18791507
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
 
LVL 2

Expert Comment

by:Tayger
ID: 18794257
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
 
LVL 7

Expert Comment

by:gattu007
ID: 18819328
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
 
LVL 7

Expert Comment

by:Docteur_Z
ID: 22250272
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22295249
PAQed with no points refunded (of 500)

Computer101
EE Admin
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question