OCI Stack Monitoring: EBS Database Discovery Fails with Error User lacks CREATE SESSION privilege; logon denied
(Doc ID 3011441.1)
Last updated on APRIL 12, 2024
Applies to:
OCI Stack Monitoring - Version N/A and laterInformation in this document applies to any platform.
Symptoms
On OCI Stack Monitoring, EBS Database Discovery Fails with ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied.
/agent_inst/log/mgmt_agent.log
[Executor.1292 (oracle_ebs_conc_mgmt_service.EBS_Test_ConcurrentProcessing:ConcurrentRequestsByStatus)-1794] INFO - MetricCollectionError =
{"type":"MetricCollectionError","specversion":"1.0","source":"mgmtagent:sourceId#oracle_ebs_conc_mgmt_service.EBS_Test_ConcurrentProcessing","id":"mgmtagent:sourceId#oracle_ebs_conc_mgmt_service.EBS_Test_ConcurrentProcessing:04f7d941-6c7a-4d4f-83dc-b3ee424dfb5c","subject":"Error evaluating ConcurrentRequestsByStatus:ConcurrentRequestsByStatus - FetchletException: Failed to connect: java.sql.SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n","time":"2024-03-18T05:26:04.851Z","data":"FetchletException: Failed to connect: java.sql.SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n due to SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n","datacontenttype":"text/plain; charset=iso-8859-1","message":"Error evaluating ConcurrentRequestsByStatus:ConcurrentRequestsByStatus - FetchletException: Failed to connect: java.sql.SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n","alertSeverity":"SEVERITY_CRITICAL","sourceId":
{"type":"MetricCollectionError","specversion":"1.0","source":"mgmtagent:sourceId#oracle_ebs_conc_mgmt_service.EBS_Test_ConcurrentProcessing","id":"mgmtagent:sourceId#oracle_ebs_conc_mgmt_service.EBS_Test_ConcurrentProcessing:04f7d941-6c7a-4d4f-83dc-b3ee424dfb5c","subject":"Error evaluating ConcurrentRequestsByStatus:ConcurrentRequestsByStatus - FetchletException: Failed to connect: java.sql.SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n","time":"2024-03-18T05:26:04.851Z","data":"FetchletException: Failed to connect: java.sql.SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n due to SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n","datacontenttype":"text/plain; charset=iso-8859-1","message":"Error evaluating ConcurrentRequestsByStatus:ConcurrentRequestsByStatus - FetchletException: Failed to connect: java.sql.SQLException: ORA-01045: user <MONITORING_USER> lacks CREATE SESSION privilege; logon denied\n","alertSeverity":"SEVERITY_CRITICAL","sourceId":
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |