Setting up AppDynamics for Oracle 9i

[spavin]

I'm experiencing some issues in getting AppDynamics to monitor an Oracle DB.

I'm getting an error: ORA-02003: invalid USERENV parameter

I have installed the Controller  (Version 4.0.0.1 / Build 17-4.0.0.next) and DB agent  (4.0.0.0).

DB version is: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

I created a new user for the agent:

CREATE user appddbmon IDENTIFIED BY password default tablespace users temporary tablespace temp;

GRANT CONNECT, SELECT ANY DICTIONARY, resource to appddbmon;

The user has access to V$SESSION, and can create tables, so access should be fine. I can connect from the agent/controller too, using SQL Developer.

I googled the error, and found a page that said:

"You tried to call the USERENV function, but specified an invalid parameter."

Somone using Tableau had a similar error and thought it might be related to the DB version.

Has anyone else come across this?  

Does AppDynamics support Oracle 9i?

[Arun_Dasetty]

Hi,

We have come across same issue in one of the customer environments and we see this is known issue, we apologize for the incovenience caused, let us know if the following information helps:

"Customer is facing the issue while configuring the Oracle 9i to monitor with the DB agent.

With the default driver embedded in DBAgent(oracle-jdbc-7.jar), the following error is raising.

• - - -
  java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

With the enclosed driver (ocjdbc6.jar related Oracle 11g and trying to connect to Oracle 9i) the following error is raising.

• - - -
  java.sql.SQLSyntaxErrorException: ORA-02003: invalid USERENV parameter"

Dev team comments on internal request "Known issue. Oracle 12c driver is not backwards compatible. A Future release will use the correct driver. We will need to work around this issue manually. You need to back up the 12c driver. Get the correct version and copy the file over."

Regards,

Arun

[spavin]

Thanks for the quick reply, Arun.

I downloaded various 10g, 11g and 12c drivers from the official Oracle site  and tried them all out. Unfortunately, I either can't load the drivers, or I get the same error.

Do you know specifically which driver I need to use?