ORA-01555

Posted by Roshan on Nov 03, 2016; 5:57am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-01555-tp1485.html

Oracle Database 10.2.0.5
 
Hello Erman,
 
I am getting the error below:
SELECT rtrim(t.transaction_set_id)||'|'||
to_char(t.trans_id)||'|'||
rtrim(t.buyer_id)||'|'||
       rtrim(t.vendor_id)||'|'||
rtrim(to_char(T.RECORD_DATE, 'DD/MM/YYYY HH24:MI:SS'))||'|'||
       rtrim(T.LABEL)||'|'||
rtrim(T.DISPATCH_CODE1)||'|'||
rtrim(T.DISPATCH_CODE2)||'|'||
rtrim(regexp_replace(T.DISPATCH_CODE3,'\|*',''))||'|'||
rtrim(t.offer_code)||'|'||
rtrim(t.subscription_code)||'|'||
to_char(T.amount)||'|'||
to_char(t.TAX_AMOUNT)||'|'||
to_char(t.correction_status)||'|'||
to_char(t.origin)||'|'||
to_char(t.tax_status)||'|'||
to_char(Max(DECODE(td.name,'U.vol_total',td.number_value,'U.total_volume',td.number_value)))||'|'||
rtrim(MAX(DECODE(td.name,'I.called_num_disp',td.string_value)))||'|'||
rtrim(max(decode(td.name,'U.invoice_label',td.string_value)))||'|'||
rtrim(max(decode(td.name,'U.destination_label',td.string_value)))||'|'||
rtrim(max(decode(td.name,'U.destination_type',td.string_value)))||'|'||
to_char(MAX(DECODE(td.name,'I.call_duration',td.number_value)))||'|'
FROM transac_detail partition(P20161003)  td INNER JOIN transac  partition(P20161003) t ON td.trans_id = t.trans_id
WHERE t.vendor_id = 'MT_CO'
group by t.transaction_set_id,t.trans_id,t.buyer_id,t.vendor_id, T.RECORD_DATE, t.LABEL,t.dispatch_code1,t.dispatch_code2,t.dispatch_code3,t.amount,t.TAX_AMOUNT,
t.offer_code,t.subscription_code,t.ORIGIN,t.correction_status,t.tax_status;
 
find below the error message
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
00000 -  "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause:    This is the generic internal error number for Oracle program
exceptions. It indicates that a process has encountered a low-level,
unexpected condition. The first argument is the internal message
number. This argument and the database version number are critical in
identifying the root cause and the potential impact to your system.
 
and the connection to the database has been lost.
 
I have checked the alert log. It says:

ORA-01555 caused by SQL statement below (SQL ID: 7mbuy20umxgfy, Query Duration=24 sec, SCN: 0x001f.e0406c42):
Thu Nov 03 05:41:28 MUT 2016
select u.name, o.name from obj$ o,user$ u,   (select obj# objnum# from tab$    where ts#=:1 and          bitand(property,64+512+8192)=0 union all    select distinct t.obj# objnum# from tabpart$ tp,tab$ t    where tp.ts#=:1 and          t.obj#=tp.bo# and          bitand(property,64+512+8192)=0 union all    select distinct t.obj# objnum# from tabcompart$ tcp,tabsubpart$ tsp,tab$ t    where tsp.ts#=:1 and          tsp.pobj#=tcp.obj# and t.obj#=tcp.bo# and          bitand(property,64+512+8192)=0 union all    select t.obj# objnum# from ind$ i,tab$ t    where i.ts#=:1 and i.type#=4 and          t.obj#=i.bo# and bitand(t.property,8192)=0 union all    select distinct t.obj# objnum# from indpart$ ip,ind$ i,tab$ t    where ip.ts#=:1 and i.type#=4 and          i.obj#=ip.bo# and          t.obj#=i.bo# and bitand(t.property,8192)=0 union all    select distinct t.obj# objnum#    from indcompart$ icp,indsubpart$ isp,ind$ i,tab$ t    where isp.ts#=:1 and i.type#=4 and          isp.pobj#=icp.obj# and i.obj#=icp.bo# and
ORA-604 signalled during: DROP TABLESPACE HD_283112519034_20160804_1 INCLUDING CONTENTS...
Thu Nov 03 08:09:14 MUT 2016
Thread 1 advanced to log sequence 12281 (LGWR switch)
  Current log# 8 seq# 12281 mem# 0: /data/ora/PMTBIL01/u01/redo8ardo
  Current log# 8 seq# 12281 mem# 1: /redo/PMTBIL01/redo8brdo
Thu Nov 03 08:39:47 MUT 2016
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=85, OS id=13022
         to execute - SYS.KUPM$MCP.MAIN('JOBDP_HD_283112519034_20160804', 'HDBUSR', 'KUPC$C_1_20161103083947', 'KUPC$S_1_20161103083947', 0);
kupprdp: worker process DW01 started with worker id=1, pid=86, OS id=13032
         to execute - SYS.KUPW$WORKER.MAIN('JOBDP_HD_283112519034_20160804', 'HDBUSR');
Thu Nov 03 08:41:29 MUT 2016
DROP TABLESPACE HD_283112519034_20160804_1 INCLUDING CONTENTS
Thu Nov 03 08:42:21 MUT 2016
Starting control autobackup
Control autobackup written to DISK device
        handle '/exec/products/oracle/v10.2/dbs/c-483556544-20161103-04'
Completed: DROP TABLESPACE HD_283112519034_20160804_1 INCLUDING CONTENTS
Thu Nov 03 09:16:07 MUT 2016
Errors in file /exec/products/oracle/v10.2/admin/PMTBIL01/udump/pmtbil01_ora_6933.trc:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [

Regards,
Roshan