I have tried the following:
– With scs_admin_config object, attribute jdbc_driver does not matter to set to oracle.jdbc.driver.OracleDriver or oracle.jdbc.pool.OracleDataSource.
– Add $ORACLE_HOME/jdbc/lib to LIBPATH
– Under /opt/documentum/share/jboss4.3.0/server/DctmServer_WEBCACHE/deploy/scs.ear/APP-INF/lib:
* File ojdbc5.jar was renamed to ojdbc5.jar.000.
* File ojdbc6.jar was copied from $ORACLE_HOME/jdbc/lib
Actually only the last step made any difference. It seemed when ojdbc6.jar was used, SCS source could enable type 2 connection automatically.