Dual host/domain names for multiple Oracle instances

[Mike Barnes_1]

Hi all,

I have a rp7400 server, HP-UX 11.11 installed. I have 2 completely different instances of Oracle Apps and Database, which I would like to have reside on the same server.

The problem is, they need to be setup in different domains, using a different hostname for each.

I have heard talk that it is possible to create an environment whereby the server can support using different hostname/domain name on the same machine.

Does anyone know if this is possible, and possibly info on setting up such an environment?

Thanks Much,

Mike

[Doug Kratky]

Definitely possible. Decide what IP addresses and names you want. Either use multiple NIC cards or multiple IP addresses on the same NIC card.

To use multiple IP addresses on the same NIC card, use names like lan0:1 and lan0:2. lan0:1 and lan0:2 would then be different IP addresses than the default lan0 (aka lan0:0). You can set this up manually with ifconfig or refer to the indexed interface names in /etc/rc.config.d/netconf.

Set up your IP addresses and names in /etc/hosts and DNS.

Use listener.ora to listen on a specific TCP/IP address for each Oracle instance instead of letting it default to any/all configured IP addresses.

[U.SivaKumar_2]

hi,
Assume You are running two instance of oracle as follows:
prod01 - production people access this.
devel01 - development people access this.

In all the clients of production department
Put ip address of your server and name in
c:\windows\hosts file.
eg:-
192.123.100.30 prodserver


All you want to do is use tnsnames.ora files in the oracle client machines.
eg:-


prod = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=prodserver)(PORT=1565))
(CONNECT_DATA=(SID=prod01))
Same way in the development department put the
ip address and server name as develserver in
c:\windows\hosts
192.0.10.10 develserver
In the tnsnames.ora file on the clients of deveopment department.

devel = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=develserver)(PORT=1565))
(CONNECT_DATA=(SID=devel01))

Now people from deveopment will connect to devel01 instance.

regards,
U.SivaKumar

[sven verhaegen]

this is a bit special

I suppose you have 2 domain lets call them aps.oracle and db.oracle, you have one server and one lancard with 1 IP , there are several thing you could do , either like proposed you keep everything completely separated by adding trough the ifconfig lanx:x procedure several subinterfaces and get each one of them a separate name ..

or you could simply give the same lancard different aliasses with fully qualified names and run 2 DNS servers which hold the same IP but a different name for this machine , you could even have the same name with a different domain that way , in the /etc/host file of the oracle machine you would have something like

ip server server.aps.oracl server.db.oracle

so you see lots of possibilities , it's up to you to choose how to do this , for more clarity I personally would advise multiple IP with different naming , that just makes averything clearer for maintenance