ORA-12154: TNS:could not resolve the connect identifier specified. Solved.

进入系统属性页面

rundll32.exe shell32.dll,Control_RunDLL sysdm.cpl,,3

并添加系统环境变量

ORACLE_HOME = ${path}
TNS_ADMIND =  ${path}
etworkadmin
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK

其中${path} = 从http://www.oracle.com/technetwork/topics/winx64soft-089540.html 下载的 instantclient-basic-windows.x64-12.2.0.1.0.zip 解压目录.

将${path}值追加进系统环境变量Path值，并在${path}下创建子目录 etworkadmin 并创建 tnsnames.ora 文件

注意：目标数据库需要创建监听并开启服务. 状态查询参考命令 lsnrctl status

ora文件参考

# tnsnames.ora Network Configuration File: ${path}
etworkadmin	nsnames.ora
# Generated by Oracle configuration tools.

#LISTENER_ORCL =
#  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.148)(PORT = 1521))

#
#ORACLR_CONNECTION_DATA =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
#    )
#    (CONNECT_DATA =
#      (SID = CLRExtProc)
#      (PRESENTATION = RO)
#    )
#  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.148)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

View Code