Completing Section 1: Replication Agent Administration Information

Determine the Replication Agent administration information, and record it in Section 1 of the worksheet.

  1. Determine the instance type of the Replication Agent. This instance type indicates which primary database server the Replication Agent will work with.
    Instance types are:
    • oracle – Oracle Database Server. Replication Agent for Oracle must be installed on the same platform of UNIX or Microsoft Windows host as the primary Oracle instance. Direct access to the Oracle logs is necessary if pdb_archive_remove is true and rman_enabled is false. See the Replication Agent Reference Manual.

    • mssql – Microsoft SQL Server. Replication Agent for Microsoft SQL Server must be installed on a Microsoft Windows host from which it can directly access the primary Microsoft SQL Server transaction logs.

    • ibmudb – IBM DB2 Universal Database (UDB). Replication Agent for UDB must be installed on the same UNIX or Microsoft Windows host as the DB2 UDB server or the DB2 Administration Client.

    Record the instance type as item 1a in Section 1: Replication Agent Administration Information on the Installation and Setup Worksheet.

  2. Determine the name of the Replication Agent instance. This name should identify this specific instance.

    Record the name of the instance as item 1b in Section 1: Replication Agent Administration Information on the Installation and Setup Worksheet.

  3. Identify the client socket port number of the administration port for this Replication Agent instance. The port number must be unique on the Replication Agent host machine.

    If you are not the system administrator for the system on which you are installing the Replication Agent instance, ask the system administrator which port number you should use for the Replication Agent administration port. Port numbers have a range of 1 to 65,535.

    Record the port number as item 1c (admin_port) in Section 1: Replication Agent Administration Information on the Installation and Setup Worksheet. Replication Agent for Oracle, Replication Agent for Microsoft SQL Server, and IBM DB2 UDB each require two port numbers. The additional one is for the RASD. By default, Replication Agent assigns the RASD port—admin port +1. This number must also be unique on the Replication Agent host machine.

  4. Determine the location of the interfaces file (sql.ini on Microsoft Windows or interfaces on Linux and UNIX).

    Use this item only if you plan to use the isql or jisql utility. The interfaces file must reside on the same machine as the Replication Agent client (isql), not necessarily on the Replication Agent host machine.

    Record the interfaces file location as item 1d in Section 1: Replication Agent Administration Information on the Installation and Setup Worksheet.

  5. Determine the administrative user ID and password for logging in to the Replication Agent administration port. Use this information to create the administrative user ID during configuration and setup.

    See the Replication Agent Administration Guide.

    Record the administrative user ID as item 1e (ltm_admin_user) and the password as item 1f (ltm_admin_pw) in Section 1: Replication Agent Administration Information on the Installation and Setup Worksheet.

Related concepts
Replication Agent System Database
Related reference
Installation and Setup Worksheet