Interactive Reporting - WIN 7 & the TNSNames.ora file (Oracle Error -1 : ORA-12170:)

A .txt extension may be added to the TNSNames.ora file by WIN 7 which will cause this file to not be found and a Oracle server connection is not possible. The TNSNames.ora file may be corrupted in other ways as well or you may be denied access when attempting to place the file in the Oracle path.

Note: Interactive Reporting, including both the IR Workspace (web) and the Studio Desktop client, will be decommissioned on March 1st, 2019. Neither the web nor the desktop software will be available or supported after this date.

UW-Madison affiliates can find more information on alternative tools on the Office of Data Management and Analytics Services website.

Other UW System affiliates can find additional information, as well as a list of support contacts, on the UWBI Support website.

If you are using a WIN 7 operating system on your PC, you have installed Oracle on your PC, you have placed the TNSNames.ora file in the Oracle path, you have set-up the connection to the Oracle data base using MS Access or Interactive Reporting and you are getting this error message when you try to run a query:

Oracle Error -1 : ORA-12170:
TNS:Connect timeout occurred

One problem might be a .txt extension has been added to your TNSNames.ora file.  If your 'extensions' are hidden you will not see that .txt extension.  Expand you file extensions so you can see if this is the problem.  If you are able to remove that extension the connection can be established. 

To avoid problems with corrupting the TNSNames.ora file you should use Notepad when opening and moving the file.  Other applications may left justify the file creating problems as well.

The correct way to use Notepad on a WIN 7 operating system is to go to the application in Programs-->Accessories-->Notepad and right click on it to select 'Run as Administrator'.  This should eliminate the .txt extension from being added and stop you from being 'Denied access' when placing the file in the Oracle path.

If this is not the cause of your problem please contact the DoIT Help Desk at (608) 264-4357 and select option 2.

Keywords:WIN 7 TNSNames.ora .txt extension Oracle Error -1 : ORA-12170: Connect timeout data base connection problem Notepad left justify Denied access   Doc ID:16529
Owner:Tim L.Group:Interactive Reporting Madison
Created:2011-01-10 19:00 CDTUpdated:2018-12-06 16:10 CDT
Sites:DoIT Help Desk, Interactive Reporting Madison
Feedback:  6   8