解决方法：打开你的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(服务器名)) ) )
