is there any information available on how to configure an embedded deployment of Alfresco repository? I mean database config, hibernate stuff and so on.
I never tried Alfresco with Oracle, so I don't know if it's a problem between Hibernate and Oracle. Oracle should be work with Alfresco.
Another thread talk about Oracle and FirstFoundationClient. Try to contact MichaelR, gatesda or amgad2002 to ask if they are found a solution about this problem.