{"id":42202,"date":"2026-01-12T09:05:00","date_gmt":"2026-01-12T08:05:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=42202"},"modified":"2026-01-13T13:10:51","modified_gmt":"2026-01-13T12:10:51","slug":"upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/","title":{"rendered":"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai"},"content":{"rendered":"\n<p><strong>Classic Extracts have been deprecated<\/strong> in GoldenGate 19c and shouldn&#8217;t be part of your GoldenGate replications for a long time now. Yet, <strong>some customers still have them<\/strong>, and with GoldenGate 19c <a href=\"https:\/\/www.dbi-services.com\/blog\/planning-goldengate-migration-before-premier-support-expires\/\" target=\"_blank\" rel=\"noreferrer noopener\">support coming to an end<\/a> in a few months, it is high time you upgrade to GoldenGate 23ai.<\/p>\n\n\n\n<p>However, <strong>GoldenGate 23ai doesn&#8217;t support classic extract<\/strong>, and the migration utility provided by Oracle will not take care of them. So, what to do with your classic extracts before migrating to GoldenGate 23ai ?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-upgrade-the-extracts-to-integrated-mode\">Upgrade the extracts to integrated mode<\/h2>\n\n\n\n<p>The natural solution is to <strong>migrate the extracts<\/strong> from the classic mode to the <strong>integrated mode<\/strong>. It might not be possible, depending on your situation, but it is the <strong>easiest way<\/strong> to get your extracts ready for a GoldenGate 23ai migration.<\/p>\n\n\n\n<p>To do so, we will use the <code>info extract &lt;extract&gt; upgrade<\/code> command, which tells us whether the extract is ready for an upgrade. <strong>Log in with the correct alias<\/strong>, <strong>stop the extract<\/strong> and <strong>register the extract<\/strong> before running the command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GGSCI (vmogg) &gt; dblogin useridalias ggadmin\nSuccessfully logged into database.\n\nGGSCI (vmogg as ggadmin@DB1) &gt; stop extract ext\n\nSending STOP request to EXTRACT EXT ...\nRequest processed.\n\nGGSCI (vmogg as ggadmin@DB1) &gt; info extract ext\n\nEXTRACT    EXT       Last Started 2025-12-21 10:13   Status STOPPED\nCheckpoint Lag       00:00:00 (updated 00:00:10 ago)\nLog Read Checkpoint  Oracle Redo Logs\n                     2025-12-21 10:19:13  Seqno 10, RBA 18472448\n                     SCN 0.2170788 (2170788)\n\nGGSCI (vmogg as ggadmin@DB1) &gt; register extract ext database\n\n2025-12-21 10:21:13  INFO   OGG-02003  Extract EXT successfully registered with database at SCN 2170800.\n\nGGSCI (vmogg as ggadmin@DB1) &gt; info extract ext upgrade<\/code><\/pre>\n\n\n\n<p>You might need to run the command multiple times, depending on the output of the last command. Once the extract is ready to be upgraded, you will see the following output.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GGSCI (vmogg as ggadmin@DB1) &gt; info extract ext upgrade\nExtract EXT is ready to be upgraded to integrated capture.<\/code><\/pre>\n\n\n\n<p>After this, <strong>run the upgrade command<\/strong> and <strong>restart the extract<\/strong>. The extract is now in <code>Oracle Integrated Redo Logs<\/code> mode.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GGSCI (vmogg as ggadmin@DB1) &gt; alter extract ext upgrade integrated tranlog\nExtract EXT successfully upgraded to integrated capture.\n\nGGSCI (vmogg as ggadmin@DB1) &gt; info extract ext\n\nEXTRACT    EXT       Initialized   2025-12-21 10:13   Status STOPPED\nCheckpoint Lag       00:00:00 (updated 00:11:43 ago)\n<strong>Log Read Checkpoint  Oracle Integrated Redo Logs\n<\/strong>                     2025-12-21 10:19:13\n                     SCN 0.2170788 (2170788)\n\nGGSCI (vmogg as ggadmin@DB1) &gt; start extract ext\n\nSending START request to MANAGER ...\nEXTRACT EXT starting<\/code><\/pre>\n\n\n\n<p>If your extract doesn&#8217;t start, have a detailed look at the parameters used in the extract with <code>view params ext<\/code>. You could use parameters for your extract that were accepted for classic extracts but not supported for integrated extracts.<\/p>\n\n\n\n<p><strong>Repeat this procedure<\/strong> for all your classic extracts in all your GoldenGate deployments, and you will be ready to migrate to GoldenGate 23ai !<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-ogg-08241-when-registering-the-extract\"><code>OGG-08241<\/code> when registering the extract<\/h4>\n\n\n\n<p>If you get the following error when registering the extract:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>OGG-08241  ERROR: This EXTRACT EXT is already registered with the database.<\/code><\/pre>\n\n\n\n<p>Check the <code>dba_capture<\/code> view of the database you are trying to register the extract into. If you see an extract already registered, it might mean that you previously registered an integrated extract with the same name.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT capture_name, queue_name, queue_owner, source_database, start_scn from dba_capture;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-recovery-scn-has-not-reached-scn-error\">&#8216;Recovery SCN has not reached SCN&#8217; error<\/h4>\n\n\n\n<p>If you receive this error when running the upgrade command, you should try restarting the extract and stopping it again.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>Extract ext is not ready to be upgraded because recovery SCN ... has not reached SCN ...<\/code><\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>start extract ext\nstop extract ext\ninfo extract ext upgrade<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-what-if-my-extract-is-abended\">What if my extract is ABENDED ?<\/h4>\n\n\n\n<p>Technically, the <code>info extract ... upgrade<\/code> command works for <code>ABENDED<\/code> extracts. But depending on the reason your extract ended up in this state, you might not be able to upgrade.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Classic Extracts have been deprecated in GoldenGate 19c and shouldn&#8217;t be part of your GoldenGate replications for a long time now. Yet, some customers still have them, and with GoldenGate 19c support coming to an end in a few months, it is high time you upgrade to GoldenGate 23ai. However, GoldenGate 23ai doesn&#8217;t support classic [&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":[3560,3780,3781,328,3782,2562],"type_dbi":[3783,3785,3740,3784],"class_list":["post-42202","post","type-post","status-publish","format-standard","hentry","category-goldengate","category-oracle","tag-23ai","tag-classic","tag-extract","tag-goldengate","tag-integrated","tag-migration-2","type-classic","type-extract","type-goldengate","type-integrated"],"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>Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai - dbi Blog<\/title>\n<meta name=\"description\" content=\"With classic extracts being deprecated, how to upgrade them to integrated mode before migrating to GoldenGate 23ai ?\" \/>\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\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai\" \/>\n<meta property=\"og:description\" content=\"With classic extracts being deprecated, how to upgrade them to integrated mode before migrating to GoldenGate 23ai ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-12T08:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-13T12:10:51+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\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai\",\"datePublished\":\"2026-01-12T08:05:00+00:00\",\"dateModified\":\"2026-01-13T12:10:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\"},\"wordCount\":392,\"commentCount\":0,\"keywords\":[\"23ai\",\"classic\",\"extract\",\"GoldenGate\",\"integrated\",\"migration\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\",\"name\":\"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2026-01-12T08:05:00+00:00\",\"dateModified\":\"2026-01-13T12:10:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"With classic extracts being deprecated, how to upgrade them to integrated mode before migrating to GoldenGate 23ai ?\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai\"}]},{\"@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":"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai - dbi Blog","description":"With classic extracts being deprecated, how to upgrade them to integrated mode before migrating to GoldenGate 23ai ?","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\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai","og_description":"With classic extracts being deprecated, how to upgrade them to integrated mode before migrating to GoldenGate 23ai ?","og_url":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/","og_site_name":"dbi Blog","article_published_time":"2026-01-12T08:05:00+00:00","article_modified_time":"2026-01-13T12:10:51+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\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai","datePublished":"2026-01-12T08:05:00+00:00","dateModified":"2026-01-13T12:10:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/"},"wordCount":392,"commentCount":0,"keywords":["23ai","classic","extract","GoldenGate","integrated","migration"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/","url":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/","name":"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-01-12T08:05:00+00:00","dateModified":"2026-01-13T12:10:51+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"With classic extracts being deprecated, how to upgrade them to integrated mode before migrating to GoldenGate 23ai ?","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-classic-extracts-to-integrated-mode-before-migrating-to-goldengate-23ai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Upgrade Classic Extracts to Integrated Mode Before Migrating to GoldenGate 23ai"}]},{"@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\/42202","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=42202"}],"version-history":[{"count":16,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/42202\/revisions"}],"predecessor-version":[{"id":42453,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/42202\/revisions\/42453"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=42202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=42202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=42202"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=42202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}