Siebel Database Upgrade Guide > Implementing Siebel High-Availability Upgrade Using Oracle GoldenGate to Upgrade to the Current Release >
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
- 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
- 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:
Table 41. Oracle GoldenGate Source Server Files and Directories
|
|
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 42 for a description of some of the target server files and directories.
Table 42. 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 41 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 the 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.
|