- For individual users
- Instant access to solutions
- Ask your tech questions
- Start your 30-day Free Trial
Main Topics
Browse All TopicsIn oracle enterprise manager under the alert section I have a critical error name of "Generic Internal Error with a message: "Internal error (ORA-600[qcscbpcbua]) detected in D:\app\administrator\diag\
The error found in the alert_orcl.log is:
Errors in file d:\app\administrator\diag\
ORA-00600: internal error code, arguments: [qcscbpcbua], [], [], [], [], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\
Thu Sep 22 11:28:45 2011
Trace dumping is performing id=[cdmp_20110922112845]
Thu Sep 22 11:28:47 2011
Sweep [inc][8457]: completed
Sweep [inc2][8457]: completed
below is contents of the trace file:
Trace file d:\app\administrator\diag\
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8357M/16371M, Ph+PgF:24997M/32740M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 39
Windows thread id: 6176, image: ORACLE.EXE (SHAD)
*** 2011-08-29 09:38:10.211
*** CLIENT ID:() 2011-08-29 09:38:10.212
*** SERVICE NAME:() 2011-08-29 09:38:10.212
*** MODULE NAME:() 2011-08-29 09:38:10.212
*** ACTION NAME:() 2011-08-29 09:38:10.212
Breaking the connection before proto/dty negotiation, error raised 3113
Trace file d:\app\administrator\diag\
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8773M/16371M, Ph+PgF:25182M/32740M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 57
Windows thread id: 6176, image: ORACLE.EXE (SHAD)
*** 2011-09-22 11:28:41.552
*** SESSION ID:(193.17032) 2011-09-22 11:28:41.552
*** CLIENT ID:() 2011-09-22 11:28:41.552
*** SERVICE NAME:(orcl) 2011-09-22 11:28:41.552
*** MODULE NAME:(devenv.exe) 2011-09-22 11:28:41.552
*** ACTION NAME:() 2011-09-22 11:28:41.552
Incident 8457 created, dump file: d:\app\administrator\diag\
ORA-00600: internal error code, arguments: [qcscbpcbua], [], [], [], [], [], [], [], [], [], [], []
***Below are the contents of orcl_ora_6176_i8457.trc:
Dump file d:\app\administrator\diag\
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8773M/16371M, Ph+PgF:25182M/32740M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 57
Windows thread id: 6176, image: ORACLE.EXE (SHAD)
*** 2011-09-22 11:28:41.553
*** SESSION ID:(193.17032) 2011-09-22 11:28:41.553
*** CLIENT ID:() 2011-09-22 11:28:41.553
*** SERVICE NAME:(orcl) 2011-09-22 11:28:41.553
*** MODULE NAME:(devenv.exe) 2011-09-22 11:28:41.553
*** ACTION NAME:() 2011-09-22 11:28:41.553
Dump continued from file: d:\app\administrator\diag\
ORA-00600: internal error code, arguments: [qcscbpcbua], [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 8457 (ORA 600 [qcscbpcbua]) ========
*** 2011-09-22 11:28:41.593
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=4uzg5zmsprw7d) -----
select BOOK.*, ID,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as QCS,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as FILMS,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as SEQS,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as TYPES
from (
select BOOK.*, NOQC.BOOK_NO_ID as ID, NOQC.QC_NUMBER_ID as QC, NOQC.FILM as FILM, NOQC.QC_SEQ as SEQ, QC_TYPE as TYPE, row_number() over(partition by NOQC.BOOK_NO_ID order by QC_SEQ) as rn
from BAY_BOOKNO_QC NOQC
JOIN BAY_CUSTOMER_BOOK BOOK
ON NOQC.BOOK_NO_ID = BOOK.BOOK_NO_ID
WHERE BOOK.BOOK_NO_ID =1)
start with rn = 1
connect by prior id = id
and prior rn = rn - 1
group by id
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- --------------------------
ksedst1()+129 CALL??? skdstdst() 009173DA2 000000000 000000000
000000000
ksedst()+69 CALL??? ksedst1() 000000002 000000000 006F605E0
000000000
dbkedDefDump()+4536 CALL??? ksedst() 000000287 000000000 000000000
000000000
ksedmp()+43 CALL??? dbkedDefDump() 000000003 000000002 000000000
***continues on for many pages
I'm pretty sure that the Sql statement below (as mentioned above) caused the problem since it fired an error when it was run from the application. My concern is did this do any damage to the database? Should there be any corrective action taken or? The database seems to be running fine at this time. Any help would be greatly appreciated.
select BOOK.*, ID,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as QCS,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as FILMS,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as SEQS,
max(ltrim(sys_connect_by_p
(dense_rank last order by level) as TYPES
from (
select BOOK.*, NOQC.BOOK_NO_ID as ID, NOQC.QC_NUMBER_ID as QC, NOQC.FILM as FILM, NOQC.QC_SEQ as SEQ, QC_TYPE as TYPE, row_number() over(partition by NOQC.BOOK_NO_ID order by QC_SEQ) as rn
from BAY_BOOKNO_QC NOQC
JOIN BAY_CUSTOMER_BOOK BOOK
ON NOQC.BOOK_NO_ID = BOOK.BOOK_NO_ID
WHERE BOOK.BOOK_NO_ID =1)
start with rn = 1
connect by prior id = id
and prior rn = rn - 1
group by id
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership