Symptons

1. Run impdp as the following

$ impdp system/oracle parfile=imp_vstb.par

Import: Release 11.1.0.7.0 – 64bit Production on Tuesday, 08 December, 2009 15:29:06

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Release 11.1.0.7.0 – 64bit Production
With the Real Application Clusters option

UDI-22303: operation generated ORACLE error 22303
OCI-22303: type “SYS”.”KU$_STATUS1020″ not found

Cause

caused by setting aq_tm_processes=0

Solution

Change aq_tmp_processes to 1

SQL> show parameter aq

NAME                                 TYPE        VALUE
———————————— ———– ——————————
aq_tm_processes                      integer     0
SQL> alter system set aq_tm_processes=1 scope=both;

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: