Friday, July 27, 2012

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 


17 comments:

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

    ReplyDelete
  2. Thank you so much!!!

    ReplyDelete
  3. "Remove ORACLE_HOME From environment Variable" worked for me!
    Thank you,

    Mike

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


    Mike

    ReplyDelete
    Replies
    1. :) your welcome Mike, Nice words I really appreciate

      Delete
    2. 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?

      Delete
  5. I removed the ORACLE_HOME variable and restarted. it worked!! :-) Gr8!!

    ReplyDelete
  6. Thanks a lot for the solution

    ReplyDelete
  7. Thank You! Solution #2 worked for us as well! :-)

    ReplyDelete
  8. Love the screenshots, and it works !

    ReplyDelete
  9. Solution #2 works, thanks for the blog

    ReplyDelete
  10. AAAA allah akbar. BOOM!

    ReplyDelete