How to fix the Oracle error TNS-01152: All addresses specified for the listener name, string, failed?

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.