My Oracle Support Banner

E1: DB: Troubleshooting Guide for E1Local Database Issues (Doc ID 1527187.1)

Last updated on MARCH 12, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.

Purpose

The purpose of this document is to provide troubleshooting tips for the E1Local Oracle (OEE - Oracle Enterprise Edition) Database. This includes information about what is supported, tips for installation and resolution to known issues.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 Scenario 1: Is OEE 11GR2 32-bit Local Database Supported on a Windows 64-bit Server?
 Scenario 2: Installing OEE 64-bit Local Database Fails When Running RUNCONFIG.BAT
 Scenario 3: Where To Find The Oracle 32-bit Client Software 11g (11.2.0.2)
 Scenario 4: Error "OUI-10197:Unable to create a new Oracle Home at C:\Oracle\E1Local" When Installing OEE on Deployment Server
 Scenario 5: How To View and Edit Data in the Oracle Local Database (E1Local)
 Scenario 6: How to Recover Lost or Corrupt SYSTEM/SYS Password in Local Oracle (OEE) Database
 Scenario 7: Passwords in E1Local OEE 11g Database may be Set With an Expiration Date
 Scenario 8: How to Access the E1Local Oracle Database for E1 9.0 Standalone as a System User
 Scenario 9: How To Change or Upgrade the OEE 10G to OEE 11G Local Database on the Deployment Server
 Scenario 10: Error ORA-19721 when Reattaching Planner Database
 Scenario 11: Error ORA-04031: unable to allocate 4064 bytes of shared memory when attaching database
 Scenario 12: Unable to connect to E1Local after installing OEE 12c as the local database
 Scenario 13: Error "OCI0000179 - Error - ORA-00376" captured while opening any application.
 Scenario 14: Connecting to E1Local splash screen is shown indefinitely while login on Deployment Server or Development Client
 Scenario 15: E1 Local fails with Error1
 Scenario 16: Local Database install fails - Cannot add user to application access ACL
 Scenario 17: Unable to sign into fat client workstations after VirtualBox software was installed.
 Scenario 18: Unable to connect to E1 Local after restoring DB related files from backup of deployment server
 Scenario 19: When using the ReconfigureMSDE.exe program to encrypt or decrypt the system user password for the E1Local database throws error.
 Scenario 20: Unable to install E1Local on Fat Client Error "A problem  caused the program to stop working correctly"
 Scenario 21: Recommendation for patch update in Local Database
 Scenario 22: Unable to sign into fat client workstations after VirtualBox software was installed.
 Scenario 23: When using the ReconfigureMSDE.exe program to encrypt or decrypt the system user password for the E1Local database, the following error occurs "Could not start the service OracleE1LocalTNSListener for the database"
 Scenario 24: How to connect to E1Local DB without SYS/SYSTEM user id password.
 Scenario 25: Where to download the OEE local database from? (Example: OEE 12.2.0.1)?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.