Home » RDBMS Server » Server Administration » IP Address, Hostname or Domain Of Oracle Database Servers (Oracle 10g)
icon4.gif  IP Address, Hostname or Domain Of Oracle Database Servers [message #548994] Tue, 27 March 2012 07:46 Go to next message
sulthan123
Messages: 1
Registered: October 2011
Location: chennai
Junior Member

Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.

Please review and advise if we need to enable any other setting for the oracle database work.
Re: IP Address, Hostname or Domain Of Oracle Database Servers [message #548998 is a reply to message #548994] Tue, 27 March 2012 07:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing.
Oracle database does not care about the name of the server or the network.
Or maybe "db_domain" if you set it and want to match your network description.

Regards
Michel
Re: IP Address, Hostname or Domain Of Oracle Database Servers [message #549002 is a reply to message #548998] Tue, 27 March 2012 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For reference, question also posted at http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=50117&SkipA=0.

Regards
Michel
Re: IP Address, Hostname or Domain Of Oracle Database Servers [message #549007 is a reply to message #548994] Tue, 27 March 2012 08:10 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Even though the database doesn't care, Oracle Net does. You should adjust your listener.ora and tnsnames.ora files, also any places where you may have hardcoded connect strings: local_listener and remote_lsitener parameters, database links, there may be others.
Previous Topic: Verify Rebuild index
Next Topic: ASM 11g R2 new feature
Goto Forum:
  


Current Time: Thu Mar 28 03:40:03 CDT 2024