Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide > Implementing Siebel High-Availability Upgrade with Oracle GoldenGate to Upgrades to Siebel CRM Version 8.1.1.x >

Extracting Oracle GoldenGate Files

The ZIP or tar files include a number parameter files and OBEY files, which can be used with Oracle GoldenGate software. For more information, see About Siebel High Availability Upgrade Files.

NOTE:  Some of the files are specific to a database platform. Depending on your database platform, database-specific ZIP or tar files must be used to extract the Oracle GoldenGate parameter files.

To extract compressed Oracle GoldenGate files

  1. From your dbsrvr directory, extract the files from the following ZIP or tar file:

    GoldenGateSIA782_SIA811_HA_Upg_*.*

  2. View the following files after extracting them:

    SIA8119/dbsrvr/COMMON

    • GoldenGateSIA782_SIA811_HA_Upg_ORA.zip (Windows only)
    • GoldenGateSIA782_SIA811_HA_Upg_DB2UDB.zip (Windows only)
    • GoldenGateSIA782_SIA811_HA_Upg_MSSQL.zip (Windows only)
    • GoldenGateSIA782_SIA811_HA_Upg_ORA.tar.gz (UNIX and Linux only)
    • GoldenGateSIA782_SIA811_HA_Upg_DB2UDB.tar.gz (UNIX and Linux only)
    • GoldenGateSIA782_SIA811_HA_Upg_MSSQL.tar.gz (UNIX and Linux only)

      SIA8119/dbsrvr/GoldenGate/SIA782_811/SourceServer/GLOBALS

    • dirprm
      • d_782sia.prm
      • e_782sia.oby
      • e_782sia.prm
      • mgr.prm
      • p_782sia.oby
      • p_782sia.prm
      • s782sia_trandata.oby
      • siebelMacro.mac
    • dirrpt
      • extractReports
      • pumpReports

        SIA8119/dbsrvr/GoldenGate/SIA782_811/TargetServer/GLOBALS

    • dirprm
      • mgr.prm
      • r782_811.oby
      • r782_811.prm
      • siebelMacro.mac
    • dirrpt
      • replicatReports
  3. Assuming a directory structure illustrated in Step 2 .../SIA8119/dbsrvr/COMMON, run tar or extract the files to the following directory, depending on your operating system:
    • Windows. cd.../SIA8119/dbsrvr
    • UNIX. tar -xvf ./COMMON/GoldenGateSIA782_SIA811_HA_Upg_ORA.tar.gz

      See Table 40 for a description of the source server files and directories.

      Table 40. Oracle GoldenGate Source Server Files and Directories
      File or Directory Name
      Description
      Required or Optional Changes

      GLOBALS

      Global Parameters file for the Oracle GoldenGate processes. This is an empty file.

      You can add the required parameters for your environment.

      d_782sia.prm

      Parameters file for the Oracle GoldenGate executable defgen. This file contains the list of Siebel CRM version 7.8.2 tables from which data is extracted from the Siebel CRM version 7.8.2 database log file by Oracle GoldenGate.

      You can do the following:

      • Change the login information for the source database.
      • Change the table owner and schema name for the tables.
      • Add your custom tables (X_* tables).

      e_782sia.oby

      The OBEY file used to create the Oracle GoldenGate Extract process.

      You can do the following:

      • (Optional) Extract the file size.
      • (Optional) Add start command.

      e_782sia.prm

      The parameter file for the Oracle GoldenGate Extract process. This file contains the list of Siebel 7.8.2 application tables from which data is extracted from the Siebel 7.8.2 database log file by Oracle GoldenGate. The tables include the following:

      • Siebel Enterprise Integration Manager tables
      • Siebel repository tables
      • Other tables related to Siebel Remote log files and other similar files

      You can do the following:

      • (Optional) Report options.
      • Add custom tables designated by the (X_*) prefix.

      mgr.prm

      The parameter file for the Oracle GoldenGate Manager process. The same file is included in both source and target dirprm directories.

      You can do the following:

      • (Optional) Port and Port List numbers.
      • (Optional) other parameters.
      •  

      p_782sia.oby

      The OBEY file used to create the Oracle GoldenGate pump process.

      You can do the following:

      • (Optional) pump file size.
      • (Optional) Add the start command.
      •  

      p_782sia.prm

      The parameter file for the Oracle GoldenGate pump process.

      No changes required.

      s782sia_trandata.oby

      The OBEY file that contains the Oracle GoldenGate ADD TRANDATA command. Use this command to get a list of the tables whose data will be extracted from the Siebel database 7.8.2. This command also requests supplemental log information for the tables to be executed by the database server. For some tables, additional columns are included because those columns are required to populate the tables in the upgraded target database.

      You can do the following:

      • Change the login information for the source database.
      • Change the table owner and schema name for the tables.
      • Add custom tables added by the customer (X_* tables).

      siebelMacro.mac

      Contains the Oracle GoldenGate macros that are used to define the following:

      • Source database login information
      • Target database login information
      • Source database table owner and schema name
      • Target database table owner and schema name
      • Target server name
      • Target manager port number
      • Primary language for the source Siebel database

      These macros are used in the parameter files for the Extract process, pump, and Replicat process. For more information, see Oracle GoldenGate Macros.

       

      extractReports

      The directory where the report files for the Extract process are stored.

      Ensure that this directory is created in the dirrpt directory of Oracle GoldenGate on the source server.

      pumpReports

      The directory where the report files for the pump process are stored.

      Ensure that this directory is created in the dirrpt directory of Oracle GoldenGate on the source server.

