ORA-12557 TNS:protocol adapter not loadable

ORA-12557 TNS:protocol adapter not loadable

Error
ORA-12557 TNS:protocol adapter not loadable

Solution
For solving the error you have to check the following points and tried to connect after each point:

1. Check the PATH variable value
It may happen due to incorrect sequence of Oracle path in the PATH variable.
If you have any recent update activity in which your PATH Environment variable is not properly set in both linux or windows environment.
Note: when you install or de-install the oracle database server or client then PATH variable automatically update in windows.
-- Check PATH variable in Windows
ECHO %PATH%

-- Check PATH variable in Linux/Unix
echo $PATH

Note: Tried to TEST the connectivity by move the PATH of Oracle software to First position. By default first position PATH is used by application.
-- Example: Change PATH position
ECHO %PATH%
D:\oracle\product\11.2.0\db_1\bin;D:\oracle\product\11.2.0\client_1\bin;

--Change client path at first position
D:\oracle\product\11.2.0\client_1\bin;D:\oracle\product\11.2.0\db_1\bin;

2. Similarly you can tried to set the ORACLE_HOME Environment Variable
-- In Windows
SET ORACLE_HOME=D:\oracle\product\11.2.0\db_1
--In Linux
EXPORT ORACLE_HOME=/u01/app/dbhome_1

3. Issue may be you are using 32 bit application with 64 bit database
1. You need to install 32-bit Oracle Client on machine and use 32-bit client string for making connection.
2. Set ORACLE_HOME to the Oracle 32-bit client location and add the same to the PATH environment variable in first position.

Verify the Oracle is 32-bit or 64-bit
It will give you the result in first line it is 64 bit or 32 bit.
tnsping service_name

--Example
C:\Users\oracle>tnsping
TNS Ping Utility for 64-bit Windows: Version 11.2.0.2.0 - Production on 22-FEB-2019 14:56:19
Copyright (c) 1997, 2014, Oracle. All rights reserved.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.