访问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
是不是还缺少什么配置啊?
------解决方案--------------------例:
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重新删除监听重新配置下应该可以,这玩意有时候排版不同都可能报错。