What you need to configure Oracle Wallet for database monitoring collectors
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.
In this article...
When configuring Oracle Wallet for database monitoring collectors, you will need to:
Create Oracle Wallet files on your database server
Configure Oracle Wallet files on your Database Agent host machine
How do I create Oracle Wallet files on my database server?
From the database server:
Create a secure folder for the Oracle wallet mkdir -p <ORACLE_HOME>/product/11.2.0.4/owm/wallets/
Give permissions to the folder chmod -R 700 <ORACLE_HOME>/product/11.2.0.4/owm/wallets
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
Configure and confirm the password
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/))
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>
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:
Copy the wallet file created above (Step 3 of how to configure Oracle Wallet for BD server machine)
Create a Collector on the Controller for DB as Oracle and configure the Oracle Collector
Check the Enable Oracle wallet from the Controller UI
NOTE | Do not provide the database password details when you configure the Collector
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
Run the database agent
These steps should correctly configure your Oracle Wallet database server monitoring.
... View more