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
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
