In this post, you’ll learn more about the Oracle ErrorTNS-01152: All addresses specified for the listener name, string, failed with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
TNS-01152: All addresses specified for the listener name, string, failed
Reason for the Error TNS-01152: All addresses specified for the listener name, string, failed
Cause: The listener failed to listen on any of the specified addresses.
How to fix the Error TNS-01152: All addresses specified for the listener name, string, failed ?
You can fix this error in Oracle by following the below steps
Action: Make sure that another application is not listening on the addresses specified or check that the appropriate protocol adapters are installed. Turn on tracing and execute again for more information.