My Oracle Support Banner

E1: DB: Troubleshooting Guide for Oracle Database ORA-NNNNN Error Messages and EnterpriseOne (Doc ID 1527551.1)

Last updated on MAY 03, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 to 9.2 [Release SP24 to 9.2]
Information in this document applies to any platform.


The purpose of this document is to provide troubleshooting tips when encountering ORA-NNNN errors with EnterpriseOne.  The following ORA errors are covered in this document:


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
Troubleshooting Steps
 Scenario 1: Oracle V$PARAMETER Open Cursors Issue with EnterpriseOne
 Scenario 2: "OCI0000375 - Error - ORA-12154" When Starting EnterpriseOne Service After Changing Database Version to Oracle 11g
 Scenario 3: Case Study on ORA-01722 Wrong Bind Variables Cause Transaction Failure
 Scenario 4: ORA-01536 Error When Trying to Run a UBE
 Scenario 5: Installation Workbench Fails With Error "OCI0000367 - Unable to connect to Oracle ORA-12154: TNS:could not resolve the connect identifier specified"
 Scenario 6: ORA-04030 Out of Process Memory Error Message for Oracle 10GR2
 Scenario 7: ORA-00942 Error Running an EnterpriseOne Application
 Scenario 8: Intermittent Error "ORA-28547: Connection to server failed" in the Enterprise Server Logs
 Scenario 9: Passwords Expires by Default In Oracle 11g
 Scenario 10: Unable to connect to Oracle ORA-12705: invalid or unknown NLS parameter value specified
 Scenario 11: ORA-01033 ORACLE initialization or shutdown in progress
 Scenario 12: ORA-04031: unable to allocate 4064 bytes of shared memory
 Scenario 13: ORA-01461 During Task Menu Index Build 

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