Changing Server Name Where ORACLE is Loaded
I was wondering other than to edit the TNS names, would changing the server name andor the IP address where ORACLE is loaded and the data files are located, what other parameters or files do I need to changeedit? Is this doable without too much work?
Many thanks,
Sam
Software/Hardware used:
Software/Hardware used:
ASKED:
September 12, 2006 12:11 PM
UPDATED:
September 13, 2006 8:52 AM
Answer Wiki:
Good morning, Sam.
Well, it may not be quite that straight forward. Part will depend on the version of Oracle you're using, which type(s) of SQL authentication, which platform you're on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I'm probably missing some, but this is all I can think of at the moment. I'm sure others will chime in though.) :-)
The GOOD news is, for a vanilla install of Oracle using TNS, it's fairly straight forward:
-- Server side tnsnames.ora
-- Client side tnsnames.ora
-- listener.ora
Bounce the listener, and you're good to go.
When you begin looking at some extended features though, you may have a few other things to modify. For instance, if you happen to use IBM's Tivoli TSM in conjunction with RMAN on an AIX platform, you're going to need to change your /etc/hosts file, tdpo.opt files, and a change will need to be made to the backup hosting server so it knows to point to the new name/IP address.
So, the question could be absolutely simple to answer, or fairly complex, depending on your environment.
I hope this didn't muddy the waters too much.
Jeff
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
