Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    3

    Unanswered: ORA-02049: timeout: distribute error

    Hi,

    For last couple of months I frequently getting ORA-02049: timeout: distribute error in one of my procedure set as DBMS.JOB to run every hour in a day. There are 3 more procedures set to run hourly. I want to know the cause of the error and how to solve it. Please help me in this regard.

    regards,
    Rin

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: ORA-02049: timeout: distribute error

    Originally posted by rin2
    Hi,

    For last couple of months I frequently getting ORA-02049: timeout: distribute error in one of my procedure set as DBMS.JOB to run every hour in a day. There are 3 more procedures set to run hourly. I want to know the cause of the error and how to solve it. Please help me in this regard.

    regards,
    Rin
    You have exceeded DISTRIBUTED_LOCK_TIMEOUT parameter.
    Default is 60 seconds (i guess). You can change (specify) it in startup file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •