Upgrade Tech Stack for Source Application

1. Download Oracle Database Server Enterprise Edition 19C from Oracle Software Delivery Cloud to a temporary directory.
2. Upgrade the database to 19C.

1. Download the Oracle Java Development Kit (JDK) 1.8 version (for example: JDK 1.8.0.291) from Oracle Technology Network to a temporary directory.
2. Upgrade the JDK to JDK 1.8.0 (291).

1. Rename the current GoldenGate Home directory.
2. Download Oracle GoldenGate 19.1 from Oracle Software Delivery Cloud to a temporary directory. See Install GoldenGate for details.
3. Install Oracle GoldenGate in a customized location within the source database server. Use the same directory name as for the previously installed GolgenGate Home.

   Example: </u01/ouaw/goldengate>

   Note: This will be referred to as Oracle GoldenGate Home.

GoldenGate Monitor Agent Installation Steps:

1. Rename both the GoldenGate Monitor Agent and the GoldenGate Monitor Agent instance homes.

2. Download Oracle GoldenGate Monitor Agent 12.2.1.2 from Oracle Software Delivery Cloud to a temporary directory.

3. Choose "Oracle GoldenGate Monitor Agent" as the installation type when installing onto a customized location. Use the same directory name as for the previously installed GolgenGate Monitor Agent home.

   Example: </u01/ouaw/oggagent>. 

   Note: This location will be referred to as Oracle GoldenGate Monitor home.

1. Download and apply patch 26982776 from My Oracle Support to Oracle GoldenGate Monitor Agent.

2. Set the ORACLE_HOME to the Oracle GoldenGate Monitor Agent home install location.

3. Unzip the patch, navigate to the patch top folder, and run the following:
   Copy

   $ORACLE_HOME/OPatch/opatch apply

Edit the configuration template:

1. Go to <Oracle GoldenGate Monitor Agent home>/oggmon/ogg_agent/cfg_templates directory and open the Config.properties file.

2. Modify the parameters using the following values:

   ACTUAL: jagent.host=localhost
   CHANGE TO: jagent.host=<<actual hostname on which Oracle GoldenGate is installed>>

   ACTUAL: monitor.jmx.username=oggmsjmxusr
   CHANGE TO: monitor.jmx.username=jmx_src

   ACTUAL: jagent.username=oggmajmxusr
   CHANGE TO: jagent.username=<<Oracle GoldenGate software installed OS user>>

   ACTUAL: jagent.rmi.port=5559
   CHANGE TO: jagent.rmi.port=5557 (or any free port other than the one on which the rmiregistry is started)

   ACTUAL: agent. type.enabled=OGGMON
   CHANGE TO: agent.type.enabled=OEM

Create the GoldenGate Monitoring Agent instance:

1. Navigate to <Oracle GoldenGate Monitor home>/oggmon/ogg_agent.
2. Run the createMonitorAgentInstance.sh script. Example execution:
   Copy

   
   cd <Oracle GoldenGate Monitor home>/oggmon/ogg_agent
   ./createMonitorAgentInstance.sh

3. When prompted, enter the following information:
   • Oracle GoldenGate home directory: <GoldenGate Home location>
   • Path to be used for Oracle GoldenGate Monitor Agent instance.

     Example: </u01/ouaw/ogginstance>.

     Note: This will be referred to as the Oracle GoldenGate Monitor instance home.

   • A unique name to replace the timestamp in the name of the file used to start the Oracle GoldenGate Monitor agent instance.

Create JAgent wallet:

1. Navigate to <Oracle GoldenGate Monitor Agent instance Home>/bin.
2. Add JAVA_HOME/bin to the PATH variable.
   Copy

   export JAVA_HOME=<JAVA HOME PATH>
   export PATH=$JAVA_HOME/bin:$PATH                            

3. Run the pw_agent_util.sh script. Example execution:
   Copy

   cd  <Oracle GoldenGate Monitor Instance>/bin
   ./pw_agent_util.sh -jagentonly 

4. Enter the Oracle wallet password. This password has to be entered as the password for the JAgent while running the OUAW installer.
5. Store the password for future reference.

1. In the command window, navigate to the Oracle GoldenGate Home directory.
2. Edit the GLOBALS file in the directory and add the following command: EnableMonitoring. Save the file.
3. Navigate to GoldenGate home and look for directories (dirprm, dirdat, dirrpt, and so on).

   If these directories do not exist, connect to the ggsci prompt and execute the statement below to create them.

   Copy

   export ORACLE_HOME=<ORACLE HOME>
   export PATH=$ORACLE_HOME/bin:$PATH
   ./ggsci
   CREATE SUBDIRS
   start mgr