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
- 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
- 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:
See Table 41 for a description of the target server files and directories
Table 41. Oracle GoldenGate Target Server Files and Directories
|
|
|
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.
|