3 Setting Up a Development Client Installer on the Deployment Server

This chapter discusses these topics:

3.1 Understanding the JD Edwards Clients (Development and Web)

The JD Edwards EnterpriseOne Development Client (also known as a Web Development Client, "Fat" Client, Administrative Client, Windows client, or Workstation) contains components that run as standard Microsoft Windows applications (for example, Active Console, Forms Design Aid (FDA), and Report Design Aid (RDA)) and components that run in a web browser.

Note:

This document uses the following terminology when discussing JD Edwards EnterpriseOne clients:
  • Web Client

    Components that run in a web browser.

  • Development Client

    Composed of standard Windows components and Web Client.

The Web Client part of the Development Client runs inside an Application Server. The supported Application Servers are:

  • Oracle Application Server (OAS)

  • IBM WebSphere Application Server (WAS) Express or WebSphere Application Server for Developers.

The Oracle Application Server is included as part of the JD Edwards EnterpriseOne system code and is automatically configured to work with the Web Client when you install the Web Client for OAS. This version of the Web Client is known by any of the following names:

  • Oracle Containers for Java HTML for Applications,

  • OC4J for H4A, or simply

  • OH4A

Although OAS is included with JD Edwards EnterpriseOne system code, you can choose to use WAS Express or WAS for Developers as the Application Server for the EnterpriseOne Web Client. Both products are similar; either one may be manually installed before installing the Web Client for WAS. Whereas WAS Express requires a licensing fee to IBM, WAS for Developers is free. The version of the Web Client that is installed on either WAS product is referred to by either of these names:

  • HTML for Applications, or

  • H4Ax (where the "x" denotes the version of WAS Express or WAS for Developers. For example, in Tools Release 9.1 the supported version is WAS 7.0)

    Tools Release 9.1 Update 2.3

    Support for WAS 8.5 is added making this value H4A85.

This chapter describes the first time setup of the JD Edwards EnterpriseOne Development Client installer and installation package on an EnterpriseOne Deployment Server. This setup on the Deployment Server must be done before a user can install a JD Edwards EnterpriseOne Development Client on a workstation. The installation package specifies the components to install and may or may not include the Web Client.

For instructions on how to install Web Clients for both Application Servers: OH4A and H4A7/H4A85, as well as the installation of WAS 7/8.5 Express or WAS 7/8.5 for Developers, refer to the JD Edwards EnterpriseOne Development Client Installation Guide.

3.2 Understanding the Oracle Universal Installer

As of Tools Release 9.1, the Development Client is installed using the Oracle Universal Installer (OUI). In addition, the Web Client is installed as a package feature using OUI. When you run the 9.1 Tools Release installer on the Deployment Server, it copies the OUI installers for the Development Client and Web Client to the correct location on the Deployment Server. The location of the Development Client installer is:

\\<deployment server name>\<release>\OneWorld Client Install

