<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Romain,<br>
<br>
I had the same problem and the issue is documented but poorly..yes you
have to fix this and that but it is not saying what to do to really fix
it:<br>
<br>
- On the oracle-xe server start sqlplus<br>
- Login with spacewalk and spacewalk (or what password you choos during
the original spacewalk installation)<br>
- Run the sql commands from the fix (copy/paste them one for one)<br>
- If you got no errors after the 'show errors' command, type: commit<br>
- Quit your sqlplus by typing quit<br>
- Follow the rest of the upgrade manual as normal<br>
<br>
I find it too bad that with every upgrade bugs are found but the
solutions are not user friendly documented, most of them are Oracle
related and sometimes for beginners with mere Oracle knowledge are hard
to understand. (yes I know there is a wiki and yes I have already
contributed to the wiki ;) )<br>
A more user friendly fix or script would be better/nice to have.<br>
<br>
But that is a big IMHO...<br>
I really love Spacewalk and it saves me ever month a couple of hours of
upgrading my linux boxes by hand. :)<br>
<br>
Kind Regards,<br>
<br>
Michiel<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:romain.pelissier@bell.ca">romain.pelissier@bell.ca</a> wrote:
<blockquote
cite="mid:93DFCD62FA33A04ABC80EFDB2993C3F87F1C2C37@MBX08.bell.corp.bce.ca"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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:#606420;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Well, I have encountered
the issue described earlier and I
have applied the fix.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">But now, when I run the
schema upgrade, I’ve got this:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Unknown schema name [no
rows selected] found.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">What can I do to finish
the upgrade?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">Thanks<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;" lang="FR-CA"> </span></font><span lang="FR-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;" lang="FR-CA"><o:p> </o:p></span></font></p>
</div>
</blockquote>
</body>
</html>