Java (Java Agent, Installation, JVM, and Controller Installation)

cancel
Showing results for 
Search instead for 
Did you mean: 

DB Collector error: ORA-00942: table or view does not exist

Highlighted
Builder

DB Collector error: ORA-00942: table or view does not exist

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

 

DB Collector error: ORA-00942: table or view does not exist
3 REPLIES
Creator

Re: DB Collector error: ORA-00942: table or view does not exist

the same problem, could you please share your solution if you have already found it?
Creator

Re: DB Collector error: ORA-00942: table or view does not exist

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;

Community Manager

Re: DB Collector error: ORA-00942: table or view does not exist

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

 

 


Thanks,
Radhika P




Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.