If you need to connect to an Oracle database from Coldfusion 9 the following are some recommendations on how to configure your connection.

1. Use Oracle JDBC with OID
2. Use Macromedia without OID

If you choose to use the Oracle JDBC driver you will need to specify the "Other" Data Source when configuring Coldfusion via CFADMIN