UPDATE_REPLICATION_SERVER

This procedure changes the settings for a replication server configuration.

Note the following restrictions for changing replication server parameters:

The configuration does not retain the sbt_parms string from the original CREATE_REPLICATION_SERVER call. If you change any parameter other than max_streams, then you must pass in this value.

Changing any setting other than max_streams requires replication to be paused, which you can achieve by calling PAUSE_REPLICATION_SERVER.

Parameters other than sbt_parms whose values are null remain unchanged, except as noted in the following parameter descriptions.

Syntax

PROCEDURE update_replication_server (
   replication_server_name IN VARCHAR2,
   sbt_so_name IN VARCHAR2 DEFAULT NULL,
   sbt_parms IN VARCHAR2 DEFAULT NULL,
   max_streams IN NUMBER DEFAULT dbms_ra_misc.number2null('p4'),
   catalog_user_name IN VARCHAR2 DEFAULT NULL,
   wallet_alias IN VARCHAR2 DEFAULT NULL,
   wallet_path IN VARCHAR2 DEFAULT dbms_ra_misc.varchar2null('p1'),
   proxy_url IN VARCHAR2 DEFAULT dbms_ra_misc.varchar2null('p2'),
   proxy_port IN NUMBER DEFAULT dbms_ra_misc.number2null('p3'),
   http_timeout IN NUMBER DEFAULT NULL,
   comments IN VARCHAR2 DEFAULT NULL);

Parameters

Table 57 UPDATE_REPLICATION_SERVER Parameters

Parameter	Description
`replication_server_name`	The name of the replication server configuration to update. This value is converted to upper-case before storing.
`sbt_so_name`	See `CREATE_REPLICATION_SERVER`.
`sbt_parms`	See `CREATE_REPLICATION_SERVER`.
`max_streams`	See `CREATE_REPLICATION_SERVER`. If you do not specify this parameter, then the Recovery Appliance retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value.
`catalog_user_name`	See `CREATE_REPLICATION_SERVER`.
`wallet_alias`	See `CREATE_REPLICATION_SERVER`.
`wallet_path`	See `CREATE_REPLICATION_SERVER`. If you do not specify this parameter, then the Recovery Appliance retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value. Path must start with `file:` .
`proxy_url`	See `CREATE_REPLICATION_SERVER`. If you do not specify this parameter, then the Recovery Appliance retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value.
`proxy_port`	See `CREATE_REPLICATION_SERVER`. If you do not specify this parameter, then the Recovery Appliance retains the existing value. If you specify a value (including null), then the Recovery Appliance sets the new value.
`http_timeout`	See `CREATE_REPLICATION_SERVER`.
`comments`	Optional user supplied comment describing reason for executing this command.