Installation and registration for instance
Describes installing and registering Instance.
1. Instance installation entry point
The users can view the Instance Management page by selecting the Instance Management tab.
At this point, the users can install and register an instance through the Instance Installation button on the top right.
2. Instance installation modal screen
The modal first screen of the Instance installation.
The users can choose between two methods.
Instance Installation
Select when the users want to install a new instance.
Instance Registration
If the users already have an installed instance, select it when the users want to register it with ProSync Manager.
3. Instance Installation and regstration
Select the tab that corresponds to the desired method to confirm.
Describes the instance Installation.
1. Installation Parameters
Enter basic information for installing the instance.
Instance ID
The ID for installing ProSync.
The value entered in this parameter must be in the form of Tablespace name and cannot start with a number.
Y
ProSync User
Sets the user name to be created in the Source and Target DB for ProSync operation.If Skip User Create is set to Y, the users must enter the user information the users want to designate as a ProSync user.
Y
Password
Sets the password for ProSync User.
Y
Source Skip TS Create
Does not create a tablespace in the Source DB to store data used for ProSync operation, but uses an existing tablespace. (Default: N)
N
Target Skip Ts Create
Does not create a tablespace in the Target DB to store the data used in the CreateProSync operation, but uses an existing tablespace. (Default: N)
N
TS Name
Sets the tablespace name to store the data used in the ProSync operation. (Default: [INSTANCE_ID]_ts)
N
TS File
Sets the tablespace file name to store the data used in the ProSync operation. (Default: [INSTANCE_ID]_ts.dtf)
N
TS Size
Sets the tablespace size to store the data used in the ProSync operation. (Default: 1G)
N
Skip User Create
Sets when using an existing user without creating a database user for the ProSync operation. (Default: N)
N
Target Min Privilege
Sets when performing only DML synchronization by granting minimal privileges to the Target DB user for the ProSync operation. If the users want to perform DDL synchronization, the users must grant the appropriate privileges later. (Default: N)
N
2. Source Database Information
Enter the information of the Source DB required when installing an instance.
Install User
This is the account used to access the Source DB for reviewing installation requirements and creating PRS_USER. It must have the required permissions for installation and is usually an account with system administrator privileges.
Y
Password
Inputs the password for Install User.
Y
Connection Check
Performs a connection check based on the information entered. Only if the connection is successful can the users perform the next step.
Y
Auto Add Sup Log
Sets whether ProSync automatically adds supplemental logs to the synchronization target table during the installation process. (Default: Y)
N
If the connection check is successful, the users'll see something like this.
This is an example of a failed connection check, and the users can see the error message by hovering over the info icon.
3. Select SyncList
The users can set the synchronization table for an Instance.
Add Sync Table
This is the button to adds list to enter synchronization table information.
N
Source Schema
Selects the schema of the source DB to be synchronized.
N
Source Table
Selects the table of the source DB to be synchronized.At this time, if the table is already specified in another instance belonging to the same Stream, it cannot be specified as a synchronization table, but if 'ALL' option is selected, it is specified as all tables belonging to that schema regardless of the synchronization tables of other instances.
N
Target Schema
The same applies to the schema of the selected source.
N
Target Table
The same applies to the table of the selected source.
N
The users can see the header of the list and the Delete button in each list.
The Delete button in the header resets the input and list count for all lists, and the Delete button in each list deletes the corresponding list.
In this case, the synchronization table the users specify has the same Source Schema/Table Name and Target Schema/Table Name, so Map Rules that specify different names are not applied.
So, to use a Map Rule, the users can either skip this step and not specify anything, or the users can specify it first and then modify it on the Mapping tab of the Instance Management page.
4. Target Database Information
Enter the information for the Target DB that is required when installing the instance.
Install User
This is the account used to access the Target DB for reviewing ProSync installation requirements and creating PRS_USER. It must have the required permissions for installation and is typically an account with system administrator privileges.
Y
Password
Inputs the password for Install User.
Y
Connection Check
Performs a connection check based on the information entered. The users can only perform the next step if the connection is successful.
Y
5. Process Information
Enter the information for the Process that will be used in the Instance.
Process
The name of the process to set.
Y
Agent Id
Selects the Agent ID to connect to the process from the Agents entered in the previous Stream registration step in order of CM-Failover.
Y
Process Port
Enters the port of the process to set.
Y (Except Ext)
The following is an example of setting up an Agent list.
6. Additional Information
Set for additional information during Instance installation.
Use TDE
A parameter to receive TDETDE_WALLET_PWD as manual input. (Default:N)
Waffle File Password
Enters TDE_WALLET_PWD to set when Use TDE is Yes.
Set LOG_DIR
A parameter to receive manual input of LOG_DIR of this instance.(Default: N)
LOG_DIR
Sets LOG_DIR If LOG_DIR is Yes, enter the LOG_DIR the users want to set. In this case, all processes (Ext and Apply, Llob) must share the same file path because the logs of all processes (Ext and Apply, Llob) are left in the location of this setting.
Set LOG_BACKUP_DIR
A parameter to receive manual input of the LOG_BACKUP_DIR of the instance.(Default:N)
LOG_BACKUP_DIR
Sets LOG_BACKUP_DIR If LOG_BACKUP_DIR is Yes, enter the LOG_BACKUP_DIR to set. At this time, backup logs of all processes (Ext and Apply, Llob) are left in the location of the corresponding setting value, so they must all share the same file path.
7. Instance installation completed Log
If the installation of the Instance was successful, the users should see this screen.
The following is an example of an Instance installation failure.
4. Main screen after completing instance registration
After successfully installing and registering the Instance, the users can see that it is registered on the main screen as shown below.
Last updated