Solved

ORA-00600 alert log

Posted on 2007-03-23
11
928 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
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

828 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