In this post, you’ll learn more about the Oracle ErrorNNC-00407: alias loop in name request with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
NNC-00407: alias loop in name request
Reason for the Error NNC-00407: alias loop in name request
Cause: The name service detected an “alias loop” when trying to retrieve information associated with a global name. An alias loop occurs when an alias name X points to another alias name Y, which in turn points back to X, rather than eventually to a global name which contains data.
How to fix the Error NNC-00407: alias loop in name request ?
You can fix this error in Oracle by following the below steps
Action: Contact your name server administrator to have the alias loop investigated and fixed.