Oracle Tns 12154 Error
Contents |
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 I will discuss the reason for this error and possible resolutions.
Full errorOra-12154 Tns Could Not Resolve The Connect Identifier Specified Windows 7
message:
OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not asp.net ora-12154: tns:could not resolve the connect identifier specified resolve the connect identifier specified". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB tns could not resolve the connect identifier specified sqlplus provider "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 upOra-12154 Sqlplus
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 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 forError While Trying To Retrieve Text For Error Ora-12154
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 tnsnames.ora file has the alias and the service name that the customer is using. TNS entry for the Oracle database =========================== OracleDB_Dev = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server01.mydomain.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = OracleDB) (SERVER = DEDICATED) ) ) In the above tnsnames.ora file Alias = OracleDB_Dev Service Name: OracleDB (Actual Oracle service naresolve the connect identifier specified"? Article: 00951 Last Reviewed: 7th September 2006 Revision: 1 This error indicates that Oracle is unable ora-12154 tns listener does not currently to locate the service name specified in your Easysoft ODBC-Oracle Driver
Ora-12154 Tns Could Not Resolve Service Name Oracle 11g
ODBC data source. You need to check the Database attribute value in the data source.If you are tns could not resolve the connect identifier specified oracle 10g using the standard Oracle client, the Database attribute value must specify a valid service name defined in tnsnames.ora. For example, for the following tnsnames.ora entry, the Database attribute 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/ value needs to be my_database: my_database = (DESCRIPTION = (ADDRESS = (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 http://www.easysoft.com/support/kb/kb00951.html host is the host name or IP address of the Oracle database server, port 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 conte
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε αυτή την προτίμηση παρακάτω. https://www.youtube.com/watch?v=QVJ1xO2V7Dc Learn more You're viewing YouTube in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ How to could not resolve the ora 12154 error DBA Pro ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής1.9751 χιλ. Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το could not resolve βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Στατιστικά στοιχεία 50.633 προβολές 42 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 43 17 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 18 Φόρτωση... Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είναι ενοικιασμένο. Αυτή η λειτουργία δεν είναι διαθέσιμη αυτήν τη στιγμή. Δοκιμάστε ξανά αργότερα. Δημοσιεύτηκε στις 31 Ιαν 2014In this tutorial you will learn how to resolve the ora 12145 error. Κατηγορία Πρόσωπα και ιστολόγια Άδεια Τυπική άδεια YouTube Εμφάνιση περισσότερων Εμφάνιση λιγότερων Φόρτωση... Αυτόματη αναπαραγωγή Όταν είναι ενεργοποιημένη η αυτόματη αναπαραγωγή, το επόμενο προτεινόμενο βίντεο παίζει αυτόματα. Επόμενο ora