[Spacewalk-list] Sync profile failure

[puck at i29.net]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081014/fd720138/attachment.htm>