Oracle Setup Issues

After you create the user, if you sign on as the EnterpriseOne services account (JDE920) and you see error messages about the Oracle setup, edit enterpriseone.sh as follows:

1. Change to the directory where you installed EnterpriseOne.

   For example:

   cd /u02/JDEdwards/e920

2. Locate this subdirectory under the EnterpriseOne installation directory:

   cd SharedScripts

3. Open enterpriseone.sh in the editor of your choice.

4. Find the entries for ORACLE_HOME and ORACLE_SID. Change the ORACLE_HOME entry to the HOME for your 32 bit client install. Ensure the ORACLE_SID matches the ORACLE_SID of your database. See examples below.:

   ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
   export ORACLE_HOME
    
   ORACLE_SID=orcl
   export ORACLE_SID
   

5. Immediately after the above line, add these lines:

   PATH=$PATH:/usr/local/bin
   export PATH
   

6. Save your changes and close the enterpriseone.sh file.

   Note: If you still receive Oracle errors after modifying your enterpriseone.sh file as described above, it is likely that the Oracle database software is installed into a location other than the default location. In such a case, your Oracle administrator can provide you with the correct directory to add to the PATH variable.