Connecting to Oracle

Follow this procedure for connecting to a Oracle database when you do not have an ODBC Datasource defined for it.

To connect to an Oracle database you need to specify:

• the machine where the Oracle server resides
• the TCP/IP Port the Oracle server is listening on. By default this is 1521 but your server may be configured to use a different port. If in doubt, contact your Oracle specialist for this.
• an Oracle server can host a number of databases. Each will be identified by a Service Name. Specify the Service Name of database you wish to connect to.

The connection to your database may be defined in your tnsnames.ora file. If so, you can just TNS Service name of the entry in the tnsnames.ora file. AQT cannot give you a dropdown list of these.

There more info on the tnsnames.ora file at Set up the tnsnames.ora file.