FAQ
I have a developer using SQLNavigator and getting the following error while
trying to recompile some code.
ORA-04021: timeout occurred while waiting to lock object. This developer is
the only one in the database.
The database has been 'bounced' to clear all locks but the error still
occurs.

Any ideas?

Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: rlsmith_at_kmg.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Alexandre Gorbatchev at Jul 30, 2002 at 3:13 pm
    Ron,

    When exactly this happens?
    Could be running pl/sql procedure and trying do something with itself or
    with calling procedure (like grant execute, for example)

    Alexandre
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, July 30, 2002 4:48 PM
    I have a developer using SQLNavigator and getting the following error while
    trying to recompile some code.
    ORA-04021: timeout occurred while waiting to lock object. This developer is
    the only one in the database.
    The database has been 'bounced' to clear all locks but the error still
    occurs.

    Any ideas?

    Ron Smith
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Alexandre Gorbatchev
    INET: alexandre.gorbatchev_at_avermann.de

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Smith, Ron L. at Jul 30, 2002 at 3:33 pm
    The developer has the object opened for update in SQLNqvigator. When he
    tries to compile and save it,
    he gets the error.

    Ron



    -----Original Message-----
    Sent: Tuesday, July 30, 2002 10:13 AM
    To: Multiple recipients of list ORACLE-L

    Ron,

    When exactly this happens?
    Could be running pl/sql procedure and trying do something with itself or
    with calling procedure (like grant execute, for example)

    Alexandre
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, July 30, 2002 4:48 PM
    I have a developer using SQLNavigator and getting the following error while
    trying to recompile some code.
    ORA-04021: timeout occurred while waiting to lock object. This developer is
    the only one in the database.
    The database has been 'bounced' to clear all locks but the error still
    occurs.

    Any ideas?

    Ron Smith
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Alexandre Gorbatchev
    INET: alexandre.gorbatchev_at_avermann.de

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Alexandre Gorbatchev at Jul 31, 2002 at 8:18 am
    Third-party tools sometimes do simple operations in non-straightforward way.
    Try to do CREATE OR REPLACE from sqlplus and check that you run a version of
    Navigator compatible with your database.

    Run script catblock.sql and look at dba_lock_internal. You should find this
    object there.

    hth
    Alexandre
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, July 30, 2002 5:33 PM
    The developer has the object opened for update in SQLNqvigator. When he
    tries to compile and save it,
    he gets the error.

    Ron



    -----Original Message-----
    Sent: Tuesday, July 30, 2002 10:13 AM
    To: Multiple recipients of list ORACLE-L


    Ron,

    When exactly this happens?
    Could be running pl/sql procedure and trying do something with itself or
    with calling procedure (like grant execute, for example)

    Alexandre
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, July 30, 2002 4:48 PM

    I have a developer using SQLNavigator and getting the following error while
    trying to recompile some code.
    ORA-04021: timeout occurred while waiting to lock object. This
    developer
    is
    the only one in the database.
    The database has been 'bounced' to clear all locks but the error still
    occurs.

    Any ideas?

    Ron Smith
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Alexandre Gorbatchev
    INET: alexandre.gorbatchev_at_avermann.de

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Alexandre Gorbatchev
    INET: alexandre.gorbatchev_at_avermann.de

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 30, '02 at 2:48p
activeJul 31, '02 at 8:18a
posts4
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase