{"id":5439,"date":"2015-11-06T06:34:43","date_gmt":"2015-11-06T05:34:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/"},"modified":"2015-11-06T06:34:43","modified_gmt":"2015-11-06T05:34:43","slug":"goldengate-error-during-a-register-extract","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/","title":{"rendered":"GoldenGate &#8211; Error during a register extract"},"content":{"rendered":"<p>This week, I tried to install a GoldenGate environment to make some test.<\/p>\n<p>The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly.<\/p>\n<p>In a second time, I wanted try to use the integrated capture mode. When arrived the time to register my extract in the database, I have received an error.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">GGSCI (goldengate as ggadmin@DB1) 2&gt; register extract test database\nERROR: Cannot register or unregister EXTRACT TEST because of the following SQL error: OCI Error 44,004\n\n<\/pre>\n<h2>Analysis<\/h2>\n<p>After some tests alone without any result, I opened a SR at Oracle. After some new tests, we finaly found a solution at this problem.<\/p>\n<p>The first test that you have to do is to control the global name of database.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; SELECT * FROM global_name;\n\nGLOBAL_NAME\n------------------------------\nDB1.IT.DBI-SERVICES.COM<\/pre>\n<p>The second test is to control the domain name.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; show parameter db_domain\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_domain                            string      it.dbi-services.com<\/pre>\n<p>The problem comes from the character &#8220;-&#8221; in the domain name. GoldenGate doesn&#8217;t support this character.<\/p>\n<p>You must change your domain name to use the integrated capture mode.<\/p>\n<h2>Solution<\/h2>\n<p>Like I said before, the solution is to change the domain name and global name. Indeed the global name doesn&#8217;t change automaticaly with the domain name.<\/p>\n<p>The command to change the domain name is :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; alter system set db_domain='it.dbi.services.com' scope=spfile;\n\nSystem altered.<\/pre>\n<p>And for the global name :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; ALTER DATABASE RENAME GLOBAL_NAME TO DB1.IT.DBI.SERVICES.COM;\n\nDatabase altered.<\/pre>\n<p>Now the database must be restarted to apply the changes.<\/p>\n<p>After that it is possible to register an extract.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">GGSCI (srvoracle) 1&gt; dblogin useridalias ggadmin\nSuccessfully logged into database.\n\nGGSCI (srvoracle as ggadmin@DB1) 2&gt; register extract test database\nExtract TEST successfully registered with database at SCN 773304.<\/pre>\n<p>It works.<\/p>\n<h2>GoldenGate integrated capture mode vs Streams<\/h2>\n<p>If we check in the log, we can find the following lines :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">*** 2015-11-02 13:02:56.873\ndumped dictionary @ first_scn:919339\ndbms_streams_adm_ivk.set_up_queue()+\ndbms_streams_adm_utl.check_queue_table()+\ndbms_streams_adm_utl.check_queue_exists()+{\nqueue_name=OGG$Q_TEST\nreturning TRUE\nfinished dbms_streams_adm_utl.check_queue_exists() }\ndbms_streams_adm_utl.check_queue_enabled()+\n\n*** 2015-11-02 13:02:56.998\ndbms_logrep_util.update_dbname_mapping:Enter<\/pre>\n<p>We can notice that these lines correspond to the streams product. Oracle said that it is not more support and it is replaced by GoldenGate. And finally we see that it is the same product but becomes paying.<\/p>\n<p>Another clue, the first thing to do to configure GoldenGate integrated capture mode is to define a size for the streams_pool.<\/p>\n<h2><\/h2>\n<h2>Conclusion<\/h2>\n<p>In conclusion, it is important to remember that when you install an environment for GoldenGate with integrated capture mode, it is necessary to banish the character &#8220;-&#8220;.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the integrated capture mode. When arrived the time to register my extract in the database, I [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":5440,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-5439","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>GoldenGate - Error during a register extract - dbi Blog<\/title>\n<meta name=\"description\" content=\"GoldenGate, Register extract, OCI Error 44,004, Integrated capture\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GoldenGate - Error during a register extract\" \/>\n<meta property=\"og:description\" content=\"GoldenGate, Register extract, OCI Error 44,004, Integrated capture\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-06T05:34:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1754\" \/>\n\t<meta property=\"og:image:height\" content=\"209\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"GoldenGate &#8211; Error during a register extract\",\"datePublished\":\"2015-11-06T05:34:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\"},\"wordCount\":316,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png\",\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\",\"name\":\"GoldenGate - Error during a register extract - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png\",\"datePublished\":\"2015-11-06T05:34:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"GoldenGate, Register extract, OCI Error 44,004, Integrated capture\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png\",\"width\":1754,\"height\":209},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GoldenGate &#8211; Error during a register extract\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"GoldenGate - Error during a register extract - dbi Blog","description":"GoldenGate, Register extract, OCI Error 44,004, Integrated capture","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/","og_locale":"en_US","og_type":"article","og_title":"GoldenGate - Error during a register extract","og_description":"GoldenGate, Register extract, OCI Error 44,004, Integrated capture","og_url":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/","og_site_name":"dbi Blog","article_published_time":"2015-11-06T05:34:43+00:00","og_image":[{"width":1754,"height":209,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"GoldenGate &#8211; Error during a register extract","datePublished":"2015-11-06T05:34:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/"},"wordCount":316,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png","articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/","url":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/","name":"GoldenGate - Error during a register extract - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png","datePublished":"2015-11-06T05:34:43+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"GoldenGate, Register extract, OCI Error 44,004, Integrated capture","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Screenshot1_site_putty.png","width":1754,"height":209},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-error-during-a-register-extract\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"GoldenGate &#8211; Error during a register extract"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5439"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5439\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5440"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5439"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}