Underneath this directory are the following. Only noteworthy files and directories are listed. Those under ThirdParty may or may not exist depending on which features are defined.

  • InstallManager.exe

    The program that the user runs to install the local database and the Development Client.

  • Installmanager.htm

    This HTML file is read by InstallManager.exe and contains commands to display a Graphical User Interface (GUI) and allows the user to select actions to carry out. The contents may be edited (to some extent) by the EnterpriseOne administrator.

  • OracleLogo.gif

    This bitmap file contains the Oracle logo that is displayed by the InstallManager.exe program.

  • \install

    This subdirectory contains the setup.exe program, which is the actual OUI installation program for the Development Client. It is run from the InstallManager.exe program. This directory also contains the oraparam.ini file, which contains parameters used by the setup.exe program.

  • \stage

    This subdirectory contains configuration files used by setup.exe during the installation.

  • \MISC

    This subdirectory contains a template jde.ini file and one or more <pathcode>.ini files. During the installation of the package the <pathcode>.ini file corresponding to the pathcode in the package that the user selects is merged with the jde.ini template file to create the jde.ini that is copied to the c:\Windows directory on the target machine.

  • \ThirdParty

    This subdirectory contains any additional programs that may need to be installed on the target machine. Examples include a database installer and an installer for OH4A, H4A7, or H4A85.

  • \ThirdParty\WebDevFeature

    This subdirectory contains the various available JD Edwards EnterpriseOne Web Client installers.

  • \ThirdParty\WebDevFeature\OH4A

    This subdirectory contains the installer and necessary files for the OH4A Web Client. A corresponding directory for H4A7 and/or H4A85 may also exist.

  • \ThirdParty\WebDevFeature\OH4A\install

    This subdirectory contains the setup.exe program, which is the actual OUI installation program for the OH4A Web Client. It is run as a feature from the Development Client installer. This directory also contains the oraparam.ini file which contains parameters that the setup.exe program uses.

  • \ThirdParty\WebDevFeature\OH4A\stage

    This subdirectory contains configuration files that tell setup.exe what to do during the installation.

  • \ThirdParty\WebDevFeature\OH4A\JDBC

    This subdirectory contains JDBC drivers that the Web Client uses to connect to databases. All of the OH4A, H4A7, and H4A85 Web Client installers have this directory. For instructions to set this up, refer to the section of this guide entitled: Section 3.5, "Copying JDBC Drivers and the tnsnames.ora file to the Deployment Server".

  • \ThirdParty\WebDevFeature\OH4A\JDK

    This subdirectory contains a Java Development Kit (JDK) that the OH4A Web Client uses. This is needed by only the OH4A Web Client installer.

  • \ThirdParty\WebDevFeature\H4A7

    This subdirectory contains all files for the H4A7 installer. A corresponding directory for OH4A and/or H4A85 may also exist.

  • \ThirdParty\WebDevFeature\H4A7\install

    This subdirectory contains the setup.exe program, which is the actual OUI installation program for the H4A7 Web Client. It is run as a feature from the Development Client OUI installer. This directory also contains the oraparam.ini file which contains parameters that setup.exe uses.

  • \ThirdParty\WebDevFeature\H4A7\stage

    This subdirectory contains configuration files used by setup.exe during the installation.

  • \ThirdParty\WebDevFeature\H4A7\JDBC

    This subdirectory contains JDBC drivers that the Web Client uses to connect to databases. All of the OH4A, H4A7, and H4A85 Web Client installers have this directory. For instructions to set this up, refer to the section of this guide entitled: Section 3.5, "Copying JDBC Drivers and the tnsnames.ora file to the Deployment Server".

  • Note:

    Tools Release 9.1 Update 2.3

    The remaining bullet points in this list are applicable to WAS 8.5 which is supported beginning with Tools Release 9.1, Update 2.3.

  • \ThirdParty\WebDevFeature\H4A85

    This subdirectory contains all files for the H4A85 installer. A corresponding directory for OH4A and/or H4A7 may also exist.

  • \ThirdParty\WebDevFeature\H4A85\install

    This subdirectory contains the setup.exe program, which is the actual OUI installation program for the H4A85 Web Client. It is run as a feature from the Development Client OUI installer. This directory also contains the oraparam.ini file which contains parameters that setup.exe uses.

  • \ThirdParty\WebDevFeature\H4A85\stage

    This subdirectory contains configuration files used by setup.exe during the installation.

  • \ThirdParty\WebDevFeature\H4A85\JDBC

    This subdirectory contains JDBC drivers that the Web Client uses to connect to databases. All of the OH4A, H4A7, and H4A85 Web Client installers have this directory. For instructions to set this up, refer to the section of this guide entitled: Section 3.5, "Copying JDBC Drivers and the tnsnames.ora file to the Deployment Server".

Note:

Any combination (or all) of the Web Client installers may exist on the Deployment Server; however, an installation package may contain only one Web Client installer (as a feature). Likewise, only one Web Client may be installed on a Development Client.

