This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Oracle SQL Query

Hi,

I'm trying to create a SQL Query to monitor amount ou record inside a particular table of my Oracle DB.

Unfortunatly when i declare un "ADO - User Experience (SQL Query) Wizard" my monitor it reply

"An error occurred while communicating with the Database Server: Could not locate any tables."

Another monitor "ADO (SQL Connect)" on the same db is working perfectly.

Any idea ?

  • Hi BackDoor,


    The ADO (SQL Connect) Monitor will simply connect to your SQL server installation, login and then disconnect.  On the other hand, the ADO - User Experience (SQL Query) Monitor will connect, login, perform the specified query, expect specified results and disconnect.  Having that said, as you are getting an error such as "Could not locate any tables", I would presum that the Credential you have assigned to the Monitors is a valid Oracle account, however, it does not appear to have permission to the database you are attempting to query.  Having that said, I recommend reviewing the security settings on that account in order to ensure that it has at least read access to the database in question.


    Hope this helps.


    Chris Foley