Oracle DBCS dataguard 구성후 patch 비교

Oracle DBCS dataguard 구성후 patch 비교

- Oracle DBCS에서 Console 화면상에서 자동으로 Dataguard 구성후 primary, standby 패치 비교하면 다르다. 

Standby 가 최신 이미지로 Provisioning 되기 때문인데 동일하게 맞추려면 Custom Oracle Image 사용하여 작업가능.

primary : 19.6.0.0

standby : 19.8.0.0

- primary 

[grid@primary OPatch]$ ./opatch lspatches

30788310;ACFS Interim patch for 30788310

30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

[TEST]oracle@primary:/home/oracle# opatch lspatches

30484981;OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)

30423135;REINSTATE IS FAILING POST APPLYING 19C OCT19 PATCHES

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

30413137;ORA-00600  INTERNAL ERROR CODE, ARGUMENTS  [2006]

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

- standby

[grid@standby OPatch]$ ./opatch lspatches

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

[TEST]oracle@standby:/home/oracle# opatch lspatches

29997959;DSTV34 UPDATE - TZDATA2019B - NEED OJVM FIX

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

Oracle DBCS에서 Console 화면상에서 Dataguard 구성후 primary, standby 패치 비교하면 다르다. 

Standby 가 최신 이미지로 Provisioning 되기 때문

primary : 19.6.0.0

standby : 19.8.0.0

- primary 

[grid@primary OPatch]$ ./opatch lspatches

30788310;ACFS Interim patch for 30788310

30655595;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30655595)

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

[TEST]oracle@primary:/home/oracle# opatch lspatches

30484981;OJVM RELEASE UPDATE: 19.6.0.0.200114 (30484981)

30423135;REINSTATE IS FAILING POST APPLYING 19C OCT19 PATCHES

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

30413137;ORA-00600  INTERNAL ERROR CODE, ARGUMENTS  [2006]

30557433;Database Release Update : 19.6.0.0.200114 (30557433)

30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

- standby

[grid@standby OPatch]$ ./opatch lspatches

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31335188;TOMCAT RELEASE UPDATE 19.0.0.0.0 (31335188)

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31304218;ACFS RELEASE UPDATE 19.8.0.0.0 (31304218)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)

[TEST]oracle@standby:/home/oracle# opatch lspatches

29997959;DSTV34 UPDATE - TZDATA2019B - NEED OJVM FIX

30432118;MERGE REQUEST ON TOP OF 19.0.0.0.0 FOR BUGS 28852325 29997937

31219897;OJVM RELEASE UPDATE: 19.8.0.0.200714 (31219897)

31301460;JDK BUNDLE PATCH 19.0.0.0.200714

31305087;OCW RELEASE UPDATE 19.8.0.0.0 (31305087)

31281355;Database Release Update : 19.8.0.0.200714 (31281355)