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.

Connecting to Oracle Database Using Service Name.

Connecting to Oracle Database Using Service Name.

While creating a connection to Database we give SID as Database Name.

To give Service name instead of SID.

• Give a back slash before the Service name Eg: /Service name

If you are using JNDI connection give URL as shown below.

Service URL is:

jdbc:oracle:thin:@Host name:port/service name