Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Put Unix/Oracle Server in Different Network

SOLVED
Go to solution
Steven Chen_1
Super Advisor

Put Unix/Oracle Server in Different Network

Hi,

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.

Steven
Steve
3 REPLIES
Slawomir Gora
Honored Contributor
Solution

Re: Put Unix/Oracle Server in Different Network

Hi,

1) you have to modify system ip parameters
/etc/rc.config.d/netconf
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
${ORACLE_HOME}/network/admin/listener.ora
${ORACLE_HOME}/network/admin/tnsnames.ora




harry d brown jr
Honored Contributor

Re: Put Unix/Oracle Server in Different Network

issues I can think of:

tnsnames config file
/etc/hosts
dns resolution
routing issues
backups
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
harry
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.

For HP-UX

/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/named.data/ 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