The installers do not prevent you from installing more than one type of Web Client on a Development Client, but unexpected results may occur if you attempt this.

3.3 Creating the Web Development Feature

Complete this task to create a Web Client Installation Feature for your version of the application server. This feature must be included in the installation package before it is deployed to the Web Client machine.

  1. On the Deployment Server, log on to the Deployment environment (for example, DEP910 for Applications Release 9.1).

  2. From Solution Explorer, FastPath to P9623.

    This image is described in surrounding text.
  3. On Work With Features, click the Add button.

    This image is described in surrounding text.
  4. On Feature Based Deployment Directory, click the Next button.

    This image is described in surrounding text.
  5. On Feature Information, complete these fields:

    • Feature

      Enter a meaningful name for the feature. For example, if you are using OAS:

      WEBDEVOAS

      If you are using WAS, an example would be:

      WEBDEVWAS

      You can specify any name for the feature.

      Tip:

      Alternatively, you can provide the WAS Express version number (for example, either 7 or 85) in the name.
    • Feature Type

      Enter the value 1.

    • Description

      Enter a description. For example:

      Web Development Objects (OH4A) for OAS

      or

      Web Development Objects (H4A) for WebSphere Express

      You can specify any name for the description.

    • Required

      Ensure this option is selected.

    • Additional Install Processes

      Ensure this option is selected.

  6. Click the Next button.

    This image is described in surrounding text.
  7. On Additional Install Processes, complete these fields:

    • Execute Before Install/Execute After Install

      The Development Client installer for Tools Release 9.1 does not use either of these flags. The behavior is to run the feature's installer after installing the Development Client.

    • Third Party

      Enter the name of the feature that you entered earlier. For example, if you are using OAS:

      WEBDEVOAS

      If you are using WAS, an example would be

      WEBDEVWAS

      You can specify any name for the feature.

    • Description

      Enter a description. For example:

      Web Development Objects (OH4A) for OAS

      or

      Web Development Objects (H4A) for WebSphere Express

      You can specify any name for the feature.

    • Executable Name

      Enter this value:

      setup.exe

    • Source Path

      Enter the path to the installation executable.

      For OH4A, the path would be:

      \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\OH4A\install

      For H4A7, the path would be:

      \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\H4A7\install

      Tools Release 9.1 Update 2.3

      For H4A85, the path would be:

      \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\H4A85\install

  8. Click the Save button.

  9. Click the Next button.

  10. On Features Summary, click the End button.

3.4 Creating an Installation Package

This task describes how to add a Web Client Installation Feature to an installation package.

  1. On the Deployment Server, run EnterpriseOne.

  2. From the Package and Deployment Tools menu (GH9083), choose Package Assembly (P9601).

  3. Choose an assembled package that you want to deploy to the Development Client, and click Package Revisions from the Row Exit menu, or click Add to create a new package.

    Caution:

    Do not attempt to add a feature to an existing package that has already been built. When you deactivate a built package, EnterpriseOne deletes the package.
  4. Click Features.

  5. On the Features Component screen, click Browse.

  6. On the Feature Component Selection screen, click Find.

  7. Choose the Web Client Installation Feature for the Application Server you are using.

    Caution:

    Do not include a feature for more than one of the Web Client installers (OH4A, H4A7, or H4A85) in a single installation package. If you use more than one application server in your environment, create a separate package for each feature.
  8. Click Select.

    A check mark displays to the left of the component.

  9. Click Close.

  10. On the Feature Component screen, click Close.

  11. On Package Component Revisions, click OK.

  12. Choose the package you just modified, and click Activate/Inactive in the Row Exit menu.

  13. Click Define Build in the Row Exit menu.

  14. On the Work with Package Build Definition screen, click Add.

  15. Navigate through the Package Build Definition screens by clicking Next.

  16. On the Build Features screen, click the Build Feature INFs check box.

  17. Complete the Build Definition process.

  18. On Work With Package Build Definition, click Submit Build in the Row Exit menu.

