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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Computer101Connect With a Mentor Commented:
PAQed with no points refunded (of 500)

Computer101
EE Admin
0
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
ImanmalikAuthor Commented:
Oracle Database 9.2.0.4
0
 
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
All Courses

From novice to tech pro — start learning today.