From oracle-l-bounce@freelists.org Thu Dec 15 13:56:59 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jBFJuxMY005559 for ; Thu, 15 Dec 2005 13:56:59 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jBFJutAX005546 for ; Thu, 15 Dec 2005 13:56:55 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0BDC925703A; Thu, 15 Dec 2005 14:56:50 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06849-04; Thu, 15 Dec 2005 14:56:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7E5132568A4; Thu, 15 Dec 2005 14:56:49 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 15 Dec 2005 14:56:46 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C3FD2256EB5 for ; Thu, 15 Dec 2005 14:56:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06830-07 for ; Thu, 15 Dec 2005 14:56:46 -0500 (EST) Received: from naiad.frmaint.com (naiad.frmaint.com [208.206.212.34]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B52042568A4 for ; Thu, 15 Dec 2005 14:56:45 -0500 (EST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C601B1.ABB77654" X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: ora-04020 Date: Thu, 15 Dec 2005 13:56:42 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ora-04020 Thread-Index: AcYBpNOBbWXAMfP0RZeUUCWEEyZX/QAC355A From: "Burton, Laura" To: X-imss-version: 2.034 X-imss-result: Passed X-imss-approveListMatch: *@frmaint.com X-archive-position: 29195 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: BurtonL@frmaint.com Precedence: normal Reply-To: BurtonL@frmaint.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org ------_=_NextPart_001_01C601B1.ABB77654 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have a 9.2.0.7 Oracle database on MS Server 2003. I am getting the error above on anything I try to do. This is a newly created database. Also was able to import data from another database to it. Now everything gets this error. On Metalink it states to run the utlrp.sql script as sys. This did not correct the problem. I can query v$lock without getting an error, and I do not see a lock on the system. If I try to look at v$session I get=20 =20 ERROR at line 1: ORA-04020: deadlock detected while trying to lock object SYS.CDC_ALTER_CTABLE_BEFORE =20 Has anyone had a problem like this and was able to resolve it. =20 Thanks in advance,=20 Laura ------_=_NextPart_001_01C601B1.ABB77654 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have a 9.2.0.7 Oracle database on = MS Server 2003. I am getting the error above on anything I try to = do. This is a newly created database. Also was able to import data from another = database to it. Now everything gets this error. On Metalink it states to = run the utlrp.sql script as sys. This did not correct the problem. I can query = v$lock without getting an error, and I do not see a lock on the system. If I try = to look at v$session I get

ERROR at line = 1:

ORA-04020: deadlock detected while = trying to lock object

SYS.CDC_ALTER_CTABLE_BEFORE

Has anyone had a problem like this = and was able to resolve it.

Thanks in advance, =

Laura

------_=_NextPart_001_01C601B1.ABB77654-- -- http://www.freelists.org/webpage/oracle-l