Oracle OCI Driver

[apons]

Hello

Is it possible to use Oracle OCI driver for alfresco 3.x?

Thanks

[pbkoob]

I am able to connect to Alfresco with an Oracle OCI driver.

This is what I did.
Install the Oracle client on the server.  Do not install a "Quick Client", it has to be the full client with all the JDBC libraries.  Then edit the sqlnet.ora and the tnsnames.ora, found at \ORACLE\product\10.2.0\client_1\NETWORK\ADMIN\, to connect to your database. Verify it connects to your database with SqlPlus.

Copy \oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14_g.jar to \Alfresco\tomcat\lib

Edit \Alfresco\tomcat\shared\classes\alfresco\extension\custom-hibernate-dialect.properties
Comment out the Derby hibernate dialect
Add to the bottom the Oracle hibernate dialect:
#
# Oracle dialect
#
hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoOracle9Dialect

Edit \Alfresco\tomcat\shared\classes\alfresco\extension\custom-repository.properties

Comment out the Derby connection
Add the Oracle Connection
Edit db.name to be your database SID (as specified in your Oracle tnsnames.ora)
Edit db.username to be your database id
Edit db.password to be your database password
Add to the bottom the Oracle connection:
# Oracle Connection
#
db.driver=oracle.jdbc.OracleDriver
db.url=jdbcracleci:@SID

I cannot testify as to whether this kosher, only an Alfresco Engineer can do that, but it does work.
A note here; if your database externally identifies users ( RADIUS ) you cannot use the thin client, you have to use OCI.