@mqureshi I dont have any such directory as /usr/hdp/current/sqoop-client/lib/. But I am able to import data from oracle database using sqoop. Problem starts while I am trying to do same using oozie sqoop action.
Make sure you add oracle jdbc driver to the sqoop sharelib in HDFS (find the current sharelib location using 'oozie admin -sharelibliblist sqoop' - For older installations (pre HDP -2.2) you can add the file to /user/oozie/share/lib/sqoop directory
Make sure you either call oozie admin -sharelibupdate or restart oozie after that