Changing Server Name Where ORACLE is Loaded

30 pts.
Tags:
Database
DB2
Oracle
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
ASKED: September 12, 2006  12:11 PM
UPDATED: September 13, 2006  8:52 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SamAvella
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/changing-server-name-where-oracle-is-loaded/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following