Solved

ORA-00600 alert log

Posted on 2007-03-23
11
939 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
Technology Partners: 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup
Suggested Courses

623 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