English

FAQ: Has ArcSDE 9.1 SP1 been certified against Oracle 10g Release 2 (10.2.x)?

Question

Has ArcSDE 9.1 SP1 been certified against Oracle 10g Release 2 (10.2.x)?

Answer

Windows
Yes; ArcSDE 9.1 SP1 has been certified for Windows operating systems.

To view certification details for Windows, see the System Requirements Web page by way of the Related Information section below.

Linux and UNIX
No; ArcSDE 9.1 SP1 has not been certified for Linux and UNIX.

For information on why ESRI cannot complete certification, see the link to the Oracle Database Upgrade Guide by way of the Related Information section below.

A bug exists in the Oracle9i R2 client, Oracle bug number: 4775042, and duplicate bug number 3396162, that prevents the Oracle9i R2 client from connecting to an Oracle10g R2 database.

On Linux/UNIX, this Oracle9i R2 client-side issue was identified by Oracle as being fixed in Oracle9i R2 Patch 3396162.

Testing done at ESRI has found this patch does not install to a client ORACLE_HOME. Oracle has confirmed this patch does not apply to an Oracle9i R2 client install.

However, Oracle has recently stated that the issue will be resolved for Linux/UNIX customers in the 9.2.0.8 client, which is expected to be released in May 2006. This means ESRI customers will be able to use the 9.2.0.8 client with an Oracle10g R2 database.

ESRI has also decided to certify ArcSDE 9.1 SP2 with both 9.2.0.8 and 10.2.0.1 clients with the Oracle10g R2 database. This means using ArcSDE 9.1 SP2, ESRI customers will be able to use the 10.2.0.1 client with their 10.2.0.1 database.

Related Information