Adding a Database (Oracle Source)

  1. Connect to SQDR Control Center with a browser as described in Connecting to SQDR Control Center (SQDR Manager).

  2. Logon as user SQDR, using the Launch Agent Control Database (Derby) password as supplied during installation.

  3. Select Add Database from the Databases drop-down menu.

  1. Choose the appropriate source database type (Oracle) and select Continue. You will see the following screen:

  1. Enter the following values:

  1. Select the Next button. If you are using Oracle 11g, or Oracle 12c that is not configured as a multitenant container database (CDB), you will see the following screen, you will see the following screen:

If you are using an Oracle 12c database that is configured as a multitenant container database (CDB), you will see the following screen:

Enter the following values:

  1. Select the Next button and configure the logging and optional email notification values. You can leave these fields blank during the installation and configure the email notification feature at a later time.

  1. Select Next to create the Agent. This operation may take a while.

  2. When you see a plus sign next to Databases, expand Databases and select the new database. If you are connecting to an Oracle 12c multitenant container database (CDB), you will see two or more agents: a parent agent that connects to the root container, and a subagent for each PDB (pluggable database) that you wish to connect to. Be sure to start the PDB subagent; you will be working primarily with the PDB subagent.

  3. Choose Start/Restart Agent from the Database drop-down menu.

Selecting Start/Restart Agent creates the Staging Agent on the SQDR Plus system, and creates configuration tables and stored procedures on the source system. This process may take several minutes; a green checked icon will appear next to the database name when the process is complete. If the icon remains red, additional troubleshooting may be required before proceeding.

  1. The Agent User (e.g. SQDR) needs certain privileges for the tables that will be replicated. The easiest way to grant these privileges is to publish the tables, as described in Publishing. In the case of an Oracle 12c multitenant container database (CDB), create the publications in the PDB subagent.