Skip to main content

How to fix ORA-12547 TNS lost contact when try to connect to Oracle

Problem:
While login to oracle, the following error may happen:

sqlplus scott/tiger
ERROR:
ORA-12547: TNS:lost contact


Solution:
Step: #1
cd $ORACLE_HOME/bin
ls -ltr oracle
-rwxr-xr-x    1 oracle   oinstall       136803483 Mar 16 20:32 oracle

Step: #2
Change permissions as below:

chmod 6751 oracle
ls -ltr oracle
-rwsr-s--x    1 oracle   oinstall       136803483 Mar 16 20:32 oracle


Source:
http://www.dadbm.com/how-to-fix-ora-12547-tns-lost-contact-when-try-to-connect-to-oracle/

Popular posts from this blog

#ThankYouCitrisys

MAY 5, 2015 an unforgettable day in my life. Why this award is so special to me? Because, after 8 years (After completion of Engineering), I landed on a good place where they identified me and involved me in the good projects with suitable PMOs. With all their support in Citrisys, I did small things with my involvement. For that, Citrisys, awarded me this "Award of Excellence". This award not shows me the best performance, but, it shows me to work more and more. Thank you Mr.ARA (CEO, Citrisys Solutions) for this award. #ThankYouCitrisys

Citrisys Poster Competition work 02