<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-2"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.Stylwiadomocie-mail17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.Stylwiadomocie-mail18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=PL link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hello,</span><span lang=EN-US><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Problem with DB resolved – I’ve recreated invalid synonyms and recompiled EVR_T type body.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Best regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Chris<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>Hello,<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>I’ve tried to migrate SW 1.5 database from Oracle 10g XE to Oracle 11gR1 EE (32-bit) and have problem. I’ve made export and import of Spacewalk schema but there are 4 objects with invalid status:<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='color:#1F497D'>></span></b><b><span lang=EN-US>select * from all_objects where status !='VALID';<o:p></o:p></span></b></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-US style='color:#1F497D'>></span></b><b><span lang=EN-US><o:p> </o:p></span></b></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>SPACEWALK CONTACT 76466 SYNONYM 12/11/19 12/11/19 2012-11-19:15:34:30 INVALID N N N 1 <o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>SPACEWALK CUSTOMER 76475 SYNONYM 12/11/19 12/11/19 2012-11-19:15:34:30 INVALID N N N 1 <o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>SPACEWALK HOST 76477 SYNONYM 12/11/19 12/11/19 2012-11-19:15:34:30 INVALID N N N 1 <o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>SPACEWALK EVR_T 75148 TYPE BODY 12/11/19 12/11/19 2012-11-19:15:13:45 INVALID N N N 2 <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><b><span lang=EN-US style='color:#1F497D'>></span></b><b><span lang=EN-US>EVR_T details:<o:p></o:p></span></b></p><p class=MsoNormal><b><span lang=EN-US style='color:#1F497D'>></span></b><b><span lang=EN-US><o:p> </o:p></span></b></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Schema SPACEWALK<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Name EVR_T<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>TypeCode - not supported here!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB># Attribs 3<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB># Methods 3<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Predefined No<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Complete Yes<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Wrapped No<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Evolved No<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB style='color:#1F497D'>></span><span lang=EN-GB>Final Yes<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>Instantiable Yes<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>OID AB51ABBF74A8ABC4E040DD0A128E2754<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>Is Oracle 11g not supported with Spacewalk? Any help is greatly appreciated.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>Thanks very much and best regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>></span><span lang=EN-US>Chris.<o:p></o:p></span></p></div>
<p><span style="font-family:'Arial';font-size:7pt;">----------------------------------------------------------------------<br>
</span><span style="font-family:'Arial';font-size:7pt; color:#000000;">BNP Paribas Bank Polska SA z siedzibą w Warszawie przy ul. Suwak 3, zarejestrowany w Sądzie Rejonowym dla m. st. Warszawy, XIII Wydział Gospodarczy, KRS pod numerem 6421, NIP: 676-007-83-01, kapitał zakładowy 1 434 646 300 zł, w całości wpłacony.</span><span style="font-family:'Arial';font-size:7pt;"><br>
</span><span style="font-family:'Arial';font-size:7pt; color:#000000;">BNP Paribas Bank Polska SA with its registered office in Warsaw at ul. Suwak 3, registered with the District Court for the capital city of Warsaw, XIII Commercial Division of the National Court Register (KRS) under No. 6421, VAT PL 6760078301, holding paid-up share capital of PLN 1,434,646,300.</span><span style="font-family:'Arial';font-size:7pt;"><br>
</span><span style="font-family:'Arial';font-size:7pt; color:#000000;">BNP Paribas Bank Polska SA disclaimer:</span><span style="font-family:'Arial';font-size:7pt; color:#000000;"> </span><span style="font-family:'Arial';font-size:7pt; color:#0000FF;"><u>http://www.bnpparibas.pl/legal/disclaimer.htm</u></span><span style="font-family:'Arial';font-size:7pt;"><br>
----------------------------------------------------------------------</span></p>
<p><span style="font-family:'Arial';font-size:7pt;"> </span></p></body></html>