3.5 Copying JDBC Drivers and the tnsnames.ora file to the Deployment Server

Required JDBC drivers and the tnsnames.ora file are automatically downloaded from the Deployment Server to the Development Client during the installation of the Development Client. To set up this process, the administrator must first obtain the required JDBC drivers for the supported platforms and databases as well as the tnsnames.ora file, if connecting to an Oracle database, and copy them to the Deployment Server as described in this procedure.

This section describes these tasks:

3.5.1 Copy the JDBC Drivers

To copy the JDBC drivers:

  1. On the Deployment Server, create a \JDBC subdirectory under the folder that contains the Web Client installation program. For example:

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\OH4A\JDBC

    or

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\H4A7\JDBC

    Tools Release 9.1 Update 2.3

    or

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\H4A85\JDBC

    Note:

    If you have to copy the JDBC files to a different directory for some reason, you have to add an entry to the oraparam.ini file for the OH4, H4A7, or H4A85 installer to indicate the location of that JDBC directory. Edit the oraparam.ini file located in this directory:

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\OH4A\Install

    or

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\H4A7\Install

    Tools Release 9.1 Update 2.3

    or

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\H4A85\Install

    Add this entry to the [FileLocations] section of the oraparam.ini file:

    JdbcPath=<Path_to_JDBC_files>
    

    For example,

    [FileLocations]
    JdbcPath=\\depsvr2\E910\My_JDBC
    

    Note:

    If you leave this entry out, the OH4A, H4A7, or H4A85 installer will look for the JDBC directory up one level from the setup.exe program for OH4A, H4A7, or H4A85.
  2. Refer to the section of this guide entitled: Section 1.4, "Accessing Minimum Technical Requirements" for information on where to obtain the JDBC drivers.

    The required JDBC drivers for each platform are listed below:

    Database Required Driver Comments
    SQL Server 2005 sqljdbc4.jar Microsoft provides a type 4 JDBC driver with full support at no additional charge. Download the JDBC driver directly from Microsoft's website.

    Use the installation documentation that comes with the download to install the JDBC driver into a temporary location.

    Oracle ojdbc5.jar The JDBC driver for Oracle will automatically be downloaded to your system when you install an Oracle database client or server. If you install a different driver, the system may not function properly.
    UDB/DB2 db2jcc.jar and db2jcc_license_cu.jar The JDBC driver for DB2/UDB is delivered with DB2/UDB server or client installation. Both files need to be present.
    DB2/400 for IBMi jt400.jar The DB2/400 driver for the IBMi platform is delivered with the DB2/400 database installation.

  3. Obtain the JDBC drivers and copy them to the JDBC directory you created in the first step.

    When the Web Client is deployed to a target machine, these drivers are automatically installed into the following directory:

    <Client Install Path>\misc

3.5.2 Copy the tnsnames.ora file

The tnsnames.ora file is required only if the Development Client will connect to an Oracle database. However, if the tnsnames.ora file is not copied to the correct directory on the Deployment Server, the user will receive an error message during the Web Client installation process.

To copy the tnsnames.ora file:

  1. Obtain the tnsnames.ora file from an Oracle database configured to run with JD Edwards EnterpriseOne.

  2. If the Web Client will use an Oracle database installed locally on the Development Client machine, you must use the following steps to ensure that the tnsnames.ora file has an entry to allow the Web Client to connect to the local database:

    1. Edit the tnsnames.ora file.

    2. If an entry for E1Local does not already exist, add this to the file:

      E1LOCAL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = E1Local)
      ))
      
    3. Save the tnsnames.ora file.

  3. Copy the tnsnames.ora to this directory on the Deployment Server:

    \\<deployment server name>\<release>\Client

    When the Web Client is installed on a target machine, this file is automatically installed to the following directory:

    For OH4A:

    <Client Install Path>\system\oc4j\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes

    For H4A7 or H4A85:

    <Client Install Path>\JAS\EA_JAS_80.ear\webclient.war\WEB-INF

