How to resolve "TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact" | Karan Rajpoot
TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Error: - "TNS-12547: TNS: lost contact TNS-12560: TNS: protocol adapter error TNS-00517: Lost contact" Cause: - This error occurs when loopback entries have been missed in the /etc/hosts file. Solution: - To resolve this error you need to put the loopback entries in the /etc/hosts file. Example: - [oracle@prod bin]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-APR-2019 22:08:16 Copyright (c) 1991, 2013, Oracle. All rights reserved. Starting /u02/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.4.0 - Production System parameter file is /u02/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u02/app/oracle/diag/tnslsnr/prod/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod.radical.com)(PORT=1521))) C