| Streams - ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance [message #680679] |
Sun, 31 May 2020 17:37  |
 |
siva_faq
Messages: 8
Registered: May 2020
|
Junior Member |
|
|
Hello Team,
In our envirnoment oracle streams for oneside replication only for just 2 schemas, it was working fine in 11GR2, after upgrading into oracle 12C with RAC one configuration, in order to avoid issue for
" ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance" error message which leads to abort propagation Hence as per oracle document advice recreated queues means (capture,propagation and queue tables) then mentioned issue gone, also these already proven into couple of critical envirnoment, which is working fine for few months as well.
now we are upgrading oracle 12C with RAC one for main production there even after recreation of queues above error encounted. still propagation / streams broken with mentioned message.
what could be the reason, and how do I trouble shoot and fix for the same.
FYI: all the above envirnoment after recreation of the queue we too got the following queue service published in the listener status as well, still facing the issue.
in production envirnoment.But in other critical envirnoment we do not had any issue after recreation of the queues.
Service "SYS$STRMADMIN.CCUSER_QUEUE.IGW11P.WORLD" has 1 instance(s).
Instance "IGW11P_1", status READY, has 1 handler(s) for this service...
Service "SYS$STRMADMIN.PC2USER_QUEUE.IGW11P.WORLD" has 1 instance(s).
Instance "IGW11P_1", status READY, has 1 handler(s) for this service...
Herewith enclosed respective tracefiles which is generated against for ORA-25333 in oracle alert log.
since it is production, expecting expert update ASAP.
Note :
Thanks in Advance,
Siva..
|
|
|
|
|
|
| Re: Streams - ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance [message #680689 is a reply to message #680683] |
Mon, 01 June 2020 08:56  |
|
siva_faq
Messages: 8
Registered: May 2020
|
Junior Member |
|
|
Hi John,
Thanks for your update.using one of the active service(exist in dba_Services), the same service name been used in propagation, db_link as well.Also scan listener been used
in the connection string of db_link.
14:18:01 01-JUN-20 at IGW11P> select sysdate from dual@IGW13P.WORLD;
SYSDATE
---------
01-JUN-20
could you guys support further, how to avoid "ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance".
FYI: Earliear 3 of our critical envirnomrnt above error been avoided by recreating queue, so that queues will be published in lsnrctl status as follows
Service "SYS$STRMADMIN.PC2USER_QUEUE.IGW13P.WORLD" has 1 instance(s).
Service "SYS$STRMADMIN.CCUSER_QUEUE.IGW11P.WORLD" has 1 instance(s).
Service "SYS$STRMADMIN.CCUSER_QUEUE.IGW13P.WORLD" has 1 instance(s).
Service "SYS$STRMADMIN.PC2USER_QUEUE.IGW11P.WORLD" has 1 instance(s).
all the steps carried out these prod as well, also we too above published queue services as well, but still we are having mention issue 0RA-25333.
Please review attached trace file which was generating for ora -25333 in DB alert log, also attached latest Health check report of our streams envirnoment for your review.
Note: In oracle support now every one is supporting Golden Gate etc.,could not found any expert who support streams yet. But we are going to live with streams may another a year or so.
Hope forum will support how where could we trouble shoot.
|
|
|
|
|
|
|
|
| Re: Streams - ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance [message #680705 is a reply to message #680691] |
Tue, 02 June 2020 04:34 |
|
siva_faq
Messages: 8
Registered: May 2020
|
Junior Member |
|
|
Hi John,
Thanks for your update.
Herewith enclosed output for SCAN_LISTENER1,2,3 and node listener status in listener_Status.txt for your review.
our source DB is IGW11P.world and target db is IGW13P.world , we have just schema to schema one way replication.
FYI. queue & propagation was restabilished as follows after RAC one configuration.
BEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE(
queue_name => 'CCUSER_QUEUE',
queue_table =>'CCUSER_QUEUE_TABLE',
queue_user => 'STRMADMIN');
end;
/
Pause ' Claim Queue Table Created '
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_PROPAGATION_RULES(
schema_name => 'CCUSER',
streams_name => 'PRP4CCUSER',
source_queue_name => 'STRMADMIN.CCUSER_QUEUE',
destination_queue_name => 'STRMADMIN.CCUSER_QUEUE@IGW13P.WORLD',
include_dml => true,
include_ddl => true,
source_database => 'IGW11P.WORLD',
inclusion_rule =>true,
queue_to_queue => true);
END;
/
FYI:error message seen in dba_queue_schedules tables and source DB alert log files.also observed that every 1 hours these error comes and broke propagation.
[Updated on: Tue, 02 June 2020 05:17] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Streams - ORA-25333: Buffered Queue to Queue propagation did not connect to the correct instance [message #680724 is a reply to message #680715] |
Wed, 03 June 2020 12:41 |
|
siva_faq
Messages: 8
Registered: May 2020
|
Junior Member |
|
|
Hello Team,
Hope you are requesting to do the following with bounce DB, already done it as follows and bounce the DB as well. still issue is not resolved.
begin
dbms_aqadm.alter_queue_table (
queue_table => 'STRMADMIN.CCUSER_QUEUE_TABLE',
primary_instance => 1,
secondary_instance => 2);
end;
/
begin
dbms_aqadm.alter_queue_table (
queue_table => 'STRMADMIN.PC2USER_QUEUE_TABLE',
primary_instance => 1,
secondary_instance => 2);
end;
/
could you update what shall we do to sort out these issue.
Thanks,
Siva..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
)