{"id":43402,"date":"2026-03-19T07:51:00","date_gmt":"2026-03-19T06:51:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=43402"},"modified":"2026-03-19T09:55:04","modified_gmt":"2026-03-19T08:55:04","slug":"credential-errors-ogg-15409-with-goldengate-migration-utility","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/","title":{"rendered":"Credential Errors (OGG-15409) with GoldenGate Migration Utility"},"content":{"rendered":"\n<p>The <a href=\"https:\/\/docs.oracle.com\/en\/database\/goldengate\/core\/26\/coredoc\/migration-utility-migrate-classic-ma.html\" target=\"_blank\" rel=\"noreferrer noopener\">GoldenGate migration utility<\/a> provided by Oracle allows you to quickly upgrade your classic architecture into GoldenGate 26ai with Microservices Architecture. But even after some updates, it still has a few bugs, as I explained in a previous blog post.<\/p>\n\n\n\n<p>One of them can lead to an <code>OGG-15409<\/code> error during the migration. This error will not appear when running the migration tool in <code>dryrun<\/code> mode. You might then be faced with this issue only when doing the real migration. Here is the exact error:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ERROR: Unable to patch EXTRACT EXT, response is HTTP Status-Code 400: Bad Request..\n&#091;ERROR] OGG-15409 - Alias &amp;#x27;ggadmin_alias&amp;#x27; not found in credential store domain &amp;#x27;OracleGoldenGate&amp;#x27;.\nExtract EXT Process Definitions patched.<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-where-does-the-error-come-from\">Where does the error come from ?<\/h2>\n\n\n\n<p>The first step is to understand what is causing the issue. For this, you need to understand how the GoldenGate migration utility works.<\/p>\n\n\n\n<p>When migrating extracts (or replicats), GoldenGate will make API calls to the new Microservices Architecture administration service to register the extract (or replicat). Once created, it will alter it with a <code>PATCH<\/code> request to update the credentials used.<\/p>\n\n\n\n<p>We can see it in the <code>restapi.log<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\"context\":{\"verb\":\"PATCH\",\"uri\":\"\/services\/v2\/extract\/EXT\",...},\"content\":{\"credentials\":{\"alias\":\"ggadmin_alias\",\"domain\":\"OracleGoldenGate\"}},...}<\/code><\/pre>\n\n\n\n<p id=\"h-unfortunately-once-the-migration-is-done-you-cannot-re-run-the-migration-you-will-need-to-fix-this-manually\">Unfortunately, once the migration is done, you cannot re-run the migration. You will need to fix this manually.<\/p>\n\n\n\n<p>But since this is the only post-migration task made on extracts and replicats, it is rather easy to do. You can just create the aliases first, and call the REST API to alter all extracts and replicats. In Python, using the client I presented in a previous <a href=\"https:\/\/www.dbi-services.com\/blog\/production-ready-goldengate-rest-client-in-python\/\" target=\"_blank\" rel=\"noreferrer noopener\">blog post<\/a>, it would look like the following. First, create the client connection.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from oggrestapi import OGGRestAPI\nogg_client = OGGRestAPI(url='https:\/\/vmogg:7810', username='ogg', password='***')<\/code><\/pre>\n\n\n\n<p>Then, check the content of the extract (or replicat) using the <code>retrieve_extract<\/code> (or <code>retrieve_replicat<\/code>) method. For the moment, we don&#8217;t see any <code>credentials<\/code> key.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># This retrieves all the configuration of an extract, except for the configuration file\n&gt;&gt;&gt; {k:v for k,v in ogg_client.retrieve_extract('EXT').items() if k != 'config'}\n{'$schema': 'ogg:extract', 'targets': &#091;{'name': 'aa', 'path': 'source', 'sizeMB': 500, ...}], 'description': 'dbi blog migration', 'source': 'tranlogs', 'type': 'Integrated'}<\/code><\/pre>\n\n\n\n<p>Then, create the alias(es) with the <code>create_alias<\/code> method.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ogg_client.create_alias(\n    alias='ggadmin_alias',\n    domain='OracleGoldenGate',\n    data={\n        \"userid\":\"ggadmin@vmora:1521\/DB\",\n        \"password\": \"***\"\n    }\n)<\/code><\/pre>\n\n\n\n<p>And finally, alter the extracts with the <code>update_extract<\/code> method.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ogg_client.update_extract(\n    extract='EXT',\n    data={\n        \"alias\": \"ggadmin_alias\",\n        \"domain\": \"OracleGoldenGate\"\n    }\n)<\/code><\/pre>\n\n\n\n<p>If you had the issue with a replicat, the syntax is exactly the same, with the <code>update_replicat<\/code> method.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ogg_client.update_replicat(\n    replicat='REP',\n    data={\n        \"alias\": \"ggadmin_alias\",\n        \"domain\": \"OracleGoldenGate\"\n    }\n)<\/code><\/pre>\n\n\n\n<p>You can check that the credentials are there by reusing the <code>retrieve_extract<\/code> (or <code>retrieve_replicat<\/code>) method. This time, we see the <code>credentials<\/code> key !<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt;&gt;&gt; {k:v for k,v in ogg_client.retrieve_extract('EXT').items() if k != 'config'}\n{'$schema': 'ogg:extract', 'credentials': {'alias': 'ggadmin_alias', 'domain': 'OracleGoldenGate'}, 'targets': &#091;{'name': 'aa', 'path': 'source', 'sizeMB': 500, ...}], 'description': 'dbi blog migration', 'source': 'tranlogs', 'type': 'Integrated', ...}<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-to-avoid-this-error\">How to avoid this error ?<\/h2>\n\n\n\n<p>For some reason, the credentials of the source setup will not always be migrated. If you don&#8217;t have too many aliases, I would suggest <strong>creating the aliases in the target environment<\/strong>. This way, you know they are <strong>working even before attempting the migration<\/strong>. This should definitely be part of your new deployment tests.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The GoldenGate migration utility provided by Oracle allows you to quickly upgrade your classic architecture into GoldenGate 26ai with Microservices Architecture. But even after some updates, it still has a few bugs, as I explained in a previous blog post. One of them can lead to an OGG-15409 error during the migration. This error will [&hellip;]<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3787,59],"tags":[3833,2500,1545,328,2562,3730,3916,2601,1812],"type_dbi":[3834,3848,2954,3740,3786,3881,3917,3308,3918],"class_list":["post-43402","post","type-post","status-publish","format-standard","hentry","category-goldengate","category-oracle","tag-alias","tag-credential","tag-error","tag-goldengate","tag-migration-2","tag-ogg","tag-ogg-15409","tag-upgrade-2","tag-utility","type-alias","type-credential","type-error","type-goldengate","type-migration","type-ogg","type-ogg-15409","type-upgrade","type-utility"],"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>Credential Errors (OGG-15409) with GoldenGate Migration Utility - dbi Blog<\/title>\n<meta name=\"description\" content=\"OGG-15409 error when migration to GoldenGate 26ai is solvable by updating the extracts\/replicats with new credentials\" \/>\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\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Credential Errors (OGG-15409) with GoldenGate Migration Utility\" \/>\n<meta property=\"og:description\" content=\"OGG-15409 error when migration to GoldenGate 26ai is solvable by updating the extracts\/replicats with new credentials\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-19T06:51:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-19T08:55:04+00:00\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\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\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"Credential Errors (OGG-15409) with GoldenGate Migration Utility\",\"datePublished\":\"2026-03-19T06:51:00+00:00\",\"dateModified\":\"2026-03-19T08:55:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\"},\"wordCount\":372,\"commentCount\":0,\"keywords\":[\"alias\",\"credential\",\"Error\",\"GoldenGate\",\"migration\",\"ogg\",\"ogg-15409\",\"upgrade\",\"utility\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\",\"name\":\"Credential Errors (OGG-15409) with GoldenGate Migration Utility - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2026-03-19T06:51:00+00:00\",\"dateModified\":\"2026-03-19T08:55:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"OGG-15409 error when migration to GoldenGate 26ai is solvable by updating the extracts\/replicats with new credentials\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Credential Errors (OGG-15409) with GoldenGate Migration Utility\"}]},{\"@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\/764ab019cc9dec42655b4c6b9b8e474e\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g\",\"caption\":\"Julien Delattre\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/juliendelattre\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Credential Errors (OGG-15409) with GoldenGate Migration Utility - dbi Blog","description":"OGG-15409 error when migration to GoldenGate 26ai is solvable by updating the extracts\/replicats with new credentials","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\/credential-errors-ogg-15409-with-goldengate-migration-utility\/","og_locale":"en_US","og_type":"article","og_title":"Credential Errors (OGG-15409) with GoldenGate Migration Utility","og_description":"OGG-15409 error when migration to GoldenGate 26ai is solvable by updating the extracts\/replicats with new credentials","og_url":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/","og_site_name":"dbi Blog","article_published_time":"2026-03-19T06:51:00+00:00","article_modified_time":"2026-03-19T08:55:04+00:00","author":"Julien Delattre","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"Credential Errors (OGG-15409) with GoldenGate Migration Utility","datePublished":"2026-03-19T06:51:00+00:00","dateModified":"2026-03-19T08:55:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/"},"wordCount":372,"commentCount":0,"keywords":["alias","credential","Error","GoldenGate","migration","ogg","ogg-15409","upgrade","utility"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/","url":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/","name":"Credential Errors (OGG-15409) with GoldenGate Migration Utility - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-03-19T06:51:00+00:00","dateModified":"2026-03-19T08:55:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"OGG-15409 error when migration to GoldenGate 26ai is solvable by updating the extracts\/replicats with new credentials","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/credential-errors-ogg-15409-with-goldengate-migration-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Credential Errors (OGG-15409) with GoldenGate Migration Utility"}]},{"@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\/764ab019cc9dec42655b4c6b9b8e474e","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a97d00e680bbf237126e24b65281cbcb66cd20bd1ed2d14bf928991b2bf68eb5?s=96&d=mm&r=g","caption":"Julien Delattre"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/juliendelattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43402","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\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=43402"}],"version-history":[{"count":9,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43402\/revisions"}],"predecessor-version":[{"id":43520,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43402\/revisions\/43520"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=43402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=43402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=43402"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=43402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}