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

RMAN DUPLICATE FROM Active Database From Standby ends with ORA-01671

Hi.

Quite interesting question was asked by one of our customers:

“Is it possible/supported to do RMAN DUPLICATE FOR STANDBY FROM ACTIVE DATABASE when TARGET is STANDBY ?”

It’s really seasonable question, especially when You already have standby database and wanna refresh a development environment using standby as a source/target to not stress primary database .

There are no such restriction in 11.2 “Prerequisites Specific to Active Database Duplication”, so why not ? 😉

But even Oracle wanted to provide mentioned functionality it’s not often used(tested), so let’s see what we get as a result Continue reading

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

Oleksandr Denysenko:

“I’d like to introduce new Contributor to this Blog – Robert Oliynichenko.

Hi will make post on topics that are related to main direction of this Blog.

So, here we have The First Post about Slow 11.2 SQL*Net connections on AIX

Problem description:

Oracle 11g utilities like tnsping, lsnrctl or sqlplus on AIX 6.1 hanged for about 2,5 minutes (150 seconds) before connection with alias to any destination when DNS server was unreachable. In the same conditions (host and configuration) 10g utilities connected without delay. Oracle*Net was configured for local naming method only – NAMES.DIRECTORY_PATH=(tnsnames) in the both 10g and 11g Oracle Home. The tnsnames.ora files where identical in the 10g and 11g Oracle Home. The aliases in the tnsnames.ora used host names instead of IP addresses in the connection descriptions; if a host name was substituted by IP address the delay disappeared for this alias. Nevertheless all the host names from tnsnames where described in the /etc/hosts and resolution order was hosts = local, bind in the netsvc.conf (analog of  the nsswitch.conf in other UNIXs). This configuration should guarantee local name resolution when DNS server was unreachable. What is the root reason of this delay in 11g Oracle*Net ? Continue reading

Oracle Database Patchset 11.2.0.3 is ready to download

Oracle RDBMS PatchSet version 11.2.0.3 is available to download since 23-SEP-2011! some time earlier than OOW2011

But(as of 28-SEP-2011) it’s still available only for Linux x86 and Linux x86-64.

Based on  NOTE:742060.1 Release Schedule of Current Database Releases:

  • 11.2.0.3 will be available for other major Unix/Linux platforms(HP-UX Itanium, Oracle Solaris SPARC (64-bit),  Oracle Solaris x86-64 (64-bit),  IBM AIX on POWER Systems) during the October 2011, perhaps during Oracle Open World 2011 or after it
  • for the rest popular platforms, like  Microsoft Windows (32-bit) and Microsoft Windows x64 (64-bit), and not so popular like IBM Linux on System z, the release date is scheduled for Q4 2011
  • for HP-UX PA-RISC (64-bit) is will be available during 1Q 2011 Continue reading