Upgrade Classic Extract to Integrated Capture

The Integrated Capture Mode provides enhanced integration with new Oracle Features and improvement in usage of the resources and performance enhancement. Below are the steps required to upgrade a new or an existing GoldenGate Classical Extract process.

Related Articles
GoldenGate Integrated Capture Mode
Oracle GoldenGate 12c: Silent Install
Oracle GoldenGate 12c: Installation Using Universal Installer

Upgrading Classic Capture

Place the parameter file for the new extract XVST1 in the $GG_HOME/dirprm directory.

EXTRACT XVST1
USERID ggsuser, 'PASSWORD' ggsuser
EXTTRAIL ./dirdat/xn
TRANLOGOPTIONS EXCLUDEUSER ggsuser
TABLE GGS_TEST.*;

Add and Register the Extract

From GGSCI add the extract process.

ADD EXTRACT XVST1, TRANLOG, BEGIN NOW
ADD EXTTRAIL ./dirdat/xn EXTRACT XVST1, megabytes 100
shell cat /u01/app/ggs/dirprm/xVST1.prm

Then register the extract process in the database.

GGSCI (ggsdb01) 6> dblogin USERID ggsuser, PASSWORD ggsuser
Successfully logged into VST database.

GGSCI (ggsdb01) 7> register extract XVST1 database
2013-04-24 11:01:32 INFO OGG-02003 Extract XVST1 successfully registered with database at SCN 344133387.

Note: It takes a while to register.

Upgrade Classic Extract to Integrated Capture

Try upgrading the registered process. An error will be returned.

GGSCI (ggsdb01) 3> info XVST1 upgrade
ERROR: Extract XVST1 is not ready to be upgraded because recovery SCN 344133277 has not reached SCN 344133387.


Reset to the process to the current SCN as it is not able to start after the upgrade with it still positioned to a point in the past.

GGSCI (ggsdb01) 5> alter extract XVST1, integrated tranlog, begin now
EXTRACT altered.

GGSCI (ggsdb01) 6> start XVST1
Sending START request to MANAGER ...
EXTRACT XVST1 starting

Verify the status of the Extract.

GGSCI (ggsdb01) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING XVST1 00:00:03 00:00:00

Upgrade to Integrated Capture

GGSCI (ggsdb01) 9> info XTRN1 upgrade
ERROR: Extract XTRN1 is not ready to be upgraded because recovery SCN values are not set.

Reset Extract SCN

So all that needs to be done is restart the process for it to update the extract to the new SCN number.

GGSCI (ggsdb01) 11> info XTRN1
EXTRACT XTRN1 Last Started 2013-04-24 11:20 Status RUNNING

Checkpoint Lag 00:00:39 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2013-04-24 11:19:39 Seqno 502, RBA 28160
SCN 0.0 (0) <

Wait a little while for the till SCN 0.0 (0) value to be updated. Then verify the status again.

GGSCI (ggsdb01) 14> info XTRN1

EXTRACT XTRN1 Last Started 2013-04-24 11:20 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:07 ago)
Log Read Checkpoint Oracle Redo Logs
2013-04-24 11:19:56 Seqno 503, RBA 1024
SCN 0.344145451 (344145451)

GGSCI (ggsdb01) 23> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING XTRN1 00:01:29 00:00:17

Errors During Upgrade


The following error will be seen in the report file if the per-requisite database patch has not been applied and an attempt is made to create an Integrated Capture process. All that needs to be done is to install the 14551959 database patch. More information is available in MOS note 1411356.1.

Source Context :
SourceModule : [er.redo.oraxo] SourceID : [/scratch/aime1/adestore/views/aime1_adc6150691/
oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c] SourceFunction : [REDOORAIX_validate_config] SourceLine : [8730]

2013-04-25 17:24:15 ERROR OGG-02022 Logmining server does not exist on this Oracle database.

2013-04-25 17:24:15 ERROR OGG-01668 PROCESS ABENDING.

Upgrade Series

Upgrade Classic Extract to Integrated Capture
Goldengate upgrade to 11.1.1.2

Comments

  1. aziz.alyosofi@gmail.com'Aziz Yousfi says

    I have a problem when installing goldengate in windows with Arabic locale it stopped working as it want to start although it works well with other languages such as Chinese ,Russian ,etc.what should i do if i must to use Arabic locale to allow my oracle forms 6i app works well

    Thanks

    Aziz

    • Natik Ameen says

      Aziz, I am sorry I have not used Arabic locale yet.

      If any of the readers have experience with Arabic locale kindly share your experience with us.

Leave a Reply

Your email address will not be published.