我下了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数据库
解决方案 »
- oracle 查询两段数据Union不了。。出现什么未正确结束 求高手指导。。。
- 关于日期分秒的处理
- 帮忙指点 这个触发器问题在哪里啊 谢谢
- 请问oracle如何自动清理日志。
- 关于PL/SQL Developer 代码助手的问题
- willnum>(select avg(willnum),couname,couno from course问题
- 谁能Oracle存储过程语法???
- 如下创建约束,为何不对?
- oracle是不是不能装在单机上,一定要有固定的IP地址
- 在ORACLE9I中运行enterprise manager console时总提示“ORA-12541:TNS:没有监听器”?
- 关于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 是否配置