Oracle Error ORA-12557 – TNS:protocol adapter not loadable occurs on my Windows machine whenever I want to access sqlplus using command prompt.
Once hit [Enter] button after issuing command
sqlplus / as sysdba, an unwanted popup appear and it said:
The procedure entry point snlseFreeSecAttrib could not be located in the dynamic link library oranl10.dll
I don’t really know how come this error come hehe, but it must be related to Windows Environment or Oracle Home PATH because sqlplus command works smoothly when I execute it inside ORACLE_HOME\bin.
Okay, let we see what’s wrong with the Windows Environment.
RUN: SYSDM.CPL to open Windows System Properties
Click on Advanced Tab > Environment Variables…
Click the Path variable under System Variable, then click Edit…
This is the original Path
Let we change the order between Oracle Client Home and Oracle DB Home:
in other words, put the Oracle DB Home in front of the other path.
Click OK to save the changes.
Open new command prompt and write down
sqlplus / as sysdba
Eh, it work..