Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Put Unix/Oracle Server in Different Network

Go to solution
Steven Chen_1
Super Advisor

Put Unix/Oracle Server in Different Network


I would like to get comments on to-do-lists to change an existing Unix/Oracle Server to a different network by changing IP, and being put behind a new FW.

There are a lot of changes and it is very grateful for any helpful drops.

Slawomir Gora
Honored Contributor

Re: Put Unix/Oracle Server in Different Network


1) you have to modify system ip parameters
a) ip adress
b) netmasks
c) gateway
/etc/hosts - IP
/etc/reslov.conf - DNS

you can use set_parms command to set above.

2) Oracle

harry d brown jr
Honored Contributor

Re: Put Unix/Oracle Server in Different Network

issues I can think of:

tnsnames config file
dns resolution
routing issues
Firewall rules

I suggest that before you attempt this change in production, that you take a similarly configured system, one that has oralce on it and your APPLICATIONS, and test the crap out of it.

We plan on doing the same soon, so unfortunately I can't exactly say what issues to look out for other than the ones above.

live free or die
Live Free or Die
Indira Aramandla
Honored Contributor

Re: Put Unix/Oracle Server in Different Network

Hi Steven,

We did this exercise couple of months ago. We changed the IP address and the host name of our rp5430 server with HP-UX 11i and Oracle 8i RDBMS on it.

We used the set_parms which is an interactive system set up program with hostname and ip_address parameters.


/etc/rc.config.d/netconf file
IP address
Subnetwork mask
Gateway IP address
On the DNS server the file /etc/hosts
Change the respective db files in the /etc/ directory
So that the DNS server resolves the name and ip_address to the changed one.

For Oracle

The entries in the tnsnames.ora and the listener.ora files. This files will be in $TNS_ADMIN directory. Change the entries refering to the hostname and ip_address and restart the listener.

This is on the server side and if you are accessing oracle database from any client side then on the clinet side change the tnsnames.ora file with the correct hostname and ip_addess.

Indira A
Never give up, Keep Trying