Tuesday, September 10, 2013

ORA-00600 when using EXPDP & IMPDP on a RAC Database.



When exporting a schema (with no data) using expdp, no issues were identified, but when using impdp with sqlfile, identified below ora 600 issue. Oracle called it out a bug and no patch yet. Hence, be little careful while using impdp on your prod systems. Btw, there was no impact to database because of the ora 600, but obviously the impdp failed. You can notice that when you start expdp or impdp, database does "alter system set services" introducing a sys related service "SYS$SYS.KUPC$Cxxxx.DBNAME"  as you can see in the below log file.

work around is to exec dbms_stats.gather_fixed_objects_stats();
but it doesn't help as the issue is reproducible.

used commands were:
expdp / directory = DATA_PUMP_DIR dumpfile="$i"_raj.dmp logfile="$i"_raj.log schemas="$i" content=metadata_only

impdp / irectory=DATA_PUMP_DIR dumpfile="$i"_raj.dmp sqlfile="$i"_raj.sql logfile="$i"_raj.log"

Error from Alert log file is:


streams_pool_size defaulting to 2867MB. Trying to get it from Buffer Cache for process 45416666.
2013-08-26 10:53:23.851000 -07:00
ALTER SYSTEM SET service_names='SRV_JOB','SRV_ORCL','ORCL','SYS$SYS.KUPC$C_4_20130826105315.ORCL' SCOPE=MEMORY SID='ORCL_4';
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_4_20130826105315.ORCL','SRV_JOB','SRV_ORCL','ORCL','SYS$SYS.KUPC$S_4_20130826105315.ORCL' SCOPE=MEMORY SID='ORCL_4';
2013-08-26 10:53:25.284000 -07:00
DM00 started with pid=969, OS id=16842836, job OPS$ORACLE.SYS_EXPORT_SCHEMA_01
2013-08-26 10:53:30.374000 -07:00
DW00 started with pid=890, OS id=13370008, wid=1, job OPS$ORACLE.SYS_EXPORT_SCHEMA_01


Dumping diagnostic data in directory=[cdmp_20130826110944], requested by (instance=4, osid=61210982 (DM00)), summary=[incident=1207772].
2013-08-26 11:09:46.331000 -07:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.


Errors in file /u01/home/oracle/diag/rdbms/orcl_live1/ORCL_4/trace/ORCL_4_dm00_61210982.trc  (incident=1207772):
ORA-00600: internal error code, arguments: [15851], [4], [4], [1], [3], [], [], [], [], [], [], []
Incident details in: /u01/home/oracle/diag/rdbms/orcl_live1/ORCL_4/incident/incdir_1207772/ORCL_4_dm00_61210982_i1207772.trc
2013-08-26 11:02:07.749000 -07:00
Non critical error ORA-48913 caught while writing to trace file "/u01/home/oracle/diag/rdbms/orcl_live1/ORCL_4/incident/incdir_1207772/ORCL_4_dm00_61210982_i1207772.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [5242880] reached
Writing to the above trace file is disabled for now on...

Dumping diagnostic data in directory=[cdmp_20130826110944], requested by (instance=4, osid=61210982 (DM00)), summary=[incident=1207772].
2013-08-26 11:09:46.331000 -07:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sweep [inc][1207772]: completed
Sweep [inc2][1207772]: completed
2013-08-26 11:09:48.495000 -07:00
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_4_20130826105656.ORCL','SRV_JOB','SRV_ORCL','ORCL' SCOPE=MEMORY SID='ORCL_4';
ALTER SYSTEM SET service_names='SRV_JOB','SRV_ORCL','ORCL' SCOPE=MEMORY SID='ORCL_4';
Errors in file /u01/home/oracle/diag/rdbms/orcl_live1/ORCL_4/trace/ORCL_4_dm00_61210982.trc  (incident=1207773):
ORA-00600: internal error code, arguments: [15851], [4], [4], [1], [3], [], [], [], [], [], [], []
ORA-06512: at "SYS.KUPM$MCP", line 1040
ORA-06512: at line 2
Incident details in: /u01/home/oracle/diag/rdbms/orcl_live1/ORCL_4/incident/incdir_1207773/ORCL_4_dm00_61210982_i1207773.trc
2013-08-26 11:09:52.970000 -07:00
Non critical error ORA-48913 caught while writing to trace file "/u01/home/oracle/diag/rdbms/orcl_live1/ORCL_4/incident/incdir_1207773/ORCL_4_dm00_61210982_i1207773.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [5242880] reached
Writing to the above trace file is disabled for now on...
2013-08-26 11:09:54.553000 -07:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
opidrv aborting process DM00 ospid (61210982) as a result of ORA-447
2013-08-26 11:10:10.618000 -07:00

No comments: