It's kind of non-trivial. However doable. Follow these steps:
1) Download Oracle Instant client for Windows x64 from
e.g. choose client e.g. 11.2.0.4
-> instantclient-basic-windows.x64-11.2.0.4.0.zip
-> instantclient-sdk-windows.x64-12.1.0.2.0.zip
2) Create directory and unzip the client & sdk in there:
e.g. c:\ora\11gx64
3) Set ORACLE_HOME and TNS_ADMIN
e.g. ORACLE_HOME=c:\ora\11gx64
and TNS_ADMIN=c:\ora\11gx64
also add %ORACLE_HOME% in Your %PATH%
4) In the created directory put file tnsnames.ora and fill with connection string to db:
%ORACLE_HOME%**tnsnames.ora** XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )
-> replace 127.0.0.1 with your hostname
-> replace XE with your SID
5) I suppose You've got already Python installed.
-> Otherwise visit Download page for Python
-> Install python (3.6.1 in the time of writting)
-> execute python get-pip.py
6) Download and Install Visual C++ 2015 Build Tools
-> Search for Visual C++ 2015 Build Tools -> Install visualcppbuildtools_full.exe
7) Use pip to install cx_oracle pip install cx_oracle
(in the time of writing there is trouble with default installed version 5.3 so the Version 6.0b2 has to be installed) python -m pip install cx_Oracle --pre
The first steps are universal in my honest opinion for both conda and pip.