In this post, you’ll learn more about the Oracle ErrorNNF-00001: Not a TNS address with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
NNF-00001: Not a TNS address
Reason for the Error NNF-00001: Not a TNS address
Cause: While asking to read an address the name service returned a record which was not an address.
How to fix the Error NNF-00001: Not a TNS address ?
You can fix this error in Oracle by following the below steps
Action: Not normally visible to the user. For further details, turn on tracing and re-execute the failing operation. If the error persists, contact Worldwide Customer Support.