1) install Oracle 11g;
2) setup default db;
3) change etc/hibernate.properties:
comment ## HypersonicSQL section,
update ## Oracle section:
hibernate.dialect org.hibernate.dialect.Oracle10gDialect
hibernate.connection.driver_class oracle.jdbc.OracleDriver
hibernate.connection.url jdbc:oracle:thin:@localhost:1521:orcl
hibernate.connection.username SYSTEM
hibernate.connection.password sa
4) add Oracle driver into the progect (on my computer it is "C:\app\Vitali\product\11.1.0\db_1\jdbc\lib\ojdbc5_g.jar")
5) Run ToolAllTests as JUnit test
screenshot is example.