On Extracting on Solaris 2.8 the Cold Backup of a Database existing in
Solaris 2.6 for Oracle ver 7.3.4.5
ORA-00600: internal error code, arguments: [2845], [0], [512], [22], [],
[], [], []
NOTE - The Database was working in a healthy condition on Solaris 2.6
for a Number of Months Prior to it's extract on Solaris 2.8
$ uname -a
SunOS SF2A 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Fire
Qs. Are there Any O.S./Oracle Patches which Should be Applied when Doing
Such an Extract ?
Part Portion .trc File Below :-
Dump file /oracle734/rdbms/userlog/bby01_ora_19128.trc
Oracle7 Server Release 7.3.4.5.0 - Production
PL/SQL Release 2.3.4.5.0 - Production
ORACLE_HOME = /oracle734
System name: SunOS
Node name: SF2A
Release: 5.8
Version: Generic_108528-10
Machine: sun4u
Instance name: bby01
Redo thread mounted by this instance: 1
Oracle process number: 1474
Unix process pid: 19128, image: oraclebby01
- SESSION ID:(204.769) 2001-11-19 10:59:03.000
- 2001-11-19 10:59:03.000
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [2845], [0], [512], [22], [],
[], [], []
Current SQL statement for this session:
update TBA_OUT_ZONE_HDR_TBL set
del_flg=:b0,tran_id1=:b1,tran_id2=:b2,cr_acid=:b3,dr_acid=:b4,home_clg_f
lg=:b5,row_locked_flg=:b6,shadow_bal_flg=:b7,micr_clg_flg=:b8,encode_flg
=:b9,zone_micr_abbr=:b10,zone_micr_chrg_code=:b11,clg_sec_dp_code=:b12,c
lg_zone_desc=:b13,tran_date1=TO_DATE(:b14,'DD-MM-YYYY
HH24:MI:SS'),tran_date2=TO_DATE(:b15,'DD-MM-YYYY
HH24:MI:SS'),zone_stat=:b16,value_date1=TO_DATE(:b17,'DD-MM-YYYY
HH24:MI:SS'),value_date2=TO_DATE(:b18,'DD-MM-YYYY
HH24:MI:SS'),tot_dr_part_tran_amt=TO_NUMBER(:b19),tot_cr_part_tran_amt=T
O_NUMBER(:b20),tot_vfd_cr_part_tran=:b21,tot_cr_part_tran_num=:b22,tot_v
fd_dr_part_tran=:b23,tot_dr_part_tran_num=:b24,tot_num_instrmnt=:b25,tot
_vfd_instrmnt=:b26,tot_instrmnt_amt=TO_NUMBER(:b27),tot_shad_bal=TO_NUMB
ER(:b28),tot_pend_amt=TO_NUMBER(:b29),remain_shad_bal=TO_NUMBER(:b30),cu
rnt_part_tran_srl_num=:b31,zone_contra_srl_num=:b32,curnt_set_num=:b33,c
urnt_instrmnt_srl_num=:b34,bar_inst_amt=TO_NUMBER(:b35),bar_inst_num=:b3
6,bar_num=:b37,bar_date=TO_DATE(:b38,'DD-MM-YYYY
HH24:MI:SS'),prnt_srl_alpha=:b39,prnt_srl_num=:b40,sets_entered=:b41,set
s_verified=:b42,lchg_user_id=:b43,lchg_time=TO_DATE(:b44,'DD-MM-YYYY
HH24:MI:SS'),rcre_user_id=:b45,rcre_time=TO_DATE(:b46,'DD-MM-YYYY
HH24:MI:SS'),frgn_crncy_clg_flg=:b47,sttlmnt_in_inst_crncy_flg=:b48,sttl
mnt_crncy_code=:b49,zone_crncy_code=:b50,zone_to_sttlmnt_crncy_rate=TO_N
UMBER(:b51),rate_code=:b52,event_id=:b53,event_type=:b54,srl_num=:b55,im
p_tran_id=:b56,def_rate_code1=:b57,def_rate_code2=:b58,clg_sec_bank_code
=:b59,dump_format_mrt_filename=:b60,dump_filename_prefix=:b61,inst_or_ac
ct_ptran_cre_flg=:b62,set_rel_reg_flg=:b63,set_rel_dr_acid=:b64,zone_lat
ency=:b65,out_rej_event_id=:b66,cr_acid_for_out_rej=:b67,control_sol_id=
:b68,ts_cnt=:b69 where ((((rowid=:b70 and sol_id=:b71) and
clg_zone_date=TO_DATE(:b72,'DD-MM-YYYY HH24:MI:SS')) and
clg_zone_code=:b73) and NVL(ts_cnt,0)=:b74)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infy.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Nov 20 2001 - 18:00:58 CST
