How-To Fix Poco::IOException Error During Goldengate 23ai Upgrade

 I recently upgraded Oracle GoldenGate 23ai. In this post, I'll share my experience and provide a step-by-step guide on how to upgrade Oracle GoldenGate 23ai using the GUI and especially a weird error which I received during this upgrade which is as follows:

Error:

Operating system character set identified as UTF-8.

terminate called after throwing an instance of 'Poco::IOException'

what(): I/O error

If you want TLDR; then I had to apply patch 27788241 to get this resolved. For details, keep reading on.

To start the upgrade, I downloaded the latest Oracle GoldenGate 23ai software from the Oracle Technology Network or eDelivery. Then, I moved the software to a staging folder and unzipped it.

For Linux users, the commands are:

$ mv /home/user/fbo_ggs_Linux_x64_Oracle_services_shiphome.zip /tmp

$ cd /tmp

$ unzip fbo_ggs_Linux_x64_Oracle_services_shiphome.zip

Next, I uploaded the Oracle GoldenGate 23ai software to a staging location on the server where the previous release of Oracle GoldenGate existed.

Upgrading the Service Manager

After installing the latest Oracle GoldenGate 23ai version, I upgraded the Service Manager. I logged into the Service Manager using the URL: https://hostname:servicemanager_port.

From the Service Manager Overview page, I selected the ServiceManager link in the Deployments section. Then, I clicked the pencil icon next to the Deployment Detail section to open the dialog box for editing the GoldenGate home path.

I updated the GoldenGate Home path with the full path to the new Oracle GoldenGate 23ai home and clicked Apply. Finally, I restarted the Service Manager using the Action dropdown.

Upgrading the Deployment

To upgrade the deployment, I stopped all Extract and Replicat processes. I checked for open transactions and Bounded Recovery.

Then, I updated the deployment with the location of the new Oracle GoldenGate 23ai Home directory. I edited the deployment details and updated the Oracle GoldenGate 23ai Home path.

Resolving the Error

During the upgrade, I got this error:

Operating system character set identified as UTF-8.

terminate called after throwing an instance of 'Poco::IOException'

what(): I/O error

After researching, I found that applying patch 27788241 fixed the issue. I applied the patch, and the upgrade completed successfully.

Hope this helps.