Requirements
GenWise uses the Oracle Data Provider for .NET 2.x to connect to Oracle databases. The latest tested version is the Oracle Data Provider for .NET 2.0 10.2.0.2.20, which is part of the Oracle Data Access Components (ODAC) that can be downloaded here:
http://www.oracle.com/technology/software/tech/windows/odpnet/index.html
GenWise uses Oracle's Data Provider for .NET instead of the Oracle Provider provided by Microsoft which is extremely slow in comparison.
After installing the Oracle Data Provider it must be configured using the Oracle configuration tools. Specifically, by default the file tnsnames.ora file (client side network configuration parameters) is not created. You first need to create it and add the servers.
Location of the tnsnames.ora file: <ORACLE_HOME directory>\product\10.2.0\client_1\network\ADMIN
Connection
Create a connection to your Oracle database by following these steps:
| 1. | Select an Oracle Version. |
GenWise uses this information to find Oracle Homes according to version specific rules.
| 2. | Choose an Oracle Home |
In a standard Oracle installation you will have one Oracle Home. This dropdown list allows you to choose if you have more than one Oracle Home.
| 3. | Select the Oracle Database |
After selecting version and home, you can now choose the server to use. The server list is based on the content of the tnsnames.ora file in the Oracle Home that has been chosen.
