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.
