I should add to this
once I got the database running again by changing the listener and names .ora
file to the FQDN I tried to use the spacewalk-hostname-rename script, that
changes the hostname back to "localhost" in both files, and therefore stops the
database from being available to connect.
I somehow need to get the database able to listen/connect with localhost in
those files again (I can still connect using sqlplus
spacewalk/spacewalk@//localhost/XE but only when the listener and names ora
files have the FQDN in instead of localhost)
The most obvious way seems to put Oracle back to it's default state (I'm hoping
this can be done) or unless some oracle wizz on here understands why I have
broke this and can help me resolve it.
thanks, sorry.
Matt
________________________________
From: [email protected] [[email protected]] on
behalf of Matthew Darcy [[email protected]]
Sent: 25 May 2011 00:02
To: [email protected]
Subject: [Spacewalk-list] re-configure Oracle XE without losing data
All,
I foolishly changed the hostname on my machine and oracle stopped working.
After a ton of reading and some advice, I change the listenera.ora to match my
new hostname / fqdn and it works
howerver I'm concerned that this is just a temp/hash fix to get spacewalk
talking to oracle again.
Is there a way I can say the data, but put oracle back to it's configuration
when first installing spacewalk.
thanks,
Matt.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
