Please explain how to connect to an Oracle database with CF9 standard

1. You'll need to download the Oracle JDBC Drivers (http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html)

2. Put the appropriate .jar files in your <coldfusion>/lib folder

3. Restart CF

4. Create a Datasource using the "Other" option

5. Create an appropriate connection string

Examples:

jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID

jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE

It has been a long time since I have done this, but I have done it and know it works. I remember the issue with SID vs SERVICE being a huge PITA.

Good luck,

Jason

I will suppose you already know you have to add an Oracle datasource in the ColdFusion Administrator. Google coldfusion 9 connecting to oracle database, and you will find that the information you need is all there in the Adobe ColdFusion documentation. The ColdFusion 9 support matrix tells you which Oracle versions ColdFusion supports.