Friday, January 22, 2016

ORA-00600 [13011], [104], [4216981]

drop procedure ldbo.sp_mvmfrm;

drop materialized view ldbo.mv_rkmfrm;


Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_ora_25880.trc  (incident=2513464):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [185], [4216981], [17], [], [], [], [], [], []
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\incident\incdir_2513464\rakshak_ora_25880_i2513464.trc
Tue Jun 16 13:07:24 2015
Dumping diagnostic data in directory=[cdmp_20150616130724], requested by (instance=1, osid=25880), summary=[incident=2513464].
opiodr aborting process unknown ospid (25880) as a result of ORA-603
Tue Jun 16 13:07:27 2015
Sweep [inc][2513464]: completed
Sweep [inc2][2513464]: completed
Tue Jun 16 13:07:28 2015
SMON: Parallel transaction recovery tried
Tue Jun 16 13:07:30 2015




ORA-00600 [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []


Tue Jun 16 11:24:47 2015
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_j002_27844.trc:
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
ORA-06512: at "LDBO.SP_MVCLIENTFOLLOWUP", line 4
ORA-06512: at line 1


select object_name,object_type,owner from dba_objects where data_object_id=104;


analyze table DEPENDENCY$ validate structure cascade;




SELECT
ss.program "SOFTWARE",last_call_et,
       substr(sqa.sql_text, 1, 50) "SQL"
,'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ''' immediate;'
  fROM v$process pr, v$session ss, v$sqlarea sqa
 WHERE pr.addr = ss.paddr
   AND ss.username is not null
   AND ss.sql_address = sqa.address(+)
   AND ss.sql_hash_value = sqa.hash_value(+)
AND ss.status = 'ACTIVE'
ORDER BY last_call_et desc;


ANALYZE INDEX I_DEPENDENCY1 VALIDATE STRUCTURE;
ANALYZE INDEX I_DEPENDENCY2 VALIDATE STRUCTURE;


alter INDEX I_DEPENDENCY1 rebuild;
alter INDEX I_DEPENDENCY2 rebuild;


DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY2";

  CREATE UNIQUE INDEX "SYS"."I_DEPENDENCY1" ON "SYS"."DEPENDENCY$" ("D_OBJ#", "D_TIMESTAMP", "ORDER#")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;



  CREATE INDEX "SYS"."I_DEPENDENCY2" ON "SYS"."DEPENDENCY$" ("P_OBJ#", "P_TIMESTAMP")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;






SQL> DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY1"
                 *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdlGetCkyName1], [106], [], [],
[], [], [], [], [], [], [], []



SQL>
SQL> analyze table DEPENDENCY$ validate structure cascade;
analyze table DEPENDENCY$ validate structure cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL>



No comments:

Post a Comment

Followers