我连接到aix上的oracle如果我的连接字符串写成jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=100.192.100.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=100.192.100.1)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=on))(CONNECT_DATA=(SERVICE_NAME=rac))),在测试连接的时候,一般是测试一次成功,再测试就出现The Network Adapter could not establish connection的问题,然后在测试有成功,如此反复,那我的程序连接上就无法使用了,请问各位高手,高手,高高手帮忙!
如果我单独写,jdbc:oracle:thin:@100.192.100.1:1521:rac1 无论是哪一个地址都能连接上,没有任何问题。跪求答案!
如果我单独写,jdbc:oracle:thin:@100.192.100.1:1521:rac1 无论是哪一个地址都能连接上,没有任何问题。跪求答案!
The Network Adapter could not establish connection的异常
连接的字符串如下:
jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = rac.localdomain)))rac1-vip.localdomain 映射到虚拟的RAC1 IP
rac2-vip.localdomain 映射到虚拟的RAC2 IP
rac.localdomain 全局数据库名
我这样去操作
开始--> 运行--> cmd--> netstat -na
里面没有如下一行:
TCP 127.0.0.1:1521 0.0.0.0:0 LISTENING
是不是这的错误啊,怎么改呢?????