<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style></style></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1>Ok, that worked. Thanks!!<o:p></o:p><o:p> </o:p>Now have an issue when starting osa:<o:p></o:p><o:p> </o:p><o:p> </o:p>Starting osa-dispatcher: RHN 7591 2011/10/20 12:36:08 -04:00: ('Traceback (most recent call last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 250, in setup_connection\n c = self._get_jabber_client(js)\n File "/usr/share/rhn/osad/jabber_lib.py", line 307, in _get_jabber_client\n c.connect()\n File "/usr/share/rhn/osad/jabber_lib.py", line 564, in connect\n jabber.Client.connect(self)\n File "/usr/lib/python2.4/site-packages/jabber/xmlstream.py", line 466, in connect\n socket.AF_UNSPEC, socket.SOCK_STREAM)\ngaierror: (-2, \'Name or service not known\')\n',)<o:p></o:p> [ OK ]<o:p></o:p><o:p> </o:p><o:p> </o:p><o:p> </o:p>Thoughts?<o:p></o:p><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>From: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] On Behalf Of Larry Letelier Sent: Thursday, October 20, 2011 11:47 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] issues with host rename<o:p></o:p></div></div><o:p> </o:p>On 20/10/11 12:37, Gomes, Rich wrote: <o:p></o:p><div>I am having issues with a SW server (1.5) that I am running. Currently it is running without issue but there is a need for a name change. <o:p></o:p>Since it is a VM, I am cloning it as the new name and then powering off the original. <o:p></o:p>Once the new server is up I do the following: <o:p></o:p> <o:p></o:p>1 – Change IP to be that of original <o:p></o:p>2 – Change hostname in both /etc/hosts and /etc/sysconfig/network <o:p></o:p>3 – Reboot and verify name change <o:p></o:p>4 – Run spacewalk-hostname-rename script <o:p></o:p> <o:p></o:p>Each time I receive the following: <o:p></o:p> <o:p></o:p>[root@newhostname ~]# spacewalk-hostname-rename xx.xx.xx.xx Validating IP ... OK ============================================= <o:p></o:p>hostname: newhostname <o:p></o:p>ip: xx.xx.xx.xx <o:p></o:p>============================================= <o:p></o:p>Stopping rhn-satellite services ... OK <o:p></o:p>Testing DB connection ... ERROR: <o:p></o:p>ORA-12505: TNS:listener does not currently know of SID given in connect descriptor <o:p></o:p> <o:p></o:p> <o:p></o:p>SP2-0306: Invalid option. <o:p></o:p>Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <o:p></o:p> <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] <o:p></o:p>SP2-0306: Invalid option. <o:p></o:p>Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <o:p></o:p> <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] <o:p></o:p>SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus FAILED Your database isn't running. <o:p></o:p>Fix the problem and run /usr/bin/spacewalk-hostname-rename again <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p>I would think it would be easier to build a new SW server from scratch but that has not worked out. Every time I try, with version 1.3, 1.4, and 1.5 everything goes smoothly but Taskomatic service will not stay running and I have not found a fix for it. <o:p></o:p>This server was\is running successfully so I decided to to just clone it and rename it. <o:p></o:p> <o:p></o:p>Interestingly, if I change host name back to original, it does me now good. <o:p></o:p>And also, tnsnames and listener.ora both have ‘localhost’ specified, not new hostname. <o:p></o:p>Changing this to the new hostname does not good either. <o:p></o:p> <o:p></o:p> <o:p></o:p>Has anyone else run into this? <o:p></o:p>How can this be fixed? <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p>Thanks, <o:p></o:p> <o:p></o:p>Rich <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p>Rich Gomes | Senior Systems Administrator, AUCA System Services | ARAMARK Uniform & Career Apparel <o:p></o:p>Tel: 781.763.4508 | Fax: 781.763.2508 <o:p></o:p><a href="mailto:Rich.Gomes@wearguard-crest.com">Rich.Gomes@wearguard-crest.com</a> | <a href="http://www.aramark-uniform.com/" title="http://www.aramark-uniform.com/">www.aramark-uniform.com</a> <o:p></o:p> <o:p></o:p></div> <o:p></o:p><pre>_______________________________________________<o:p></o:p></pre><pre>Spacewalk-list mailing list<o:p></o:p></pre><pre><a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><o:p></o:p></pre><pre><a href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></pre> Rich: Try this, <o:p></o:p><pre style='line-height:13.5pt;vertical-align:baseline'>-> Stop the osa-dispatcher and jabberd service.<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'>-> #rm -f /var/lib/jabberd/db/*<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'><o:p> </o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'>-> Switch to the oracle user and using sqlplus clear out the client and dispatcher tables.<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'><o:p> </o:p></pre><p style='margin:0in;margin-bottom:.0001pt;line-height:13.5pt;vertical-align:baseline;background-image:initial;background-attachment:initial;background-origin: initial;background-clip: initial;border-style:initial;border-color:initial;background-position:initial initial;background-repeat:initial initial'> sqlplus $(spacewalk-cfg-get default_db)<o:p></o:p><p style='margin:0in;margin-bottom:.0001pt;line-height:13.5pt;vertical-align:baseline;background-image:initial;background-attachment:initial;background-origin: initial;background-clip: initial;border-style:initial;border-color:initial;min-height: 8pt;background-position:initial initial;background-repeat:initial initial'> <o:p></o:p><pre style='line-height:13.5pt;vertical-align:baseline;overflow-x: auto;overflow-y: auto;white-space:pre-line;background-image:initial;background-attachment:initial;background-origin: initial;background-clip: initial;border-style:initial;border-color:initial;background-position:initial initial;background-repeat:initial initial'> delete from rhnPushDispatcher;<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'> delete from rhnpushclient;<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'> commit;<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'><o:p> </o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'> quit<o:p></o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'><o:p> </o:p></pre><pre style='line-height:13.5pt;vertical-align:baseline'>-> Now restart the jabberd and osa-dispatcher services<o:p></o:p></pre> Good luck- -- Larry Letelier<o:p></o:p></div></body></html>