Error Attach Server Ora-12154
Contents |
while creating a linked server to Oracle ★★★★★★★★★★★★★★★ SnehadeepJune 30, 201028 0 0 0 This is one of the most common errors while creating linked
Error While Trying To Retrieve Text For Error Ora-12154
server to Oracle database. Today I will discuss the reason for this ora 12154 error in oracle 11g error and possible resolutions.
Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned ora 12154 error solution message "ORA-12154: TNS:could not resolve the connect identifier specified". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB providerOra 12154 Error In Toad
"MSDAORA" for linked server "LINKED_ORA".
First of all 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 OracleOra 12154 Tns Error
Client on the SQL server. If the SQL server is 64 bit then we 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 noEarly Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? ora 12154 tns could not resolve service name Search on GeoNet Submit to ArcGIS Ideas Error: Failed to connect to
Ora 12154 Tns No Listener
the specified server. Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified. No extended error] Error Message ora 12154 tns could not resolve service name oracle 9i When creating a direct connect from ArcGIS Desktop installed on a computer installed with Windows 64-bit, the following error message is displayed:"Failed to connect to the specified server. Underlying DBMS error[ORA-12154: 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/ TNS:could not resolve the connect identifier specified. No extended error.]" Cause This is a known issue with parentheses in install path names on the Windows 64-bit operating system. Solution or Workaround Perform one of the following workarounds:Reinstall ArcGIS Desktop on a Windows 64-bit computer to a path that does not contain parenthesis. For example:C:\Program Files\ArcGISFix the bug on a 64-bit computer:1. http://support.esri.com/technical-article/000008951 Download and install the Oracle 10g 32 bit client from Oracle.com. This installs version 10.2.0.1 of the client.2. Download and install Oracle Patch Number 4547817, which is '10.2.0.2 Patch for Windows 32-bit'. This upgrades the client to version 10.2.0.2.3. Download and install Oracle 32-Bit Patch Number 5383042. This patch fixes Oracle Bug 3807408:Externally authenticated usernames containing a '(',')' or '=' cannot be authenticated, additionally if a program name / path contains these characters, it may not be possible to connect (ORA-12154). Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000008951 Software: ArcSDE 9.1, 9.2, 9.3, 9.3.1 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Contact Support USA +1-888-377-4575 Name Email URL Please rate your online support experience with Esri's Support website.* Poor Below Satisified Satisfied Above Satisfied Excellent What issues are you having with the site? How can we improve? Submit Feedback sent successfully. Error while sending mail. Loading
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.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: The ORA-12154 is a http://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error 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 ora 12154 you are using. Your service name might have an alias, so 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 ora 12154 tns 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 service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached. Action: The following actions may be appropriate: If you are using local naming (tnsnames.ora file): Make sure that TNSNAMES is listed as one of the values of the names.directory_path parameter in the sqlnet.ora Oracle Net profile. Verify that a tnsnames.ora file exists and is in the proper directory and ishere 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 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 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.Connection") oracle odbc tns share|improve this question edited Oct 15 '08 at 19:26 David Basarab 35.2k38105144 asked Oct 15 '08 at 19:23 Joe 4164811 add a comment| 19 Answers 19 active oldest votes up vote 8 down vote from http://ora-12154.ora-code.com ORA-12154: TNS:could not resolve the connect identifier specified Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolv