Drop User Gets Error ORA-00604/ORA-942
(Doc ID 2192171.1)
Last updated on JULY 21, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
+ This is Oracle Database 12.1.0.2.
+ Dropping a user fails with ORA-604 and ORA-942 errors.
+ An event trace on the ORA-942 reveals the problem with a missing javajar$ table
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=ct0qvwfca6gz7) -----
select name from javajar$ where owner#=:1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
...
qcsprfro()+867 CALL??? ksfpec() 01367A2C0 0135A22E8
1D21B33DD3808CB 7FEF7E0E7F5
qcsprfro_tree()+344 CALL??? qcsprfro() 000000000 000000000 000DA4D80
027145B90
qcsprfro_tree()+113 CALL??? qcsprfro_tree() 000000005 000000005 0000007FD
000000A50
qcspafq()+286 CALL??? qcsprfro_tree() 027CDA340 027CDA340 000036CA8
000000000
qcspqbDescendents() CALL??? qcspafq() 027145FB0 027CDA900 0204708C8
+251 0204708C8
qcspqb()+223 CALL??? qcspqbDescendents() 020472B70 020472B40 027145FB0
143948997
kkmdrv()+94 CALL??? qcspqb() 020422838 000000000 027CDA300
000036C98
opiSem()+2532 CALL??? kkmdrv() 000000000 0135A2350 027146920
0135A3810
Changes
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 |