Impdp Fails in RAC With Alert Log Showing ORA-600 [1:kwqvss], [33], [SYS.KUPC$C_1_20171029051115]
(Doc ID 2327634.1)
Last updated on FEBRUARY 19, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Impdp will fail in a RAC environment with following error message generated into the database alert log:
Thu Nov 02 16:45:31 2017
Errors in file /u01/app/oracle/diag/rdbms/xxxxarc/xxxxarc1/trace/xxxxarc1_ora_234453.trc (incident=362858) (PDBNAME=XXXXDEV):
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171102164528], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/d001arc/d001arc1/incident/incdir_362858/d001arc1_ora_234453_i362858.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Nov 02 16:45:35 2017
Warning: encountered error 600 starting queue service.
kwqbcpccb: queue table object number SYS.KUPC$C_1_20171102164528 pdb 3
Errors in file /u01/app/oracle/diag/rdbms/xxxxarc/xxxxarc1/trace/xxxxarc1_ora_234453.trc (incident=362859) (PDBNAME=XXXXDEV):
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171102164528], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171102164528], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/oracle/diag/rdbms/xxxxarc/xxxxarc1/trace/xxxxarc1_ora_234453.trc (incident=362858) (PDBNAME=XXXXDEV):
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171102164528], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/d001arc/d001arc1/incident/incdir_362858/d001arc1_ora_234453_i362858.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Nov 02 16:45:35 2017
Warning: encountered error 600 starting queue service.
kwqbcpccb: queue table object number SYS.KUPC$C_1_20171102164528 pdb 3
Errors in file /u01/app/oracle/diag/rdbms/xxxxarc/xxxxarc1/trace/xxxxarc1_ora_234453.trc (incident=362859) (PDBNAME=XXXXDEV):
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171102164528], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171102164528], [], [], [], [], [], [], [], [], []
The database trace file (.trc) will show this message:
kswsiss_int: max rlb services check failed, rc=0
Incident 362826 created, dump file: /u01/app/oracle/diag/rdbms/d001arc/d001arc1/incident/incdir_362826/d001arc1_ora_286194_i362826.trc
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171030150925], [], [], [], [], [], [], [], [], []
Incident 362826 created, dump file: /u01/app/oracle/diag/rdbms/d001arc/d001arc1/incident/incdir_362826/d001arc1_ora_286194_i362826.trc
ORA-00600: internal error code, arguments: [1:kwqvss], [33], [SYS.KUPC$C_1_20171030150925], [], [], [], [], [], [], [], [], []
And following call stack:
----- Current SQL Statement for this session (sql_id=3huk444dnag6r) -----
BEGIN sys.kupc$que_int.create_queues(:1, :2, :3, :4, :5); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xb38aa210 814 package body SYS.DBMS_AQADM_SYSCALLS
0xe2af6f00 6132 package body SYS.DBMS_AQADM_SYS
0xe2af6f00 5980 package body SYS.DBMS_AQADM_SYS
0x6e602a40 1482 package body SYS.KUPC$QUE_INT
0xdb731cf0 1 anonymous block
0xfe80f4f8 158 package body SYS.KUPC$QUEUE_INT
0x1106ca220 745 package body SYS.KUPV$FT_INT
0x8bae8f88 1515 package body SYS.KUPV$FT
0x8bae8f88 988 package body SYS.KUPV$FT
0x7ef72bc0 5869 package body SYS.DBMS_DATAPUMP
0xe6fdb060 1 anonymous block
BEGIN sys.kupc$que_int.create_queues(:1, :2, :3, :4, :5); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xb38aa210 814 package body SYS.DBMS_AQADM_SYSCALLS
0xe2af6f00 6132 package body SYS.DBMS_AQADM_SYS
0xe2af6f00 5980 package body SYS.DBMS_AQADM_SYS
0x6e602a40 1482 package body SYS.KUPC$QUE_INT
0xdb731cf0 1 anonymous block
0xfe80f4f8 158 package body SYS.KUPC$QUEUE_INT
0x1106ca220 745 package body SYS.KUPV$FT_INT
0x8bae8f88 1515 package body SYS.KUPV$FT
0x8bae8f88 988 package body SYS.KUPV$FT
0x7ef72bc0 5869 package body SYS.DBMS_DATAPUMP
0xe6fdb060 1 anonymous block
----- Abridged Call Stack Trace -----
ksedsts()+244<-kjzdssdmp()+321<-kjzduptcctx()+692<-kjzdpcrshnfy()+347<-kstdmp()+352<-dbkedDefDump()+8728<-ksedmp()+261<-ksupop()+6244<-k2send()+7214<-
xctCommitTxn()+764<-kwqaetx()+266<-spefcmpa()+1022<-spefmccallstd()+236<-pextproc()+90<-peftrusted()+151<-psdexsp()+296<-rpiswu2()+1918<-
kxe_push_env_internal_pp_()+395<-kkx_push_env_for_ICD_for_new_session()+160<-psdextp()+398
----- End of Abridged Call Stack Trace -----
ksedsts()+244<-kjzdssdmp()+321<-kjzduptcctx()+692<-kjzdpcrshnfy()+347<-kstdmp()+352<-dbkedDefDump()+8728<-ksedmp()+261<-ksupop()+6244<-k2send()+7214<-
xctCommitTxn()+764<-kwqaetx()+266<-spefcmpa()+1022<-spefmccallstd()+236<-pextproc()+90<-peftrusted()+151<-psdexsp()+296<-rpiswu2()+1918<-
kxe_push_env_internal_pp_()+395<-kkx_push_env_for_ICD_for_new_session()+160<-psdextp()+398
----- End of Abridged Call Stack Trace -----
Changes
Added new database services via "srvctl add service".
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |