Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
06-07-2018 07:33 PM
I'm trying a trial installation and getting this error from the collector:
[DBAgent-4] 07 Jun 2018 19:24:53,151 ERROR ADBMonitorConfigResolver - Failed to resolve DB topological structure [<collector-name>].
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
I've already added PLAN_TABLE by running utlxplan.sql
How to find out more details on which table it is complaining about? Thx
09-21-2018 01:44 AM
09-21-2018 06:17 AM - edited 09-21-2018 06:18 AM
Hello,
I had the same problem and solved it by granting to user appropriate roles as described in AppDynamics documentation:
https://docs.appdynamics.com/display/PRO44/Configure+Oracle+Collectors
CREATE USER DBMon_Agent_User IDENTIFIED BY password
default tablespace users
temporary tablespace temp;
GRANT CREATE SESSION, SELECT_CATALOG_ROLE TO DBMon_Agent_User;
09-21-2018 09:10 AM
Hi,
Were you able to resolve the issue with the help from the procedure that @Bagdat.B suggested? If so, kindly mark that response as Accepted Solution so others can easily find answers. Please use the Accept as Solution button to do so.
Let us know if you are still looking for help on your inquiry.
Thank you
Radhika
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form