img.pngwe are getting below error/exception while executing sqoop
action via oozie .
Error - Failing Oozie Launcher, Main class
[org.apache.oozie.action.hadoop.SqoopMain], exception invoking main(),
org.apache.oozie.action.hadoop.SqoopMain not found
It seems some jars related to sqoop action not available on
oozie share lib path i.e. “/user/oozie/share/lib/lib_20160807001458/sqoop”.
We are getting access issues while trying to update the oozie share lib
path with required jars.
You are executing an oozie admin command, so you need to be using an oozie admin user. Usually 'oozie' user is configured as admin user in oozie You can take look at the 'adminusers.txt' file under oozie configuration. Once you switch to an oozie admin user, you should be able to update the oozie sharelib. 'sudo su - oozie'
The another error which you have mentioned regarding the 'java.lang.ClassNotFoundException: Class org.apache.oozie.action.hadoop.SqoopMain not found', I guess you did not specify the 'oozie.use.system.libpath=true' into your "job.properties" file. This should resolve both of your issues.
Note: If 'oozie.use.system.libpath=true' property was missing then just add it and submit/run the workflow, you need not to update the oozie share lib.