Splunk AppDynamics

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

CommunityUser
Splunk Employee
Splunk Employee

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

Labels (1)

CommunityUser
Splunk Employee
Splunk Employee

Hi,

Were you able to resolve the issue with the help from the procedure that @Anonymous 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

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Hello,

I had the same problem and solved it by granting to user appropriate roles as described in AppDynamics documentation:
https://docs.appdynamics.com/appd/24.x/24.10/en/database-visibility/add-database-collectors/configur...



CREATE USER DBMon_Agent_User IDENTIFIED BY password
default tablespace users
temporary tablespace temp;

GRANT CREATE SESSION, SELECT_CATALOG_ROLE TO DBMon_Agent_User;

CommunityUser
Splunk Employee
Splunk Employee
the same problem, could you please share your solution if you have already found it?
0 Karma
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...