Error:
Testing connectivity to Oracle instance and also checking the associated grants for the user(XXXXX:XXXXX)
Click to show/hide the full result
line 22: sql: command returned with a non-zero status (status: 1) !
Cannot locate driver 'oracle.jdbc.driver.OracleDriver' !
Resolution/fix:
> login to the SRM Collector via Putty, where 'Collector-Manager - oracle-database' is installed or where 'Data collection' & 'ASM Data collection' services are installed
> change directory to below path
SRMCollector~ # cd /opt/APG/Databases/JDBC-Drivers/Default/lib
>check weather jdbc drives or located or not
SRMCollector:/opt/APG/Databases/JDBC-Drivers/Default/lib # dir | grep -i ojdbc
-rw-r--r-- 1 root root 3692096 Apr 23 05:15 ojdbc6.jar
-rw-r--r-- 1 root root 3698857 Apr 23 05:15 ojdbc7.jar
-rw-r--r-- 1 root root 4036257 Jun 6 11:17 ojdbc8.jar
<If Not like above>
>Download JDBC Drivers from oracle Website
Link: http://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html
Note: you need to have a Oracle account to download and its free to register
>download below 3 files
ojdbc6.jar
ojdbc7.jar
ojdbc8.jar
>use WinSCP or any other tool to upload the files to the SRM Collector
>once uploaded and verify then provide the privileges
SRMCollector:/opt/APG/Databases/JDBC-Drivers/Default/lib # chmod 777 ojdbc6.jar
SRMCollector:/opt/APG/Databases/JDBC-Drivers/Default/lib # chmod 777 ojdbc7.jar
SRMCollector:/opt/APG/Databases/JDBC-Drivers/Default/lib # chmod 777 ojdbc8.jar
SRMCollector:/opt/APG/Databases/JDBC-Drivers/Default/lib # dir | grep -i ojdbc
-rwxrwxrwx 1 root root 3692096 Apr 23 05:15 ojdbc6.jar
-rwxrwxrwx 1 root root 3698857 Apr 23 05:15 ojdbc7.jar
-rwxrwxrwx 1 root root 4036257 Jun 6 11:17 ojdbc8.jar
> Now restart the services
SRMCollector:/opt/APG/Databases/JDBC-Drivers/Default/lib # manage-modules.sh service restart all
> now try to Discover the Oracle Instance
!! I Guess it should work !!
or
refer below EMC Link
https://www.emc.com/techpubs/vipr/solutionpack_for_oracle_database-2.htm
