<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Okay, I guess this is a known issue. There's a reference to it in the
Known Issues at the bottom of the OracleXeSetup instructions but I
missed it since it says it applies to a different problem than the one
I thought I was having. The issue only shows itself when there are more
than 500 packages in a channel so I didn't see it at first for the
initial registration of the servers but then once I'd loaded the
channels with data it appeared. Whew. So for the record, the fix is:<br>
<br>
<a class="moz-txt-link-freetext" href="https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#KnownIssues">https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#KnownIssues</a><br>
<br>
Jem Tallon<br>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:puck@i29.net">puck@i29.net</a> wrote:
<blockquote cite="mid:48F4D14C.8090100@i29.net" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Whew, a reboot finally fixed oracle. No clue what happened to cause it
to stop working like that for so many hours. At least now I can get
back to troubleshooting those unhelpful, hidden log files ;)<br>
<br>
Jem Tallon<br>
<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:puck@i29.net">puck@i29.net</a> wrote:
<blockquote cite="mid:48F4CF22.5090901@i29.net" type="cite">
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
I guess that wasn't the problem. Oracle is running much better outside
of VmWare but it's still having the same issue with syncing profiles.
Oddly it works for the initial package sync with rhn_register but never
again. I had rebooted the oracle server a few times to make sure it
wasn't just dead but it never helped.<br>
<br>
Now the last time I tried restarting oracle only the listener comes
back up (from running /etc/init.d/oracle-xe start). I've tried
following the manual startup steps but it never gets me anywhere. The
problem appears to be that sqlplus refuses to connect, even to issue a
startup command for the DB, giving me the following error:<br>
<br>
sqlplus "sys/password@XE as sysdba"<br>
<br>
ERROR:<br>
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor<br>
<br>
Anyone want to wager a guess as to what might be wrong? I've tried it
with and without the @XE just in case. For the record, my listener.ora
file is identical (copy/pasted even) to the one in the spacewalk howto
except that I've changed the domain name to mine. I haven't done any
customizations other than the ones in that howto. The domain is also a
FQDN and I've confirmed reverse DNS works if that matters<br>
<br>
It looks like port 9000 and 1521 are open but when I try to connect to
9000 with a browser I receive a blank page and a similar error shows in
the log file.<br>
<br>
I'm starting to think that the whole problem is just that oracle sucks.
I've reinstalled it 3 times now following the instructions and I keep
coming back to these insanely complex, nearly untraceable errors. Am I
doing something wrong or should I abandon my project until another DB
back-end is available?<br>
<br>
Jem Tallon<br>
<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:puck@i29.net">puck@i29.net</a> wrote:
<blockquote cite="mid:48E63DD5.4010203@i29.net" type="cite">
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
I haven't noticed a performance issue on this server but it is running
in vmware so that may be part of the issue. When I restarted oracle-xe,
it got slow again shortly after the restart. As a troubleshooting
measure, I increased the PGA (168M) and SGA (512M) sizes in the
oracle's memory administration panel to see if that would help. Oracle
has been much faster since then but the profile sync still fails.<br>
<br>
The load average on the guest stays right around 0.20 while I run the
command and the load average is around 0.35 on the vmware server.<br>
<br>
Jem Tallon<br>
<br>
<br>
Zac Elston wrote:
<blockquote
cite="mid:7728C700-6B31-492E-B6AA-0692E69AF278@metavante.com"
type="cite">I had similar issues with running Oracle in a XenGuest.
I was able to get it working with using real disk partitions instead of
Vdisks but the guest instance were always noticeably slower then
running in Dom0. is machine performance an issue for this server?
what's the load average when these errors occur?
<div><br>
</div>
<div>-zac<br>
<div><br>
</div>
<div><br>
<div>
<div>On Oct 3, 2008, at 11:17 AM, <a moz-do-not-send="true"
href="mailto:puck@i29.net">puck@i29.net</a> wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite"><span class="Apple-style-span"
style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">I
can but it seems to be rather unreliable at the moment. I can run a few
queries and then it will hang for a while. I've restarted oracle many
times since this behavior started so it may be something persistent
with oracle-xe. I'll keep digging into it and see what I can figure
out. I don't suppose we'll be seeing mysql support anytime soon? ;)</span></blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
Spacewalk-list mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre>
</blockquote>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
Spacewalk-list mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre>
</blockquote>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Spacewalk-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a>
<a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre>
</blockquote>
</body>
</html>