Receiving ORA-03135 Connection Lost Contact Warning/Error In Final Stages Of Ascential Datastage Job (Doc ID 1299750.1)

Last updated on MAY 16, 2016

Applies to:

PeopleSoft Enterprise EPM Foundation - Version 9 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Oct-2012***

Goal


When running an Ascential DataStage job that builds a fact table in the MDW layer of our warehouse, we receive the ORA-03135 connection lost contact error during the final moments of the job. This usually occurs during long-running jobs (2+ hours)


Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms