Hi Arjun, No error message getting logged in drillbit.log once I click on "create" button.
Thanks, Akshay On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr <[email protected]> wrote: > > Do you see any specific error message in drillbit.log ? > > Thanks, > > Arjun > > ________________________________ > From: Akshay Joshi <[email protected]> > Sent: Tuesday, October 31, 2017 11:10 PM > To: [email protected] > Subject: Re: Apache drill : Error while creating storage plugin for Oracle > DB > > 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 <[email protected]> wrote: > > > Hi Akshay, > > > > > > Did you copy jdbc driver to all the drill nodes and restarted drillbits ? > > > > > > Thanks, > > > > > > Arjun > > > > > > ________________________________ > > From: Akshay Joshi <[email protected]> > > Sent: Tuesday, October 31, 2017 9:46 PM > > To: [email protected] > > 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 > > >
