Thanks guys, so I understand now that this is done as any other oracle client/server connectivity via Net8.
I see my process of moving oracle database from one server to another as:
- recreate oracle on second machine
- shutdown oracle on webserver machine
- setup SID entries in tnsnames.ora on webserver machine pointing to second machine
- change entries for SID in nsd.tcl
For the oracle to be moved from RH7.3 to RH8 is this necessary to go thru the installation process or is it enough to clone it from the old machine?