Oracle internals, debugging and undocumented features

Disabling Oracle Streams Propagation when nothing else works

It’s been a while since I  wrote any post .. I need vacation too 🙂

Here is very short one but useful tip for folks that are using Oracle Streams.

I know everyone is talking about GoldenGate but trust  me Oracle Streams are good solution if  you do not have budget for GoldenGate.Oracle is working very hard to implement best of Streams into GG.

Anyway this tip shows how to disable Oracle Streams propagation when nothing else is working.At least in my case..

I was trying to stop Oracle Streams propagation process but for some reason nothing did not work..  Finally I realized that Oracle Streams propagation process is related to Oracle jobs and by  quickly disabling (  remember there are other jobs that runs ) oracle scheduler I was able to stop Streams propagation process .

First disable scheduler:

SQL> exec dbms_scheduler.set_scheduler_attribute(‘SCHEDULER_DISABLED’,’TRUE’);
PL/SQL procedure successfully completed.

Stop propagation:

SQL> exec dbms_propagation_adm.stop_propagation(‘TEST_PROPAGATION’, true);

PL/SQL procedure successfully completed.

and enabling scheduler again.

SQL>  exec dbms_scheduler.set_scheduler_attribute(‘SCHEDULER_DISABLED’,’FALSE’);

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: