[Spacewalk-list] Sync profile failure

[puck at i29.net]

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


puck at i29.net 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
>
>
> puck at i29.net 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/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
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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/42e9ea5a/attachment.htm>