Giving additional user privileges for tables in Oracle EBS v12.1.3
For monitoring Oracle EBS v12.1.3, the following user privileges will be required to query data from the database:
- CONNECT role.
- SELECT_CATALOG_ROLE role.
- SELECT ANY TABLE role
The following commands can be executed in order to grant the above mentioned roles to the user.
- GRANT CONNECT TO user;
GRANT SELECT_CATALOG_ROLE TO user;
GRANT SELECT ANY TABLE TO user;
Note - The "user" mentioned in the above commands refers to the username of the user configured in Applications Manager for monitoring.
If the issue still exists, reach out to our support with the screenshot of the error obtained to appmanager-support@manageengine.com along with the latest Support Information File (SIF) from Applications Manager with print all logs enabled for analysis.
New to ADSelfService Plus?
Related Articles
How to import certificates for monitoring Oracle database with SSL authentication?
For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...Monitoring Oracle standby databases in Applications Manager
Do we support Oracle Standby Database monitoring? Yes, we do. How to connect to the Standby/Standalone Oracle database which is in MOUNTED mode? To connect to an Oracle database in STANDBY MOUNTED or normal MOUNTED mode, you must use the sysdba user ...The Oracle monitor is not working / The Oracle monitor is not collecting any data. What can I do?
Reason 1 - This could be because the Oracle user provided in Applications Manager does not have the necessary permission to run the query Go to <AppManager/logs> directory and check if you have an error print in stderr.txt / stderr.txt.1 / ...Data collection is not happening in my Oracle EBS monitor.
Error: org.xml.sax.SAXParseException; lineNumber: 1; Missing whitespace before SYSTEM literal URI. Note: We have supported only the following versions of E-Business Suite Version 11i, 12.0, 12.2.0 You can use the following URLs to verify the data for ...Troubleshooting Hyper-V-Cluster data collection
In Hyper-V clusters, the data is collected via WMI. So if any of data is not retrieved properly in the UI, you can check and troubleshoot by executing the VBScript. 1) Go to Applications Manager's installed directory and navigate to the path ...