 | | | ora-04020 | ora-04020 2005-12-15 - By Burton, Laura
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
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@(protected) Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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 <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>ERROR at line 1:<o:p></o:p></span></font><
/p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>ORA-04020 (See ORA-04020.ora-code.com): deadlock detected while trying
to lock object<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>SYS.CDC_ALTER_CTABLE_BEFORE<o:p></o:p><
/span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Has anyone had a problem like this and was
able to resolve it.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks in advance, <o:p></o:p></span><
/font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Laura<o:p></o:p></span></font></p>
</div>
</body>
</html>
|
|
|