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:
https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#KnownIssues
Jem Tallon
[EMAIL PROTECTED] wrote:
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 ;)
Jem Tallon
[EMAIL PROTECTED] wrote:
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.
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:
sqlplus "sys/[EMAIL PROTECTED] as sysdba"
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in
connect descriptor
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
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.
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?
Jem Tallon
[EMAIL PROTECTED] wrote:
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.
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.
Jem Tallon
Zac Elston wrote:
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?
-zac
On Oct 3, 2008, at 11:17 AM, [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> wrote:
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? ;)
------------------------------------------------------------------------
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
------------------------------------------------------------------------
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
------------------------------------------------------------------------
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
