topic Put Unix/Oracle Server in Different Network in Operating System - HP-UX

Put Unix/Oracle Server in Different Network

Steven Chen_1 — Thu, 02 Sep 2004 09:27:17 GMT

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

Re: Put Unix/Oracle Server in Different Network

Slawomir Gora — Thu, 02 Sep 2004 09:40:31 GMT

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

Re: Put Unix/Oracle Server in Different Network

harry d brown jr — Thu, 02 Sep 2004 09:40:37 GMT

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

Re: Put Unix/Oracle Server in Different Network

Indira Aramandla — Thu, 02 Sep 2004 20:33:38 GMT

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