AQ Propergation fails after import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: AQ Propergation fails after import

  1. #1
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525

    AQ Propergation fails after import

    To all you AQ experts, this is driving me nuts.......

    ...The setup...

    We have three databases DB1 (8.1.7 solaris), DB2 (8.1.7 solaris) and DB3 (9.2.03 solaris).

    We have a user ENT on all databases.

    We have AQ setup DB2 --> DB3 across a link ENTMIS going from queue ENT.ENT_LOAD_QUEUE --> ENT.MIS_LOAD_QUEUE.

    ...What happened...

    I took an export of the ENT user from DB1, dropped the ENT user on DB3, recreate the user with the same privileges as before and imported the data from DB1.

    Now the queue propegation from DB2 --> DB3 fails with the following error (reported by DB2):

    "ORA-21700: object does not exist or is marked for delete
    ORA-02063: Message 2063 not found; No message file for product=RDBMS, facility=ORA; arguments: [] [line] [ENTMIS] []"

    All the queues exist as before and all the privileges are the same, Oracle are as useful as ever and it's driving me insane.

    Thanks in advance
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Check if after import the queue is enabled:
    ---- code starts here ----

    SELECT NAME, ENQUEUE_ENABLED, DEQUEUE_ENABLED
    FROM USER_QUEUES;

    ---- code ends here ----
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Yes, the queues are enabled.
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width