what IP should I use

[Nguyen Anh Tien]

Hi all.
I am planning to install OPS cluster.
My system are: rp4440 (hostname: sys1 DATA IP:10.4.11.2) and rp4440(hostnam: sys2 DATA IP:10.4.11.3) share vgs are located on eva5000.
My application want to connect to server via IP: 10.4.11.5. SO how should I declare this IP in package control file? If I only declare in package on sys1 or sys2 how OPS will work to balance load. IF I declare on a package running on sys1 and sys2 IP will be conflicted.
Pls show me how.

[RAC_1]

You need to specify the ip address in package configuration file and then do cmappyconf to distribute changes to all nodes.

[Luk Vandenbussche]

Each rac package has its own IP adres.

The failover and load balance is defined in the listener configuration on your client.

Here you find my tnsnames.ora

You can connect directly or in failover, racdbf is my failover connection

RACDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb1)
)
)

RACDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = racdb)
)
)


LISTENER_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
)

RACDBF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = racdb)
(failover_mode =
(type = select)
(method = basic)
)
)
)

RACDB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb2)
)
)

[Nguyen Anh Tien]

Ok. How my application can connect to only one IP and all application job are balanced load on both server

[Luk Vandenbussche]

Like I said,

you connect to racdbf.

Here you see the definition load_balance=yes

Believe me, works fine

[Thayanidhi]

Hi,
As explained by Luk, The package don't have IP address as they don't failover. So the client/server's tnsnames/listner configuration should be made as Luk explained.

Regds
TT

[baiju_3]

Yes as posted by others ,in a RAC invironment you will have one RAC instance per node and each instance will be using individual IPs . So you may have to assign unique IP address for each package .

Also consider to have a giga bit interface for communication between servers because RAC operation needs a faster network.


Thanks,
BL.