Turns out after you put the jar in the directory you have to restart drill.
Works now. Dan Holmes | Revenue Analytics, Inc. Direct: 770.859.1255 www.revenueanalytics.com -----Original Message----- From: Dan Holmes [mailto:[email protected]] Sent: Friday, July 21, 2017 3:51 PM To: [email protected] Subject: Add oracle as a storage fails: Please retry: error (unable to create/ update storage) I have followed the instructions here: https://drill.apache.org/docs/rdbms-storage-plugin/#Example-Oracle-Configuration I get the error in the subject. I don't see anything in the logs about it. { type: "jdbc", enabled: true, driver: "oracle.jdbc.OracleDriver", url:"jdbc:oracle:thin:user/pwd@yoda:1523/ORCL" } I have the thin driver installed. dan@ubuntu:~/apache-drill-1.10.0/jars/3rdparty$ ll o* -rwxrwxr-x 1 dan dan 3698857 Jul 21 15:25 ojdbc7.jar* I can telnet to the server. dan@ubuntu:~/apache-drill-1.10.0/jars/3rdparty$ telnet yoda 1523 Trying 10.10.10.10... Connected to yoda.RADOM.local. Escape character is '^]'. ^] telnet> quit Connection closed. I don't know how to troubleshoot this further. Thank you any help. Dan Holmes | Architect | Revenue Analytics, Inc. 300 Galleria Parkway, Suite 1900 | Atlanta, Georgia 30339 Direct: 770.859.1255 Cell: 404.617.3444 www.revenueanalytics.com<https://webmail.revenueanalytics.com/owa/redir.aspx?SURL=RqmyOJRm3r383jV2nPQLyg9BvjWZqMX4-tL3BHj81WfaslMWau_SCGgAdAB0AHAAOgAvAC8AdwB3AHcALgByAGUAdgBlAG4AdQBlAGEAbgBhAGwAeQB0AGkAYwBzAC4AYwBvAG0A&URL=http%3a%2f%2fwww.revenueanalytics.com> LinkedIn<https://webmail.revenueanalytics.com/owa/redir.aspx?SURL=SrcaeiXxVTCDhl49ibCO7CHhTsNynunc_8gSjHDaikXaslMWau_SCGgAdAB0AHAAcwA6AC8ALwB3AHcAdwAuAGwAaQBuAGsAZQBkAGkAbgAuAGMAbwBtAC8AYwBvAG0AcABhAG4AeQAvAHIAZQB2AGUAbgB1AGUALQBhAG4AYQBsAHkAdABpAGMAcwAtAGkAbgBjAC0A&URL=https%3a%2f%2fwww.linkedin.com%2fcompany%2frevenue-analytics-inc-> | Twitter<https://webmail.revenueanalytics.com/owa/redir.aspx?SURL=cdePsMV8TCGx8O_Rugbj-maE9C9DVT373vSJwbUc23faslMWau_SCGgAdAB0AHAAcwA6AC8ALwB0AHcAaQB0AHQAZQByAC4AYwBvAG0ALwBSAGUAdgBfAEEAbgBhAGwAeQB0AGkAYwBzAA..&URL=https%3a%2f%2ftwitter.com%2fRev_Analytics>
