Saturday, February 7, 2015

Segmentation fault - During IMP from 11g Database - EXP & IMP Utility Version 9iR2

Scenerio 
Oracle IMP gives 'Segmentation fault' error . EXP  was taken from 11g R2 database using 9iR2 export utility. Import utility is also of 9iR2 version.
---------------------------------------------------------------------------------------------------------------
Import: Release 9.2.0.6.0 - Production on Sun Feb 8 10:23:48 2015

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Username: system/system

Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by ME, not by you

import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setSegmentation fault
--------------------------------------------------------------------------------------------------------------- 
Workaround 
1. Connect to database 11g as SYSDBA with SQL*Plus
2. Change the definition of view EXU9DEFPSWITCHES from:

CREATE OR REPLACE VIEW SYS.EXU9DEFPSWITCHES
(COMPFLGS, NLSLENSEM)
AS
SELECT  a.value, b.value
        FROM    sys.v$parameter a, sys.v$parameter b
        WHERE   a.name = 'plsql_compiler_flags' AND
                b.name = 'nls_length_semantics'

to:
CREATE OR REPLACE VIEW SYS.EXU9DEFPSWITCHES
(COMPFLGS, NLSLENSEM)
AS
SELECT  a.value, b.value
        FROM    sys.v$parameter a, sys.v$parameter b
        WHERE   a.name = 'plsql_code_type' AND
                b.name = 'nls_length_semantics'


3. Now take the export using exp utility 9iR2 version
4. Import using imp utility 9iR2 version

---------------------------------------------------------------------------------------------------------------
Oracle Doc ID : 550740.1

Sunday, January 25, 2015

ORA-00600: internal error code, arguments: [13013], [5001], [517]


Scenerio 

ORACLE RDBMS Version: 10.2.0.3.0 - x86_64 GNU/Linux

Throws error message :  ORA-00600: internal error code, arguments: [13013], [5001], [517], [4260059], [139], [4260059], [3], []  in the alert log and sometimes, the database stops working ...

Workaround 

SQL> Select object_name,object_type,owner from dba_objects where data_object_id=517;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         OWNER
------------------- ------------------------------
COL_USAGE$
TABLE               SYS

SQL> analyze table SYS.COL_USAGE$ validate structure online;

Table analyzed.

SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;
analyze table SYS.COL_USAGE$ validate structure cascade online
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],[]

SQL> select index_name from dba_indexes where table_name='COL_USAGE$';

INDEX_NAME
------------------------------
I_COL_USAGE$

SQL> Set long 1000000
SQL> Select dbms_metadata.get_ddl('INDEX','I_COL_USAGE$','SYS') from dual;

DBMS_METADATA.GET_DDL('INDEX',
--------------------------------------------------------------------------------

 CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "SYSTEM"

SQL> drop index "SYS"."I_COL_USAGE$";

Index dropped.

SQL> CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM";

Index created.

SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;




Table analyzed. ---------------------------------------------------------------------------------------------------------------
Oracle Doc ID : 816784.1