Oracle Error 12154 Tns Could Not Resolve Service Name
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 ora-12154 tns could not resolve service name this site About Us Learn more about Stack Overflow the company Business ora-12154 tns could not resolve the connect identifier specified windows 7 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask tns could not resolve the connect identifier specified sqlplus Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
Oracle ORA-12154: TNS: Could not resolve service name Error? up vote 11 down vote favorite 5 I am a SQL Server user . I am on a project that is using oracle (which I rarely use) I need to create an ODBC connection so I can access the some data via MS Access I have a application on my machine called oraHome90. It asp.net ora-12154: tns:could not resolve the connect identifier specified seems to allow a configuration of something called a listener in a “net configuration utility”, I think that a “Local Net Service Name Configuration” needs to also be done. The IT support gave me this information to set up the ODBC connection . I have tried every combination that I can think of. I can get past a test that successfully passes a test to “login“ to the oracle server database. When I try to create the ODBC connection I get the following error: ORA-12154: TNS: Could not resolve service name. Assuming that I want to start from scratch and the following information is supposed to allow for me to connect to the database….. Any suggestions or comment ? Note: ultimately the project will have a website .ASP page query the data, but I have to first prove that I can see the data using the ODBC connection via MS Access Service name: SERVICENAME HOST = HOST.XYZi.com User Id: MYUSERID Password: MYPASSWORD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'Oracle Connection Dim ocst Dim oconn ocst = "Provider=OraOLEDB.Oracle;" & _ "Data Source=DATASOURCE;" & _ "User ID=CHIJXL;" & _ "Password=password;" set oconn = CreateObject("ADODB.Connec
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 Share 0 0 This is one of the most common errors while creating linked server to Oracle database. Today tns could not resolve the connect identifier specified oracle 10g I will discuss the reason for this error and possible resolutions.
Tns Could Not Resolve The Connect Identifier Specified Odbc
Full error message:
OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not resolve theOra-12154 Tns Listener Does Not Currently Know Of Service Requested In Connect Descriptor
connect identifier specified".
Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "LINKED_ORA". First of all http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error make sure you have reviewed the following Microsoft KB article that has a lot of good information on troubleshooting Oracle linked server issues. How to set up and troubleshoot a linked server to an Oracle database in SQL Server http://support.microsoft.com/kb/280106 Also make sure you have installed Oracle Client on the SQL server. If the SQL server is 64 bit then we 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/ need to install 64 bit Oracle provider. You can also create linked server using Oracle ODBC driver together with Microsoft OLE DB provider for ODBC. Once again on a 64 bit SQL server you need to install the 64-Bit OLEDB Provider for ODBC (MSDASQL) and 64 bit Oracle ODBC drivers. However 64-Bit OLEDB Provider for ODBC (MSDASQL) is already there in Windows Vista/Windows Server 2008 and later OS. This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/ In SQL Server Linked Server, it could indicate a few things (not limited to)– 1. SQL Server (and oracle net libraries) is not able to get the TNS alias from tnsnames.ora file. 2. Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax) 3. TNS alias could not be resolved into a connect descriptor Below is a list of things that you can try to resolve this issue. 1. Verify that the tnsnamesSQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
http://web.synametrics.com/oratns.htm ORA-12154: TNS could not resolve service name tips Question: I need help with this error: ORA-12154: TNS: could not resolve service name.Answer: could not The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases. Make sure that your listener is listening for the same service name that you are using. Your service name might have an alias, so could not resolve check for global (world) entries and local entries. Check: $ORACLE_HOME/network/admin/tnsnames.ora Check your global_name setting with this SQL: select * from global_name; The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an ALTER DATABASE command, as follows: alter database rename global_name to xxx; Also see these notes on configuring your tnsnames.ora file and troubleshooting network errors. Rampant author Steve Callan notes this on the ORA-12154 error: "One of the most common errors related to improper configuration is the "ORA-12154: TNS: could not resolve service name" error. It is not uncommon for new users of Oracle to spend hours upon hours trying to figure out what their mistake is when ORA-12154 appears." The oerr utility notes this on the ORA-12154 error:: $oerr ora 12154 ORA-12154: TNS:could not resolve the connect identifier specifiedCause: A connection to a database or other servCost What can it do? SyncriBox New Partners What's new SynaMan Home Download Purchase Support Cost FTP Replacement Other Product/Services Xeams JaySQL SynTail Complete List Purchase Purchase Online Resellers/Partners Support WinSQL Syncrify SynaMan WinSQL KB Syncrify KB SynaMan KB Forums SynaPress Blogs Press Releases In The News Success Stories About Synametrics Contacts Company Info WinSQL » Knowledge base Document informationDocument ID:770Subject:TNS: Could not resolve service name - What does this mean?Creation date:7/29/09 3:00 PMLast modified on:7/29/09 3:00 PMDocument Details When trying to connect to Oracle the following error is generated: ORA-12154: TNS:could not resolve service name Cause This error indicates that the service name specified in your ODBC DSN setup does not exist. 'TNS aliases' or 'service names' are defined locally to each workstation. Thus different workstations could have a completely different alias to refer to the same database. SolutionCheck what aliases or service names are defined on the workstation and specify that value in the ODBC DSN. An invalid or non-existent name will result in this error. The following methods can be used to view existing TNS Service names on your machine: Look in the file 'ORANT\Network\Admin\Tnsnames.ora' (for versions of Oracle prior to 8.1) or 'Oracle\Ora81\ Network\Admin\Tnsnames.ora' (for versions of Oracle from 8.1 onwards). In this file each defined name will normally have ".world" appended to it.For Oracle 8, run "Oracle Net8 Easy Config". This will list the available service names.For Oracle 7, run "SQL Net Easy Configuration". This provides the option to list the available service names.For Oracle 8.1 onwards: Try specifying the full service name, i.e. as it appears in the tnsnames file. User commentsPosted by Ed Giarrusso on 1/19/11 10:18 AMWe had this problem after completing a default on a 2008 x64 server. ODBC connectivity test passed but WinSQL would fail to connect using the same ODBC. To resolve this problem I uninstalled and reinstalled to a folder that did not have the (x86) in the path. Ed Giarrusso Network Administrator The TImes-PicayunePosted by Prince on 3/8/16 6:20 AMHi Friend I have successfully installed Oracle 11g but now i have facing error which is error: ORA-12154: TNS: could not resolve service name Plz give me solution Posted by Richard Stanton on 4/29/11 10:16 AMthat tip worked for me too (although it kept trying to insta