3.6 Updating the Database Drivers in the JDBJ.ini File

The Web Client installer updates the JDBJ.ini file with settings for the databases to which the Web Client will connect based on the JDBC database drivers found in this directory:

<Client Install Path>\misc

As noted in the preceding section of this chapter entitled: Section 3.5.1, "Copy the JDBC Drivers", these JDBC database drivers are copied from this directory:

\\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\<OH4A_or_H4A7_or_H4A85>\JDBC

Note:

If you copy additional database drivers into the <Client Install Path>\misc directory after installing OH4A, H4A7, or H4A85, you will need to update the list of drivers in the JDBJ.ini file.

To update the database drivers in the JDBJ.ini file:

  1. Edit the JDBJ.ini file, which is typically found in this directory on your JD Edwards Development Client machine:

    For OH4A:

    <Client Install Path>\system\oc4j\j2ee\home\applications\webclient.ear\webclient\WEB-INF\classes

    For H4A7 and H4A85:

    <Client Install Path>\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\classes

  2. Locate the section: [JDBj-JDBC DRIVERS] and comment (add a hash or pound sign '#' at the beginning of the line) to disable any drivers that are not needed and uncomment (remove any hash or pound signs '#' at the beginning of the line) to enable any drivers that are needed.

    The following table lists the database driver names for the types of databases that EnterpriseOne supports.

    Database Setting in [JDBj-JDBC DRIVERS]
    Oracle ORACLE=oracle.jdbc.driver.OracleDriver
    IBM AS/400 DB AS400=com.ibm.as400.access.AS400JDBCDriver
    SQL Server 2005 SQLSERVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
    UDB UDB=com.ibm.db2.jcc.DB2Driver

3.7 Copying the JDK to the Deployment Server (OH4A Only)

As with the JDBC drivers, you must store the correct version of JDK in a defined directory on the Deployment Server. The JDK is then automatically downloaded to the Web Client during the installation of the OH4A Web Client. (For H4A7 and H4A85, the JDK is installed when you install WebSphere Express or WebSphere for Developers.) To set up this process, the administrator must first obtain the required JDK from Oracle and copy this application to the Deployment Server as described in the following procedure.

Note:

These instructions refer to a JDK (Java Developers Kit) -- not a JRE (Java Runtime Environment). These terms refer to distinctly different products that should not be confused. A JDK contains a JRE plus other components. A specific JDK is an MTR that is required by the Web Client.
  1. On the Deployment Server, create a directory called \JDK under the folder that contains the Web Client installation program. For example:

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\OH4A\JDK

  2. Refer to the section of this guide entitled: Section 1.4, "Accessing Minimum Technical Requirements" for a link to the MTRs which specify the required JDK.

  3. Locate and download the appropriate JDK from the Oracle web site:

    www.oracle.com

    The JDK may be called Java 2 Platform, Standard Edition (J2SE) for Windows or just J2SE.

    Note:

    Do not install a JDK with a version higher than what is indicated in the MTRs for the Web Client unless instructed to do so by JD Edwards EnterpriseOne support.
  4. Save the JDK to a temporary directory.

  5. From Microsoft Windows Explorer, navigate to the temporary directory and run the executable program as an administrator.

  6. Click Next.

  7. Select Accept and click Next.

  8. Click Change, and select the \JDK directory you created in Step 1 of this procedure.

  9. Accept all other default values, and click Next.

  10. Deselect both Browse Registration options.

  11. Click Install.

    The installation process takes several minutes

  12. When the process is complete, click Finish.

Note:

If you have to copy the JDK files to a different directory for some reason, you have to add an entry to the oraparam.ini file for the OH4A installer to indicate the location of that JDK directory. Edit the oraparam.ini file located in this directory:

\\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\WebDevFeature\OH4A\Install

Add this entry to the [FileLocations] section of the oraparam.ini file:

JdkPath=<Path_to_JDK_files>

The path should be the parent directory of the \bin directory that holds the javac.exe program. Be sure this path can be reached by the installer as it runs on the target Web Client machine. For example, if the javac.exe resides in \\depsvr2\E910\My_JDK\bin, enter the following in the [FileLocations] section of the oraparam.ini file:

JdkPath=\\depsvr2\E910\My_JDK

Note:

If you do not add the entry described in the preceding note, the OH4A installer looks for the JDK directory up one level from the setup.exe program for OH4A.

3.8 Updating the InstallManager.htm File

To install a database or the Development Client onto a Development Client machine, the user runs this program:

\\<deployment server name>\<release>\OneWorld Client Install\InstallManager.exe

This program displays a Graphical User Interface that provides several options for the user to perform. The options that InstallManager.exe displays are read from the file InstallManager.htm that resides in the same directory as InstallManager.exe.

The JD Edwards EnterpriseOne administrator can edit this file to rename the options or to add new options. Instructions are inside the file.

Caution:

Although InstallManager.htm is in HTML format, it is a restricted HTML that the InstallManager.exe can read. Some text file editing programs add extraneous HTML tags that InstallManager.exe cannot recognize.

The Microsoft Windows program Notepad.exe is an example of a program that is known to not add these extra tags, making it safe to use. Before you make any changes to the file, it is good practice to save a copy in case any changes that you make are not recognized by InstallManager.exe when it reads it.

Note that the installation path of the Development Client's installer (setup.exe) changed with Tools Release 9.1. This means that you will need to change the path of the Development Client's installer in the InstallManager.htm when you first install Tools Release 9.1 onto a Deployment Server that has a tools release prior to 9.1 installed.

The following is an example of a line in a pre-9.1 InstallManager.htm that creates the link to install the Development Client (this should be on a single line):

<a class="sectionItem" id="LaunchLink" link="setup.exe" href="InstallManager.htm">EnterpriseOne Client</a>

The Development Client's installer prior to Tools Release 9.1 is called setup.exe. It should be in the same directory as InstallManager.exe and InstallManager.htm. The value of the link in the above line should be a path and executable for the installer. If a relative path is used (for example, the path starts with neither a drive letter followed by a colon nor a backslash), the path is relative to the location of InstallManager.exe. If no path is given, Setup.exe and InstallManager.exe are in the same directory.

Here is an example of a similar line for Tools Release 9.1 (this should be on a single line):

<a class="sectionItem" id="LaunchLink" link="install\setup.exe" href="InstallManager.htm">EnterpriseOne Client</a>

Note the addition of this relative path: install. With Tools Release 9.1, the Development Client's installer (which, is also called setup.exe) is now located in a subdirectory called install under the path where InstallManager.exe resides.

3.9 Updating the oraparam.ini File

The OUI installer reads installation parameters from the oraparam.ini file. This file resides with the OUI executable called setup.exe in this directory:

\\<deployment server name>\<release>\OneWorld Client Install\install

When initially updating a Deployment Server to Tools Release 9.1, the oraparam.ini file is not updated from the existing install.inf file. Therefore, you must manually update some settings in the oraparam.ini file as described in this section.

The oraparam.ini file follows the standard format of ini files for Microsoft Windows: it contains sections with names inside square brackets ( [ ] ) and key/value pairs. The keys and their values are separated by equals signs ( = ).

If the following section or keys do not exist in your oraparam.ini, you must add them along with the values indicated. Be sure that any paths can be reached by the OUI program that is running on the machine where the Development Client is being installed; that is, do not use local paths -- use paths of this form:

\\<deployment server name>\<release>\xxx

Section Key Value Description Value Example
[Oracle] DEFAULT_HOME_LOCATION Default Oracle Home path into which Development Client will be installed. Users can change this path at installation time. E910
[Oracle] DEFAULT_HOME_NAME Default Oracle Home name of path into which Development Client will be installed. Users can change this path at installation time. JDE_E910_Client
[FileLocations] PackageInfs Path to package.inf files. \\depsvr2\E910\package_inf
[FileLocations] currentReleaseMasterPath Path including deployment server and share. \\depsvr2\E910
[FileLocations] JdbcPath Optional - Used when installing OH4A, H4A7, or H4A85

- Path to JDBC files

- If not specified, installer looks for a directory called JDBC; this directory is expected up one level from the directory containing the setup.exe file for OH4A, H4A7, or H4A85.

\\depsvr2\E910\My_JDBC
[FileLocations] JdkPath Optional - Used when installing OH4A

- Path to JDK files

- If not specified, installer looks for a directory called JDK; this directory is expected up one level from the directory containing the setup.exe for OH4A.

\\depsvr2\E910\My_JDK
[Attributes] DataByPathCode Optional - Used when installing OH4A, H4A7, or H4A85 to create the datasource name that points to local data

=1 means that local data is specific to individual pathcodes.

=0 means that local data is shared among all installed pathcodes.

For details, see the appendix of this guide entitled Appendix C, "Data by Pathcode".

1
[Attributes] LocalDS Optional - Used when installing OH4A, H4A7, or H4A85 to create the datasource name that points to local data

For details, see the appendix of this guide entitled  Appendix C, "Data by Pathcode".

OneWorldLocal

3.10 Setting Up Local Database Installers

The Development Client requires a database to be installed onto the same machine on which the Development Client is to be installed. You can choose the database based on the Applications Release of E1 and "bitness" of the Windows operating system that your users are using. Do not take the following information for granted - you should always check the MTRs for the most current official information.

  • Applications Release 9.1 / 64-bit Windows 7

    64-bit Oracle Enterprise Edition 11gR2 (OEE)

  • Applications Release 9.0 / 64-bit Windows 7

    64-bit Oracle Enterprise Edition 11gR2 (OEE)

    Microsoft SQL Server 2005 Express Edition (SSE; SP3 is required if installing on Windows 7)

  • Applications Release 9.0 / 32-bit Windows XP

    32-bit Oracle Enterprise Edition 10gR2 (OEE)

    Microsoft SQL Server 2005 Express Edition (SSE; may use any service pack)

To install a database onto a Development Client machine, the user runs this program:

\\<deployment server name>\<release>\OneWorld Client Install\InstallManager.exe

This program allows the user to install a local database or the E1 Development Client. By default, the InstallManager.htm file is shipped from Oracle configured to install OEE.

This section describes these topics:

3.10.1 Additional OEE Setup

The main installation program for OEE is OEESetup.exe. Upon initial installation of Tools Release 9.1, this directory is created:

\\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\ORACLE

The installation delivers these files in the above directory:

  • OEESetup.exe

  • deinstall.bat.tmpl

  • deinstall_E1Local.rsp.tmpl

  • settings.ini

The above files can be used for both 32- and 64-bit versions of the database and for 11gR2 and 10g versions.

You must manually copy the E1Local cloned database to this directory:

\\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\ORACLE

This cloned database can be downloaded from the Oracle Software Delivery Cloud site or the JD Edwards Update Center. Available versions of the database include 32- and 64-bit. You should choose the bitness of database that is applicable to your end-user versions of Microsoft Windows.

Inside the zip files that you download are files containing the cloned database. These internal files are called E1Local.cab, E1Local2.cab, through E1Local15.cab. The names are the same for both 32- and 64-bit versions of the database, so be sure to keep them separated.

