Update the Credentials
If you change the credentials of the monitoring user, for example MONCS
, to access the database or the monitoring user credentials to access the WebLogic Server in Oracle E-Business Suite due to a routine password change policy, then the credentials must be updated on the Oracle Management Cloud side for the corresponding entities to ensure proper functioning of the agents running on the Oracle E-Business Suite entity hosts.
Oracle Management Cloud for Oracle E-Business Suite environment uses three sets of credentials that may require an update if the user name or password changed after the first discovery:
- Credentials to access the Oracle E-Business Suite database from Oracle Management Cloud for metric collection. See Update Database Credentials for Metric Collection.
- Credentials to extract Oracle EBS Transaction Logs from the database. See Update Credentials on the Database Entity.
- Credentials to access the WebLogic domain from Oracle Management Cloud for metric collection. See Update WebLogic Server Credentials for Metric Collection.
Update Database Credentials for Metric Collection
From the Oracle Infrastructure Monitoring user interface, update the credentials for monitoring user, for example MONCS
, to access database for metric collection.
-
Navigate to Oracle Infrastructure Monitoring
>
Entity Home Page>
Oracle E-Business Suite composite entity home page. -
Click the down arrow next to the Actions menu, and select Update Monitoring Configuration.
The Update Monitoring Configuration page is displayed.
-
Select the Edit Credentials check box.
In the database credentials section, update the credentials of the monitoring user.
Click Save to save the changes.
-
You can verify the update by visiting the Discovery Job Status page.
Update Credentials on the Database Entity
If you change the credentials of the monitoring user, for example MONCS
, to access the database due to a routine password change policy, then the credentials must be updated in the agent credential store to ensure continued log collection from the database entity.
The credentials are defined in a JSON file and registered for log collection in the agent credential store of the agent running on the database host. When the credentials change, update the JSON file and the agent credential store.
-
Update the existing credentials JSON registered for log collection with the new credentials information. For example, for a database named
avdf_instance
and user name, password, and role asmoncs
,newsyspasswd
, andSYSDBA
respectively, the JSON file should contain:[{ "entity":"omc_oracle_db_instance.avdf_instance/orcl", "name":"LCAgentDBCreds", "type":"DBCredsNormal", "globalName":"AgentUserCredential", "usage":"LOGANALYTICS", "description":"DB Credentials", "properties":[{ "name":"USERNAME", "value":"CLEAR[moncs]" }, { "name":"PASSWORD", "value":"CLEAR[newsyspasswd]" }, { "name":"ROLE", "value":"CLEAR[SYSDBA]" }] }]
-
Register the new credential information with the agent credential store. Run the following command from the
<AGENT_BASE_DIR>/agent_inst/bin
location:./omcli add_credentials agent -credential_file <PATH_TO_CRED_JSON_FILE>
-
You can verify the update with the following command by specifying the path to the entity definition JSON file.
./omcli status_entity agent <PATH_TO_ENTITY_DEFINITION_FILE>
Refer to the sample entity definition file
omc_oracle_db_sample.json
for Oracle Database in Sample JSON Files (zip file) .
Update WebLogic Server Credentials for Metric Collection
From the Oracle Infrastructure Monitoring user interface, update the credentials of monitoring user to access WebLogic Server for metric collection.
-
Navigate to Oracle Infrastructure Monitoring
>
Entity Home Page>
Oracle E-Business Suite composite entity home page. -
Click the Members tab. Click the link on the Oracle E-Business Suite WebLogic Domain entity.
The WebLogic Domain entity home page is displayed.
-
Click the down arrow next to the Actions menu, and select Update Monitoring Configuration.
The Update Monitoring Configuration page is displayed.
-
Select the Edit Credentials check box.
Update the WebLogic Server entity credentials.
Click Save to save the changes.
-
You can verify the update by visiting the Discovery Job Status page.