Issue:
we had recently upgraded the target database from 11202 to 11204 and after that replicate restarted and found replicate abended with below error.
2020-02-20 20:34:45 ERROR OGG-02091 Operation not supported because enable_goldengate_replication is not set to true.
2020-02-20 20:34:45 ERROR OGG-01668 PROCESS ABENDING.
Solution:
while checking with MOS find the below solution which is solved the problem.
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
SQL> alter system set enable_Goldengate_replication=TRUE scope=both;
System altered.
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
we had recently upgraded the target database from 11202 to 11204 and after that replicate restarted and found replicate abended with below error.
2020-02-20 20:34:45 ERROR OGG-02091 Operation not supported because enable_goldengate_replication is not set to true.
2020-02-20 20:34:45 ERROR OGG-01668 PROCESS ABENDING.
Solution:
while checking with MOS find the below solution which is solved the problem.
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
SQL> alter system set enable_Goldengate_replication=TRUE scope=both;
System altered.
SQL> show parameter ENABLE_GOLDENGATE_REPLICATION
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE
thank for this, More Info about Database
ReplyDeleteoutras operadoras? E os que prometem que enviam e nada chega. Para onde está indo as meus SMS? E para a Tim, Vivo? Alguma Idéia? Ou significa ter de desembolsar?. É só um desabafo, realmente está difícil achar bons sites para enviar SMS de graça.
ReplyDeleteWeb Design and Development
ReplyDeletedrive the content home a bit, besides that, this is informative blog. A wonderful read. Ill certainly revisit again.
I guess you have made many really interesting points. Not as well many ppl would actually think about it the direction you just did. I am really impressed RCG ONLINE STORE
I totally agree, but the points could easily be stated in a clearer fashion, thats all I was saying. No prob here bro, Im not that uptight about it.
ReplyDeletemuch about this subject. So much so that you made me want to learn more about it. Your blog is my stepping stone, my friend. Thanks for the heads up on this ALL ABOUT SEO
Not as well many ppl would actually think about it the direction you just did Automatic Screw Feeder Machine
ReplyDeleteUnlike other analytics services, Azure Synapse Analytics allows you to create custom applications to run your own custom logic, and export the results using a variety of different data formats. This means that you can create your Data Warehouse Service and own application using any language you want, and then run it on any platform you want, and you can use it for a wide variety of different purposes.
ReplyDelete