ORA-12547: TNS:lost contact After Operating System Restart

My Final Post in 2023, weird issue was faced where a database system after Linux operating system reboot startups in a defect way. when you attempt to connect through Bequeath Protocol:

ERROR:
ORA-12547: TNS:lost contact

After investigation….The Solution:

cat /etc/oratab

current entry was the following:

ORCLCDB:/opt/oracle/product/19c/dbhome_1/:Y

changed it to:

ORCLCDB:/opt/oracle/product/19c/dbhome_1:Y

Typo’s can cause serious problems…it took some time to figure out the problem.

Leave a comment