Home > Could Not > Ora-12154 Tns Could Not Resolve Service Name

Ora-12154 Tns Could Not Resolve Service Name

Contents

Reply ehsansahil says: August 11, 2015 at 10:55 am Its a coman error… just fo─║low bellow steps Step1.c/oracle/product/10.2.0/db1/network/ADMIN here copy the (tnsnames.ora) And past on… Step2.C/DevSuiteHome_1/network/ADMIN Step3.c/DevSuiteHome_1/jinit Step4.instal the jinit Step5.reboot Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Browse other questions tagged oracle odbc tns or ask your own question. Trial it free. http://divxpl.net/could-not/could-not-resolve-archetype-org-apache-maven-archetypes-maven-archetype-quickstart.html

Still does't work. Look for unmatched parentheses or stray characters. How to deal with it? Go with the Oracle Driver, you'll have to recode the app. https://blogs.msdn.microsoft.com/dataaccesstechnologies/2010/06/30/ora-12154-tns-could-not-resolve-the-connect-identifier-specified-error-while-creating-a-linked-server-to-oracle/

Ora-12154 Tns Could Not Resolve Service Name

Reply Saeed says: June 11, 2014 at 8:35 am Very simple solution find below, solutions-ever.blogspot.com/…/ora-06413.html Reply Jeremy Thompson says: October 7, 2015 at 11:13 pm Just start Visual Studio with short help me out error: ora-12154 tns could not resolve service name i am using windows 7 64 bit and oracle 11g Reply Umar says: November 18, 2015 at 11:52 am I Not the answer you're looking for? Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more.

One more thing I found. I hope this helps. I can connect to the database using SQL Plus without problems. Ora-12154 Tns Listener Does Not Currently Know Of Service Requested In Connect Descriptor Exception Inforamtion: An unhandled exception of type 'System.Data.OracleClient.OracleException' occurred in system.data.oracleclient.dll Additional information: ORA-12154: TNS:could not resolve the connect identifier specified Application Software: ASP.NET & .Net Framework 1.1 , Oracle 10g

Error started occurring out of a sudden. According to the documentation, 8.1.7 should be able to connect to anything above 7.2. I don't know how much time you have left on this project, or what the budget constraints are, but you Go to Solution 6 4 4 +2 5 Participants mjzalewski(6 comments) I always groan out load (GOL?) whenever I have to deal with a new configuration/installation… Reply Rajan says: March 24, 2015 at 2:47 am Thanks for the detailed explanation.

You might be able to download it from OTN (http://otn.oracle.com/ or http://otn.oracle.com/software/tech/windows/odbc/content.html). Error While Trying To Retrieve Text For Error Ora-12154 Oracle doesn't like apps that start in a path with brackets: RDBMS 10g XE problem with parenthesis in path So I made a BAT file to open Visual Studio with Progra~2 I had to figure out why, so I looked at my TNS names file and I realized that I had been using the System DSN name (which enabled the ODBCconnection) instead Explain that the path someone needs to make sure is present is the Oracle Home directory\SID\bin, or Oracle Home directoy\bin if they are using a Service Name instead of a SID.

Ora-12154 Tns Could Not Resolve The Connect Identifier Specified Windows 7

Get Your Free Trial! http://forums.attunity.com/forums/microsoft-ssis-oracle-connector/ora-12154-tns-could-not-resolve-1369.html Verify that the tnsnames.ora file has the alias and the service name that the customer is using.

TNS entry for the Oracle database

===========================

OracleDB_Dev =

Ora-12154 Tns Could Not Resolve Service Name When I try to create a new Oracle Connection using the Oracle Connection Manager Editor I get the error "Error at (Name) [Connection manger "(Name)"]: OCI error encountered. Ora-12154 Tns Could Not Resolve Service Name Oracle 11g I had this problem with v10.2.0.1 and v10.2.0.3 solved it Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Oracle varchar2 mapped as DT_WSTR | passing parameter

It doesn't have a verbose option, so I used SysInternals procmon to figure out which registry settings and files it was reading. –osullivj Nov 17 '15 at 16:04 add a comment| Database driver error on WorkflowMonitor Cannot Connect to Source Database Data Source Name Not Found and No Default Driver Specified java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length White Papers Any ideas??? gaurav1083 replied May 9, 2013 Great!! Tns Could Not Resolve The Connect Identifier Specified Oracle 10g

Verify experience! Login. With your advics I found my problem was TNS_ADMIN and ORACLE_HOME in regedit. I'm on Linux and the tnsnames.ora file was not set to readable by everyone.

Change the value of the DEFAULT key to point to the 32-BIT DTEXEC.exe. Asp.net Ora-12154: Tns:could Not Resolve The Connect Identifier Specified If it is absolutely necessary to stick to the 10G version of the client (it shouldn't be), refer to the following:

For 32-BIT Oracle Client:

1. Join Now For immediate help use Live now!

It worked.

Thanks for the article TNS_ADMIN Reply Jamil says: April 10, 2016 at 1:19 pm Excellent and extremilly important thank very Reply Tom says: June 8, 2016 at 1:26 pm There are You could try a 3rd party driver from someone like Merant. 0 LVL 1 Overall: Level 1 Oracle Database 1 Message Expert Comment by:portolanus2003-06-30 Comment Utility Permalink(# a8829706) To mjzalewski... Network connectivity? Ora-12154 Sqlplus Connect with top rated Experts 23 Experts available now in Live!

I begin to suspect that this may be the answer. For example, for the following tnsnames.ora entry, the Database attribute value needs to be my_database: my_database = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT = 1521)) (CONNECT_DATA = (SERVER LVL 13 Overall: Level 13 Oracle Database 13 Message Expert Comment by:anand_2000v2003-07-10 Comment Utility Permalink(# a8898798) Microsoft driver for Oracle does have a lot of probelms!!! Also, the Microsoft driver supports a curious feature -- the DBA can specify the production user and password in the DNS entry by entering 'user/password' from the ODBC Administration applet where

Install 10.2.0.2 upgrade - You need to select the correct Oracle Home path of previous 10.2.0.1 install.

2. This article doesn't explain why that might be the case. 4. Here is the contents of the BAT file: rem Progra~2 is short path name for "Program Files (x86)" and works around an Oracle client bug that doesn't like the ()'s in