The oracle mix-in is now in metasploit trunk so should be a snap to get working. Installation instructions are up here.
Especially note the requirements for specific versions of the dbi and oci8 gems, later versions don't always work as expected with some of the oracle exploit plugins.
Leave a comment