Monday 30 May 2016

TNS-12557: TNS:protocol adapter not loadable


Error: While trying to connect to database through command prompt it through the                       error  :TNS-12557: TNS:protocol adapter not loadable


Cause: It is due to the multiple location entries for Oracle clients. So windows can't recognize which adapter to load.

Solution:

Put oracle DB home first in the PATH environment variable.

Then delete the ORACLE_HOME from Environment variable and reboot the PC.



No comments:

Post a Comment