Migration of extract and pump process from 11g to 19c in golden gate

 In this example, we are going to migrated golden gate from 11g to 19c. As part of migration, we need to perform the below steps.

Step 1: Prerequisites.

1. Make sure that you can connect to GGSCI prompt.

2. check whether you have write access under $GGS_HOME

Step 2: Encrypt the GGSUSER password.

Note : Welcome123 is the actual password which will get encrypt.

GGSCI > ENCRYPT PASSWORD Welcome123 BLOWFISH ENCRYPTKEY DEFAULT

Using Blowfish encryption with DEFAULT key.

Encrypted password:  AACAAAAAAAKKKAAKAWDSBDHKHMBMGVBXAWHVCXHQIWIZEUCJF

Algorithm used:  BLOWFISH

Step 3: Login to the db using the encrypted password in GGSCI prompt.

GGSCI >  dblogin USERID  GGSUSER,  password AACAAKKKAAAAAKAWDSBDHKHMBMGVBXAWHVCXHQIWIZEUCJF, BLOWFISH encryptkey default

Successfully logged into database.

Step 4: create extract

GGSCI > edit params E_extract01

--ADD the below value and save it.

EXTRACT E_extract01

SETENV (ORACLE_SID="test")

SETENV (ORACLE_HOME="/opt/app/user/oracle/product/19.8.0")

USERID GGSUSER@test, password AACAAAAAAAAAAAKAWDSBDHKHMBMGVBXAWHVCXHQIWIZEUCJF, BLOWFISH ENCRYPTKEY DEFAULT

EXTTRAIL /opt/app/test/ggs/19.1.0.0.4/trails/g1

DISCARDFILE /opt/app/test/ggs/19.1.0.0.4/dirrpt/e_extract01.dsc, APPEND

GETTRUNCATES

NOCOMPRESSDELETES

REPORTROLLOVER ON sunday

REPORTCOUNT EVERY 60 MINUTES, RATE

REPORT At 23:59

TABLE user.A8;

TABLE user.BACKUP;

TABLE user.BAND;

GGSCI > add extract E_extract, integrated tranlog, begin now

EXTRACT (Integrated) added.

GGSCI > register extract E_extract database

2024-06-06 03:13:03  INFO    OGG-02003  Extract E_extract successfully registered with database at SCN 31393982.

GGSCI > ADD RMTTRAIL /opt/app/test/ggs/19.1.0.0.4/trails/g1, EXTRACT E_extract01

RMTTRAIL added.

Step 4: start the extract

GGSCI > start E_extract01

Step 5: create the pump process to communicate to the target server.

GGSCI > edit params P_pump01

STATOPTIONS REPORTFETCH

REPORTCOUNT EVERY 10 MINUTES, RATE

RMTHOST  target_localhost, MGRPORT 8000, TcpBufSize 1048576, TcpFlushBytes 1048576

RMTTRAIL /opt/app/target_host/acfs/ggs/ggs19c/trails/Bag/b1

PASSTHRU

TABLE user.A8;

TABLE user.BACKUP;

TABLE user.BAND;

GGSCI > ADD EXTRACT P_pump01, EXTTRAILSOURCE /opt/app/test/ggs/19.1.0.0.4/trails/g1

EXTRACT added.

GGSCI > ADD RMTTRAIL /opt/app/target_test/acfs/ggs/ggs19c/trails/BAG/b1, EXTRACT P_pump01

RMTTRAIL added.

Step 6: start the Pump process

GGSCI > start P_pump01

Step 7: Validate the extract and the pump process.

If still RBA is 0, then cross check below link

ogg-01061-invalid-csn-value-length0