Upgrading GoldenGate Stream Analytics

Prerequisites:

Unpublish pipelines before upgrading to the new GGSA versions, because the Kafka also has to be upgraded.
Upgrade Spark version to 4.0.1.
Upgrade Kafka version to 4.1.0, and migrate the offset details from old Kafka to new Kafka.

Setup Steps:

Backup your metadata store using any of Oracle or MySQL backup tools. The backup is required to restore the tools in case the upgrade fails.
Stop the OSA instance by command
Get the latest OSA-26.1.0.0.0.zip & unzip it by command unzip OSA_26.1.0.0.0.zip
Upgrade the JAVA , Spark , Kafka as per installation document
Setup the environment variable from STEP 4 in installation section.

Configuring Data Source

Fetch the details of metaDB from <OldVersion>/osa-base/etc/jetty-osa-datasource.xml

Edit the osa-datasource.xml file according to your old database credentials.

vi OSA-26.1.0.0.0/osa-base/etc/osa-datasource.xml

Encrypt the password as per STEP 1 of installation section.

Point it to your existing database instance.
Update connection URL, username, and password as needed from the osa-datasource.xml file.

Configurating SSL

By default GGSA will start in SSL enabled mode, if values are not provided in the ssl.conf file, then the start script will generate a self-signed certificate for you.

Note:

To disable SSL mode set NEED_SSL=false in the ssl.conf file.
The default port is 9080, when SSL=False.

For SSL-enabled HTTPS configuration, to modify the ssl.conf file.

vi OSA-26.1.0.0.0/osa-base/etc/osa-ssl/ssl.conf

ssl.conf sample

NEED_SSL=true
OSA_SERVER_CRT_P12=/scratch/kusshubh/gitlocal2/soa-osa/zips/OSA-26.1.0.0.0/osa-base/etc/osa-ssl/self-server.p12
OSA_SERVER_CRT_PWD=wPxQ4+k5da4ys+1hbYvdBKZj9JVsGzWGkdTJwrICpfKV4tyg
OSA_SERVER_CRT_GENERATED_BY=app
OSA_SERVER_CRT_FAIL_ON_VALIDATIONS=true

The parameters are described below:

NEED_SSL: To enable/disable SSL ( true/ false)
OSA_SERVER_CRT_P12: Path of Signed certificate by known authority
OSA_SERVER_CRT_PWD: Encrypted certificate passphrase. User can generate this encrypted passphrase by the tool ./osa-secure-tool.sh mentioned in STEP 1 of Installation Guide
OSA_SERVER_CRT_GENERATED_BY: Specifies if the certificate is generated by app or the user.
OSA_SERVER_CRT_FAIL_ON_VALIDATIONS: This flag fails the startup of app if any issues found during validations of certificate. (true/ false).

Starting the Application

Once configuration is complete, start the application using the following command:

./start-osa.sh   ## start without the proxy
./start-osa.sh --proxy=<YOUR_PROXY>  ## start with proxy

2.12 Upgrading GoldenGate Stream Analytics