✦

Technology Geek

18+ YEARS AMONG THE CLOUDS

✦ TRANSMISSION

ORA-12557: TNS:protocol adapter not loadable

this problem On windows Platforms .

and it must be related to Windows Environment or Oracle Home PATH because sqlplus command works smoothly when I execute it inside ORACLE_HOME\bin.

RUN: SYSDM.CPL to open Windows System Properties
Click on Advanced Tab > Environment Variables…

Click the Path variable under System Variable, then click  Edit…

change the order between Oracle Client Home and Oracle DB Home:

From: D:\oracle\product\10.2.0\client_1\bin;D:\oracle\product\10.2.0\db_1\bin;

To: D:\oracle\product\10.2.0\db_1\bin;D:\oracle\product\10.2.0\client_1\bin;

in other words, put the Oracle DB Home in front of the other path.

Or i Don’t love this way , Since its not actual solution but its solve problem sometimes :
1-Remove ORACLE_HOME From environment Variable .


2- Restart PC 
Done

Osama mustafa 

21 responses to “ORA-12557: TNS:protocol adapter not loadable”

  1. Unknown

    #2 worked for us; THANKS!

    Like

    Reply
  2. Somnath Das

    #2 worked for me too. Thank you so much!!!

    Like

    Reply
  3. Anonymous

    Thank you so much!!!

    Like

    Reply
  4. Osama Mustafa

    Welcome 🙂

    Like

    Reply
  5. Anonymous

    “Remove ORACLE_HOME From environment Variable” worked for me!Thank you,Mike

    Like

    Reply
  6. Anonymous

    “change the order between Oracle Client Home and Oracle DB Home” SOLVES, ORA-12560 : TNS: protocol adapter error as well as ORA-12557Thanks you again, Osama Mustafa.What would we do without you,Mike

    Like

    Reply
  7. Osama Mustafa

    🙂 your welcome Mike, Nice words I really appreciate

    Like

    Reply
  8. syed farhan

    thanks osama can you trained me in oracle platform i want to be OCA AND OCP BUT i am not able to finance my self so please reply if u can?

    Like

    Reply
  9. Narmadha Anbarasan

    I removed the ORACLE_HOME variable and restarted. it worked!! 🙂 Gr8!!

    Like

    Reply
  10. Osama Mustafa

    Anytime

    Like

    Reply
  11. Anonymous

    Thanks a lot for the solution

    Like

    Reply
  12. Osama Mustafa

    Welcome

    Like

    Reply
  13. Kavitha

    Thank You! Solution #2 worked for us as well! 🙂

    Like

    Reply
  14. Osama Mustafa

    Your welcome

    Like

    Reply
  15. Anonymous

    Love the screenshots, and it works !

    Like

    Reply
  16. Anonymous

    Solution #2 works, thanks for the blog

    Like

    Reply
  17. Anonymous

    AAAA allah akbar. BOOM!

    Like

    Reply
  18. Anonymous

    Worked for me as well !

    Like

    Reply
  19. Anonymous

    worked for me thx

    Like

    Reply
  20. Anonymous

    Dear Mustafa am really in a bad need to your helpi have a oracle 12c DB 64bit installed on my win serv 2012and installed oracle client 11g 32as i need to open connection through client between unix server and windowsand always recives orror like 125557 please in a bad need to ur help

    Like

    Reply
  21. Osama Mustafa

    Did you follow the above steps ?

    Like

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.