ODBC Set-Up: Oracle

To set up an Oracle Server DSN:

  1. Open the Windows Data Sources (ODBC) control panel:
    1. From the Start menu, choose Control Panel.
    2. On Windows 2000/XP/Vista, open the Administrative Tools folder.
    3. Double-click the Data Sources (ODBC) icon.
  • This will open the ODBC Data Source Administrator:

Create New Data Source

Create Data Source
  • On the System DSN tab, click the Add… button.

Choose Driver

Create Data Source
  • From the list of drivers that appears, choose Oracle ODBC Driver (this may be named Oracle in [Oracle Home Name] if you have multiple Oracle installations on your computer – in this case it is important to choose the installation that is used for your SIS).
  • If you cannot find a suitable Oracle Driver you may need to install one: Oracle Driver Install

  • Click Finish. The Oracle ODBC Driver Configuration will appear.

Oracle ODBC Drive Configuration

Oracle ODBC Driver Configuration
  • For Data Source Name, enter a name for the data source. Remember the name you choose, it is the same name you should enter in the ODBC DSN box in the Extractor. This can be almost anything, typically the name of your SIS will work.
  • Description This can be left blank, but is best used for reference so others will know what this ODBC is used for.
  • TNS Service Name This is the name of the listener for the Oracle server. This information is dependent on server set up and may have typical values based on the SIS you are using:

  • Generally in this format: [server address]:[port]/[Listener]

    The [server address] is the ipaddress of your server.

    The [Listener] is the name of the Oracle Listener

    Please contact your Oracle DBA for more information.

UserID This is the user name used to log onto the Oracle server.
Enable Query Timeout: On the Application tab there is a setting with this label, we suggest unchecking this option when setting up if this ODBC DSN. If checked, long queries (ie section information) may cause the extraction to fail. You may see an error window with this text: [Ora]ORA-01013: user requested cancel of current operation
Once all of this information is entered click the Test Connection button, you will be prompted for the password for the account, click OK
If the entries are correct a Connection successful message will appear, your set is finished, click OK numerous times to exit the Administrator.
Once set up you are ready to move on to the next stage of Set Up


If after examining the error codes below you still cannot find your issue, please email our support department with your issue, and then try this website: Oracle Error Codes. Please be aware that this site is external to the discovery website.

[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

  1. Open the ODBC Data Source Administrator.
  2. Select the appropriate DSN. Click Configure
  3. Ensure that "Enable Query Timeout" is unchecked
  4. Click OK.
  5. Re-rerun the extraction, this error should not appear now.

This error occurs because the query for the requested information is taking a inordinate amount of time to return, so Oracle cancels the query.

[Oracle][ODBC][Ora]ORA-12170: TNS: Connect timeout occurred

[Oracle][ODBC][Ora]ORA-12170: TNS: Connect timeout occurred
Possible solutions:

  • IP address of the TNS Listener may be incorrect

  • Ensure local machine is connected to the network

  • Ensure server machine is powered on and connected to the network

[Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

[Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Possible solutions:

  • IP address is correct (if any) but the Listener name is probably incorrect

  • Ensure Listener is spelled correctly

  • Ensure server machine has a listener set up

[Oracle][ODBC][Ora]ORA-12541: TNS:no listener

[Oracle][ODBC][Ora]ORA-12541: TNS:no listener
Possible solutions: