Archived Content: This information is no longer maintained and is provided "as is" for your convenience.
Summary
When the user runs "Check credential" for oracle database the connection fails
Error
The following error is logged in the probeMgr-patternDebug.log
... [DEBUG] [Thread-<xx>] - connection to ip=<x.x.x.x> by 'sql' protocol failed. error: java.lang.ClassNotFoundException: com.inet.ora.OraDriver
... [DEBUG] [Thread-<xx>] - connection to ip=<x.x.x.x> by 'sql' protocol failed. error: java.lang.ClassNotFoundException: com.inet.ora.OraDriver
Cause
This is a bug since the drivers or jar files needed to run Check credentials is not configured in the probe's environment path. The probe environment path can be located at <DDM DiscoveryProbe install path>\scripts\install\conf\WrapperEnv.conf
Fix
Follow the instructions below
Note: Also added drivers for Microsoft SQL as discussed in Document ID KM476885 - Error: "java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver"
1. Add or modify the following lines in WrapperEnv.conf file. This file can be located at <DDM DiscoveryProbe install path>\scripts\install\conf
# Define jdbc path in the Environment global vars section around line 30
set.jdbc =%root%/lib/collectors/probeManager/discoveryResources/db
# Define Oracle and MSSQL in the Environment Collectors Path section around line 79 and 80
set.ORACLE_CLASSPATH=%jdbc%/oracle/Seropto.jar
set.MSSQL_CLASSPATH=%jdbc%/mssqlserver/jtds-1.2.2.jar
# Add Oracle and MSSQL path in the Manager and Probe's class path as show in two lines below
set.COLLECTORS_LOCAL_CLASSPATH=%MAM_JARS%;%lib%/collectors;%MYSQL_CLASSES%;%ext%/silib.jar;%SAP_CLASSES%;%FLOW_CLASSES%;%SNMP_CLASSES%;%JMX_CLASSES%;%ORACLE_CLASSPATH%;%MSSQL_CLASSPATH%
set.COLLECTORS_PROBE_CLASSPATH=%MAM_JARS%;%lib%/collectors;%MYSQL_CLASSES%;%ext%/silib.jar;%SAP_CLASSES%;%FLOW_CLASSES%;%SNMP_CLASSES%;%JMX_CLASSES%;%ORACLE_CLASSPATH%;%MSSQL_CLASSPATH%
set.jdbc =%root%/lib/collectors/probeManager/discoveryResources/db
# Define Oracle and MSSQL in the Environment Collectors Path section around line 79 and 80
set.ORACLE_CLASSPATH=%jdbc%/oracle/Seropto.jar
set.MSSQL_CLASSPATH=%jdbc%/mssqlserver/jtds-1.2.2.jar
# Add Oracle and MSSQL path in the Manager and Probe's class path as show in two lines below
set.COLLECTORS_LOCAL_CLASSPATH=%MAM_JARS%;%lib%/collectors;%MYSQL_CLASSES%;%ext%/silib.jar;%SAP_CLASSES%;%FLOW_CLASSES%;%SNMP_CLASSES%;%JMX_CLASSES%;%ORACLE_CLASSPATH%;%MSSQL_CLASSPATH%
set.COLLECTORS_PROBE_CLASSPATH=%MAM_JARS%;%lib%/collectors;%MYSQL_CLASSES%;%ext%/silib.jar;%SAP_CLASSES%;%FLOW_CLASSES%;%SNMP_CLASSES%;%JMX_CLASSES%;%ORACLE_CLASSPATH%;%MSSQL_CLASSPATH%
2. Restart the probe for changes to take effect
Note: Also added drivers for Microsoft SQL as discussed in Document ID KM476885 - Error: "java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver"