Skip to Content
avatar image
Former Member

ORA-03135

Hi,

We are facing connection lost issue. When i Initiate the job,Job will terminated in 20 to 30 seconds. Data moving from Oracle to Oracle.Please Help me out

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 12 at 12:47 PM

    Hi Gowtham :

    What is you rows per commit size is that default 1000,

    what is the source data table size .

    Try to run the job bu query filter rownum <2.If still the connection lost then talk with your DBA this might possible that the incorrect parameter set on SQLNET.ora file

    Please send the error screen shot

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13 at 11:53 AM

    Thanks Abhisekh,

    Row per commit Size is 1000 only..and I reduced the per commit size also..

    Source file size is 1crore. and Where to apply row num<2 in query transform.

    I’m not able send Screen shot..

    Please help me sir

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14 at 07:51 AM

    Hi Gowtham,

    Is the case with this particular job or all the jobs in the local repository ?

    Please create a test job --- > one data flow --- > 1 script with a print statement, such as print('********* Testing local Repo *********'); Check whether the is successful or not. If the job fails, then the issue is with the local repository, if it is success then please attach or copy paste the entire error.

    BR,

    Mahesh

    Add comment
    10|10000 characters needed characters exceeded