Forum Stats

  • 3,782,161 Users
  • 2,254,607 Discussions


Oracle Client + ORA-12557: TNS:protocol adapter not loadable

Deat experts, We migrated from Oracle 12c to Oracle 19c in the windows server 2016 last week.

The DBA did not remove the previous version of oracle client - 12c and in addition installed the latest version of Oracle 19c.

Also I can see the environment variable has below 2 entry in addition to both the client installation



When we connect to the database using external connection, we get the below error. The DB connection was working fine prior to the oracle 19c installation.

The program has ended abnormally due to an unhandled exception.
Exception Code (OCI[DBConnectOCI.cpp[192]]
ORA-12557:TNS:protocol adapter not loadable)


  1. I am not a DBA person but technically oracle has what it needs, why does it not getting connected to the DB using oracle client 19c?
  2. Is it 100% true that we need to remove the previous version of the DB Client and always have only one client version?
  3. Is the environment variable creating the issue ? or both env variable and oracle client ?


  • Sunny kichloo
    Sunny kichloo Member Posts: 2,447 Gold Trophy

    Try to run below mentioned command


    In this command do confirm any environment variables using old oracle version.

    If it is just Oracle client Try to update old oracle version path with new one in environment variables like ORACLE_HOME,PATH or any others.

    Do share the output and if it is not connecting after above mentioned changes do share error message.