ORA-12557: TNS:protocol adapter not loadable x_Oracle.DatabaseError: ORA-12557:

报错 Error while trying to retrieve text for error ORA-01804
环境变量可能有问题
将dll文件复制到python安装路径

05/01/2020  02:22 pm           807,424 oci.dll
15/11/2019  06:59 pm           182,272 ocijdbc19.dll
05/01/2020  01:56 pm           612,352 ociw32.dll
05/01/2020  01:42 pm            88,576 oramysql19.dll
21/08/2019  05:35 am         4,762,112 orannzsbb19.dll
05/01/2020  01:10 pm         1,149,952 oraocci19.dll
05/01/2020  01:34 pm         1,163,776 oraocci19d.dll
05/01/2020  02:25 pm       205,559,808 oraociei19.dll
15/11/2019  07:48 pm           288,768 oraons.dll
05/01/2020  02:17 pm           232,448 orasql19.dll
15/11/2019  07:19 pm         1,659,392 orasqlplusic19.dll

没有安装vs 也可能出错

vs下载地址
https://docs.microsoft.com/en-US/cpp/windows/latest-supported-vc-redist?view=msvc-170#bookmark-vs2010

cx-oracle官方参考
https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html#wininstall

Answer: There are two solutions to this issue:

1 - put the Oracle DB Home in front of the other paths in the PATH environment variable.

2 - Remove ORACLE_HOME From environment Variable and re-boot PC

参考
https://stackoverflow.com/questions/21426915/ora-12557-tnsprotocol-adapter-not-loadable

http://www.dba-oracle.com/t_ora_12577.htm