All Oracle Error CodesOracle DBA Forum

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.
Action: Contact your name server administrator to have the alias loop investigated and fixed.