Error Reading Tnsnames.ora
Descriptions in tnsnames.ora Multiple Address Lists in tnsnames.ora Connect-Time Failover and Client Load Balancing with Oracle Connection Managers Local Naming Parameters Overview of Local Naming Parameters This tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses. A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application. By default, tnsnames.ora is located in the $ORACLE_HOME/network/admin directory on UNIX operating systems and in the %ORACLE_HOME%\network\admin directory on Windows operating systems. tnsnames.ora can also be stored the following locations: The directory specified by the TNS_ADMIN environment variable or registry value On UNIX operating systems, the global configuration directory. For example, on the Solaris Operating System, this directory is /var/opt/oracle. See Also: Oracle operating system-specific documentation General Syntax of tnsnames.ora The basic syntax for a tnsnames.ora file is shown in Example 6-1. DESCRIPTION contains the connect descriptor, ADDRESS contains the protocol address, and CONNECT_DATA contains the database service identification information. Example 6-1 Basic Format of tnsnames.ora File net_service_name= (DESCRIPTION= (ADDRESS=(protocol_address_information)) (CONNECT_DATA= (SERVICE_NAME=service_name))) Multiple Descriptions in tnsnames.ora A tnsnames.ora file can contain net service names with one or more connect descriptors. Each connect descriptor can contain one or more protocol addresses. Example 6-2 shows two connect descriptors with multiple addresses. DESCRIPTION_LIST defines a list of connect descriptors. Note: Oracle Net Manager does not support the creation of multiple connect descriptors for a net service name. Example 6-2 Net Service Name with Multiple Connect Descriptors in tnsnames.ora net_service_name= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS=(protocol_address_information)) (ADDRESS=(protocol_address_information)) (ADDRESS=(protocol_address_information)) (CONNEC
IBM DB2 MySQL NoSQL Oracle SQL Server PRODUCTSDiscussion & Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point Toad Extension for Eclipse Toad for Hadoop Toad for IBM DB2 Toad for Oracle Toad for MySQL Toad for SQL Server Toad for SAP Solutions Toad MAC Edition Home » Products » Toad Extension for Eclipse » https://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm Toad Extension for Eclipse Forum » Error reading tnsnames.ora Error reading tnsnames.ora Toad Extension for Eclipse Community Join Overview Forum Blog Idea Pond Connections Data Editor Off Topic Other Projects Schema Browser Settings Wiki Media Members Forum Options RSS Feed Tweet Related Posts error reading tnsnames.ora by GlennS on 18 https://www.toadworld.com/products/toad-extension-for-eclipse/f/42/t/5538 May 2011 Can Toad Extension reading of tnsnames.ora file be turn off during the startup of Eclipse by chung.ley on 25 Oct 2013 why this error msg? (not retrieve transation read-only status... by woogun on 30 Sep 2013 View More Error reading tnsnames.ora Follow richard.stewart_890 / 7 Oct 2011 at 3:56pm I have tried to use Toad Extension for Eclipse with Eclipse 3.6.1, with no success.Could my problems have something to do with the fact that I have also installed Oracle's Eclipse Enterprise Pack for Eclipse?The error log entry follows:eclipse.buildId=M20110210-1200java.version=1.6.0_14java.vendor=Sun Microsystems Inc.BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_USCommand-line arguments: -os win32 -ws win32 -arch x86This is a continuation of log file C:\Documents and Settings\e3ccbry.NAMCK.000\ERx_projects\.metadata\.bak_0.logCreated Time: 2011-10-07 08:29:49.836 ErrorFri Oct 07 08:29:56 CDT 2011Problems occurred when invoking code from plug-in: "com.quest.toadext.oracle.win32".org.eclipse.core.runtime.CoreException: error reading tnsnames.oraat com.quest.toadext.oracle.tns.TNSNamesParser.getServiceData(Unknown Source)at com.quest.toadext.oracle.tns.TNSNamesParser.getNetServices(Unknown Source)at com.quest.toadext.oracle.tns.OracleHome.getNetServices(Unknown Source)at com.quest.toadext.oracle.tns.OracleHome.getNetServices(Unknown Source)at com.quest.toadext.integration.toad.ToadConnectionLoader$1.run(Unknown Source)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)at com.quest.toadext.integration.toad.ToadConnectionLoader.getNetServices(Unknown Source)at com.quest
a unique format. Though the TNSNames.ora file may not always be required. For instance, if you http://kb.tableau.com/articles/knowledgebase/oracle-connection-errors have installed only the Tableau-provided Oracle files and do not have a stand-alone Oracle client. The Oracle error messages refer to the TNSNames.ora file. http://stackoverflow.com/questions/11437522/odbc-administrator-cant-find-oracle-tns-names-file Typically, correcting route or naming syntax in the Advanced Oracle Connection dialog box or using your full .WORLD database name resolves most Oracle connection issues. error reading If your connection error requires more troubleshooting, refer to the four common connection errors listed below. ORA-03113: end-of-file on communication channelORA-12154: TNS: could not resolve the connect identifier specified HOST value incorrect or Global name incorrect or unknownORA-12514: TNS listener does not currently know of service requested in connect error reading tnsnames.ora descriptorSERVICE value incorrectORA-12541: TNS: no listenerPORT value incorrectORA-00932: inconsistent data types ORA-03113: end-of-file on communication channel ORA-03113 is a catch-all type error for any problem interrupting an Oracle session. There can be numerous causes for this error. Please refer to the list below for some troubleshooting guidance. Refer to Oracle documentation specific to this error: My Oracle Support.Refer to Oracle's B Troubleshooting Common Errors page.Oracle recommends that you check for network problems and review the SQL*Net setup.If you're connecting to Oracle 9.2.0.5, in many cases the primary cause of this error is Oracle bug 3010227. Ask your Oracle database administrator to apply Oracle patch 9.2.0.6 or another patch appropriate for your server. Set the Oracle initialization parameter 'STAR_TRANSFORMATION_ENABLED' to FALSE.Alternatively, if you would like to test this issue further follow the optional procedure listed below. Step 1 From the Tableau Desktop start page, select Connect to
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ODBC Administrator Can't Find Oracle TNS Names File up vote 6 down vote favorite 2 With a new Oracle Installation when I go to Configuration Management Tools > Microsoft ODBC Administrator > System DSN > Add > [new installation] it does not have the TNSNAMES.ora connection name in the drop down. With the old installation, this had worked. I've tried updating Environment Paths and Registry keys but still can't find a way to get ODBC to see it in the drop down. There was a previous installation of Oracle Client on the Windows Server. I tried to remove most of the files but our Oracle DBA said we could just do another install and update the Environment Paths with the new location. I understand there are two other posts on SO here and here regarding this issue. However, I'm not sure TNS PING will help yet because it seems to be an issue regarding Environment Paths and ODBC being able to locate the .ora file. TNSNAMES.ORA Location TNS_Admin = E:\app\[username]\product\11.2.0\client_1\network\admin\TNSNAMES.ora Environment Variables TNS_Admin = E:\app\[username]\product\11.2.0\client_1 Path = E:\app\[username]\product\11.2.0\client_1 Registry Entries home3 is the new installation. Should I delete the old registry key (home2)? HKLM\SOFTWARE\ORACLE\KEY_OraClient11g_home2 and \..._home3 Also, if I select "OraClient11g_home2" in the Create New Data Source screen here is what is displayed in the drop down: oracle oracle11g windows-server-2003 tnsnames share|improve this question edited Jul 11 '12 at 17:14 asked Jul 11 '12 at 16:50 pixelbobby 2,58921836 1 I've voted to move this to dba.se, where I believe that it would be a better fit. If you a