The procedure entry point could not be located in the dynamic link library oranl10.dll

You might encounter the following error when you trying to connect to the Oracle database by using SQL PLUS:

The procedure entry point could not be located in the dynamic link library oranl10.dll

The solution is as below:

a). Go to the Oracle Universal Installer.

b). Click the "Installed Products...".

c). System will prompt you a new screen called "Inventory".

d). Now, click the "Environment" tab.

e). In the "Home Name", please move up the original service name by using the arrow.

f). After that, click the "Apply" button and then "Close" button.

g). Exit the Oracle Universal Installer.

h). Try to connect to the Oracle database by using SQL PLUS now.