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 Golden Gate files

From your dbsrvr directory, extract the files from the following ZIP or tar file:
```
GoldenGateSIA782_SIA811_HA_Upg_*.*
```
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
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 the following table for a description of the 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 the following table for a description of some of the 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 the previous table 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 in this topic have been created under the dirrpt directory where Oracle GoldenGate software has been installed.