Where to maintain HADR Local service port entry if the database instance is in cluster

[Former Member]

Hi Experts,

My primary system is in cluster and HADR local_host is configured with cluster database instance resource IP to  i.e,192.168.1.15 address at Primary.

Port entries are maintained in both services file of Node1 and Node2 and in DR system.

After starting HADR at Primary list when i use netstat -a it is showing HADR related process details as

TCP   192.168.1.10:53146      BELLI-DR:TNT_HADR_2  ESTABLISHED.

It is using 192.168.1.10 as local host since that is Node1 IP and it is presently active but I am worried that i have not maintained this port 53146 entry in Node1 and Node2 of Primary site and the port number is changing daily based on available ports.

But in DR system HADR local service port is showing service name that i maintained in services file.

Kindly suggest where to maintain port entries and how to make HADR to use only one static port or service at Primary site.

Thanks,

Bharath.

[former_member188883 · Accepted solution]

Hi Bharath,

Port and services entries should be maintained in /etc/hosts and /etc/services file for both the nodes.

Which i see you already maintained.

Please ensure that no other service is using the ports used for your installation.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thank you Deepak. We don't have strong network people to open the ports in internal firewall properly.

So we are planning to change port numbers in HADR configuration. 

netstat -a shows some free ports in Node1, Node2 and also in DR server.

The ports 49152 49153 are free on all systems.

Can i change HADR configuration to replace present ports with these free ports available on all systems.

Kindly suggest.

Thanks,

Bharath.