How to fix the Oracle error NNC-00002: error listening on stream string?

In this post, you’ll learn more about the Oracle ErrorNNC-00002: error listening on stream string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

NNC-00002: error listening on stream string

Reason for the Error NNC-00002: error listening on stream string

Cause: The name server was asked to listen on the specified address, and failed, probably because the address is malformed, or because it uses a SQL*Net protocol adaptor which has not been installed.

How to fix the Error NNC-00002: error listening on stream string ?

You can fix this error in Oracle by following the below steps

Action: Make sure the address is properly formed, and that it uses a protocol adaptor which has been installed on your system.