<html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> On 20/10/11 12:37, Gomes, Rich wrote: <blockquote cite="mid:716C4F59FAB01649B085832B6DC831BA04D3F0A8@anorpexbe01.AUCA.Corp" type="cite"> <meta http-equiv="Context-Type" content="text/html; charset=us-ascii"> <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. Since it is a VM, I am cloning it as the new name and then powering off the original. Once the new server is up I do the following: 1 – Change IP to be that of original 2 – Change hostname in both /etc/hosts and /etc/sysconfig/network 3 – Reboot and verify name change 4 – Run spacewalk-hostname-rename script Each time I receive the following: [root@newhostname ~]# spacewalk-hostname-rename xx.xx.xx.xx Validating IP ... OK ============================================= hostname: newhostname ip: xx.xx.xx.xx ============================================= Stopping rhn-satellite services ... OK Testing DB connection ... ERROR: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] SP2-0306: Invalid option. Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]] where <logon> ::= <username>[/<password>][@<connect_identifier>] <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>] SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus FAILED Your database isn't running. Fix the problem and run /usr/bin/spacewalk-hostname-rename again 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. This server was\is running successfully so I decided to to just clone it and rename it. Interestingly, if I change host name back to original, it does me now good. And also, tnsnames and listener.ora both have ‘localhost’ specified, not new hostname. Changing this to the new hostname does not good either. Has anyone else run into this? How can this be fixed? Thanks, Rich Rich Gomes | Senior Systems Administrator, AUCA System Services | ARAMARK Uniform & Career Apparel Tel: 781.763.4508 | Fax: 781.763.2508 <a moz-do-not-send="true" href="mailto:Rich.Gomes@wearguard-crest.com">Rich.Gomes@wearguard-crest.com</a> | <a moz-do-not-send="true" href="http://www.aramark-uniform.com/" title="http://www.aramark-uniform.com/">www.aramark-uniform.com</a> </div> <fieldset class="mimeAttachmentHeader"></fieldset> <pre wrap="">_______________________________________________ Spacewalk-list mailing list <a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre> </blockquote> Rich: Try this, <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> <span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: 'Liberation Sans', 'Lucida Grande', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(248, 244, 230); "> <pre class="caseCommentStyle publicComment" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; display: block; width: auto; overflow-x: auto; overflow-y: auto; white-space: pre-line; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: 'Liberation Sans', 'Lucida Grande', 'Luxi Sans', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; background-position: initial initial; background-repeat: initial initial; ">-> Stop the osa-dispatcher and jabberd service. <span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: 'Liberation Sans', 'Lucida Grande', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(248, 244, 230); "><pre class="caseCommentStyle publicComment" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; display: block; width: auto; overflow-x: auto; overflow-y: auto; white-space: pre-line; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: 'Liberation Sans', 'Lucida Grande', 'Luxi Sans', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; background-position: initial initial; background-repeat: initial initial; "><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: arial, helvetica, sans-serif; background-positi on: initial initial; background-repeat: initial initial; ">-> #rm -f /var/lib/jabberd/db/* </pre> <span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: 'Liberation Sans', 'Lucida Grande', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(248, 244, 230); "><pre class="caseCommentStyle publicComment" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; display: block; width: auto; overflow-x: auto; overflow-y: auto; white-space: pre-line; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: 'Liberation Sans', 'Lucida Grande', 'Luxi Sans', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; background-position: initial initial; background-repeat: initial initial; "><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: arial, helvetica, sans-serif; background-positi on: initial initial; background-repeat: initial initial; ">-> Switch to the oracle user and using sqlplus clear out the client and dispatcher tables. </pre><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: arial, helvetica, sans-serif; background-position: initial initial; background-repeat: initial initial; "> </pre> <p style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; vertical-align: baseline; background-position: initial initial; background-repeat: initial initial; "> sqlplus $(spacewalk-cfg-get default_db) <p style="background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; vertical-align: baseline; min-height: 8pt; height: 8pt; background-position: initial initial; background-repeat: initial initial; "> <pre class="caseCommentStyle publicComment" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; display: block; width: auto; overflow-x: auto; overflow-y: auto; white-space: pre-line; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: 'Liberation Sans', 'Lucida Grande', 'Luxi Sans', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; background-position: initial initial; background-repeat: initial initial; "> delete from rhnPushDispatcher; delete from rhnpushclient; commit; quit <span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: 'Liberation Sans', 'Lucida Grande', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 18px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(248, 244, 230); "><pre class="caseCommentStyle publicComment" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; display: block; width: auto; overflow-x: auto; overflow-y: auto; white-space: pre-line; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: 'Liberation Sans', 'Lucida Grande', 'Luxi Sans', 'Trebuchet MS', 'Bitstream Vera Sans', helvetica, verdana, arial, sans-serif; background-position: initial initial; background-repeat: initial initial; "><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: arial, helvetica, sans-serif; background-positi on: initial initial; background-repeat: initial initial; ">-><span style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: transparent; font-size: 13px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; vertical-align: baseline; font-family: arial, helvetica, sans-serif; background-position: initial initial; background-repeat: initial initial; "> Now restart the jabberd and osa-dispatcher services</pre></pre> Good luck- -- Larry Letelier </body> </html>