To switch to Oracle thin client - Websphere Mass Load Utility.

The massload utility must be using the thick client during instance creation and the migration process. By Default, the massload utility uses the Oracle thick JDBC client. To change the massload utility to use the Oracle thin JDBC client:

Steps -

•     Extract DbConnectionImplIDProperty.properties from the following file:
•     WCDE_installdir\workspace\wc\lib\loader\dbconnect.zip
•     Open DbConnectionImplIDProperty.properties
•     Locate the following text: ConnectStringID = jdbc:oracle:oci8:@
•     Change the text to - jdbc:oracle:thin:@hostname:port:SID.
•     Save your changes.