Oracle Database Discussions

I don't have an accurate answer and I didn't yet find any answer in the documentation, I only have this statement for 10g:
/*
Neither Oracle9i nor Oracle10g Database provides native IPv6 support. The plan is to provide native IPv6 address support, i.e., 128-bit address support, in Oracle Net Services in the upcoming Oracle Database major release.
*/

Obviously 11g is the next major release, so there should be support.

Werner

Thanks Werner.


Oracle database 11g should support does not give me a confident answer.
I want to hear Oracle database 11g does/ does not support IPv6. :-)
Can you please confirm on this?

I would like to clarify few more questions:

I use ojdbc14.jar in my product to connect to oracle database server and for oracle database 11g I need to use ojdbc5.jar.

1) Can you please tell me why to use different jdbc drivers to connect to different database servers.

2) Is ojdbc5.jar backward compatible?

3)Does ojdbc14.jar and 0jdbc5.jar support IPv6?

4) Is there any other component at oracle client side which supports IPv6?

Thanks in advance.

You don't need to 'hear' whether 11g supports IPv6, you can search for this in the 11g installation documentation.
You won't find anything.

1) Oracle enhances their products continually. This results in new drivers.
2) Usually all Oracle software is backwards compatible. Further info, usually, in the documentation
3) Apparently not.
4) Searching for IPv6 in the 11g documentation resulted in no hits.

--
Sybrand Bakker
Senior Oracle DBA

Thank Sybrand Bakker.

I too could not find any stuff related to IPv6 support in Oracle database 11g R1.
Does Oracle database 11g R2 have support for IPv6.
If not when and in which release of oracle databse is Oracle planing to have support for IPv6.
I have heard that Oracle might give a patch to have IPv6 support for Oracle database 11g.Please do comment on this.

Thanks in advance.

I can't provide any authorative answer. No one can.
This information is not public, and Oracle usually doesn't disclose any info about a new release prior to some three months before the actual release.
You would need to get info from Oracle Technical Support on any schedules.
Obviously, if you are an important customer, you'll get it.
If you are not, you'll have to wait like anyone else.

--
Sybrand Bakker
Senior Oracle DBA

Thank you Sybrand Bakker.

Hello,

As I am also looking into that problem, here is the information I found so far :

Oracle® Database Net Services Administrator's Guide
11g Release 1 (11.1)
Part Number B28316-03
February 2008 (Note: this paragraph is not present in the same guide with part number B28316-02 from September 2007)
Oracle Database Support for IPv6
This release of Oracle Database supports IPv6 addressing and connectivity. This support is restricted to commonly used products and components.
A.2.1 Oracle Database Components Supporting IPv6
The following Oracle Database 11g Release 1 components support IPv6:
• Databases running in single-instance mode with local listeners
Note:
Both dedicated and shared server modes are supported.
• Oracle Connection Manager
• Database links
• Client or middle-tier applications that meet the following criteria:
o Deployed with the 11.1.0.6 version of the Oracle Client stack
o Use OCI, OCCI, JDBC, ODBC, OLEDB and ODP.Net data access methods, or were developed with precompilers

How about this ?

In documentation.
Oracle supports the standard IPv6 address notations specified by RFC 2732.

Ref : http://download.oracle.com/docs/cd/B28359_01/network.111/b28316/ipv6.htm

hi
i think the oracle definately must provide the support to this IPv6 , cus oracle keeps update.

I know the followings:

- Oracle 11gR1 support dual stack: both IPv4 and IPv6,
- Oracle 11gr2 support IPv6 only;
- Oracle 11gR2 RAC Database does not support IPv6

Does anyone know whether 11gR2 RAC Database support IPv6? Thanks.

From Metalink note 783570.1, yes native IPv6 is supported ONLY on 11gR2.

The note explains how to set it up.

hi，the oracle company has declared that 11g R2 has support IPV6 and ojdbc6.jar is the right one.
but when I test it .I get exception,have you solved that?
my test code is:
import java.sql.SQLException;
import java.util.Properties;


public class Test {
final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
java.sql.Connection conn=null;
Properties pro=System.getProperties();
//pro.p
pro.setProperty("java.net.preferIPv6Addresses", "true");
System.out.println(System.getProperty("java.net.preferIPv6Addresses"));
//System.setProperties(pro);
String url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=[fe80::b056:5cff:fe78:b672])(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=fnstdb1))";
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(url,"scott","fnst1234");
}
catch (Exception e)
{
System.out.println("ERROR:"+e.getMessage());
}
finally
{
System.out.println("连接是否关闭："+conn.isClosed());
conn.close();
}

}

}
and I use the following cmd:
java -cp ojdbc6.jar -Djava.net.preferIPv6Addresses=true Test
but the result is:ERROR:NL Exception was generated

what is wrong?????