ODBC Set-Up: Oracle
To set up an Oracle Server DSN:
- Open the Windows Data Sources (ODBC) control panel:
- From the Start menu, choose Control Panel.
- On Windows 2000/XP/Vista, open the Administrative Tools folder.
- Double-click the Data Sources (ODBC) icon.
- This will open the ODBC Data Source Administrator:
- On the System DSN tab, click the Add… button.
- 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.
- 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
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.
- Open the ODBC Data Source Administrator.
- Select the appropriate DSN. Click Configure
- Ensure that "Enable Query Timeout" is
- Click OK.
- Re-rerun the extraction, this error should not appear
This error occurs because the query for the requested information is taking a inordinate amount of time to return, so Oracle cancels the query.
- 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
- 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 administrator will need to ensure that the TNS Listener is running on the server
- This website has some good advice: http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm