TNS-12557: TNS:protocol adapter not loadable
I have did some work around, firstly checked my TNSPING, but the result showing as below
So I have checked my PATH setting and discovered the original PATH setting missing my old Oracle Home details. This below is my present PATH environment setting. |
PATH=C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\Middlewar
e\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn
\lib;C:\Middleware\Oracle_BI2\perl\bin
After experimentation revealed that my exiting TNS_ADMIN and bin directory has been missing from PATH environment, so I have decided to add the existing directory and now its looks like. (close the command window and open another one)
PATH=C:\OraHome_1\bin;C:\OraHome_1\network\ADMIN;C:\Program Files\PC Connectivit
y Solution\;C:\WINDOWS\system32;C:\Middleware\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn\lib;C:\Middleware\Oracle_BI2\perl\bin
As a result of this path setting, again open one command window (startup->cmd) and tried with same command. Now its working fine |
No comments:
Post a Comment