Receiving ORA-03135 Connection Lost Contact Warning/Error In Final Stages Of Ascential Datastage Job

(Doc ID 1299750.1)

Last updated on NOVEMBER 06, 2017

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***


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)


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