Oracle Database Discussions

3148407 wrote:
Does Oracle RAC and Failsafe 11gr2 support ipv6?

Oracle itself has NO inherent built in networking capability.

Oracle depends upon OS for packet exchange activity.

Oracle does not know or care about IPV6.

Does that mean Oracle 11g R2 supports the IPv6?

In one of the Oracle document we found below information but this information is only mentioning about the Oracle 12c so posted question for

Oracle 11Gr2

IPv6 Support for Public Networks

Oracle RAC 12c Release 1 (12.1.0.2) on Windows supports IPv6-based public IP and VIP addresses.

IPv6-based IP addresses have become the latest standard for the information technology infrastructure in today's data centers. With this release, Oracle RAC and Oracle Grid Infrastructure support this standard. You can configure cluster nodes during installation with either IPv4 or IPv6 addresses on the same network. Database clients can connect to either IPv4 or IPv6 addresses. The Single Client Access Name (SCAN) listener automatically redirects client connects to the appropriate database listener for the IP protocol of the client request.

Also My question is specific Oracle RAC as it has VIP IP Addresses, SCAN and all

Oracle calls OS when it requires network activity.

If the OS network API is identical for ipv4 as ipv6, then Oracle will operate without error & be oblivious to what really occurs at the network level.

What OS (name & version) are you now running that uses IPV6?

I am looking for both RHEL 7 and Windows 2012 R2 or Windows 2016.

I am from veritas and we support Oracle RAC backup through our product.

Yes, it is supported in VIP.

Not supported in private interconnect.

Public is dependent on whether IPv6 is enabled in your network device.

RohithRNair wrote:
Yes, it is supported in VIP.
Not supported in private interconnect.
Public is dependent on whether IPv6 is enabled in your network device.

please explain how & why the OS supports IPv6 for some network interfaces (VIP & public) but not other interfaces (private) on the same system.

What differentiates public from private interfaces?

IPV6 is supported for the Public and VIP interfaces in 12c.  The Private network must run IPV4.

See Support Document ID 810394.1

Also see Oracle Net Services Product Overview

and http://www.oracle.com/technetwork/database/enterprise-edition/oracledatabaseipv6sod-2141330.pdf

However, since you are running Windows, particularly note this from the StatementOfDirection

Limitations of IPv6 with Oracle Database 12c

IPv6 client connectivity for Oracle RAC databases and Oracle Clusterware running on Windows is not supported in the initial release of Oracle Database 12c (12.1.0.1).

Additionally, neither ASM nor ONS-based FAN notifications are supported for single-instance databases running on Windows in Oracle Database 12c.

IPv6 is not supported on the private network required by Oracle RAC and Oracle Clusterware.

Ask Oracle Support for an updated position with respect to 12.2

Hemant K Chitale

Thanks for detailed information. We need one more input on SQLPLUS connecting to oracle database on the same oracle server.

Will there be any change in the way we used to connect to oracle database using sqlplus? Specifically RAC?

Also please confirm if utilities like SRVCTL(Windows and Linux) , FSCMD, RMAN (Windows and Linux ) are also tranparent to the Protocol being used or we need

changes in a way we connect to target database using these utilities?

Please let us know if IPV6 support for Linux Oracle RAC too has same configuration like Public and VIP on IPv6 while private on IPv4?

Thanks in advance!

The IPv6 should be transparent to sqlplus, srvctl etc.

Grid Infrastructure would configure the interfaces for the VIP.  It should automatically detect the IPv6 and work. 

The Public IP should already have been configured by the System Administrator.

Hemant K Chitale