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.
When configuring Oracle Wallet for database monitoring collectors, you will need to:
From the database server:
mkdir -p <ORACLE_HOME>/product/11.2.0.4/owm/wallets/
chmod -R 700 <ORACLE_HOME>/product/11.2.0.4/owm/wallets
Path - <ORACLE_HOME>/product/11.2.0.4/bin
sudo ./mkstore -wrl <ORACLE_HOME>/product/11.2.0.4/owm/wallets/oracle/ -create
sqlnet.ora
and add the newly created wallet locationvi <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/))
sudo ./mkstore -wrl <ORACLE_HOME>
/product/11.2.0.4/owm/wallets/ -createCredential <DB_HOST_NAME>:<DB_PORT> <user_name> <password>
sudo ./mkstore -wrl <ORACLE_HOME>/product/11.2.0.4/owm/wallets/ -listCredential
To configure Oracle Wallet for DBAgent Host machine:
NOTE | Do not provide the database password details when you configure the Collector
TrustStore Type- PKCS12 (default) OR SSO: enables auto-login.
TrustStore Password - password of Oracle Wallet
Username - username of the database
These steps should correctly configure your Oracle Wallet database server monitoring.