7.2 Creating the Oracle Wallet

Perform the following steps to create the Oracle Wallet and to add the password that the Oracle Management agent uses to connect to the Oracle GoldenGate agent to receive metric values. This is applicable for the Oracle GoldenGate classic instance only as the Oracle GoldenGate monitoring agent (jAgent) is used by classic instance.

To create the Oracle Wallet:

  1. Navigate to the OGG_AGENT_ORA_HOME directory.

    Note:

    Oracle GoldenGate 12c (12.1.2.0.0) introduced the storing of passwords for extract and replicats in Oracle Wallets. However, both the Oracle GoldenGate core replication and Oracle GoldenGate monitoring agent wallets cannot reside in the same location. If both Oracle GoldenGate core and the Oracle GoldenGate monitoring agent are using the Oracle Wallet then Oracle GoldenGate core must use a non-default location. This configuration can be set by using the GLOBALS parameter WALLETLOCATION.

  2. Run the appropriate pw_agent_util script using the runtime argument specifying that you’re using only the Java agent (and not Oracle GoldenGate Monitor Server):
    • Windows: Go to the command line and enter Shell> pw_agent_util.bat -jagentonly
    • UNIX: Enter the command Shell>./pw_agent_util.sh -jagentonly

    If a wallet doesn't exist, then one is created.

  3. Enter and confirm the Oracle Enterprise Manager agent password when you see this prompt:

    Please create a password for Java Agent:

    Please confirm password for Java Agent:

    Attention:

    If a wallet already exists in the dirwlt directory, a message is returned and the utility stops. If this happens go to the next step.

  4. Optional: Run the utility to create the JAgent password by entering one of the following commands. (Note that the command options are not case sensitive):

    Caution:

    Only perform this step if the wallet already exists in the dirwlt directory.
    • Windows: Go to the command line and enter: Shell> pw_agent_util.bat -updateAgentJMX
    • UNIX: Enter the command Shell> ./pw_agent_util.sh -updateAgentJMX