Hi there,
We are fetching ip addresses by executing utl_inaddr.get_host_address for a certain host name a bunch of times. On Oracle 12.1 it delivers a set of ip addresses that is shorter than the one on 19.3 (both run on different physical machines). The list of ip addresses returned on 12.1 have the same first 2 digits, e.g. 192.168. always. The list of ip addresses returned on 19.3 has more diverse ip addresses, e.g. 10.10. but also 192.168.. All ip addresses found on 12.1 are also found on 19.3, but not in reverse.
Doing an nslookup of the hostname on the two servers returns the same set of ip addresses and are varied in nature (not limited to the first 2 digits (192.168.)) ifconfig reports similar network settings, including the same subnet mask and both servers have an ip adress with the same first 2 digits.
I get the feeling that Oracle 12.1 is setup differently and that somehow a subnet mask or something like it is being used during the execution of the utl_inaddr.get_host_address function.
I would like to get the same filter in Oracle 19.3 . Any ideas where such kind of masking might have been set would be much appreciated.
Thanx,
Lennert