error ora-12154:tns:无法解析指定的连接标识符 ORA

解决方法：
打开你的ORACLE的network配置 (oracle的安装目录：如 E:/oracle/product/10.2.0/db_1/NETWORK/ADMIN)
ADMIN目录下有个文件tnsnames.ora
查看有没有配置好服务，也可以按照上面的例子自己手工写进去
如xxx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)

例子：
wrnop_sh(上海数据库)=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.46.161)(PORT = 2234))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = shwrnop(服务器名))
    )
  )