Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp is failing with UDE-22303, OCI-22303 type "SYS"."KU$_STATUS1020" not found

veritasAug 31 2016 — edited Sep 4 2016

Hi,

After an RAC upgrade from 11.0.2.3 to 11.2.0.4  (Sles 11) expd is failing with :

UDE-22303: operation generated ORACLE error 22303

OCI-22303: type "SYS"."KU$_STATUS1020" not found

It's just a plain export, nothing fancy.  In the alert.log, I can see :

" ...  Instance number :1 31-AUG-16 11.14.23.501 AM +03:00 => Errors in file ... /trace/PRD001_ora_2168.trc  (incident=214558):

ORA-07445: exception encountered: core dump [koln2i()+43] [SIGSEGV] [ADDR:0xBBD97] [PC:0x2EA377D] [Address not mapped to object] [] "

I've read a few notes (I understand that there is even a bug 6824129 that it's supposed to be fixed in 11.1.0.7) and so far I can say what it's not about  :

   - DataPump directory contains an environment variable;

   - incorrect memory settings (aq_tm_processes is set on 1 and streams_pool_size is 512M);

   - OS directory rights (it's 777);

   - ORA_NLS10 variable (it's not set);

   - invalid objects in sys or schema objects;

The only option I have is to try to recreate the DataPump utility. Problem is that starting from 11.2 that means to  run the catproc.sql in upgrade mode ... and a maintanance window on a 7x7 PROD system it's hard to get !  So, if you have any ideea, I'm all ears !

Regards,

Gabi

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2016
Added on Aug 31 2016
11 comments
11,377 views