Toad World® Forums

TNS Timeout Message in Data Analysts


#1

Hi hoping someone has experienced this issue and can help. Everyday when I use the Data Analyst Tool I get an intermittent message “ORA-12154: TNS:could not resolve service name”. I never get this message in the full version of TOAD and I don’t think I have issues with my TNS file.

It happens on anything I’m doing and brings me to a halt. Sometimes things run fine and then all the sudden I’ll get this message.


#2

Do you have multiple clients? Depending on what is occurring we do create more than one connection when needed. Somehow when this connection is created, perhaps it is using the wrong client…Can you turn on SQL Trace to output and bring up the output window. When the error occurs please copy the messages and post or send to me in email to dpeabody@quest.com.

Debbie


#3

Actually yes I have two Oracle Clients (8.17 and 9.02). One I don’t use 8.17 anymore. I have removed it. I may need to have my pc scrubbed for multiple Oracle Clients.

I’m not sure this is the SQL Trace Report but here’s what it says on my Export fail:

Export Started [3/11/2009 9:29:19 AM]

Export Wizard error processing objects, export halted.

Error parsing Export template: ORA-12154: TNS:could not resolve service name

Export Finished [3/11/2009 9:31:09 AM]


#4

Check your environmental path for the location to the old client. If found, remove.


#5

Hi there,

Changed my Environment Path from the following to the following:

Old Path

C:\Program Files\Oracle92\bin;
C:\Program Files\Oracle-9-2-0-6-0-SRM\Oracle\jre\1.3.1\bin;
C:\Program Files\Oracle-9-2-0-6-0-SRM\Oracle\jre\1.1.8\bin;
C:\Program Files\Oracle92\bin;
C:\Program Files\Business Objects\common\3.5\bin\NOTES;
C:\Program Files\Business Objects\common\3.5\bin\NOTES\DATA;
C:\Program Files\oracle92\Bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;
C:\Program Files\AdminTools\Resource Kit;%SystemRoot%\system32\nls;%SystemRoot%\system32\nls\ENGLISH;
C:\Program Files\Novell\ZENworks;C:\ESWMAPI\VB;C:\ESWMAPI\Include;
C:\ESWMAPI\SYS;C:\ESWMAPI;C:\ESWMAPI\BIN;C:\PROGRA~1\IBM\SQLLIB\BIN;
C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\Program Files\1E\SMSNomad;
C:\Program Files\RSA Security\RSA SecurID Software Token\

New Path

C:\Program Files\Oracle92\bin;
C:\Program Files\Business Objects\common\3.5\bin\NOTES;
C:\Program Files\Business Objects\common\3.5\bin\NOTES\DATA;
C:\Program Files\AdminTools\Resource Kit;%SystemRoot%\system32\nls;%SystemRoot%\system32\nls\ENGLISH;
C:\Program Files\Novell\ZENworks;
C:\ESWMAPI\VB;
C:\ESWMAPI\Include;
C:\ESWMAPI\SYS;
C:\ESWMAPI;
C:\ESWMAPI\BIN;
C:\PROGRA~1\IBM\SQLLIB\BIN;
C:\PROGRA~1\IBM\SQLLIB\FUNCTION;
C:\Program Files\1E\SMSNomad;
C:\Program Files\RSA Security\RSA SecurID Software Token\

Still getting the message? Can I point this tool directly to the Oracle Client I want it to use? Maybe I should wipe out all Clients & re-install I just hate to do that.


#6

