| AQ Propagation not happening over remote DBLINK [message #131910] |
Wed, 10 August 2005 01:01  |
syedashfaq2
Messages: 12
Registered: July 2005
Location: India
|
Junior Member |
|
|
Hi Experts,
I have the AQ set up at my Source Database(9.2.0.3) and also at Target Database(8i).
I have the public db link created in Source Database with SID/GLOBAL_NAME of the target Database.
When i run the EQ scripts at source DB, the data is getting populated in respective Queue tables but it is not propagating to the respective Queue table at target DB and when i looked into the trace file, i came across the following errors,
Tue Aug 9 18:54:08 2005
Errors in file /var/oracle/admin/GMPR99B/bdump/gmpr99b_j000_20045.trc:
ORA-00600: internal error code, arguments: [kwqidrdq: loop], [0], [0], [0], [0], [], [], []
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5631
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 6056
ORA-06512: at "SYS.DBMS_AQADM", line 895
ORA-06512: at line 1
Please let me know the reason for this error and also about the possible solutions to resolve this.
Thanks in Advance,
Syed Ashfaq Ahmed
|
|
|
|
| Re: AQ Propagation not happening over remote DBLINK [message #156583 is a reply to message #131910] |
Thu, 26 January 2006 01:30  |
0ri0n2005
Messages: 4
Registered: November 2005
Location: Russia
|
Junior Member |
|
|
First of all, visit Metalink to see description of this error. May be you'll need some patches, or there will be the solution.
Second - I am not sure that AQ work properly between 9i and 8i databases. We tried to set up AQ replication beetween 8.1.7 and 10.1.0.4 databases and failed. Migrate your 8i base to 9i and then try this propagation. I think that everithing will be ok.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
