{"id":193,"date":"2016-03-29T17:34:56","date_gmt":"2016-03-29T15:34:56","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=193"},"modified":"2016-03-29T17:35:16","modified_gmt":"2016-03-29T15:35:16","slug":"goldengate-12-2-error-ogg-00041-data-source-not-specified","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2016\/03\/29\/goldengate-12-2-error-ogg-00041-data-source-not-specified\/","title":{"rendered":"Goldengate 12.2 &#8211; ERROR OGG-00041 Data source not specified."},"content":{"rendered":"<p>While testing the new Goldengate 12.2 with a training material I&#8217;ve been doing, I got the error:<\/p>\n<pre>2016-03-29 15:36:00 ERROR OGG-00041 Data source not specified. \r\n2016-03-29 15:36:00 ERROR OGG-01668 PROCESS ABENDING.<\/pre>\n<p>This when configuring the most simple integrated extract.<\/p>\n<p>Looking at the ggserr.log did not gave any other idea.<\/p>\n<p>After opening a SR with Oracle, I decided to try the same configuration on Goldengate 12.1. And to my surprise the error was &#8220;clearer&#8221;:<\/p>\n<pre>2016-03-29 16:15:51 ERROR OGG-00303 Unrecognized parameter (EXTRACT\u00a0e_hr).<\/pre>\n<p>Immediatly it come to my mind that the problem was related to my copy\/paste from powerpoint (training material I&#8217;m doing) to the putty window. Doing &#8216;:set list&#8217; in vi did not show any strange character, but after recreating the extract parameter file from scratch with exactly the same parameters, it worked like a charm.<\/p>\n<p>Go back test on Goldengate 12.2 and no error either.<\/p>\n<p>So, if you have OGG-00041\u00a0error, it can be just that Goldengate is not interpreting well the parameter file.<\/p>\n<p>Meanwhile, another problem on Goldengate 12.2 is that it crashes when you delete an extract while connected to a database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While testing the new Goldengate 12.2 with a training material I&#8217;ve been doing, I got the error: 2016-03-29 15:36:00 ERROR OGG-00041 Data source not specified. 2016-03-29 15:36:00 ERROR OGG-01668 PROCESS ABENDING. This when configuring the most simple integrated extract. Looking at the ggserr.log did not gave any other idea. After opening a SR with Oracle, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5,7],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","category-bug","category-goldengate","category-oracle-12c","czr-hentry"],"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":194,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/193\/revisions\/194"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}