IBM PowerHA(HACMP) shutdowns oracle 11.2 because of IPv6 and DNS is not accessable

Hi.

Just a quick post with some additions to situation covered in

Investigation of the 11g Oracle*Net connection delay when DNS server is unreachable.

Just a short recap:

  • customer experienced long timeout(slow connection) doing tnsping to 11.2 database running on AIX when DNS server was unreachable;

” tnsping ‘ (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dns-hostname)(PORT = 1521))\ (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XXX)))’

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.3.0 – Production

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dns-hostname)(PORT = 1521))   (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XXX)))

OK (150010 msec)

  • issue was because of IPv6 support was included in Oracle 11g and even if connection hostname was resolved by /etc/hosts to IPv4 client tried to resolve it to IPv6 address too.
  • issue was fixed by replacing local, bind by local4, bind4  in the /etc/netsvc.conf.

So why I’m doing this recap ?

It’s because of mentioned problem was only a part of issue faced during IBM PowerHA(HACMP) cluster with oracle resources testing. Continue reading

Advertisements