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.
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
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]
Check your environmental path for the location to the old client. If found, remove.
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.
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.
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.
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.
Glad you got this figured out.