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.

Purpose

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:

ORA-00942: table or view does not exist
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-01722: invalid number
ORA-01536: space quota exceeded for tablespace
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-04030: out of process memory when trying to allocate xxxxx bytes
ORA-00942: table or view does not exist
ORA-28547: connection to server failed, probable Oracle Net admin error
ORA-12705: Unable to connect to Oracle ORA-12705: invalid or unknown NLS parameter value specified
ORA-01033: ORACLE initialization or shutdown in progress
ORA-04031: unable to allocate 4064 bytes of shared memory

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.