Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I configure Oracle Wallet authentication for database monitoring collectors?

Overview

This article provides detailed instructions for configuring Oracle Wallet for database monitoring collectors.

 

To learn more about Oracle collectors, connection details, and user permissions for Oracle, see Configure Oracle Collectors

 

Table of Contents

When configuring Oracle Wallet for database monitoring collectors, you will need to:

 

How do I create Oracle Wallet files on my database server?

From the database server: 

  1. Create a secure folder for the Oracle wallet
    mkdir -p <ORACLE_HOME>/product/11.2.0.4/owm/wallets/ 

  2. Give permissions to the folder
    chmod -R 700 <ORACLE_HOME>/product/11.2.0.4/owm/wallets 

  3. Create the wallet by specifying the secure folder path
    Path - <ORACLE_HOME>/product/11.2.0.4/bin
    sudo ./mkstore -wrl <ORACLE_HOME>/product/11.2.0.4/owm/wallets/oracle/ -create
     

  4. Configure and confirm the password

  5. Edit sqlnet.ora and add the newly created wallet location
    vi <ORACLE_HOME>/product/11.2.0.4/network/admin/sqlnet.ora
    SQLNET.WALLET_OVERRIDE = TRUE
    WALLET_LOCATION=(
    SOURCE=(METHOD=FILE)
    (METHOD_DATA=(DIRECTORY=<ORACLE_HOME>/product/11.2.0.4/owm/wallets/))


  6. Add the database credentials for the authenticated connection
    sudo ./mkstore -wrl <ORACLE_HOME>/product/11.2.0.4/owm/wallets/ -createCredential <DB_HOST_NAME>:<DB_PORT> <user_name> <password>

  7. List the wallet’s contents
    sudo ./mkstore -wrl <ORACLE_HOME>/product/11.2.0.4/owm/wallets/ -listCredential

 

How do I configure Oracle Wallet on my DBAgent Host machine?

To configure Oracle Wallet for DBAgent Host machine:

 

  1. Copy the wallet file created above (Step 3 of how to configure Oracle Wallet for BD server machine)

  2. Create a Collector on the Controller for DB as Oracle and configure the Oracle Collector

  3. Check the Enable Oracle wallet from the Controller UI

Note: Do not provide the database password details when you configure the Collector

  1. Enter the TrustStore location - location of the e-wallet file on the database Agent host 

               TrustStore Type- PKCS12 (default) OR SSO: enables auto-login.
               TrustStore Password - password of Oracle Wallet 
               Username - username of the database

 

  1. Run the database agent

 

These steps should result in Oracle wallet database server monitoring that is correctly configured.

Version history
Revision #:
7 of 7
Last update:
a month ago
Updated by:
 
Labels (1)


Found this article helpful? Click the Thumbs Up button.
Have an additional comment? Post it below.
0 Kudos