• Home
    • 2017
  • Oracle GoldenGate
    • Core Platform
    • Cloud Service
    • For Oracle DB
    • For Big Data
    • For MySQL
    • For DB2 z/OS
    • For DB2 LUW
    • For DB2 i
    • For Informix
    • For SQL Server
    • For Teradata
    • For AWS Aurora
    • Foundation Suite
    • Use Cases
  • Data Management
    • General
    • Big Data
    • Oracle Database
    • MySQL
    • MS SQL Server
    • IBM DB2
    • IBM Informix
    • Teradata
    • SAP ASE
  • Data Science
  • IT
    • IT Management
    • IT Technology
  • About
Jinyu's Blog
About Data, Database, Integration and IT 

How to Check Character Set Information in Oracle GoldenGate

12/11/2014

0 Comments

 
Let's look at the following content from an example replicat report file.  You can find the following outputs:

Version 12.1.2.1.1 19797716 OGGCORE_12.1.2.1.1_PLATFORMS_141030.1944
Linux, x64, 64bit (optimized), Informix_SDK410 on Oct 30 2014 23:15:54
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.

Then,  the report file provide detailed character set information.  Let's look at this with an example replicat report file.  You can find the following outputs:

2014-12-08 16:05:00  INFO    OGG-03059  Operating system character set identified as UTF-8.  
---> This is the OS character set. 
…

2014-12-08 16:05:00  INFO    OGG-03036  Database character set identified as UTF-8. Locale: en_US. 
---> This is the target database server character set. 
…
2014-12-08 16:05:00  INFO    OGG-03037  Session character set identified as UTF-8. 
---> This is the target database session character set. 
…
2014-12-08 16:05:00  INFO    OGG-03528  The source database character set, as determined from the table definition file, is UTF-8. 
---> This shows the source database character set defined in the defgen file. 
…
2014-12-08 16:05:00  INFO    OGG-03506  The source database character set, as determined from the trail file, is UTF-8.
---> This shows the source database character set defined in the trail file. 

In this case, because source and target are all in UTF-8 encoding. There should not be any character set conversion in Oracle GoldenGate. 
I discussed that there are four types of character sets related to Oracle GoldenGate processing:
  • Operating System Character Set
  • Terminal Character Set
  • DB Character Set, DB N-Charset
  • DB Client/Session Character Set
In this blog, let me show you how to find all the character set information, except the terminal character set information.
0 Comments



Leave a Reply.

    Oracle GoldenGate

    This blog has updates, tips and tricks for Oracle GoldenGate.

    Categories

    All
    12.1 New Feature
    12.2 New Feature
    12.3 New Feature
    Azure
    Basic Concepts
    Best Practices
    Cloud
    Customer Story
    DB2 For ISeries
    DB2 For LUW
    DB2 For Z/OS
    Disaster Recovery
    Globalization
    GoldenGate Fundamentals
    GoldenGate Security
    How To
    HP NonStop
    Informix IDS
    Installation
    JD_Edward
    Manager
    MySQL
    Network
    News
    Oracle DB
    Release
    SQL Server
    Sybase
    Teradata
    Top
    Troubleshooting
    Tutorial
    Use Case
    User Story

    Archives

    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    May 2016
    April 2016
    March 2016
    February 2016
    December 2015
    November 2015
    October 2015
    July 2015
    June 2015
    May 2015
    March 2015
    February 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    October 2013

    RSS Feed

Copyright © 2010-2027 Jinyu Wang.
✕