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

dbtut July 29, 2018 ORACLE

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:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node-VIP) (PORT = 1521))))

1	(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node-VIP) (PORT = 1521))))

Correct Host Definition:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node-vip.domain.local) (PORT = 1521))))

1	(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node-vip.domain.local) (PORT = 1521))))

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

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

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node01-vip.domain.local)(PORT=1521))))' scope=both sid='ORCL1';

1	SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node01-vip.domain.local)(PORT=1521))))' scope=both sid='ORCL1';

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node02-vip.domain.local)(PORT=1521))))' scope=both sid='ORCL2';

1	SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node02-vip.domain.local)(PORT=1521))))' scope=both sid='ORCL2';

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux