SAP Knowledge Base Article - Preview

1901386 - ORA-12154: TNS:could not resolve the connect identifier specified", when trying to connect to Oracle through DCO

Symptom

  • Error message is raised when trying to connect to ECDA DCO (Direct Connect to Oracle)

  % isql -SDCO_Oracle_SRV –U< user> -P< pword>
  Msg 12154, Level 16, State 0: Server 'DCO_Oracle_SRV':
  ORA-12154: TNS:could not resolve the connect identifier specified
  CT-LIBRARY error: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

  • The Oracle SID changed, and therefore corresponding modifications were made in the Oracle tnsnames.ora file and the Sybase DirectConnect for Oracle configuration file.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.5 on HP Itanium
  • Direct Connect to Oracle (DCO) 15.0.1 on HP Itanium
  • Oracle 11x on HO Itanim

This is a generic issue and could happen on most versions and platforms.

 

Product

Sybase Adaptive Server Enterprise 15.5 ; Sybase EnterpriseConnect Data Access 15.7

Keywords

ECDA  Enterprise Connect Data Access, DCO  Direct Connect to Oracle, proxy_table , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.