{"id":43393,"date":"2026-03-12T08:41:00","date_gmt":"2026-03-12T07:41:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=43393"},"modified":"2026-03-08T07:38:08","modified_gmt":"2026-03-08T06:38:08","slug":"userid-syntax-warning-in-goldengate-migration-utility","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/","title":{"rendered":"USERID Syntax Warning in GoldenGate Migration Utility"},"content":{"rendered":"\n<p>When running 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>, which I presented in an previous <a href=\"https:\/\/www.dbi-services.com\/blog\/upgrade-goldengate-from-classic-to-microservices-architecture-before-its-too-late\/\" target=\"_blank\" rel=\"noreferrer noopener\">blog post<\/a>, you might encounter the following warning on <code>USERID<\/code> syntax:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WARNING: USERID\/PASSWORD parameter is no longer supported and will be modified to use USERIDALIAS for the database credentials.<\/code><\/pre>\n\n\n\n<p>This is not really a surprise, since <code>USERID<\/code> is an old syntax that should not be used anymore. In fact, it is not even part of the latest versions of GoldenGate. Let&#8217;s see a very basic example of a replicat running in the GoldenGate 19c Classic Architecture.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GGSCI (ogg) 1&gt; view params rep\nREPLICAT rep\nUSERIDALIAS dbi_blog\nMAP PDB1.APP_PDB1.SOURCE, PDB2.APP_PDB2.TARGET,\nCOLMAP (\n\u00a0\u00a0\u00a0 COL_SOURCE_USER = COL_TARGET_USER,\n\u00a0\u00a0\u00a0 COL_SOURCE_USERID = COL_TARGET_USERID\n);<\/code><\/pre>\n\n\n\n<p>Nothing here should be a cause for concern, because the database connection is done with the <code>USERIDALIAS<\/code> syntax. Yet, when running the migration utility in <code>dryrun<\/code> mode, I get the following warning:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Migration of Extract E2T Completed Successfully.\n\nParameter file for REPLICAT REP has the following warnings:\n        WARNING: USERID\/PASSWORD parameter is no longer supported and will be modified to use USERIDALIAS for the database credentials.\n\nMigrating REPLICAT REP to http:\/\/oggma:port.\n\nParameter File rep.prm Saved Successfully.\n\nCheckpoint File(s) Copied and Converted Successfully.\n\nREPLICAT REP patched.\n\n...\n\nMigration Summary\n\n\u00a0\u00a0\u00a0 Migration of Replicat REP ..............................: Successful\n...<\/code><\/pre>\n\n\n\n<p>It is technically not an error, and the migration utility seems to have no problem migrating this replicat to the new Microservices Architecture. However, a question remains. Will <code>USERID<\/code> be replaced in the process ? Of course, we do not want all <code>USERID<\/code> occurrences to be replaced with <code>USERIDALIAS<\/code>, if these are not connection keywords.<\/p>\n\n\n\n<p>Let&#8217;s run the migration utility, for real this time, to see what happens. The output of the migration utility is exactly the same as before. The process is migrated with a warning on the <code>USERID<\/code> syntax.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WARNING: USERID\/PASSWORD parameter is no longer supported and will be modified to use USERIDALIAS for the database credentials.<\/code><\/pre>\n\n\n\n<p>And if we look at the migrated parameter file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; grep USERID $OGG_DEPLOYMENT_HOME\/etc\/conf\/ogg\/rep.prm\nUSERIDALIAS dbi_blog\n\u00a0\u00a0\u00a0 COL_SOURCE_USER = COL_TARGET_USER,\n\u00a0\u00a0\u00a0 COL_SOURCE_USERID = COL_TARGET_USERID<\/code><\/pre>\n\n\n\n<p>In this specific case, despite the warning on <code>USERID<\/code>, the migration utility did not change the parameter file. But of course, if you get the warning, you should always check the migrated parameter file before restarting your GoldenGate processes:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; diff $OLD_OGG_HOME\/dirprm\/rep.prm $OGG_DEPLOYMENT_HOME\/etc\/conf\/ogg\/rep.prm<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>When running the GoldenGate migration utility, which I presented in an previous blog post, you might encounter the following warning on USERID syntax: This is not really a surprise, since USERID is an old syntax that should not be used anymore. In fact, it is not even part of the latest versions of GoldenGate. Let&#8217;s [&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":[3780,328,3229,2562,3730,3901,3903],"type_dbi":[3783,3740,3231,3786,3881,3902,3904],"class_list":["post-43393","post","type-post","status-publish","format-standard","hentry","category-goldengate","category-oracle","tag-classic","tag-goldengate","tag-microservices","tag-migration-2","tag-ogg","tag-userid","tag-useridalias","type-classic","type-goldengate","type-microservices","type-migration","type-ogg","type-userid","type-useridalias"],"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>USERID Syntax Warning in GoldenGate Migration Utility - dbi Blog<\/title>\n<meta name=\"description\" content=\"If you get a warning on USERID syntax when migrating to Microservices Architecture, do not worry, but make sure to check your parameter files.\" \/>\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\/userid-syntax-warning-in-goldengate-migration-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"USERID Syntax Warning in GoldenGate Migration Utility\" \/>\n<meta property=\"og:description\" content=\"If you get a warning on USERID syntax when migrating to Microservices Architecture, do not worry, but make sure to check your parameter files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-12T07:41:00+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\/userid-syntax-warning-in-goldengate-migration-utility\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"USERID Syntax Warning in GoldenGate Migration Utility\",\"datePublished\":\"2026-03-12T07:41:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/\"},\"wordCount\":240,\"commentCount\":0,\"keywords\":[\"classic\",\"GoldenGate\",\"microservices\",\"migration\",\"ogg\",\"userid\",\"useridalias\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/\",\"name\":\"USERID Syntax Warning in GoldenGate Migration Utility - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2026-03-12T07:41:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"If you get a warning on USERID syntax when migrating to Microservices Architecture, do not worry, but make sure to check your parameter files.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"USERID Syntax Warning in 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":"USERID Syntax Warning in GoldenGate Migration Utility - dbi Blog","description":"If you get a warning on USERID syntax when migrating to Microservices Architecture, do not worry, but make sure to check your parameter files.","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\/userid-syntax-warning-in-goldengate-migration-utility\/","og_locale":"en_US","og_type":"article","og_title":"USERID Syntax Warning in GoldenGate Migration Utility","og_description":"If you get a warning on USERID syntax when migrating to Microservices Architecture, do not worry, but make sure to check your parameter files.","og_url":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/","og_site_name":"dbi Blog","article_published_time":"2026-03-12T07:41:00+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\/userid-syntax-warning-in-goldengate-migration-utility\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"USERID Syntax Warning in GoldenGate Migration Utility","datePublished":"2026-03-12T07:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/"},"wordCount":240,"commentCount":0,"keywords":["classic","GoldenGate","microservices","migration","ogg","userid","useridalias"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/","url":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/","name":"USERID Syntax Warning in GoldenGate Migration Utility - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-03-12T07:41:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"If you get a warning on USERID syntax when migrating to Microservices Architecture, do not worry, but make sure to check your parameter files.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/userid-syntax-warning-in-goldengate-migration-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"USERID Syntax Warning in 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\/43393","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=43393"}],"version-history":[{"count":4,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43393\/revisions"}],"predecessor-version":[{"id":43401,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/43393\/revisions\/43401"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=43393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=43393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=43393"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=43393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}