Symptom
Connect to database using dblink failed with error ORA-12154
For example:
SQL> conn <username>@<dbsid>
Enter password:
Connected.
SQL> select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual@<dblink_name>;
select to_char(sysdate,'dd/mm/yyyy hh24:mi:ss') from dual@<dblink_name>
*
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified
Read more...
Environment
SAP on Oracle
Product
SAP NetWeaver all versions
Keywords
ORA-12154, dblink , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.