-
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!
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|