2) In our case, we start the Sitescope service with an AD account. Logged in to the Sitescope machine (we're using MS Windows 2008 Server to run Sitescope) with the AD account in question, configured the system variables (LD_LIBRARY_PATH, default is C:\OracleClient; SQLPATH, default is C:\OracleClient; TNS_ADMIN, default is C:\OracleClient). Logged out and back in to have the variables take effect.
3) Copied the "ojdbc5.jar" file (will be in the location where you installed the Oracle Instant Client, default is C:\OracleClient) to $SITESCOPE_HOME\WEB-INF\lib\
4) Restarted Sitescope
5) Tested everything works fine by running the DB connect tool. Format is:
Connection string: jdbc:oracle:thin:@[HOST][:PORT]:SID OR jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE