Hello
I am trying to setup Orabbix for Oracle 11G, however I keep getting error oracle.jdbc.driver.T4CConnection is closed
Using SQLPLUS I can run the queries with no issue, all I can think of is that the JDBC driver connection has a problem.
My connection settings look like this:
I’ve tried using the IP address instead of the name. The hostname is definitely resolving…
Any suggestions are welcome…
Thanks,
Damian
From the log file:
I am trying to setup Orabbix for Oracle 11G, however I keep getting error oracle.jdbc.driver.T4CConnection is closed
Using SQLPLUS I can run the queries with no issue, all I can think of is that the JDBC driver connection has a problem.
My connection settings look like this:
CPCS2.Url=jdbc
racle:thin:@hostname.mynetwork.com:1521:CPCS2
racle:thin:@hostname.mynetwork.com:1521:CPCS2
Any suggestions are welcome…
Thanks,
Damian
From the log file:
2010-08-12 08:49:20,378 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbblockgets statement is select to_char(sum(decode(name,'db block
gets', value,0))) "block_gets" FROM v$sysstat
2010-08-12 08:49:20,378 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query =dbblockgets Error returned is java.sql.SQLException:
Connection oracle.jdbc.driver.T4CConnection@19b1de is closed.
2010-08-12 08:49:20,378 [pool-1-thread-1] WARN Orabbix - I'm going to return for query dbblockgets
gets', value,0))) "block_gets" FROM v$sysstat
2010-08-12 08:49:20,378 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query =dbblockgets Error returned is java.sql.SQLException:
Connection oracle.jdbc.driver.T4CConnection@19b1de is closed.
2010-08-12 08:49:20,378 [pool-1-thread-1] WARN Orabbix - I'm going to return for query dbblockgets