How to upgrade oracle golden gate from 12.2.0.1 to 12.2.0.2

Note: before start below step copy you new software version to respective database server. So activity won’t take more time.

1] First stop all traffic of your primary database, then stop extract process.

GGSCI (source.example.com) 15> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DATAPMP0 00:00:00 00:00:01
EXTRACT RUNNING DATAPMP1 00:00:00 00:00:02
EXTRACT STOPPED EXTRACT0 00:00:07 00:00:35
EXTRACT STOPPED EXTRACT1 00:00:00 00:00:34

2] Check lag of extract and pump on primary (source) database.

=> Check lag of extract process

GGSCI (source.example.com as ggadmin@DB11G) 8> lag extract EXTRACT0

Sending GETLAG request to EXTRACT EXTRACT0 ...
No records yet processed.

=> Check lag of PUMP process.

GGSCI (source.example.com as ggadmin@DB11G) 9> lag extract DATAPMP0

Sending GETLAG request to EXTRACT DATAPMP0 ...
No records yet processed.
At EOF, no more records to process.

3] Stop extract, pump and mgr process on source database.

GGSCI (source.example.com) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DATAPMP0 00:00:00 00:00:06
EXTRACT RUNNING EXTRACT0 00:00:10 00:00:04

GGSCI (source.example.com) 2> stop *

Sending STOP request to EXTRACT DATAPMP0 ...
Request processed.
Sending STOP request to EXTRACT EXTRACT0 ...
Request processed.

GGSCI (source.example.com) 3> stop mgr

Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

GGSCI (source.example.com) 4> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED DATAPMP0 00:00:00 00:00:10
EXTRACT STOPPED EXTRACT0 00:00:02 00:00:10
GGSCI (source.example.com) 5>

3] start installation of 12.2.0.2 Golden gate software Source Database .

4] Take copy of dir* directories from new gg home.

mv dirwww dirwww_bkp
mv dirout dirout_bkp
mv dirsql dirsql_bkp
mv dirdef dirdef_bkp
mv dirbdb dirbdb_bkp
mv dirwlt dirwlt_bkp
mv dircrd dircrd_bkp
mv dirprm dirprm_bkp
mv dirchk dirchk_bkp
mv dirdmp dirdmp_bkp
mv dirrpt dirrpt_bkp
mv dirtmp dirtmp_bkp
mv dirdat dirdat_bkp
mv dirpcs dirpcs_bkp

5] Create soft link of above directories from old GG_HOME new GG_HOME.

[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirout dirout
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirsql dirsql
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirdef dirdef
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirbdb dirbdb
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirwlt dirwlt
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dircrd dircrd
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirprm dirprm
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirchk dirchk
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirdmp dirdmp
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirrpt dirrpt
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirtmp dirtmp
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirdat dirdat
[oracle@source ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirpcs dirpcs

vaidation:

[oracle@source ggs.12.2.0.2]$ ls -dltr dir*

lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:34 dirwww -> /u02/ggs.12.2.0.1/dirwww
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirout -> /u02/ggs.12.2.0.1/dirout
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirsql -> /u02/ggs.12.2.0.1/dirsql
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirdef -> /u02/ggs.12.2.0.1/dirdef
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirbdb -> /u02/ggs.12.2.0.1/dirbdb
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirwlt -> /u02/ggs.12.2.0.1/dirwlt
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dircrd -> /u02/ggs.12.2.0.1/dircrd
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirprm -> /u02/ggs.12.2.0.1/dirprm
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirchk -> /u02/ggs.12.2.0.1/dirchk
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirdmp -> /u02/ggs.12.2.0.1/dirdmp
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirrpt -> /u02/ggs.12.2.0.1/dirrpt
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirtmp -> /u02/ggs.12.2.0.1/dirtmp
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirdat -> /u02/ggs.12.2.0.1/dirdat
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:35 dirpcs -> /u02/ggs.12.2.0.1/dirpcs

6] Check lag of replicat process on target database server.

GGSCI (target.example.com as ggadmin@DB11G) 7> lag REPLCAT0

Sending GETLAG request to REPLICAT REPLCAT0 ...
Last record lag 20,698 seconds.
Low watermark lag: 1.
High watermark lag: 1.
Low watermark position: 1031955.
High watermark position: 1036542.
At EOF, no more records to process.

GGSCI (target.example.com as ggadmin@DB11G) 8> stop REPLCAT0

Sending STOP request to REPLICAT REPLCAT0 ...
Request processed.

GGSCI (target.example.com as ggadmin@DB11G) 9> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
REPLICAT STOPPED REPLCAT0 00:00:00 00:00:40
GGSCI (target.example.com as ggadmin@DB11G) 10>

7] start installation of 12.2.0.2 Golden gate software target Database .

8] Take back of dir* drectories from new GG_HOME.

