I am new with HDP (v2.5 as Sandbox) and I am trying to submit an Oozie job using a Sqoop action to connect to an Oracle Database.
I managed to run Oozie jobs with a simple Hive action and a simple Sqoop action (just sending 'version') - both worked. The error occurs when sending the command:
<command>sqoop-list-tables --connect jdbc:oracle:thin:@//XX.XX.XX.XXX:XXXX/NAME --username USER --password PW</command>
Actually, the command is working from the command line so it has something to do with Oozie. At some point I have read that there might be an issue with the ojdbc6.jar file so I copied it to several /lib/ folders without success.
To get rid of the spaces inbetween the command I also tried <arg></arg> but it didn't work.
What am I doing wrong here? Any advice is appreciated!
I really have no clue what to do and the error log doesn't help.
Thanks and regards,
(If you need further information just let me know!)