• Database Blog
  • GoldenGate 12c
    • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Master Oracle 12c DBA
  • Oracle Tutorials
    • Oracle Tips & Tricks
    • Oracle VirtualBox
  • Learn Excel

VitalSoftTech

Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen

  • Digital Marketing
  • Blogging Tutorial and Tips
  • Cool Names
  •   Login
« Previous Post
Next Post »

Upgrade Classic Extract to Integrated Capture

June 17, 2014 by Natik Ameen   /  Goldengate

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

Filed Under: Goldengate Tagged With: Goldengate

Comments

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

    January 1, 2016 at 7:37 am

    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

    Reply
    • Natik Ameen says

      January 15, 2016 at 8:27 pm

      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.

      Reply

Leave a Reply Cancel reply

Your email address will not be published.

« Previous Post
Next Post »

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database    GoldenGate

Natik Ameen

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud.

Who is Natik Ameen?

Guides

  • My GoldenGate Tutorials
  • Oracle 12c Database Tutorials
  • GoldenGate GGSCI Command Series
  • My OraTips and Tricks

Popular Blogs

  • My GoldenGate Home Page
  • Top 50 Oracle Goldengate Interview Questions To Get the Job!
  • Top 30 RAC Interview Questions That Helped Me. Are You Prepared?
  • Oracle GoldenGate Concepts and Architecture Made Simple!
  • Virtualize Oracle RAC 12c on My Laptop
  • Step by Step Oracle 12c Database Install on Virtual Box

Popular Oracle Articles

Oracle Announces Beta Availability of Oracle Database 12c Release 2
Top 5 Announcements at Oracle Open World
News on Oracle Database STANDARD EDITION 12.1.0.2

Technology Centers

Oracle Business Intelligence and DW
Cloud Computing, SOA, Virtualization
Big data, Java, Linux, PLSQL, Security
Enterprise Architecture, Digital Experience

Oracle Documentation

10g R1, 10g R2, 11g R1, 11g R2, 12c R1
Oracle CPU's, EM 11g, EM 12c
GoldenGate 12c, Oracle VM, VirtualBox

Copyright ©2021

BLOGOracle Tutorials