最近中联服务器配置工具一直进不了,提示:ORA-12538: TNS: no such protocol adapter,网上找了一圈,也没有找了多种方法,也没有解决,看到这篇日志:
http://www.dba-oracle.com/t_iora_12538_tns_no_protocol_adapter.htm,看到最后:
Solutions:
If TNS_ADMIN is set then you should be able to use a network alias, not the full "(DESCRIPTION..." connect string. The TNS_ADMIN parm tells Oracle clients where to find the tnsnames.ora file.
Setting the ORACLE_HOME environment variable incorrectly on a Windows based system will create this problem.
因为机器装了oracle8i的一个简易客户端,一个oracle 11g服务端,把ORACLE_HOME设置成了oracle 11g的主目录,试着删除,就可以了。解决!!!!!!!!