[解决]ORA-12514:TNS:监听进程不能解析SERVICE_NAME

只要去修改以下tnsnames.ora文件就可以了
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = "host")(PORT = "port"))
    )
    (CONNECT_DATA =
      (SID = "databasename")
      (SERVER = DEDICATED)
    )
  )
其中把引号部分进行相应的替代就可以了