ora-04020 - Solution 2005-12-16 - By Burton, Laura
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@(protected)]
Sent: Thursday, December 15, 2005 2:13 PM
To: Burton, Laura
Subject: Re: ora-04020 (See ora-04020.ora-code.com)
On 12/15/05, Burton, Laura <BurtonL@(protected)> 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 (See ORA-04020.ora-code.com): 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
--
http://www.freelists.org/webpage/oracle-l
|
|
