Prework for the demonstrations
Create and activate a configuration
Before you run the basic demonstrations, have the following items available.
You will replicate splex.demo_src from the source system to splex.demo_dest on the target system. These tables are installed by default into the SharePlex schema, which in these demonstrations is "splex." Your SharePlex schema may be different. Verify that these tables exist.
Column Name | Data Type | Null? |
NAME | varchar2(30) | |
ADDRESS | verchar2(60) | |
PHONE | varchar2(12) |
|
The following are instructions for starting SharePlex and the sp_ctrl command-line interface on Windows systems. Start SharePlex on the source and target systems.
To start SharePlex on Windows systems
SharePlex gets its replication instructions from a configuration file, which defines the objects that are to be replicated. The file specifies following:
Note: This demonstration demonstrates replication from one database to another. It does not cover replication to a file or a messaging container.
Perform these steps on the source system. The demonstration objects are assumed to be in the schema named splex.
Run sp_ctrl.
Issue the following command to create a configuration file named sample_config in the default text editor.
sp_ctrl(source)> create config sample_config
In the text editor, build your configuration file based on the appropriate template, as shown in the Configuration templates. Allow no spaces between the characters in a component (source specification, target specification, routing map), and place at least one space between each component.
In sp_ctrl, verify that the configuration file will activate successfully.
sp_ctrl(source)>verify config sample_config
datasource:o.source_SID | ||
splex.demo_src |
splex.demo_dest |
target_system@o.target_SID |
where:
datasource:o.source_SID | ||
splex.demo_src |
splex.demo_dest |
target_system@r.database_name |
where:
Perform these steps on the source system. When you activate a configuration, SharePlex is ready to capture transactional changes that are made to the specified source data.
Activate the configuration.
sp_ctrl(source)> activate config sample_config
Note: Configuration names are case-sensitive.
Confirm that the configuration activated successfully. The name sample_config should appear under File Name, and the word Active should appear under State.
sp_ctrl(source)> list config
If your configuration activation fails, isue the view config sample_config command to view the file. Compare it to the template and make sure all of the information you entered is correct. Make certain you specified the correct database identifier. Check your syntax for extra spaces or missing components.
Because the configuration file is not active, you can edit it directly with the following command:
sp_ctrl(source)> edit config sample_config
Save the changes, then re-try the activation.
Note: To change an active configuration, you must copy it to a new file first, and then edit and activate the copy. For more information, see Add or change objects in an active configuration in the SharePlex Installation and Setup Guide.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center