我下了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 = (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数据库
解决方案 »
- 我有一个表,这个表里的两个字段都是检修周期,检修时间,检修周期的单位是D,M,Y,表示天,月,年,如何用decode进行两个字段相加
- oracle 问题:the account is locked
- sql语句的优化。
- 如何标记记录的多个状态,select的时候取余作为条件对性能影响大不大
- [100分求救]在同一架机子上安装不同版本的Oracle(Oracle9i及Oracle8i)步骤及注意事项
- 在线等,安装过8.1.X的请进来
- oracle 8i 数据库如何备份与恢复?
- oracle 启动不了!说是没有“监听”。
- 如何对字段进行加密解密?--高分送高手
- 我是新手,想学oracle databases如何入门
- 关于Orcle的安装遇到的问题,本人新手,莫鄙视,求解决
- 关于oracle排序 在线等
这样写:
WHXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = whxx)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = whxx)
)
)
WHXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WHXX)
)
)
还有listener.ora 是否配置