my oracle rac has 2 nodes A and B.
the ip of A: 192.168.12.179 and 192.168.12.249
the ip of B: 192.168.12.180 and 192.168.12.250
the scan ip is 192.168.12.248
when i use jdbc:oracle:oci:@192.168.12.249:1521/orcl, i always get success result;
when i use jdbc:oracle:oci:@192.168.12.250:1521/orcl, i always get success result;
when i use jdbc:oracle:oci:@192.168.12.248:1521/orcl, i always get success result;
when i use jdbc:oracle:oci:@192.168.12.249:1521/orcl:pooled, i always get success result;
when i use jdbc:oracle:oci:@192.168.12.250:1521/orcl:pooled, i always get success result;
when i use jdbc:oracle:oci:@192.168.12.248:1521/orcl:pooled, sometimes i get success result, sometimes i get error result(ORA-12545);
now, if i shutdown the instance of B and use jdbc:oracle:oci:@192.168.12.248:1521/orcl:pooled, i always get success result;
if i shutdown the instance of A and use jdbc:oracle:oci:@192.168.12.248:1521/orcl:pooled, i always get error result;
is it a bug of oracle???? or is there something wrong with my configuration????? my oracle version is 11.2.0.2.0, the status of database Resident Connection Pooling is active, and there are not iptables running on A and B;
Exactly, the problem is the same with
1098935 but there wasn't anyone can exactly answer.
Thank you.