ORA-12154: TNS: 无法解析指定的连接“/one card”应用程序中的服务器错误

解决方案：

问题发生在listener.org和tnsnames.org配置文件上，重新研究分析后，按照如下配置，并重启oracle server和listener服务，问题解决，配置内容如下，大家可参考修改

在oracle安装目录下D:\app\Lenovo\product\10.2.0\dbhome_2\NETWORK\ADMIN配置listener.org和tnsnames.org文件

listener.org文件

# listener.ora Network Configuration File: D:\app\Lenovo\product\11.2.0\dbhome_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\Lenovo\product\11.2.0\dbhome_2)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Lenovo\product\11.2.0\dbhome_2\BIN\oraclr11.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = D:\app\Lenovo\product\11.2.0\dbhome_2)
      (SID_NAME = orcl)
    )
  )
 
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Eli-Yu-Save)(PORT = 1521))
  )
 
ADR_BASE_LISTENER = D:\app\Lenovo
 

 

tnsnames.org文件

# tnsnames.ora Network Configuration File: E:\app\EDZ\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
 
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
 

也可以通过Oracle - OraDb11g_home1–>配置和移植工具–>Net Manager进行配置监听程序和服务命名

监听程序

 服务命名

2、ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

将listener.ora文件中的SID_NAME的值改为服务器中OracleService的值，重启OracleService