Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them.
Today let’s have look on this.
Error’s
TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 104: Connection reset by peer
or
TNS-12537: TNS:connection closed TNS-12560: TNS:proto adapter error TNS-00507: Connection closed Linux Error: 29: Illegal seek
Solution:
We must make sure the following loopback entries exist in /etc/hosts file. If the Operating system configured with IPV6 then you need to add the second line as well. Start the listener after adding the following entries. For more information please check Doc ID 960152.1 from Oracle Support.
127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain localhost6
Today’s thought
If you light a lamp for someone else, it will also brighten your path. —Buddha
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