Also here is a more detailed error message:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
CoreLab.Oracle.OracleException: ORA-12154: TNS:could not resolve service name
at CoreLab.Oracle.h.b(Int32 A_0)
at CoreLab.Oracle.ak.a(bz A_0, bh A_1)
at CoreLab.Oracle.OracleInternalConnection…ctor(bz connectionOptions, OracleInternalConnection proxyConnection)
at CoreLab.Oracle.aw.a(u A_0, Object A_1, DbConnectionBase A_2)
at CoreLab.Common.DbConnectionFactory.a(DbConnectionBase A_0, u A_1)
at CoreLab.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at CoreLab.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at CoreLab.Oracle.OracleConnection.Open()
at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)
at Quest.Toad.Oracle.OracleToadConnection.OpenConnection(IDbConnection connection)
at Quest.Toad.Db.Connection.AllocConnection()
at Quest.Toad.Db.Connection.Db(ConnectionType type, Boolean transaction)
at Quest.Toad.Db.Connection.Db(ConnectionType type)
at Quest.Toad.Editor.ScriptEngineManager.AllocateDbConnection()
at Quest.Toad.Editor.EditorForm.RefreshParserMessages(List`1 messages, Int32 offset)
at Quest.Toad.Editor.EditorForm.Parse(Boolean processParserMessages, Boolean syntaxCheck)
at Quest.Toad.Editor.EditorForm.DoFileOpen(String file)
at Quest.Toad.Editor.EditorForm.DoExecute(String filename)
at Quest.Toad.ProjectManager.ProjectManagerControl.executeItem_ItemClick(Object sender, ItemClickEventArgs e)
at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarItemLink.OnLinkClick()
at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
at DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)
at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

Toad
Assembly Version: 4.1.0.227
Win32 Version: 2.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Toad.exe

System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

DevExpress.Utils.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.Utils.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.Utils.v8.2.dll

ToadPlugin
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/ToadPlugin.dll

ToadCore
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/ToadCore.dll

FastData
Assembly Version: 2.1.0.227
Win32 Version: 2.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/FastData.dll

DevExpress.Data.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.Data.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.Data.v8.2.dll

SharpZLib
Assembly Version: 0.84.0.0
Win32 Version: 0.84.0.0
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/SharpZLib.dll

System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

System.Runtime.Serialization.Formatters.Soap
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Serialization.Formatters.Soap/2.0.0.0__b03f5f7f11d50a3a/System.Runtime.Serialization.Formatters.Soap.dll

System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

DevExpress.BonusSkins.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.BonusSkins.v8.2/8.2.4.0__95fc6c5621878f0a/DevExpress.BonusSkins.v8.2.dll

DevExpress.OfficeSkins.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.OfficeSkins.v8.2/8.2.4.0__95fc6c5621878f0a/DevExpress.OfficeSkins.v8.2.dll

DevExpress.XtraBars.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.XtraBars.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.XtraBars.v8.2.dll

ActiproSoftware.UIStudio.Dock.Net20
Assembly Version: 2.0.99.0
Win32 Version: 2.0.99.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/ActiproSoftware.UIStudio.Dock.Net20/2.0.99.0__be939c973e8cb8a6/ActiproSoftware.UIStudio.Dock.Net20.dll

DevExpress.XtraEditors.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.XtraEditors.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.XtraEditors.v8.2.dll

ActiproSoftware.WinUICore.Net20
Assembly Version: 1.0.95.0
Win32 Version: 1.0.95.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/ActiproSoftware.WinUICore.Net20/1.0.95.0__1eba893a2bc55de5/ActiproSoftware.WinUICore.Net20.dll

ActiproSoftware.Shared.Net20
Assembly Version: 1.0.95.0
Win32 Version: 1.0.95.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/ActiproSoftware.Shared.Net20/1.0.95.0__36ff2196ab5654b9/ActiproSoftware.Shared.Net20.dll

System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll

ToadOdbcProvider
Assembly Version: 2.1.0.227
Win32 Version: 2.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Odbc/ToadOdbcProvider.dll

ToadDB2Provider
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/DB2/ToadDB2Provider.dll

ToadMySQLProvider
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/MySQL/ToadMySQLProvider.dll

ToadOracleProvider
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Oracle/ToadOracleProvider.dll

ToadSqlServerProvider
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/SqlServer/ToadSqlServerProvider.dll

ToadSybaseProvider
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Sybase/ToadSybaseProvider.dll

System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll

CoreLab.Oracle
Assembly Version: 4.75.42.0
Win32 Version: 4.75.42.0
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Oracle/CoreLab.Oracle.dll

CoreLab.Data
Assembly Version: 4.70.23.0
Win32 Version: 4.70.23.0
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Oracle/CoreLab.Data.dll

Quest.PersistentCache
Assembly Version: 2.1.0.227
Win32 Version: 2.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Quest.PersistentCache.dll

ToadOracle
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Oracle/ToadOracle.dll

ManagedQP5
Assembly Version: 4.1.0.227
Win32 Version:
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/managedqp5.dll

DevExpress.XtraTreeList.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.XtraTreeList.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.XtraTreeList.v8.2.dll

System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll

OciCall.dll
Assembly Version: 0.0.0.0
Win32 Version: 4.75.42.0
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Oracle/CoreLab.Oracle.dll

ActiproSoftware.SyntaxEditor.Net20
Assembly Version: 4.0.276.0
Win32 Version: 4.0.276.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/ActiproSoftware.SyntaxEditor.Net20/4.0.276.0__21a821480e210563/ActiproSoftware.SyntaxEditor.Net20.dll

System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

Microsoft.JScript
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1433
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.JScript/8.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll

msvcm80
Assembly Version: 8.0.50727.1433
Win32 Version: 8.00.50727.1433
CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.1433_x-ww_5cf844d2/msvcm80.dll

DevExpress.XtraGrid.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.XtraGrid.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.XtraGrid.v8.2.dll

CoreLab.Data
Assembly Version: 4.70.24.0
Win32 Version: 4.70.24.0
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/MySQL/CoreLab.Data.dll

ToadAutomation
Assembly Version: 4.1.0.227
Win32 Version: 4.1.0.227
CodeBase: file:///C:/Program%20Files/Quest%20Software/Toad%20for%20Data%20Analysts%202.1/Plugins/Automation/ToadAutomation.dll

System.Workflow.ComponentModel
Assembly Version: 3.0.0.0
Win32 Version: 3.0.4203.2
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Workflow.ComponentModel/3.0.0.0__31bf3856ad364e35/System.Workflow.ComponentModel.dll

System.Workflow.Activities
Assembly Version: 3.0.0.0
Win32 Version: 3.0.4203.2
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Workflow.Activities/3.0.0.0__31bf3856ad364e35/System.Workflow.Activities.dll

DevExpress.XtraVerticalGrid.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.XtraVerticalGrid.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.XtraVerticalGrid.v8.2.dll

DevExpress.XtraNavBar.v8.2
Assembly Version: 8.2.4.0
Win32 Version: 8.2.4.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/DevExpress.XtraNavBar.v8.2/8.2.4.0__9b171c9fd64da1d1/DevExpress.XtraNavBar.v8.2.dll

System.Workflow.Runtime
Assembly Version: 3.0.0.0
Win32 Version: 3.0.4203.2
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Workflow.Runtime/3.0.0.0__31bf3856ad364e35/System.Workflow.Runtime.dll

Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll

krimxzyk
Assembly Version: 4.1.0.227
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

MailBee.NET
Assembly Version: 3.0.2.79
Win32 Version: 3.0.2.79
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/MailBee.NET/3.0.2.79__cd85b70fb26f9fc1/MailBee.NET.dll

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


#7

I don’t see a conflict of client paths here. Is your tns definition fully qualified? IE: serverA vs serverA.domain.

Do you have more than one alias pointing to the same server?

Also, as a quick short term solution you can use Direct Connect instead of using the client.


#8

Ok I figured it out. Apparently I have multiple TNS Files on my PC and the one that Data Analysts uses was missing a Server Name. Therefore everytime it went back to refresh it timed out. Thanks for the help Deb.


#9

Glad you got this figured out.