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
#2 worked for us; THANKS!
LikeLike
#2 worked for me too. Thank you so much!!!
LikeLike
Thank you so much!!!
LikeLike
Welcome 🙂
LikeLike
“Remove ORACLE_HOME From environment Variable” worked for me!Thank you,Mike
LikeLike
“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
LikeLike
🙂 your welcome Mike, Nice words I really appreciate
LikeLike
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?
LikeLike
I removed the ORACLE_HOME variable and restarted. it worked!! 🙂 Gr8!!
LikeLike
Anytime
LikeLike
Thanks a lot for the solution
LikeLike
Welcome
LikeLike
Thank You! Solution #2 worked for us as well! 🙂
LikeLike
Your welcome
LikeLike
Love the screenshots, and it works !
LikeLike
Solution #2 works, thanks for the blog
LikeLike
AAAA allah akbar. BOOM!
LikeLike
Worked for me as well !
LikeLike
worked for me thx
LikeLike
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
LikeLike
Did you follow the above steps ?
LikeLike