JDE 8.96 oracle database supported in 64 bit for Microsoft Windows x64 Edition (x86-64),
charl...@gmail.com
Database Software
Last Updated: 05-11-2007
Release Level: GA
ONLY THE SOFTWARE AND PLATFORMS SHOWN IN THE CHARTS BELOW
ARE SUPPORTED
ANY DEVIATIONS WILL NOT BE SUPPORTED
Topics in this Document
Requirements for Oracle Database
Requirements for Oracle Database Communications
Requirements for RedHat Linux 3.0 (x86) Oracle Database (EnterpriseOne
8.96)
Requirements for RedHat Linux 4.0 (x86) Oracle Database (EnterpriseOne
8.96)
Requirements for HP UX (PA-RISC) Oracle Database
Requirements for HP-UX (Itanium) Oracle Database
Requirements for Microsoft Windows (x86) Oracle Database
Requirements for Solaris (UltraSPARC) Oracle Database
Requirements for AIX (IBM pSeries) Oracle Database
Requirements for SQL Server 2005 Database
Requirements for SQL Server 2005 Database Communications
Requirements for SQL Server 2000 Database
Requirements for SQL Server 2000 Database Communications
Requirements for DB2 UDB for iSeries
Requirements for DB2 UDB for iSeries Database Communications
Requirements for DB2 UDB Database
Requirements for DB2 UDB Database for RedHat Linux 3.0 (x86)
Requirements for DB2 UDB Database for RedHat Linux 4.0 (x86)
Requirements for DB2 UDB Database for Microsoft Windows (x86)
Requirements for DB2 UDB Database for HP-UX 11.11 (PA-RISC)
Requirements for DB2 UDB Database for HP-UX 11.23 update 2 (PA-RISC)
Requirements for DB2 UDB Database for HP-UX 11.23 update 2 (Itanium)
Requirements for DB2 UDB Database for Solaris (UltraSPARC)
Requirements for DB2 UDB Database for AIX (IBM pSeries)
Requirements for DB2 UDB Database Communications and Administration
The following tables list minimum database software technical
requirements for JD Edwards EnterpriseOne 8.9.
Information Common for all Database Software
TO AVOID A POTENTIAL OPERATIONAL FAILURE
ORACLE HIGHLY RECOMMENDS THAT CUSTOMERS REVIEW VENDOR
REQUIREMENTS FOR ADDITIONAL OPERATING SYSTEM PATCHES THAT NEED
TO BE INSTALLED PRIOR TO ANY DATABASE UPGRADES OR UPDATES
Additional requirements apply in clustered database server
environments. See below for specific clustered database
requirements.
Only the database software and platforms indicated in the charts below
are supported.
Specific Vendor Hardware and Software Information available at
Informational Web Sites for JD Edwards EnterpriseOne 8.9 Document.
Unless otherwise noted in this document, requirements for hardware
platform (processor), operating system, and patch levels for the
database server are the same as for the enterprise server. Refer to
the Enterprise Server MTR document for details.
Requirements for Oracle Database
Database Software
Minimum
Version AIX
(IBM pSeries) HP-UX
(PA-RISC) HP-UX
(Itanium)
Solaris
(UltraSPARC) Red Hat
Linux (x86) Microsoft
Windows (x86)
Oracle 9i R2
32 Bit
Version 9.2.0.4
Version 9.2.0.5
Version 9.2.0.6
Version 9.2.0.7
Version 9.2.0.8
X
For Specifics
SEE BELOW
Oracle 9i R2
64 Bit
Version 9.2.0.4
Version 9.2.0.5
Version 9.2.0.6
Version 9.2.0.7
Version 9.2.0.8
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
Oracle 10g R1
32 Bit
Version 10.1.0.4
Version 10.1.0.5
X
For Specifics
SEE BELOW
Oracle 10g R1
64 Bit
Version 10.1.0.4
Version 10.1.0.5
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
Oracle 10g R2
32 Bit
Version 10.2.0.1
Version 10.2.0.2
X
For Version
3.0 Specifics
SEE BELOW
X
For Version 4.0 Specifics
SEE BELOW
X
For Specifics
SEE BELOW
Oracle 10g R2
64 Bit
Version 10.2.0.1
Version 10.2.0.2
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
General Information:
Note: Only Oracle Certified Database Version and Operating
System is supported.
(See Oracle MetaLink)
Note: Beginning with JD Edwards EnterpriseOne Application
Release 8.11 used with JD Edwards EnterpriseOne Tools 8.94 Oracle is
supported with EnterpriseOnePlatform Pack.
Note: Raw devices are supported with the Oracle database.
Please note that when the EnterpriseOnePlatform Pack is used only
operating system created disk "mount points" can be used. (Ex. /u01/
...). Customers choosing to use raw devices must create the entire
database including all necessary JD Edwards EnterpriseOne tablespaces
using their chosen raw devices.
Oracle 9i R2:
ALERT: Oracle 9i R2: Oracle has recommended that only versions
9.2.0.4, 9.2.0.5, 9.2.0.6, 9.2.0.7 or 9.2.0.8 be used based on the
patch fixes for the Security Alert 68 they issued. Please use the
Oracle MetaLink site and reference the document ID# 282108.1 for
specific details.
Note: Oracle 9i R2: Oracle Server: Standard Edition or
Enterprise Edition is supported in 64 bit for AIX (IBM pSeries), HP-UX
(PA-RISC), HP-UX (Itanium), and Solaris (UltraSPARC). 32 bit is
supported for Microsoft Windows (x86) and Red Hat Linux (x86).
Note: Oracle 9i R2: (9.2.0.4, 9.2.0.5, 9.2.0.6, 9.2.0.7 or
9.2.0.8) Real Application Clusters (RAC) Option of Enterprise Edition
is supported beginning with JD Edwards EnterpriseOne 8.93_A1
Note: Oracle 9i R2: JD Edwards EnterpriseOne 8.9 Shared
Libraries used with Oracle 9.2.0.4, 9.2.0.5, 9.2.0.6, 9.2.0.7 or
9.2.0.8 Database:
libora90.so AIX (IBM pSeries), Solaris (UltraSPARC) and HP-UX
(Itanium)
libora90.sl HP-UX (PA-RISC)
jdboci90.dll Microsoft Windows (x86)
Oracle 10g R1:
Note: Oracle 10g R1: (10.1.0.4, 10.1.0.5) Database software
is supported beginning with JD Edwards EnterpriseOne 8.95_A1.
Note: Oracle 10g R1: Oracle Server: Standard Edition One,
Standard Edition or Enterprise Edition is supported in 64 bit for AIX
(IBM pSeries), HP-UX (PA-RISC), HP-UX (Itanium), and Solaris
(UltraSPARC). 32 bit is supported for Microsoft Windows (x86).
Note: Oracle 10g R1: (10.1.0.4, 10.1.0.5) Real Application
Clusters (RAC) Option of Enterprise Edition is supported beginning
with JD Edwards EnterpriseOne 8.95_A1 (See specific platforms
supported below)
Note: Oracle 10g R1: JD Edwards EnterpriseOne 8.95_A1 Shared
Libraries used with Oracle 10.1.0.4, 10.1.0.5 Database:
libora101.so AIX (IBM pSeries), Solaris
(UltraSPARC) and HP-UX (Itanium)
libora101.sl HP-UX (PA-RISC)
jdboci101.dll Microsoft Windows (x86)
Oracle 10g R2:
Note: After installation of the Oracle Database software
ORACLE_HOME and subsequent directories will have the wrong
permissions. This problem will only allow only the OS user oracle to
be able to run such programs as SQL*Plus. You must apply the
following patch which is available from Oracle Metalink: 4516865
Note: Oracle 10g R2: (10.2.0.1, 10.2.0.2) Database software
is supported beginning with JD Edwards EnterpriseOne 8.96
Note: Oracle 10g R2: (10.2.0.2) Database software is
supported in 64 bit for Microsoft Windows x64 Edition (x86-64)
beginning with JD Edwards EnterpriseOne 8.96.1
Note: Oracle 10g R2: Oracle Server: Standard Edition One,
Standard Edition or Enterprise Edition is supported in 64 bit for
Microsoft Windows x64 Edition (x86-64), AIX (IBM pSeries), HP-UX (PA-
RISC), HP-UX (Itanium), and Solaris (UltraSPARC). 32 bit is supported
for Microsoft Windows (x86) and Red Hat Linux (x86).
Note: Oracle 10g R2: (10.2.0.1, 10.2.0.2) Real Application
Clusters (RAC) Option of Enterprise Edition is supported beginning
with JD Edwards EnterpriseOne 8.96 (See specific platforms supported
below)
Note: Oracle 10g R2: (10.2.0.2) Real Application Clusters
(RAC) Option of Enterprise Edition is supported in 64 bit for
Microsoft Windows x64 Edition (x86-64) beginning with JD Edwards
EnterpriseOne 8.96.1
Note: Oracle 10g R2: (10.2.0.1, 10.2.0.2) JD Edwards
EnterpriseOne 8.96 Shared Libraries used with Oracle 10.2.0.1,
10.2.0.2 Database:
libora101.so AIX (IBM pSeries), Solaris
(UltraSPARC), Red Hat Linux (x86) and HP-UX (Itanium)
libora101.sl HP-UX (PA-RISC)
jdboci101.dll Microsoft Windows (x86) and Microsoft Windows x64
Edition (x86-64)
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Certifications for Real Application Clusters are
performed against the Operating System and Clusterware versions. The
corresponding system hardware is offered by system vendors and
specialized technology vendors. Some system vendors offer pre-
installed, pre-configured RAC clusters. Oracle will support the
Oracle software on clusters comprised of RAC compatible technologies
and certified software combinations. Please consult your hardware
vendor as not all vendors may choose to support their hardware in
every possible cluster combination. Only the database software and
platforms indicated in the charts below are supported.
Requirements for Oracle Database Communications
Oracle
Database Communications AIX
(IBM pSeries) HP-UX
(PA-RISC) HP-UX
(Itanium) Solaris
(UltraSPARC) Red Hat
Linux (x86) Microsoft
Windows (x86)
Oracle Client Software
X
X
X
X
X
X
PROTOCOL
Note: Only TCP/IP and IPC Protocols are supported.
IPC PROTOCOL
Note: IPC Protocol should be used when running JD Edwards
EnterpriseOne Server Software on the same server as the database.
Note: An Oracle Client is considered any machine that needs to
communicate with the Database Server.
Note: The Oracle Client Software must match the release version of
Oracle Server Software.
Note: The Oracle sqlnet.ora file and tnsnames.ora file must be
configured to communicate with the Database Server Oracle Database.
Note
Requirements for Red Hat Linux 3.0 (x86) Oracle Database
(EnterpriseOne 8.96)
Operating System Requirements Minimum Supported Oracle Versions
Red Hat Enterprise Linux
AS 3.0 - Update 5 Required
Oracle Server Standard Edition One
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle Server Standard Edition
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle Server Enterprise Edition
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle Server Enterprise Edition with RAC Option
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
General Information:
Note: Red Hat Enterprise Linux AS 3.0 - Update 5 is supported in 32
Bit Only
Note: Red Hat Enterprise Linux AS 3.0 - Update 5 is supported with
Oracle 10g R2
Note: Please see specific Oracle version below for compatible
Operating System Version
Note: Refer to current release notes and Oracle Metalink Note:
169706.1 for necessary O/S Kernel settings.
Note: Raw devices are supported with the Oracle database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Oracle 10g R2:
Note: Oracle 10g R2: Database software is supported beginning
with JD Edwards EnterpriseOne 8.96
Note: Oracle 10g R2: Oracle requires use of RedHat Enterprise
Linux Advanced Server 3.0 - Update 5
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition.
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for Red Hat Linux 4.0 (x86) Oracle Database
(EnterpriseOne 8.96)
Operating System Requirements Minimum Supported Oracle Versions
Red Hat Enterprise Linux
AS 4.0 - Update 2 Required
Oracle Server Standard Edition One
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle Server Standard Edition
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle Server Enterprise Edition
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle Server Enterprise Edition with RAC Option
Oracle 10g R2 - 32 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 32 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle 10g R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
General Information:
Note: Red Hat Enterprise Linux AS 4.0 - Update 2 is supported in 32
Bit Only
Note: Red Hat Enterprise Linux AS 4.0 - Update 2 is supported with
Oracle 10g R2
Note: Please see specific Oracle version below for compatible
Operating System Version
Note: Refer to current release notes and Oracle Metalink
Note: Raw devices are supported with the Oracle database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Oracle 10g R2:
Note: Oracle 10g R2: Database software is supported beginning
with JD Edwards EnterpriseOne 8.96
Note: Oracle 10g R2: Oracle requires use of RedHat Enterprise
Linux Advanced Server 4.0 - Update 2
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition.
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for HP-UX (PA-RISC) Oracle Database
Operating System Requirements Minimum Supported Oracle Versions
HP-UX (PA-RISC) 11i (11.11)
HP-UX (PA-RISC) 11i v2 (11.23)
Oracle Server Standard Edition One
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle Server Standard Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle Server Enterprise Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle Server Enterprise Edition with RAC Option
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
General Information:
Note: Please see specific Oracle version below for compatible
Operating System Version
Note: This is a 64 Bit product and 64 Bit hardware is absolutely
required.
Note: Refer to current release notes and Oracle Metalink Note:
169706.1 for necessary O/S Kernel settings.
Note: Verify the following symbolic links are created:
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl
Note: Raw devices are supported with the Oracle database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Oracle 9i R2:
Note: Oracle 9i R2: HP-UX (PA-RISC) 11i (11.11) Install all
the OS patches/patch bundles, mentioned in Oracle 9i R2 Release Notes
or superseding patches, patch bundles. As per the Release Notes and
Oracle Metalink Note: 169706.1 the required OS patches to run Oracle
9i R2 on HP-UX (PA-RISC) 11i (11.11) are:
Note: Oracle 9i R2: HP-UX (PA-RISC) 11i (11.11) required O/S
patches:
Support Plus Bundle
'December 2002 SP-0212'
PHCO_24402 s/b
PHCO_25569
PHCO_28427 s/b
PHCO_29029
PHCO_31903
PHKL_25506
PHNE_27745 s/b
PHNE_30580
PHNE_28568 s/b
PHNE_30378
PHSS_26560 s/b
PHSS_30966
PHSS_26946
PHSS_28849
PHSS_26263
PHSS_24638
JDK 1.3.1.02
Oracle 10g R1:
Note: Oracle 10g R1: HP-UX (PA-RISC) 11i (11.11) Install
all the OS patches/patch bundles, mentioned in Oracle 10g R1 Release
Notes or superseding patches, patch bundles. As per the Release Notes
and Oracle Metalink Note: 169706.1 the required OS patches to run
Oracle 10g R1 on HP-UX (PA-RISC) 11i (11.11) are:
Note: Oracle 10g R1: HP-UX (PA-RISC) 11i (11.11) required O/
S patches:
GOLDQPK11i, June 2003 or
later
GOLDAPPS11i
GOLDBASE11i
Jun03GQPK11i_Aux_Patch (Does not exist, see Oracle Metalink Bug:
3512068)
PHCO_28123
PHKL_29198
PHNE_28476 s/b
PHNE_29825
PHNE_28923 s/b
PHSS_30049
PHSS_28871
PHSS_28880
PHCO_26331 s/b
PHCO_27958
PHCO_29109 s/b
PHCO_29960
PHKL_25468 s/b
PHKL_30542
PHKL_25842
PHKL_25993
PHKL_25994
PHKL_25995 s/b
PHKL_30541
PHKL_26468 s/b
PHKL_27316
PHKL_28489
Note: Oracle 10g R1: HP-UX (PA-RISC) 11i v2 (11.23) In
order to install Oracle 10g R1 on please use the
-
ignoreSysPreReqs flag with runInstaller
Oracle 10g R2:
Note: Oracle 10g R2: HP-UX (PA-RISC) 11i (11.11) Install
all the OS patches/patch bundles, mentioned in Oracle 10g R2 Release
Notes or superseding patches, patch bundles. As per the Release Notes
and Oracle Metalink Note: 169706.1 the required OS patches to run
Oracle 10g R2 on HP-UX (PA-RISC) 11i (11.11) are:
Note: Oracle 10g R2: HP-UX (PA-RISC) 11i (11.11) required O/
S patches:
GOLDQPK11i, December 2004 or
later
PHNE_31097
PHSS_31221
PHSS_30970
Note: Oracle 10g R2: HP-UX (PA-RISC) 11iv2 (11.23) required
O/S patches:
PHSS_31849
PHSS_31852
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition.
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for HP-UX (Itanium) Oracle Database
Operating System Requirements Minimum Supported Oracle Versions
HP-UX (Itanium)
11i v2 (11.23)
Oracle Server Standard Edition One
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle Server Standard Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle Server Enterprise Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
Oracle Server Enterprise Edition with RAC Option
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Reference MetaLink Note 363721.1)
General Information:
Note: Please see specific Oracle version below for compatible
Operating System Version
Note: This is a 64 Bit product and 64 Bit hardware is absolutely
required.
Note: Refer to current release notes and Oracle Metalink Note:
169706.1 for necessary O/S Kernel settings.
Note: Raw devices are supported with the Oracle database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Oracle 9i R2:
Note: Oracle 9i R2: HP-UX (Itanium) 11i v2 (11.23) Install
all the OS patches/patch bundles, mentioned in Oracle 9i R2 Release
Notes or superseding patches, patch bundles.
Oracle 10g R1
Note: Oracle 10g R1: HP-UX (Itanium) 11i v2 (11.23)
Oracle 10g R2
Note: Oracle 10g R2 : HP-UX (Itanium) 11i v2 (11.23)
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition.
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for Windows Oracle Database
Operating System Requirements Minimum Supported Oracle Versions
Windows 2003
Oracle Server Standard Edition One
Oracle 10g R1 - 32 Bit 10.1.0.4
Oracle 10g R1 - 32 Bit 10.1.0.5
Oracle 10g R1 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R2 - 32 Bit 10.2.0.1
Oracle 10g R2 - 32 Bit 10.2.0.2
Oracle 10g R2 - 64 Bit 10.2.0.2
Oracle Server Standard Edition
Oracle 9i R2 - 32 Bit 9.2.0.4
Oracle 9i R2 - 32 Bit 9.2.0.5
Oracle 9i R2 - 32 Bit 9.2.0.6
Oracle 9i R2 - 32 Bit 9.2.0.7
Oracle 9i R2 - 32 Bit 9.2.0.8
Oracle 9i R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R1 - 32 Bit 10.1.0.4
Oracle 10g R1 - 32 Bit 10.1.0.5
Oracle 10g R1 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R2 - 32 Bit 10.2.0.1
Oracle 10g R2 - 32 Bit 10.2.0.2
Oracle 10g R2 - 64 Bit 10.2.0.2
Oracle Server Enterprise Edition
Oracle 9i R2 - 32 Bit 9.2.0.4
Oracle 9i R2 - 32 Bit 9.2.0.5
Oracle 9i R2 - 32 Bit 9.2.0.6
Oracle 9i R2 - 32 Bit 9.2.0.7
Oracle 9i R2 - 32 Bit 9.2.0.8
Oracle 9i R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R1 - 32 Bit 10.1.0.4
Oracle 10g R1 - 32 Bit 10.1.0.5
Oracle 10g R1 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R2 - 32 Bit 10.2.0.1
Oracle 10g R2 - 32 Bit 10.2.0.2
Oracle 10g R2 - 64 Bit 10.2.0.2
Oracle Server Enterprise Edition with RAC Option
Oracle 9i R2 - 32 Bit 9.2.0.4
Oracle 9i R2 - 32 Bit 9.2.0.5
Oracle 9i R2 - 32 Bit 9.2.0.6
Oracle 9i R2 - 32 Bit 9.2.0.7
Oracle 9i R2 - 32 Bit 9.2.0.8
Oracle 9i R2 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R1 - 32 Bit 10.1.0.4
Oracle 10g R1 - 32 Bit 10.1.0.5
Oracle 10g R1 - 64 Bit - Not supported with JD Edwards EnterpriseOne
Oracle 10g R2 - 32 Bit 10.2.0.1
Oracle 10g R2 - 32 Bit 10.2.0.2
Oracle 10g R2 - 64 Bit 10.2.0.2
General Information:
Note: Please see specific Oracle version below for compatible
Operating System Version
Oracle 9i R2:
Note: Oracle 9i R2: Windows 2003 - 32 Bit is only supported.
Oracle 10g R1
Note: Oracle 10g R1: Windows 2003 - 32 Bit is only
supported.
Oracle 10g R2
Note: Oracle 10g R2 : Windows 2003 - 32 Bit is only
supported with the 32-bit version of Oracle 10g R2.
Note: Oracle 10g R2: Windows 2003 R2 - 32 Bit is only
supported with the 32-bit version of Oracle 10g R2 with 10.2.0.2
Minimum Required.
Note: Oracle 10g R2 : Windows 2003 - 64 Bit is only
supported with the 64-bit version of Oracle 10g R2 with 10.2.0.2
Minimum Required.
Note: Oracle 10g R2: Windows 2003 R2 - 64 Bit is only
supported with the 64-bit version of Oracle 10g R2 with 10.2.0.2
Minimum Required.
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition.
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for Solaris (UltraSPARC) Oracle Database
Operating System Requirements Minimum Supported Oracle Versions
Solaris 8 - 64 Bit
Solaris 9 - 64 Bit
Solaris 10 - 64 Bit
Oracle Server Standard Edition One
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Mandatory Patch 5117016) (Then
Apply Patch 5087548)
Oracle Server Standard Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Mandatory Patch 5117016) (Then
Apply Patch 5087548)
Oracle Server Enterprise Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Mandatory Patch 5117016) (Then
Apply Patch 5087548)
Oracle Server Enterprise Edition with RAC Option
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Mandatory Patch 5117016) (Then
Apply Patch 5087548)
General Information:
Note: Please see specific Oracle version below for compatible
Operating System Version
Note: This is a 64 Bit product and 64 Bit hardware is absolutely
required.
Note: Refer to current release notes and Oracle Metalink Note:
169706.1 for necessary O/S Kernel settings.
Note: Raw devices are supported with the Oracle database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Oracle 9i R2:
Note: Oracle 9i R2: Solaris 8, 9 and 10 is supported.
Note: Oracle 9i R2: Oracle 9i R2 supports Solaris 10
beginning with 9.2.0.5
Note: Oracle 9i R2: Solaris 8, 9 and 10 must be 64 Bit.
Note: Oracle 9i R2: Starting with Oracle version 9.2.0.4,
the Server product is always in 64 Bit and ships with both a 32 Bit
and 64 Bit client. If the Server product is 64 Bit then 64 Bit
hardware (processors) is required.
Note: Oracle 9i R2: Oracle 9.2.0.4, 9.2.0.5, 9.2.0.6,
9.2.0.7 and 9.2.0.8 are 64 Bit products and 64 Bit hardware is
absolutely required.
Note: Oracle 9i R2: Solaris 8 required patch:
108528-05
Note: Oracle 9i R2: Solaris 8, 9, and 10 required OS
packages:
SUNWarc,
SUNWbtool,
SUNWhea,
SUNWlibm,
SUNWlibms,
SUNWmfrun,
SUNWsprot,
SUNWtoo
SUNWi1of and SUNWxwfnt (for Java)
SUNWsprox (Not applicable to Solaris 10)
Note: Oracle 9i R2: Solaris 10: In order to install Oracle
9i R2 please use the
-
ignoreSysPreReqs flag with runInstaller
Oracle 10g R1:
Note: Oracle 10g R1: Solaris 8, 9 and 10 is supported
Note: Oracle 10g R1: Solaris 10 supports Oracle 10g R1
beginning with 10.1.0.4 or 10.1.0.5
Note: Oracle 10g R1: Solaris 8, 9 and 10 must be 64 Bit.
Note: Oracle 10g R1: Oracle 10g R1 is a 64 Bit product and
64 Bit hardware is absolutely required
Note: Oracle 10g R1: Solaris 8 required patches:
108528-23
108652-66
108773-18
108921-16
108940-53
108987-13
108989-02
108993-18
109147-24
110386-03
111023-02
111111-03
111308-03
111310-01
112396-02
111721-04
112003-03
112138-01
Note: Oracle 10g R1: Solaris 9 required patches:
112233-11
111722-04
Note: Oracle 10g R1: Solaris 8, 9, and 10 required OS
packages:
SUNWarc,
SUNWbtool,
SUNWhea,
SUNWlibm,
SUNWlibms,
SUNWmfrun,
SUNWsprot,
SUNWsprox (Not applicable to Solaris 10),
SUNWtoo,
SUNWxwfnt,
SUNWi1cs,
SUNWi15cs,
SUNWi1of
SUNWuiu8,SUNWulcf (if Oracle Bug:4025250 occurs)
Note: Oracle 10g R1: Solaris 10 Installation Information:
1. Execute runInstaller with the -ignoreSysPrereqs option.
2. Select 'Do not create a starter database' when installing
Oracle 10g.
3. During installation, the warning message 'SUNWsprox package not
installed' can be ignored. Press Continue to resume the installation.
4. Download and install patch 4365826 from metalink.oracle.com.
5. Download and install 10.1.0.4, or 10.1.0.5
6. If you have an End User Solaris 10 distribution, install the
SUNWuiu8 package prior to installing the 10g client.
Oracle 10g R2:
Note: Bug 5117016 Solaris: Mandatory Patch for 10.2.0.2 on
Solaris. Metalink Note 394933.1 gives a brief overview of this bug.
(Apply Mandatory Patch 5117016) (Then Apply Patch 5087548)
Note: Oracle 10g R2: Solaris 8, 9 and 10 is supported
Note: Oracle 10g R2: Solaris 8, 9 and 10 must be 64 Bit.
Note: Oracle 10g R2: Oracle 10g R2 is a 64 Bit product and
64 Bit hardware is absolutely required
Note: Oracle 10g R2: Solaris 8 required patches:
108528-23
108652-66
108773-18
108921-16
108940-53
108987-13
108989-02
108993-45
109147-24
110386-03
111023-02
111111-03
111308-03
111310-01
112396-02
111721-04
112003-03
112138-01
112760-05
Note: Oracle 10g R2: Solaris 9 required patches:
112233-11
111722-04
115675-01
113471-08
115675-01
112760-05
Note: Oracle 10g R2: Solaris 8, 9, and 10 required OS
packages:
SUNWarc,
SUNWbtool,
SUNWhea,
SUNWlibm,
SUNWlibms,
SUNWmfrun,
SUNWsprot,
SUNWsprox (Not applicable to Solaris 10),
SUNWtoo,
SUNWxwfnt,
SUNWi1cs,
SUNWi15cs,
SUNWi1of
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for AIX (IBM pSeries) Oracle Database
Operating System Requirements Minimum Supported Oracle Versions
AIX 5.2
AIX 5.3
(see notes below for supported maintenance levels)
Oracle Server Standard Edition One
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Patch 5087548)
Oracle Server Standard Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Patch 5087548)
Oracle Server Enterprise Edition
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Patch 5087548)
Oracle Server Enterprise Edition with RAC Option
Oracle 9i R2 - 64 Bit 9.2.0.4
Oracle 9i R2 - 64 Bit 9.2.0.5
Oracle 9i R2 - 64 Bit 9.2.0.6 (See MetaLink DocID 292946.1)
Oracle 9i R2 - 64 Bit 9.2.0.7 (See MetaLink DocID 292946.1) (Apply
Patch 4533592)
Oracle 9i R2 - 64 Bit 9.2.0.8 (Apply Patch 5606601)
Oracle 10g R1 - 64 Bit 10.1.0.4
Oracle 10g R1 - 64 Bit 10.1.0.5
Oracle 10g R2 - 64 Bit 10.2.0.1 (Apply Patch 4516865)
Oracle 10g R2 - 64 Bit 10.2.0.2 (Apply Patch 5087548)
General Information:
Note: All Oracle 9i Database and Oracle 10g Database customers who
are running on AIX 5L V5.3 Technology Level 5 (TL 5300-05) must
reference Metalink Note 282036.1 titled Minimum Software Versions and
Patches Required to Support Oracle Products on IBM pSeries
Note: Please review Oracle Metalink Note: 169706.1 (Oracle RDBMS
on (UNIX Platforms): Versions, Sizes, Requirements Quick Reference.
Note: Please review Oracle Metalink Note: 282036.1 (Minimum
Software Versions and Patches Required to Support Oracle Products on
IBM pSeries). This is a dynamic document so users should check back
for any document updates before installing or updating software.
Note: Please see specific Oracle version below for compatible
Operating System Version.
Note: Raw devices are supported with the Oracle database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Oracle 9i R2:
Note: Oracle 9i R2: AIX 5.2 Maintenance level 1, or 5.3 is
supported.
Note: Oracle 9i R2: Starting with Oracle version 9.2.0.4,
the Server product is always in 64 Bit and ships with both a 32 Bit
and 64 Bit client. If the Server product is 64 Bit then 64 Bit
hardware (processors) is required.
Note: Oracle 9i R2: Oracle 9.2.0.4, 9.2.0.5, 9.2.0.6,
9.2.0.7 and 9.2.0.8 are 64 Bit products and 64 Bit hardware is
absolutely required.
Note: Oracle 9i R2: AIX 5L required OS packages:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
Oracle 10g R1:
Note: Oracle 10g R1: AIX 5.2 Maintenance level 1, or 5.3 is
supported
Note: Oracle 10g R1: This is a 64 Bit product and 64 Bit
hardware is absolutely required.
Note: Oracle 10g R1: AIX 5.2 required OS patches:
IY43980
IY44810
IY45462
IY45707
IY46214
IY46605
IY48525
IY51801
IY59082 refer to
Oracle Metalink Note 285158.1
Note: Oracle 10g R1: AIX 5.3 required OS patches: Refer to
Oracle Metalink Note 282036.1
IY58143
IY59386
IY60930
Note: Oracle 10g R1: AIX 5L required OS packages:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
Oracle 10g R2:
Note: Oracle 10g R2: AIX 5.2 Maintenance level 4, or 5.3
Maintenance level 2 is supported
Note: Oracle 10g R2: This is a 64 Bit product and 64 Bit
hardware is absolutely required.
Note: Oracle 10g R2: AIX 5.2 ML4 required OS patches:
IY63133
IY64978
IY63366
IY64691
IY64737
IY65001
Note: Oracle 10g R2: AIX 5.3 ML2 required OS patches:
IY58143
IY59386
IY60930
IY66513
IY70159
Note: Oracle 10g R2: AIX 5L required OS packages:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
Oracle Enterprise Edition with Real Application Clusters (RAC) Option:
Note: Refer to the Oracle Metalink Certification Matrices and
Product Availability for platform specific requirements that must be
met when using the RAC option of Oracle Database Enterprise Edition.
Note: When using Oracle RAC with JD Edwards EnterpriseOne the
following Oracle parameter must be set:
max_commit_propagation_delay = 0
Requirements for SQL Server 2005 Database
Support for SQL Server 2005 begins with EnterpriseOne Tools 8.96_F1.
Database Software Microsoft Windows (x86) Microsoft Windows
(x64)
Microsoft SQL Server 2005
32 Bit Service Pack 1
X
Microsoft SQL Server 2005
for x64-based Systems Service Pack 1
X
Supported Microsoft SQL Server 2005 Editions:
Microsoft SQL Server 2005 Standard Edition (32-bit)
Microsoft SQL Server 2005 Enterprise Edition (32-bit)
Microsoft SQL Server 2005 Standard Edition for x64-based Systems
Microsoft SQL Server 2005 Enterprise Edition for x64-based Systems
Note: Oracle validates JD Edwards EnterpriseOne products with
Microsoft SQL Server 2005 Standard Edition. This validation also
extends to Microsoft SQL Server 2005 Enterprise Edition.
General Information:
Note: Support for SQL Server 2005 begins with EnterpriseOne Tools
8.96_F1. Apply the appropriate Planner ESU as listed below:
8.9
PF4671
8.10
PG4759
8.11
PH12097
8.11 SP1
JJ12489
8.12
JK10721
Note: Follow the instructions on the Update Center to apply
current ESUs if any of these have been superseded.
Note: Not all EnterpriseOne components are currently supported
using SQL Server 2005. At this time support for SQL Server 2005
excludes:
· Mobile Sales
· Collaborative Portal (with WebSphere Portal)
· Web Services Gateway, XPI, and prebuilt EnterpriseOne
integrations
· Crystal Reports and Crystal Enterprise
· Business Intelligence 3.0 and 4.0
Refer to the MTR documents for these components for specific
information about supported configurations.
Note: Oracle strongly advises customers to use ODBC instead of
OLEDB for SQL Server 2005 connectivity. For further information
regarding this recommendation, please refer to breaking news document
OTM-04-0003 on Customer Connection.
Note: Hotfix number KB925227 is required to be applied to the SQL
Server 2005 database. This hotfix can be downloaded from the Microsoft
web site.
Requirements for SQL Server 2005 Database Communications
Microsoft SQL Server 2005 Database Communications Microsoft
Windows (x86) Microsoft Windows (x64)
SQL Server Native Client
X
X
SQL Server Native Client:
Note: Microsoft SQL Server Native Client (SNAC) is required on
any machine that will communicate with the database server, for
example, the enterprise server, deployment server, and Windows client.
The SQL Server Native Client can be downloaded from the Microsoft web
site.
Note: If both SQL Server 2000 and SQL Server 2005 databases are
used, the SQL Server Native Client is required instead of the SQL
Server 2000 client.
Requirements for SQL Server 2000 Database
Database Software Microsoft Windows (x86)
Microsoft SQL Server 2000
32 Bit
Service Pack 3a
Service Pack 4
X
Microsoft SQL Server 2000
64 Bit
Not Supported With JD Edwards EnterpriseOne
Supported Microsoft SQL Server 2000 Versions:
Microsoft SQL Server 2000 Standard Edition - 32 Bit
Microsoft SQL Server 2000 Enterprise Edition - 32 Bit
Microsoft SQL Server 2000 - 64 Bit - Not Supported with JD Edwards
EnterpriseOne
Note: Oracle validates JD Edwards EnterpriseOne products with
Microsoft SQL Server 2000 Standard Edition. This validation also
extends to Microsoft SQL Server 2000 Enterprise Edition.
General Information:
Note: Oracle strongly advises customers to use ODBC instead of
OLEDB for SQL Server 2000 connectivity. For further information
regarding this recommendation, please refer to breaking news document
OTM-04-0003 on Customer Connection.
Note: Oracle suggests that all MDAC levels be the same across all
client workstations and servers.
Note: Updates to the installed software may change the MDAC Level
automatically.
Note: Additional MDAC information and reference web sites can be
found on the Informational Web Sites for JD Edwards EnterpriseOne 8.9
Document.
Note: SQL Server 2000 is supported with EnterpriseOnePlatform
Pack.
Requirements for SQL Server 2000 Database Communications
Microsoft SQL Server 2000 Database Communications Microsoft
Windows (x86)
Microsoft SQL Server 2000 Database Communications
32 Bit
X
Microsoft SQL Server 2000
Database Communications
64 Bit
Not Supported With JD Edwards EnterpriseOne
SQL Server 2000 Client:
Note: A SQL Server 2000 Client is considered any machine that
needs to communicate with the Database Server.
MDAC (Microsoft Data Access Components):
Note: Unless otherwise noted the Client Database Component version
should match the Enterprise Server Database Component version.
Note: Oracle suggests that all MDAC levels be the same across all
client workstations and servers.
Note: Updates to the installed software may change the MDAC Level
automatically.
Note: Additional MDAC information and reference web sites can be
found on the Informational Web Sites for JD Edwards EnterpriseOne 8.9
Document.
Requirements for DB2 UDB for iSeries
Database Software
OS/400
(IBM iSeries)
DB2 UDB for iSeries Database
X
Requirements for DB2 UDB for iSeries Database Communications
DB2 UDB for iSeries Database Communications OS/400
(IBM iSeries) Microsoft Windows (x86)
DB2/400
Client
Note: A DB2/400 Client is considered any machine that needs to
communicate with the Database Server.
TCP/IP
X
iSeries Access for Windows (formerly Client Access Express)
X
Note: When connecting a Windows machine that needs to
communicate with DB2 UDB for iSeries, iSeries Access Express must be
installed on the Windows Machine.
Note: The Client Access Express version level must match the AS/
400 Operating System level.
Note: The minimum recommended V5R2 iSeries Access for Windows
service pack is SI08894.
Note: The minimum recommended V5R3 iSeries Access for Windows
service pack is SI11345.
Note: Support for V5R3 starts with JD Edwards EnterpriseOne
8.93_D1.
Note: DB2/400 iSeries Access for Windows service pack download
site is listed on the Informational Web Sites for JD Edwards
EnterpriseOne 8.9
Requirements for DB2 UDB
Database Software
Minimum
Version AIX
(IBM pSeries) HP-UX
(PA-RISC) HP-UX
(Itanium)
Solaris
(UltraSPARC) Red Hat
Linux (x86) Microsoft
Windows (x86)
DB2 UDB Enterprise Server Edition
32 bit
V8.1 and V8.2
X
For Version
3.0 Specifics
SEE BELOW
X
For Version 4.0 Specifics
SEE BELOW
X
For Specifics
SEE BELOW
DB2 UDB Enterprise Server Edition
64 bit
V8.1 and V8.2
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
X
For Specifics
SEE BELOW
General Information:
Note: JD Edwards EnterpriseOne products are not certified with any
IBM DB2 UDB Database Clustering solutions.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Requirements for DB2 UDB Database for RedHat Linux 3.0 (x86)
DB2 UDB Enterprise Server Edition
32 bit
V8.2
DB2 UDB Version 8.1
FixPak 7q - Supported
FixPak 10 - Supported
DB2 UDB Version 8.2.0
V8.2.0 (FixPak 7q) - Supported - Must be applied over 8.2.0 base level
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base level
to 7q
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak/Patch download site is listed on
the Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: UDB 8.2 is supported with EnterpriseOnePlatform Pack.
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 7q
or 10 is required for EnterpriseOnePlatform Pack. The FixPak 7q is
applied to database server only. The FixPak 7q can be downloaded from
IBM/PeopleSoft/EnterpriseOne special site.
Applicable to Red Hat Linux Only
Note: Red Hat Enterprise Linux AS 3.0 is supported in 32 Bit
Only
Note: Raw devices are supported with the DB2 UDB database.
Please note that when the EnterpriseOnePlatform Pack is used only
operating system created disk "mount points" can be used. (Ex. /u01/
...). Customers choosing to use raw devices must create the entire
database including all necessary JD Edwards EnterpriseOne tablespaces
using their chosen raw devices.
Requirements for DB2 UDB Database for RedHat Linux 4.0 (x86)
DB2 UDB Enterprise Server Edition
32 bit
V8.2
DB2 UDB Version 8.1
FixPak 10 - Supported
DB2 UDB Version 8.2.0
V8.2.3 FixPak 10 - Supported
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak/Patch download site is listed on the
Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: UDB 8.2 is supported with EnterpriseOnePlatform Pack.
Applicable to Red Hat Linux Only
Note: Red Hat Enterprise Linux AS 4.0 is supported in 32 Bit
Only.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Requirements for DB2 UDB Database for Microsoft Windows (x86)
Note: DB2 UDB V8.2.0 is equivalent to DB2 UDB V8.1 FixPak 7 level
DB2 UDB Enterprise Server Edition
32 bit
V8.1 and V8.2
DB2 UDB Version 8.1
FixPak 7b - Not supported - Required when applying 7q - (Now
equivalent to DB2 UDB Version 8.2.0)
FixPak 7q - Supported - Must be applied over 7b
FixPak 10 - Supported
DB2 UDB Version 8.2.0
V8.2.0 (FixPak 7q) - Supported - Must be applied over 8.2.0 base
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base to 7q
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak/Patch download site is listed on
the Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: UDB 8.1 is supported with EnterpriseOnePlatform Pack
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 7q
or 10 is required for EnterpriseOnePlatform Pack. The FixPak 7q is
applied to database server only. The FixPak 7q can be downloaded from
IBM/PeopleSoft/EnterpriseOne special site.
Requirements for DB2 UDB Database for HP-UX 11.11 (PA-RISC)
DB2 UDB Enterprise Server Edition
64 bit
V8.1 and V8.2
DB2 UDB Version 8.1
FixPak 7q - Supported
FixPak 10 - Supported
DB2 UDB Version 8.2.0
V8.2.0 (FixPak 7q) - Supported - Must be applied over 8.2.0 base
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base to 7q
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak/Patch download site is listed on the
Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: UDB 8.1 is supported with EnterpriseOne PlatformPack.
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 7q, or
10 is required for EnterpriseOnePlatform Pack. The FixPak 7q is
applied to database server only. The FixPak 7q can be downloaded from
IBM/PeopleSoft/EnterpriseOne special site.
Applicable to UNIX Only
Note: UNIX kernel must be booted in 64 bit for DB2 UDB Version 8.1
and Version 8.2.
Note: Only 64-bit instances are supported.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Applicable to HP-UX (PA-RISC) Only
Note: Support for DB2 UDB Version 8.1 Fixpak 7q or Version 8.2.0
begins with JD Edwards EnterpriseOne 8.94 L1.
June 2003 GOLDBASE11i
June 2003 GOLDAPPS11i
PHCO_27434
PHCO_29960
PHKL_28489
PHSS_26560
PHSS_28871
Requirements for DB2 UDB Database for HP-UX 11.23 Update 2 (PA-RISC)
DB2 UDB Enterprise Server Edition V8.2
64 bit
DB2 UDB Version 8.2.0
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base
Note: Must use V8.2.0 image to install DB2. V8.1 image will not
install on this OS level
Steps to install DB2 UDB V8.2.0
- Copy the V8.2.0 image to a local file system, for example /
db2_cd
- Download and unzip the INDEX.zip file from
http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg21223704
- Go to the local V8.2.0 image and change folder to /db2_cd/
db2/hpux/catalog
- Replace the INDEX file with the one you have downloaded.
- For example, if you are installing ESE, run the following
command to replace the file
cp INDEX.ese /db2_cd/db2/hpux/catalog/INDEX
- Proceed with the product installation from the file is
replaced
- Apply FixPak 10 using the normal procedures.
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 10 is
required for EnterpriseOnePlatform Pack.
Applicable to UNIX Only
Note: UNIX kernel must be booted in 64 bit for DB2 UDB Version
8.2.
Note: Only 64-bit instances are supported.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Applicable to HP-UX 11.23 Update 2 (PA-RISC) Only
Note: Support for DB2 UDB Version 8.2 Fixpak 10 begins with JD
Edwards EnterpriseOne 8.94 L1.
PHNE_32606
Requirements for DB2 UDB Database for HP-UX 11.23 Update 2 (Itanium)
DB2 UDB Enterprise Server Edition V8.2
64 bit
DB2 UDB Version 8.2.0
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base
Note: Must use V8.2.0 image to install DB2. V8.1 image will not
install on this OS level
Steps to install DB2 UDB V8.2.0
- Copy the V8.2.0 image to a local file system, for example /
db2_cd
- Download and unzip the INDEX.zip file from
http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg21223704
- Go to the local V8.2.0 image and change folder to /db2_cd/
db2/hpux/catalog
- Replace the INDEX file with the one you have downloaded.
- For example, if you are installing ESE, run the following
command to replace the file
cp INDEX.ese /db2_cd/db2/hpux/catalog/INDEX
- Proceed with the product installation from the file is
replaced
- Apply FixPak 10 using the normal procedures.
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 10 is
required for EnterpriseOnePlatform Pack.
Applicable to UNIX Only
Note: UNIX kernel must be booted in 64 bit for DB2 UDB Version
8.2.
Note: Only 64-bit instances are supported.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Applicable to HP-UX 11.23 Update 2 (Itanium) Only
Note: Support for DB2 UDB Version 8.2 Fixpak 10 begins with JD
Edwards EnterpriseOne 8.96 E1.
PHNE_32606
Requirements for DB2 UDB Database for Solaris (UltraSPARC)
DB2 UDB Enterprise Server Edition
64 bit
V8.1 and V8.2
DB2 UDB Version 8.1
FixPak 7q - Supported
FixPak 10 - Supported
DB2 UDB Version 8.2.0
Solaris 10 support begins with DB2 UDB Version 8.2.0
V8.2.0 (FixPak 7q) - Supported - Must be applied over 8.2.0 base
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base to 7q
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak/Patch download site is listed on the
Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: UDB 8.1 is supported with EnterpriseOnePlatform Pack.
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 7q, or
10 is required for EnterpriseOnePlatform Pack. The FixPak 7q is
applied to database server only. The FixPak 7q can be downloaded from
IBM/PeopleSoft/EnterpriseOne special site.
Applicable to UNIX Only
Note: UNIX kernel must be booted in 64 bit for DB2 UDB Version 8.1
and Version 8.2.
Note: Only 64-bit instances are supported.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Requirements for DB2 UDB Database for AIX (IBM pSeries)
DB2 UDB Enterprise Server Edition
64 bit
V8.1 and V8.2
DB2 UDB Version 8.1
FixPak 7q - Supported
FixPak 10 - Supported
DB2 UDB Version 8.2.0
V8.2.0 (FixPak 7q) - Supported - Must be applied over 8.2.0 base
V8.2.3 (FixPak 10) - Supported - Must be applied over 8.2.0 base to 7q
EnterpriseOne Information
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak/Patch download site is listed on the
Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: UDB 8.1 is supported with EnterpriseOnePlatform Pack.
Note: Beginning with JD Edwards EnterpriseOne 8.94, FixPak 7q, or
10 is required for EnterpriseOnePlatform Pack. The FixPak 7q hot fix
is applied to database server only. The FixPak 7q can be downloaded
from IBM/PeopleSoft/EnterpriseOne special site.
Applicable to UNIX Only
Note: UNIX kernel must be booted in 64 bit for DB2 UDB Version 8.1
and Version 8.2.
Note: Only 64-bit instances are supported.
Note: Raw devices are supported with the DB2 UDB database. Please
note that when the EnterpriseOnePlatform Pack is used only operating
system created disk "mount points" can be used. (Ex. /u01/...).
Customers choosing to use raw devices must create the entire database
including all necessary JD Edwards EnterpriseOne tablespaces using
their chosen raw devices.
Applicable to AIX (IBM pSeries) Only
Note: IBM VisualAge C++ Version 6.0 with March 2003 C++ Runtime is
required.
Note: For AIX 5.3, APAR IY58143 is required.
Requirements for DB2 UDB Database Communications and Administration
Note: DB2 UDB V8.2.0 is equivalent to DB2 UDB V8.1 FixPak 7 level
DB2 UDB
Database Communications and Administration AIX
(IBM pSeries) HP-UX
(PA-RISC) Solaris
(UltraSPARC) Red Hat
Linux (x86) Microsoft
Windows (x86)
DB2 UDB
Client
Note: A DB2 UDB Client is considered any machine that needs to
communicate with the Database Server.
DB2 UDB
Run-Time Client
32 bit
V8.1 and V8.2
X
X
DB2 UDB
Run-Time Client
64 bit
V8.1 and V8.2
X
X
X
DB2 UDB
Administration Client
32 bit
V8.1 and V8.2
X
X
DB2 UDB
Administration Client
64 bit
V8.1 and V8.2
X
X
X
Note: DB2 UDB Client Version 8.2 FixPak 7a is supported for Unix
and Linux platforms and FixPak 7b is supported for Windows platform
Note: DB2 UDB Client Version 8.2.3 (V8.1 FixPak 10) is supported.
Note: DB2 UDB Client Version 8.1 FixPak 7a, 7b, and 10 are
supported. FixPak 10 is strongly recommended.
Applicable to UNIX (non-Linux) Only
Note: UNIX kernel must be booted in 64 bit for DB2 UDB Version 8.1
and Version 8.2
Applicable to HP-UX (PA-RISC) Only
Note: Support for DB2 UDB Version 8.2 or V8.1 FixPak 7b begins with
JD Edwards EnterpriseOne 8.94 L1.
Note: Required OS patches to run DB2 UDB Version 8.1 on HP-UX (PA-
RISC) 11i (11.11) are:
June 2003 GOLDBASE11i
June 2003 GOLDAPPS11i
PHCO_27434
PHCO_29960
PHKL_28489
PHSS_26560
PHSS_28871
Note: DB2 UDB V8.1 is not supported on HP-UX (PA-RISC) 11i v2
(11.23). V8.1 image will not install on this OS level.
Applicable to AIX (IBM pSeries) Only
Note: For AIX 5.3, APAR IY58143 is required.
Applicable to Windows and UNIX
Note: Run-Time Clients can be utilized for general database
connectivity.
Note: Administration Clients are required for administration of DB2
UDB databases.
Note: The Run-Time and Administration Client software must match
the release version of the DB2 UDB Server Software.
Note: DYNAMIC=1 keyword is required in the [Common] section of
db2cli.ini file.
Note: DB2 UDB special FixPak download site is listed on the
Informational Web Sites for JD Edwards EnterpriseOne 8.9
Note: Reference IBM requirements for Java Runtime Environment (JRE)
Version to run DB2's Java-based tools, such as the Control Center.
Applicable to EnterpriseOne Web Servers with Tools Release 8.93.B1
Note: LOBCACHESIZE=2500000 is required in the [Common] section of
db2cli.ini file.
Special DB2 UDB Version 8.1 Client Information
Note: The 32 Bit client from DB2 UDB V8.1 or V8.2 can access both
32 and 64 Bit DB2 UDB V8.1 or V8.2 instance on the server.