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