ORA-12502: TNS:listener received no CONNECT_DATA from client

Error:

When clients attempts to connect to the database, they can not connect with the error “ORA-12502: TNS: listener received no CONNECT_DATA from client”.

Reason:

Missing host definition in local_listener parameter.

Solution:

The definition in the local_listener parameter should be changed as follows.

Missing Host Definition:

Correct Host Definition:

You should type your domain name instead of “domain.local”.

If the database is RAC, the definition of sid = ‘XX’ should also be added.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *