RE: ora-04020 - Solution
- From: "Burton, Laura" <BurtonL@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Dec 2005 06:03:54 -0600
Just wanted to let everyone know that after running the catpatch.sql
file the problem was resolved. I had created the new database via dbca.
Many thanks to Paul for his suggestions.
Thanks, Laura
-----Original Message-----
From: Paul Drake [mailto:bdbafh@xxxxxxxxx]
Sent: Thursday, December 15, 2005 2:13 PM
To: Burton, Laura
Subject: Re: ora-04020
On 12/15/05, Burton, Laura <BurtonL@xxxxxxxxxxx> wrote:
>
>
>
> 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
Laura,
Do you need change data capture?
Did you apply a one-off patchset for CPUOct2005?
Did you run catpatch.sql after applying the 9.2.0.7 patchset?
If you created a new database using dbca, you still have to run the
catpatch script afterwards.
Paul
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: ora-04020 - Solution