If some users require 32-bit and others require 64-bit versions of the database, follow these steps:

  1. Create a copy of this directory:

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\ORACLE

    Name the new directory appropriately for the bitness, for example, ORACLE64.

    Place the OEESetup.exe and related files (listed at the beginning of this section) into that directory.

  2. Download the appropriate version of the E1Local cloned database from the Oracle Software Delivery Cloud or the JD Edwards Update Center.

  3. Expand the downloaded zip files and put the contents into the directory you created in Step 1 (for example, ORACLE64). The contents should include 15 cab files that are prefixed with E1Local.

  4. Edit this file:

    \\<deployment server name>\<release>\OneWorld Client Install\InstallManager.htm

  5. Locate this line near the bottom of the file:

    <a class="sectionItem" id="LaunchLink" link="ThirdParty\ORACLE\OEESetup.exe" href="InstallManager.htm">Oracle Local Database</a>

  6. Change the line to point to the correct directory and update the text that will appear on the screen:

    <a class="sectionItem" id="LaunchLink" link="ThirdParty\ORACLE64\OEESetup.exe" href="InstallManager.htm">64-Bit Oracle Local Database</a>

    Note:

    The database will be installed in the directory specified in the [Bootstrap] section and OracleBasePath key in the settings.ini file.
  7. Save and close the InstallManager.htm file.

    Note:

    The only differences between the installation files for the 32- and 64-bit versions of the database are in the CAB files and their contents. The non-CAB files (for example, OEESetup.exe, settings.ini, etc.) are the same for both versions of the database.

3.10.2 SSE Setup

If you want users to install SSE as the local database for the Development Client, you must change the installer option in the InstallManager.htm file to point to the SSE database installer. You should also refer to the complete instructions on editing the InstallManager.htm file in the section of this guide entitled: Section 3.8, "Updating the InstallManager.htm File".

To setup the InstallManager.htm file to install the SSE local database for the Development Client:

  1. Using an editor such as Microsoft Notepad, edit this file:

    \\<deployment server name>\<release>\OneWorld Client Install\InstallManager.htm

  2. Locate this line near the bottom of the file:

    <a class="sectionItem" id="LaunchLink" link="ThirdParty\ORACLE\OEESetup.exe -i" href="InstallManager.htm">Oracle Local Database</a>

  3. Change the line to point to the correct directory and installation program for SSE:

    <a class="sectionItem" id="LaunchLink" link="ThirdParty\SSE\DotNetSSESetup.exe" href="InstallManager.htm">SSE Local Database</a>

  4. Save and close the InstallManager.htm file.

Follow these steps to download the installer for the database and the installer for the .NET Framework from Microsoft.

Note:

If the JD Edwards EnterpriseOne MTRs specify a higher version of the database, use the MTRs in the following instructions.
  1. Download the Microsoft SQL Server Express 2005 SP3 installer:

    1. Go to the Microsoft Download Center:

      http://www.microsoft.com/downloads

    2. In the search field near the top of the screen, enter "SQL Server 2005 Express Edition SP3" and click the magnifying glass icon.

    3. Click on the link titled "SQL Server 2005 Express Edition SP3".

    4. Next to the file called SQLEXPR.EXE, click the Download button.

    5. Save the file to your local machine. It is recommended that you put the download in a specific location on the drive with the most space in a directory such as:

      D:\SSE

  2. The .NET Framework contains new Windows files that applications such as SSE can use. Oracle highly recommends that you install at least version 4.0 of Microsoft's .NET Framework. To download its installer:

    1. Go to the Microsoft Download Center:

      http://www.microsoft.com/downloads

    2. In the menu bar at the top of the screen, click on "Downloads A-Z" and type "N" and NET".

    3. Click on the link titled "Microsoft .NET Framework 4 (Web Installer)".

    4. Next to the file called dotNetFx40_Full_setup.exe, click the Download button.

    5. Save the file to your local machine in the folder created above. For example, D:\SSE.

  3. The main installation program for SSE is called DotNetSSESetup.exe. It runs the .NET Framework and SSE installers. Upon initial installation of Tools Release 9.1, the following files should reside in \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\SSE:

    • DotNetSSESetup.exe

    • settings.ini

  4. Copy both the .NET Framework and SSE installers that you downloaded from Microsoft into this directory:

    \\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\SSE

    Note:

    The DotNetSSESetup.exe program is normally run from the InstallManager.exe program, but it can be run from the command line. If you need to run DotNetSSESetup.exe for some reason, you can run it from a command prompt with the argument -h to see a list of the available arguments.