See Table 41 for a description of the target server files and directories

Table 41. Oracle GoldenGate Target Server Files and Directories
File or Directory Name
Description or Usage
Changes to Make

GLOBALS

Global parameters file for the Oracle GoldenGate processes. This file has only one line, which is required: checkpoint table GGS_CHECKPOINT.
  • (Optional) Add the required parameters for your environment.
  • Change the checkpoint table name if you have a defined checkpoint table with any other name.
  • Add a checkpoint table in the target database by using the command:
    ADD CHECKPOINTTABLE <table owner name>.GGS_CHECKPOINT

mgr.prm

The parameters file for the Oracle GoldenGate Manager process. This file is included in both the source and the target dirprm directories.
  • (Optional) provide the port and the post list numbers.
  • (Optional) provide the other required parameters.

r782_811.oby

The OBEY file to create the Oracle GoldenGate Replicat process.

(Optional) Add the start command.

r782_811.prm

This file contains the list of Siebel SIA 8.1.1 tables for which the transaction data that was extracted from Siebel 7.8.2 SIA database is replicated in the target Siebel 8.1.1 SIA database. applying the required upgrade logic to the table.
  • (Optional) Add the report options.
  • Add any additional upgrade logic for Siebel database tables and custom tables (X_*).

siebelMacro.mac

Contains the Oracle GoldenGate macros that define following:

  • Source database login information
  • Target database login information
  • Source database table owner and schema name
  • Target database table owner and schema name
  • Target server name,
  • Target manager port number
  • Primary language for the source Siebel database

This file has the same values as the file on the source server. See Table 40 for more information.

These macros are used in the parameter files for the Extract, pump, and Replicat process.

You can copy the file from the instance of Oracle GoldenGate on the source database after the macro values have been changed for this file in the source server.

 

replicatReports

The directory where the report files for the Replicat process are stored.

Ensure that this directory is created in the Oracle GoldenGate dirrpt directory on the target server.

.

NOTE:  The standard Siebel upgrade process, described in this guide, does not use the ZIP files, tar files, or the extracted files and directories. Oracle GoldenGate software does not use the ZIP files, tar files, extracted files, and directories directly. These files must be located in the dirprm directory for the Oracle GoldenGate software installation.

The extracted files must be copied to the dirprm directory in the Oracle GoldenGate software installation and modified to reflect your environment. For example, modify the following: database login and password information, table owner and schema names, port numbers and the target server name and so on. Make sure that the directories mentioned above have been created under dirrpt directory where Oracle GoldenGate software has been installed.

Oracle GoldenGate Macros

The Oracle GoldenGate macros identify the following:

  • Source database table owner and schema name.
  • Target database table owner and schema name.
  • Source database login and password information.
  • Target database login and password information.
  • The remote host name. In other words, the server name where the Oracle GoldenGate instance for the target database is located.
  • The port number used by the Oracle GoldenGate Manager process for the Oracle GoldenGate instance in the target database.
  • Optionally, the macro determines the string value for the DB_LAST_UPD_SRC column in the target database.
  • The language code for the primary language of your Siebel CRM installation on the source database.
    
Siebel Database Upgrade Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.