访问oracle数据库
我下了10201_client_win32和qlsql搭配访问oracle数据库，配置tnsnames.ora如下：
WHXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.13)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.14)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = whxx)
)
)
然后打开qlsql在工具里面做好了设置，电脑的环境变量也加进去了，然后登陆qlsql报错：
ORA-12154：TNS：could not resolve the connect identifier specifier
是不是还缺少什么配置啊？
oracle 数据库
[解决办法]
例：
WHXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WHXX)
)
)
还有listener.ora 是否配置
[解决办法]
直接在dos窗口敲sqlplus username/password@WHXX 看能不能登录
[解决办法]
netca重新删除监听重新配置下应该可以，这玩意有时候排版不同都可能报错。