OraFAQ Forum: Server Administration » ORA-00600: internal error code, arguments: [sorsik

Home » RDBMS Server » Server Administration » ORA-00600: internal error code, arguments: [sorsik_2]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00600: internal error code, arguments: [sorsik_2] [message #55944]

Tue, 25 February 2003 23:52

Clayment Lim
Messages: 2
Registered: February 2003

Junior Member

Had been running query using the following PLSQL script for quite a while now, but only this time round, we hit into the ORA-00600 error.

Would appreciate if anyone out there can help to explain to us what happened and is it harmful to the DB?

Many thanks in advance.

sincerely,
the clay.
======================================================

/u01/app/oracle/9.0.2/admin/UAT1GEMY/bdump/uat1gemy_s000_22801.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /u01/app/oracle/9.0.2
System name: SunOS
Node name: geuatsvr3
Release: 5.8
Version: Generic_108528-12
Machine: sun4us
Instance name: UAT1GEMY
Redo thread mounted by this instance: 1
Oracle process number: 9
Unix process pid: 22801, image: oracle@geuatsvr3 (S000)

*** SESSION ID:(27.48060) 2007-07-31 11:57:27.186
*** 2007-07-31 11:57:27.155
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [[sorsik_2]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
Current SQL statement for this session:

select /*+ choose */ e.iac_no,
e.agmt_id,
e.hrchy_pos,
a.fin_txn_id, a.mny_prov_id,
decode(c.rate_val_type, 'P', c.rate_val/100, c.rate_val) rate_val,
c.rate_val_type,
c.prem_end_mth, a.ins_contr_anchr_id,
trunc(c.prem_end_mth/12) prem_mth, d.pol_no, d.prod_code,
d.prem_trm,
a.nature
from tb_event_agmt_rlship a,
tb_production_stat b,
tb_commission_rate c,
tb_ins_contract d,
tb_channel_role e,
tb_statistic_header f
where exists (select 1
from tb_commission_rate g
where type_code = 'MDA'
and g.comsn_rate_id = c.parent_rate_id
and g.valid_from_date <= sysdate
and g.valid_to_date > sysdate)
and exists (select 1
from tb_actual_event h
where h.valid_from_date <= sysdate
and h.valid_to_date > sysdate
and h.event_id = a.event_id
and h.actual_event_code = 'STAT_ADJT'
and h.compltn_sts is null
and h.acctg_mth = 6
and h.acctg_yr = 2007)
and e.agmt_id = a.agmt_id
and a.valid_from_date <= sysdate and a.valid_to_date > sysdate
and c.valid_from_date <= sysdate and c.valid_to_date > sysdate
and b.valid_from_date <= sysdate
and b.valid_to_date > sysdate
and b.event_agmt_rls_id= a.event_agmt_rls_id
and b.stat_code = c.rate_base||c.trm_yrs

--and a.ins_contr_anchr_id > 0
--and a.nature in ('ADJT_FOR', 'DR_ADJT', 'MAN_ADJT')
and ((a.nature in ('ADJT_FOR', 'MAN_ADJT')
and mny_prov_id is not null)
or (a.nature in ('DR_ADJT', 'ADJT_FOR')
and not exists (select 1 from tb_commission_money where agmt_id = a.agm
t_id and ins_agmt_id = a.ins_contr_anchr_id and type_code = 'BASE' and aggr_mp_i
d = a.fin_txn_id)))
and a.ins_contr_anchr_id = d.agmt_id
and d.valid_from_date <= sysdate and d.valid_to_date > sysdate
and c.valid_from_date <= sysdate and c.valid_to_date > sysdate
and a.agmt_id = e.agmt_id
and a.agmt_id = 1169
and e.valid_from_date <= sysdate and e.valid_to_date > sysdate
and b.hdr_stat_id = f.stat_id
and f.hrchy_yr = c.hrchy_type
and f.agt_grp = 'PS'
and f.valid_from_date <= sysdate and f.valid_to_date > sysdate
and e.co_org_unit_code = 'GELM'
and e.type_code = 'TAGT'

Report message to a moderator