[oracle@target ggs.12.2.0.2]$ mv dirwww dirwww_bkp
[oracle@target ggs.12.2.0.2]$ mv dirout dirout_bkp
[oracle@target ggs.12.2.0.2]$ mv dirsql dirsql_bkp
[oracle@target ggs.12.2.0.2]$ mv dirdef dirdef_bkp
[oracle@target ggs.12.2.0.2]$ mv dirbdb dirbdb_bkp
[oracle@target ggs.12.2.0.2]$ mv dirwlt dirwlt_bkp
[oracle@target ggs.12.2.0.2]$ mv dircrd dircrd_bkp
[oracle@target ggs.12.2.0.2]$ mv dirprm dirprm_bkp
[oracle@target ggs.12.2.0.2]$ mv dirchk dirchk_bkp
[oracle@target ggs.12.2.0.2]$ mv dirdmp dirdmp_bkp
[oracle@target ggs.12.2.0.2]$ mv dirrpt dirrpt_bkp
[oracle@target ggs.12.2.0.2]$ mv dirtmp dirtmp_bkp
[oracle@target ggs.12.2.0.2]$ mv dirdat dirdat_bkp
[oracle@target ggs.12.2.0.2]$ mv dirpcs dirpcs_bkp

9] Create softlink of above directories from old GG_HOME new GG_HOME.

[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirwww dirwww
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirout dirout
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirsql dirsql
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirdef dirdef
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirbdb dirbdb
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirwlt dirwlt
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dircrd dircrd
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirprm dirprm
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirchk dirchk
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirdmp dirdmp
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirrpt dirrpt
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirtmp dirtmp
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirdat dirdat
[oracle@target ggs.12.2.0.2]$ ln -ds /u02/ggs.12.2.0.1/dirpcs dirpcs

[oracle@target ggs.12.2.0.2]$ ls -dltr dir*

lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirwww -> /u02/ggs.12.2.0.1/dirwww
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirout -> /u02/ggs.12.2.0.1/dirout
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirsql -> /u02/ggs.12.2.0.1/dirsql
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirdef -> /u02/ggs.12.2.0.1/dirdef
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirbdb -> /u02/ggs.12.2.0.1/dirbdb
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirwlt -> /u02/ggs.12.2.0.1/dirwlt
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dircrd -> /u02/ggs.12.2.0.1/dircrd
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirprm -> /u02/ggs.12.2.0.1/dirprm
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirchk -> /u02/ggs.12.2.0.1/dirchk
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirdmp -> /u02/ggs.12.2.0.1/dirdmp
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirrpt -> /u02/ggs.12.2.0.1/dirrpt
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirtmp -> /u02/ggs.12.2.0.1/dirtmp
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirdat -> /u02/ggs.12.2.0.1/dirdat
lrwxrwxrwx. 1 oracle oinstall 24 Jul 31 10:54 dirpcs -> /u02/ggs.12.2.0.1/dirpcs

[oracle@target ggs.12.2.0.2]$

10] Start manager process on both source and target database server.

Source database Server :

GGSCI (source.example.com) 3> start mgr
Manager started.

GGSCI (source.example.com) 4> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DATAPMP0 00:00:00 00:46:49
EXTRACT STOPPED EXTRACT0 00:00:02 00:46:49

Target database Server :

GGSCI (target.example.com) 2> start mgr
Manager started.

GGSCI (target.example.com) 3> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REPLCAT0 00:00:00 00:20:32

11] Start extract and dump process on source database server.

GGSCI (source.example.com) 5> start extract EXTRACT0

Sending START request to MANAGER ...
EXTRACT EXTRACT0 starting

GGSCI (source.example.com) 6> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED DATAPMP0 00:00:00 00:49:33
EXTRACT RUNNING EXTRACT0 00:49:32 00:00:03

GGSCI (source.example.com) 7> start extract DATAPMP0

Sending START request to MANAGER...
EXTRACT DATAPMP0 starting

GGSCI (source.example.com) 11> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DATAPMP0 00:00:00 00:00:00
EXTRACT RUNNING EXTRACT0 00:00:03 00:00:04
12] Start replicat process on target database server.

GGSCI (target.example.com) 4> start REPLCAT0

Sending START request to MANAGER ...
REPLICAT REPLCAT0 starting

GGSCI (target.example.com) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPLCAT0 00:00:00 00:00:01

Validation:

A] Insert one row in source database table

SQL> insert into departments values(280,'sales',205,1700);
1 row created.
SQL> commit;
Commit complete.

B] Check stats of extract, pump and replicat process.

GGSCI (source.example.com) 12> stats DATAPMP0

Sending STATS request to EXTRACT DATAPMP0 ...
Start of Statistics at 2019-07-31 11:10:44.
Output to /u02/ggs.12.2.0.1/dirdat/tx:
Extracting from HR.DEPARTMENTS to HR.DEPARTMENTS:
*** Total statistics since 2019-07-31 11:10:35 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Daily statistics since 2019-07-31 11:10:35 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Hourly statistics since 2019-07-31 11:10:35 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Latest statistics since 2019-07-31 11:10:35 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
End of Statistics.

GGSCI (target.example.com) 8> stats REPLCAT

Sending STATS request to REPLICAT REPLCAT0 ...
Start of Statistics at 2019-07-31 11:11:27.
Integrated Replicat Statistics:
Total transactions 1.00
Redirected 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%
Replicating from HR.DEPARTMENTS to HR.DEPARTMENTS:
*** Total statistics since 2019-07-31 11:10:39 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Daily statistics since 2019-07-31 11:10:39 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Hourly statistics since 2019-07-31 11:10:39 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
*** Latest statistics since 2019-07-31 11:10:39 ***
Total inserts 1.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 1.00
End of Statistics.
GGSCI (target.example.com) 9>