Copying 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 (Tools Releases prior to 9.2.9) or Development Client (Tools Release 9.2.9) 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. Tools Releases prior to 9.2.5.0: If the Development 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 Development Client to connect to the local database:
    • Edit the tnsnames.ora file.
    • 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)

      ))

    • Save the tnsnames.ora file.
  3. Copy the tnsnames.ora to this directory on the Deployment Server: \\<deployment server name>\<release>\Client When the Development Client is installed on a target machine, this file is automatically installed to the following directories:

For WLSH4A (Tools Releases Prior to 9.2.9):

  • <Client Install Path>\system\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\classes
  • <Client Install Path>\<pathcode>\ini\sbf

For WASH4A (Tools Releases Prior to 9.2.9):

  • <Client Install Path>\JAS\EA_JAS_80.ear\webclient.war\WEB-INF
  • <Client Install Path>\<pathcode>\ini\sbf

For Development Client (Tools Releases Prior to 9.2.5):

  • <64-bit Oracle database install path>\NETWORK\ADMIN

For Development Client (Tools Releases 9.2.9):

  • <Client Install Path>\<pathcode>\ini\sbf