[Spacewalk-list] Sync profile failure

[puck at i29.net]

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/password at XE 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


puck at i29.net 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, puck at i29.net <mailto:puck at i29.net> 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 at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081014/893a295d/attachment.htm>