How to fix the Oracle error TNS-01185: Registration attempted from a remote node?

In this post, you’ll learn more about the Oracle ErrorTNS-01185: Registration attempted from a remote node with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

TNS-01185: Registration attempted from a remote node

Reason for the Error TNS-01185: Registration attempted from a remote node

Cause: It was determined that the registering instance is not located on the same node as the listener. It is required that the instance be colocated with the listener for this type of service registration.

How to fix the Error TNS-01185: Registration attempted from a remote node ?

You can fix this error in Oracle by following the below steps

Action: Check the configuration of the registering instance. Ensure that local_listener parameter specifies only local listeners. Use remote_listener parameter to specify remote listeners.