The thing is I used this same code to import data from oracle, changing only connection details. My only guess is that oozie doesn't like the fact the script is in folder oracle, but I'm not sure and don't know what to change it to if that's the case.
I don't use sqoop action because there are some libs missing on the claster and it doesn't work.
It is always better to use specific action in oozie instead putting commands in shell action.
----> Can you put echo for sqoop command in shell script to check the exact sqoop command which oozie action will be executing?
----> Also please post the errors which you face when executing sqoop action, there are very few jars which are required for sqoop action (Sqoop jars from System share lib, Metastore/exec jar file and driver jar file for databse we you are trying to connect. These can be place in workflow/lib directory on HDFS).