Ora-12154 Instant Client Error
Contents |
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 error ora-12154 tns could not resolve the connect identifier specified Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation ora-12154 tns could not resolve service name Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just
Ora-12154 Tns Could Not Resolve The Connect Identifier Specified Windows 7
like you, helping each other. Join them; it only takes a minute: Sign up ora-12154 could not resolve… with oracle instant client up vote 0 down vote favorite Here are the details: I installed the oracle instant client
Ora 12154 Error In Oracle 10g
11.2.0.2.0 from the OTN download page on a windows 7 64 bit vm (vmware). I am trying to to connect to a remote oracle database, and I can successfully connect with one program using TNS, but not with SQL*Plus and other applications. Trying to connect with SQL*Plus, using schema@servicename, password, etc, gives the above error. To connect via SQL Developer, normally I would use the basic connection info and not rely on tnsnames, but trying asp.net ora-12154: tns:could not resolve the connect identifier specified a normal connection gives me: io error: unknown host specified. SQL Developer can successfully connect and query database if i use the TNS protocol. Trying from other programs gives me the same error I got with SQL*Plus. Same when trying with the service name from tnsnames. This is obviously quite frustrating for it to work one way and not the other. I followed all the normal instructions for using the instant client, the directory with instantclient has been addded to the PATH, a TNS_ADMIN entry has also been created, with the directory to the tnsnames.ora file oracle oracle-sqldeveloper tnsnames ora-12154 share|improve this question edited Aug 17 '11 at 8:59 APC 87.3k1384184 asked Aug 16 '11 at 20:17 chrismarx 3,16633558 tried the 10.2 version of the instant client, same problem –chrismarx Aug 16 '11 at 20:35 What's the value of NAMES.DIRECTORY_PATH in sqlnet.ora? –vc 74 Aug 17 '11 at 9:02 i dont have a sqlnet.ora file, it wasnt part of the instant client download, nor did the instructions say to manually create one? –chrismarx Aug 17 '11 at 14:11 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote accepted Well, on a whim, I went to changing everything in my setup to match an windows 2003 server that i had setup with
resolve the connect identifier specified"? Article: 00951 Last Reviewed: 7th September 2006 Revision: 1 This error indicates that Oracle is unable to locate the service
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
name specified in your Easysoft ODBC-Oracle Driver ODBC data source. You need to tns could not resolve the connect identifier specified sqlplus check the Database attribute value in the data source.If you are using the standard Oracle client, the Database ora-12154 sqlplus attribute value must specify a valid service name defined in tnsnames.ora. For example, for the following tnsnames.ora entry, the Database attribute value needs to be my_database: my_database = (DESCRIPTION = (ADDRESS http://stackoverflow.com/questions/7084439/ora-12154-could-not-resolve-with-oracle-instant-client = (PROTOCOL = TCP)(HOST = my_host)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = my_database) ) ) If you are using the Instant Client without a tnsnames.ora file, the Database attribute value needs to be a SQL connect URL rather than a service name: //host:port/service_name where host is the host name or IP address of the Oracle database server, port http://www.easysoft.com/support/kb/kb00951.html is the Oracle listener port and service_name is the service name. For example: //my_host:1521/my_database If you want to use the Instant Client with a tnsnames.ora file, the Database attribute value must specify a tnsnames.ora service name and you need to set and export the TNS_ADMIN environment variable. Set TNS_ADMIN to specify the location of the tnsnames.ora file. For example: TNS_ADMIN = /home/oracle/network/admin export TNS_ADMIN Applies To Products Easysoft ODBC-Oracle Driver Knowledge Base Feedback * Did this content help you? Yes No Maybe * Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links Suggest new content or let us know how we can improve this content: (* Required Fields) About Easysoft Contact Us About Us Clients Upgrade Offer Blog Careers Products ODBC Drivers JDBC Drivers Bridges and Gateways In Development Services Consultancy Training Cu
Sign in Pricing Blog Support Search GitHub This repository Watch 54 Star 276 Fork 109 joeferner/node-oracle https://github.com/joeferner/node-oracle/issues/59 Code Issues 98 Pull requests 13 Projects 0 Pulse Graphs http://kb.tableau.com/articles/knowledgebase/oracle-connection-errors New issue ORA-12154: TNS:could not resolve the connect identifier specified #59 Closed thaumant opened this Issue Jul 10, 2013 · 31 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 8 participants thaumant could not commented Jul 10, 2013 Here is the code: var oracle = require("oracle"); var conData = { tns: '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=mysid)))', user: 'myname', password: 'mypass' }; oracle.connect(conData, function(err, con){ if (err) console.log('ERROR', err); else console.log('OK', con); }); And I get: ERROR [Error: ORA-12154: TNS:could not resolve the connect identifier specified] Connection data is correct. I could not resolve have php installed with oci extension and it connects with the same copypasted connection string, username and password. SQLPlus also works. I also tried to use: an object with "hostname" and "database" properties instead of "tns", easy connect string, reference to tnsnames.ora, random strings in all properties, like @#$%^&*(, empty object { }. I see the same error 12154 in each case, no matter what data I put in the conData variable. Some info about my environment: ORACLE_HOME=/usr/lib/oracle/11.2/client64 OCI_INCLUDE_DIR=/usr/include/oracle/11.2/client64 OCI_LIB_DIR=/usr/lib/oracle/11.2/client64/lib TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin $ uname -rvio 3.8.0-21-generic #32-Ubuntu SMP Tue May 14 22:16:46 UTC 2013 x86_64 GNU/Linux $ node --version v0.10.12 Thanks! kontrafiktion commented Jul 10, 2013 Please try the following: Put the connection string into your tnsnames.ora: FOOBAR = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=mysid))) than try that connection with sqlplus. If it works try to connect with node.js using: var conData = { tns: 'FOOBAR', user: 'myname', password: 'mypass' }; kontrafiktion commented Jul 10, 2013 If you use 'hostname
a unique format. Though the TNSNames.ora file may not always be required. For instance, if you 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. 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. 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 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 Data. Step 2 For Tableau Desktop 8.2 and later, on the Connect page, click Oracle. For Tableau Desktop 8.1 and earlier, on the Connect to Data page, click Oracle. Step 3 For Tableau Desktop 8.2 and later, connect to the Oracle server, and then click OK. For Tableau Desktop