Hi Arjun,
Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and restarted
the drillbits on all nodes.
Thanks and Regards,
Akshay
On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr <arjun...@outlook.com> wrote:
> Hi Akshay,
>
>
> Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
>
>
> Thanks,
>
>
> Arjun
>
>
> ________________________________
> From: Akshay Joshi <joshiakshay0...@gmail.com>
> Sent: Tuesday, October 31, 2017 9:46 PM
> To: user@drill.apache.org
> Subject: Apache drill : Error while creating storage plugin for Oracle DB
>
> Hi Team,
>
> I have configured drill on 4 node cluster and getting error while creating
> storage plugin for Oracle DB.
>
> Error : Please retry: error (unable to create/ update storage)
>
> Oracle DB Version : *12.1.0.2.0*
>
> Following steps followed to create storage plugin:
> 1. copied ojdbc7.jar to jars/3rdparty folder
> 2. Storage plugin configuration
> {
> "type": "jdbc",
> "driver": "oracle.jdbc.driver.OracleDriver",
> "url": "jdbc:oracle:thin:<<username>>/<<password>>@<<IP>>:<<PORT>>/ORCL",
> "enabled": true
> }
> 3. drill-override.conf file
> drill.exec: {
> cluster-id: "drillbits1",
> drill.exec.sys.store.provider.local.path="/u01/bdcsce/drill/
> apache-drill-1.11.0",
> zk.connect: "<<IP>>:<<PORT>"
> }
>
> Thanks and Regards,
> Akshay
>
