Configuration Parameter Reference

The Replication Agent configuration parameters table lists all of the Replication Agent configuration parameters and a brief description of each parameter. See Table 3. Password Parameters for a list and description of password parameters with their default values.

Replication Agent Configuration Parameters
Parameter Name	Description
admin_port	Port number that Replication Agent will use to listen for administrative connections.
asa_password	Identifies the password for Replication Agent System Database (RASD).
column_compression	Use minimal column information in LTL.
compress_ltl_syntax	Use abbreviated LTL syntax.
connect_to_rs	Enable/disable connection from LTI to Replication Server.
ddl_password	Password for ddl_username.
ddl_username	The database user name included in LTL for replicating DDL commands to the replicate database.
dump_batch_timeout	Number of seconds to wait before sending an incomplete LTL buffer to Replication Server.
filter_maint_userid	Log Reader filters operations with maintenance user ID.
function_password	Password for user ID passed in LTL with replicated stored procedure invocations.
function_username	User ID passed in LTL with replicated stored procedure invocations.
log_backup_files	Determines the number of log backup files kept in the log directory.
log_directory	Directory where Replication Agent system log file is located.
log_trace_verbose	Switch on/off verbose mode in trace log file.
log_wrap	Number of 1KB blocks written to log file before wrapping.
lr_max_lobdata_cache	Maximum size of LOB data cache for off-row LOB data.
lr_max_op_queue_size	Maximum number of operations permitted in the log reader operation queue during replication.
lr_max_scan_queue_size	Maximum number of log records permitted in the log reader log scan queue during replication.
lr_ntext_byte_order	Specifies which byte order to use when replicating NCLOB.
lr_send_trunc_partition_ddl	Determines whether truncate partition commands are sent as DDL or DML to the replicate database.
lti_batch_mode	Switches on/off LTI batch mode.
ltl_formatter_count	Number of threads in the LTL formatter that work concurrently on items in the LTI queue.
lti_max_buffer_size	Maximum number of change sets stored in the LTI input buffer.
lti_update_trunc_point	Number of LTL commands sent before LTI requests new LTM Locator.
ltl_batch_size	Size of the LTL batch buffer.
ltl_big_endian_unitext	Specifies whether unicode LOB data should be converted from little endian to big endian before sending LTL to Replication Server.
ltl_character_case	Case of database object names sent to Replication Server.
ltl_origin_time_required	Specifies whether to send origin_time command tag in LTL.
ltl_send_only_primary_keys	Controls whether Replication Agent sends only primary key columns data for the before image for update and delete operations.
ltm_admin_pw	Password for Replication Agent administrative port.
ltm_admin_pw_min_length	The minimum length of the Replication Agent administrator login password.
ltm_admin_user	User ID for Replication Agent administrative port.
max_ops_per_scan	Maximum number of operations Log Reader will read in a single log scan.
pdb_archive_path	Identifies the directory path where Replication Agent expects to find archived Oracle redo log files.
pdb_archive_remove	Enables or disables the removal of archived transaction log files from the path specified by pdb_archive_path.
pdb_auto_create_repdefs	If set to true, when tables and procedures are marked for replication, a replication definition is automatically created at Replication Server for that table or procedure.
pdb_automark_tables	Determines if Replication Agent automatically marks tables for replication during initialization or DDL replication.
pdb_auto_run_scripts	Automatic execution of SQL scripts used to create/remove transaction log objects and mark/unmark primary database objects.
pdb_convert_datetime	Converts native date/time formats to Sybase `datetime` format.
pdb_dflt_column_repl	Enables replication for LOB columns by default when table is marked.
pdb_dflt_object_repl	Enables replication by default when object is marked.
pdb_ignore_unsupported_anydata	Determines whether or not Replication Agent ignores data of unsupported datatypes stored in columns of type `ANYDATA`.
pdb_include_archives	Enables or disables the use of Oracle archive log files.
pdb_skip_missing_user	Determines whether or not Replication Agent skips the processing of any command for which there is no matching session or user information.
pdb_support_large_identifier	To support replication of large identifiers up to 255 characters in length with Replication Server 12.6 or later.
pdb_timezone_file	Specifies the file to read at Replication Agent initialization to obtain Oracle time zone information.
pdb_xlog_device	Name of the primary database device.
pdb_xlog_prefix	Character string prefix used to identify transaction log objects.
pdb_xlog_prefix_chars	Non-alphabetic characters allowed in pdb_xlog_prefix.
pds_connection_type	Type of connection to primary data server.
pds_database_name	Name of database replicated from the primary data server.
pds_host_name	Name of primary data server host machine.
pds_password	Password for user ID that Replication Agent uses to access the primary data server.
pds_port_number	Port number for the primary data server.
pds_retry_count	Number of times to retry connection to primary data server.
pds_retry_timeout	Number of seconds to wait between connection retry attempts.
pds_ssl_sc_dn	The distinguished name (DN) of the primary data server certificate.
pds_tns_connection	Oracle connection name found in the tnsnames.ora file which identifies the connection information for the primary database.
pds_tns_filename	Oracle file name identifying the Oracle tnsnames.ora file to be used to identify the connection information for the primary database.
pds_use_ssl	Indicates whether to use SSL to connect to the primary data server.
pds_username	User ID that Replication Agent uses to access primary data server.
ra_admin_device	The primary database device on which Replication Agent system objects are created.
ra_admin_instance_prefix	The prefix string used to identify Replication Agent system objects specific to one Replication Agent instance.
ra_admin_prefix	The prefix string used to identify shared Replication Agent system objects.
ra_admin_prefix_chars	Non-alphabetic characters that are allowed in the database object name prefix string that identifies Replication Agent system objects.
ra_admin_owner	The owner of all Replication Agent system objects, including shared and instance-specific system objects.
ra_retry_count	Number of times LTM attempts to get back to Replicating state after a failure.
ra_retry_timeout	Number of seconds to wait between LTM attempts to get back to Replicating state.
rasd_backup_dir	The directory path for Replication Agent System Database (RASD) backup files.
rasd_database	The directory path for the Replication Agent System Database (RASD) database file.
rasd_mirror_tran_log	Enables or disables Replication Agent System Database (RASD) transaction log mirroring.
rasd_trace_log_dir	The directory path for the Replication Agent System Database (RASD) trace log file.
rasd_tran_log	The directory path for the Replication Agent System Database (RASD) transaction log file.
rasd_tran_log_mirror	The directory path for the Replication Agent System Database (RASD) transaction log file mirror.
ra_standby	Determines whether or not Replication Agent functions in standby mode.
ra_statrack_interval	Determines the interval, in seconds, at which statistics are sampled.
rman_enabled	Indicates whether or not Replication Agent uses the Oracle RMAN utility to truncate old archive log files.
rman_password	Password used with rman_username to connect to the Oracle RMAN utility.
rman_username	Login name used with rman_password to connect to the Oracle RMAN utility.
rs_charset	Character set used to communicate with Replication Server.
rs_host_name	Name of primary Replication Server host machine.
rs_packet_size	Network I/O packet size for data sent to Replication Server.
rs_password	Password for user ID Replication Agent uses to access Replication Server.
rs_port_number	Port number for primary Replication Server.
rs_replicate_owner_required	Indicates if the owner is always included with the replicate table clause when generating replication definitions.
rs_retry_count	Number of times to retry connection to primary Replication Server.
rs_retry_timeout	Number of seconds to wait between connection retry attempts.
rs_source_db	Name of primary database identified to Replication Server.
rs_source_ds	Name of primary data server identified to Replication Server.
rs_ssl_sc_dn	The distinguished name (DN) of the Replication Server certificate and is only valid if rs_use_ssl is set to true.
rs_ticket_version	Determines whether Replication Agent records the primary database time or the primary database date and time into the rs_ticket marker.
rs_use_ssl	Indicates whether Replication Agent (as a client) should use SSL to connect to Replication Server.
rs_username	User ID that Replication Agent uses to access primary Replication Server.
rssd_charset	Character set used to communicate with RSSD.
rssd_database_name	Name of RSSD database.
rssd_host_name	Name of RSSD host machine.
rssd_password	Password for user ID that Replication Agent uses to access RSSD.
rssd_port_number	Port number for RSSD.
rssd_username	User ID that Replication Agent uses to access RSSD.
scan_fetch_size	Number of rows to fetch from the primary database when Oracle LogMiner is scanning the log in each network round-trip.
scan_sleep_increment	Number of seconds to increase Log Reader wait before next scan after finding no operations to replicate.
scan_sleep_max	Maximum number of seconds for Log Reader to wait before next scan after finding no operations to replicate.
skip_lr_errors	Determines whether Replication Agent ignores log record processing errors.
skip_ltl_errors	LTI ignores error messages returned by Replication Server.
ssl_identity_filename	Indicates the path to the Replication Agent instance identity file, a PKCS #12 file containing an asymmetric key pair used for SSL communication.
ssl_identity_password	The passsword to access a Replication Agent instance identity file.
ssl_certificates_filename	Indicates the path of the file containing Certificate Authority (CA) certificates included with the Replication Agent installation.
structured_tokens	LTI uses structured tokens when generating LTL output.
truncation_interval	Number of minutes to wait between automatic log truncations.
truncation_type	Methods of log truncation allowed.
use_rssd	Switches on/off access to RSSD for replication definitions.
use_ssl	Indicates whether clients must use SSL to connect to Replication Agent.