How to Enable VNCR on RAC Database to Register only Local Instances (Doc ID 1914282.1)

Last updated on JULY 17, 2023

Applies to:

Goal

Explains the VNCR or Validnode checking registration option that was introduced in 11.2.0.4 and enhanced in 12.1.0.2.
Starting with 11.2.0.4 we have the option of using VNCR to protect the listener from having remote/unknown instances registering to it.

See <Note 1600630.1> Valid Node Checking For Registration (VNCR)

On 11.2.0.4 RAC databases, the parameter VALID_NODE_CHECKING_REGISTRATION_listener_name is set to off.

However, sometimes this allows other instances in the same subnet to register against these listeners. We want to prevent that and allow only local instances to that RAC database to be registered with these listeners.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.