IIDR Oracle Agent Installation

For deployment model option 1, the IIDRClosed IBM Infosphere Data Replication. This is a solution to efficiently capture and replicate data, and changes made to the data, on relational source systems. Used to move data from DataBases to the In-Memory Data Grid. source database agent should be installed on a source database server.

The following instructions should be followed to complete the installation for the IIDR Oracle Agent.

 

  1. Login to the Oracle server mcahing as gsods OS user

  2. Create a directory where the IIDR Agent software will be installed.

  3. mkdir -p /home/gsods/iidr
    cd /home/gsods/iidr
  4. Download the IIDR Oracle Agent to the newly created directory of /home/gsods/iidr

  5. The downloaded file should then be used in the setup using the following command (example Agent version used is 11.4.0.4:

  6. setup -iidr-11.4.0.4-5629-linux-x86.bin
  7. Ensure that the DISPLAY environment is not set

  8. unset DISPLAY
  9. Begin the IIDR Oracle installation:

  10. chmod u+x setup-iidr-11.4.0.4-5629-linux-x86.bin
    ./setup-iidr-11.4.0.4-5629-linux-x86.bin
  11. Select the Locale (language)

  12. Preparing to install
    Extracting the JRE from the installer archive...
    Unpacking the JRE...
    Extracting the installation resources from the installer archive...
    Configuring the installer for this system's environment...
    					
    Launching installer...
    ===============================================================================
    Choose Locale...
    ----------------
         1- Deutsch
       ->2- English
         3- Español
         4- Italiano
         5- Português  (Brasil)
    					
    CHOOSE LOCALE BY NUMBER: 2
  13. Select "Install new product"

  14. Introduction
    InstallAnywhere will guide you through the installation of IBM InfoSphere Data
    Replication 11.4.0.4
    Respond to each prompt to proceed to the next step in the installation.  If
    you want to change something on a previous step, type 'back'.
    						
    You may cancel this installation at any time by typing 'quit'.
       ->1- Install new product
         2- Upgrade existing product
    						
    ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 1
  15. Select Datastore Type: Oracle (option 8):

  16. Select the IIDR Offering "IBM InfoSphere Data Replication" (option 4):

  17. Choose the installation folder /home/gsods/iidr/iidr-oracle
  18. Accept the license agreement, by entering 1:
  19. Click enter, to select to keep the default Instance Folder of IIDR to be under /home/gsods/iidr/iidr-oracle

  20. Review the Pre-Installation Summary carefully and then press Enter to start the installation. Note: This will start the full installation.

  21. Upon a successful installation, the following message is displayed:

  22. The Configuration Tool will be launched to configure a new instance of the Oracle Agent.  You must provide a name for the new agent instance, in the example below ORACLE is used:

  23. Accept the default port 11001

  24. Change the Staging Store Disk Quota from the default of 100GB to 1GB

  25. Accept the default max memory of 1024MB

  26. Select [n] for a read-only database connection

  27. Select [n] for archive-only mode

  28. Select option 1 - Manage Encryption Profile

  29. Select option 1 - Add encryption profile:

  30. Enter the name profile 1 for the encryption profile name.

  31. Select option 2 - Disabled - for the above encryption file:

  32. Select Enter for the no-private key store option:

  33. Enter the default path of the trust store:

  34. Enter the default password to encrypt the trust store:

  35. Select JKSClosed A Java keystore (JKS) file is a secure file format used to hold certificate information for Java applications. as the trust store type (this is the default option 1):

  36. Complete the encryption profile definition by selecting option 4 - Completed management of encryption profiles:

  37. On the following screen, the newly created encryption profile is displayed. Select option 1 of the encryption profile -profile1:

  38. Select [n] not to use JMS.

  39. Enter the full path to ORACLE_HOME (in this example - /u01/app/oracle.product/19.0.0/dbhome_1):

  40. Enter the full path of the tnsnames.ora file.  By default it is located under $ORACLE_HOME/network/admin:

  41. Select tns alias from the list that connects to the local database, for example ORCL:

  42. Select [y] for advanced parameters configuration:

  43. Select NONE (default) for the JDBCClosed Java DataBase Connectivity. This is an application programming interface (API) for the Java programming language, which defines how a client may access a database. parameters.

  44. Select [n] (default) for the Kerberos authentication.

  45. Select [n] (default) for database login credentials from an extgernal secret source:

  46. Enter the username GSIIDR and the password:

  47. Select the GSIIDR schema number from the list. The GSIIDR schema holds the IIDR objects),

  48. Select [n] to replicate encrypted columns:

  49. Select Local log reading (option 1) for the IIDR Oracle Agent configuration mode:

  50. Review the summary and start the Oracle IIDR Agent instance:

  51. Review the existing instances:

  52. Select Exit (option 6) to complete the setup:

  53.