It is helpful to read these repair guidelines if you receive the error “Linked server error Ora-12154”.
Quick and Easy PC Repair
This is often one of the most common Oracle errors, which more or less tells you that you want to connect to a legitimate database whose name is unknown to the computer. The most common cause is typos in the connection string or in the group configuration files.
First published on MSDN Jun 30, 2010
This is by far one of the most common mistakes, evenwhen creating a linked server with Oracle information. Today I will go over the legitimate cause of this error and you may be able to find some solutions.
OLE DB Provider ‘MSDAORA’ for linked server ‘LINKED_ORA’ returned subject ‘ORA-12154: TNS: Could not resolve ID specified for collection’.
Where is the Tnsnames Ora file located?
By default, you will see tnsnames. ora is located in the entire ORACLE_HOME / network / admin directory.
Msg 7303, Level 16, State 1, Line 1
The OLE DB solution file source object “MSDAORA” that is associated with server “LINKED_ORA” could not be initialized.
First, make sure you read the following Microsoft Knowledge Base article, which has a lot of helpful information on troubleshooting Oracle Restricted Server.
How to set up and restore a linked server to an Oracle database in SQL Server
연결된 서버 오류 Ora 12154
Lankad Serverfel Ora 12154
Linked Server Fehler Ora 12154
Gekoppelde Serverfout Ora 12154
Error Del Servidor Vinculado Ora 12154
Erreur De Serveur Lie Ora 12154
Oshibka Svyazannogo Servera Ora 12154
Blad Serwera Polaczonego Ora 12154
Erro De Servidor Vinculado Ora 12154
Errore Del Server Collegato Ora 12154