{"id":46068,"date":"2026-08-10T08:02:00","date_gmt":"2026-08-10T06:02:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=46068"},"modified":"2026-08-05T21:13:15","modified_gmt":"2026-08-05T19:13:15","slug":"goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/","title":{"rendered":"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">While working on a client\u2019s GoldenGate 26ai environment, I ran into a NFS-related replication issue that could have been serious, had it happened in production. Here is what happened and how the issue was fixed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The client\u2019s GoldenGate extract was running on a dedicated server, capturing changes from an Oracle 19c source database. Trail files were written on an NFS. Depending on the configuration, this is officially supported by Oracle, and works rather well.<\/p>\n\n\n\n<h2 id=\"h-ogg-02897-ogg-01668-input-output-error\" class=\"wp-block-heading\"><code>OGG-02897<\/code> \/ <code>OGG-01668<\/code> Input\/Output Error<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">On a Monday morning, however, the extract was <code>ABENDED<\/code>. The extract had been down since Saturday night, with the following error messages:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n2026-06-07T00:19:11.404+0200  ERROR   OGG-02897  Oracle GoldenGate Capture for Oracle, EXT.prm:  Failed to synchronize trail file. Error detail: Could not sync &quot;PDB1\/aa000000009&quot; (error 5, Input\/output error).\n2026-06-07T00:19:11.404+0200  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, EXT.prm:  PROCESS ABENDING.\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">The extract was failing with an <code>OGG-02897<\/code> error. The OS-level error, <code>errno 5: Input\/output error<\/code>, did not seem to indicate any good news for us. Needless to say that restarting the extract did not fix the issue.<\/p>\n\n\n\n<h2 id=\"h-root-cause-analysis\" class=\"wp-block-heading\">Root Cause Analysis<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A firewall upgrade had taken place that Saturday night. The firewall between the GoldenGate server and the NFS server was upgraded, and it briefly went down during the operation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The real problem was what happened after the firewall came back up: some extracts caught up and managed to restart properly, while other were left in this <code>ABENDED<\/code> state, unable to restart. For these extracts, I\/O operations kept failing even though the network path was healthy again.<\/p>\n\n\n\n<h2 id=\"h-solution-remount-the-nfs\" class=\"wp-block-heading\">Solution: Remount the NFS<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The solution was to stop all GoldenGate processes whose trail files were generated on the NFS, including all the processes which were running fine, and then unmount and remount the NFS filesystem.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n# Unmount the NFS path\numount \/path\/to\/nfs\n\n# Remount all filesystems defined in \/etc\/fstab, including the NFS\nmount -a\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Once that came back up, I restarted the extracts from the <code>adminclient<\/code> and they all started successfully.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this case, the firewall upgrade happened during the night with no GoldenGate-aware procedure in place. Next time, a scheduled GoldenGate maintenance spanning over the firewall upgrade window will probably avoid crashing multiple replications during the week-end, or worse.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While working on a client\u2019s GoldenGate 26ai environment, I ran into a NFS-related replication issue that could have been serious, had it happened in production. Here is what happened and how the issue was fixed. The client\u2019s GoldenGate extract was running on a dedicated server, capturing changes from an Oracle 19c source database. Trail files [&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":"","_members_access_role":[],"_members_access_error":""},"categories":[3787,59],"tags":[3380,62,3827,3804,1545,3781,328,112,3730,4170,4171,3813,44],"type_dbi":[3835,4026,3828,3823,2954,3785,3740,4172,3881,4174,4173,4122,4175],"class_list":["post-46068","post","type-post","status-publish","format-standard","hentry","category-goldengate","category-oracle","tag-3380","tag-19c","tag-3827","tag-26ai","tag-error","tag-extract","tag-goldengate","tag-nfs","tag-ogg","tag-ogg-01668","tag-ogg-02897","tag-trail","tag-troubleshooting","type-3835","type-19c","type-3828","type-26ai","type-error","type-extract","type-goldengate","type-nfs","type-ogg","type-ogg-01668","type-ogg-02897","type-trail","type-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.2 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error - dbi Blog<\/title>\n<meta name=\"description\" content=\"Root cause and fix for OGG-02897 and OGG-01668 input\/output errors when a GoldenGate Extract writes trail files to an NFS mount.\" \/>\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-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error\" \/>\n<meta property=\"og:description\" content=\"Root cause and fix for OGG-02897 and OGG-01668 input\/output errors when a GoldenGate Extract writes trail files to an NFS mount.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-10T06:02: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\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"headline\":\"GoldenGate Extract Abending on NFS Trail: OGG-02897 \\\/ OGG-01668 Input\\\/Output Error\",\"datePublished\":\"2026-08-10T06:02:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/\"},\"wordCount\":313,\"commentCount\":0,\"keywords\":[\"19\",\"19c\",\"26\",\"26ai\",\"Error\",\"extract\",\"GoldenGate\",\"NFS\",\"ogg\",\"ogg-01668\",\"ogg-02897\",\"trail\",\"Troubleshooting\"],\"articleSection\":[\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/\",\"name\":\"GoldenGate Extract Abending on NFS Trail: OGG-02897 \\\/ OGG-01668 Input\\\/Output Error - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-08-10T06:02:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/764ab019cc9dec42655b4c6b9b8e474e\"},\"description\":\"Root cause and fix for OGG-02897 and OGG-01668 input\\\/output errors when a GoldenGate Extract writes trail files to an NFS mount.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GoldenGate Extract Abending on NFS Trail: OGG-02897 \\\/ OGG-01668 Input\\\/Output Error\"}]},{\"@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":"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error - dbi Blog","description":"Root cause and fix for OGG-02897 and OGG-01668 input\/output errors when a GoldenGate Extract writes trail files to an NFS mount.","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-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/","og_locale":"en_US","og_type":"article","og_title":"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error","og_description":"Root cause and fix for OGG-02897 and OGG-01668 input\/output errors when a GoldenGate Extract writes trail files to an NFS mount.","og_url":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/","og_site_name":"dbi Blog","article_published_time":"2026-08-10T06:02: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\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"headline":"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error","datePublished":"2026-08-10T06:02:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/"},"wordCount":313,"commentCount":0,"keywords":["19","19c","26","26ai","Error","extract","GoldenGate","NFS","ogg","ogg-01668","ogg-02897","trail","Troubleshooting"],"articleSection":["GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/","url":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/","name":"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-08-10T06:02:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/764ab019cc9dec42655b4c6b9b8e474e"},"description":"Root cause and fix for OGG-02897 and OGG-01668 input\/output errors when a GoldenGate Extract writes trail files to an NFS mount.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/goldengate-extract-abending-on-nfs-trail-ogg-02897-ogg-01668-input-output-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"GoldenGate Extract Abending on NFS Trail: OGG-02897 \/ OGG-01668 Input\/Output Error"}]},{"@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\/46068","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=46068"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46068\/revisions"}],"predecessor-version":[{"id":46265,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46068\/revisions\/46265"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=46068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=46068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=46068"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=46068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}