- 论坛徽章:
- 0
|
TNS-01153: Failed to process string: (ADDRESS=(PROTOCOL=TCP)(HOST=135.89.205.75)(PORT=1521))
NL-00305: the specified path name does not exist.
node1
listener文件中配置用的是vip 而非主机名,在数据
LISTENER_PUB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.89.205.75)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.89.205.94)(PORT = 1521)(IP = FIRST))
)
)
)
其中75是vip,94是public ip.
node2 listener配置
LISTENER_PUB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.89.205.99)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.89.205.87)(PORT = 1521)(IP = FIRST))
)
)
)
其中99是vip
tnsname.ora配置LISTENERS_IPTV =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.89.205.99)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 135.89.205.75)(PORT = 1521))
)
在数据库中设置了local listener和remote listener.都是直接用vip字符串表示,
SQL> show parameter list
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
local_listener string
(ADDRESS = (PROTOCOL = TCP)(HO
ST = 135.89.205.75)(PORT = 152
1))
remote_listener string
LISTENERS_IPTV
SQL>
中间件jboss配置连接池时指定最少连接数是20,但起jboss时只起了5到6个jdbc连接,虽然连接也是负载均衡到两台rac节点上,jboss启动时,jdbc应该会起最少连接池指定的连接数也就是20个才对,还好的是随着jboss请求访问的增加
jdbc连接数还是可以成功增加和建立起来.
请各位帮忙分析一下.谢谢.
|
|