Remember: The first time you install Python cx_oracle encounters the pit to avoid forgetting

Installation Cx_oracle encounter a lot of pits, but are common on-line problems, do not list, just record the final installation of the success of the example is good

Download Cx_oracle Library, Address: https://sourceforge.net/projects/cx-oracle/files/Choose a package that matches your own version,

1.cx_oracle must be in the same position as Python and instantclient, either 32-bit or 64-bit

The 2.PLSQL supports only 32-bit instantclient,

3. My environment is, Windows 64-bit, python2.7,64 bit, cx_oracle-5.2.1-11g.win-amd64-py2.7,instantclient-basic-win-x86-64-11.1.0.7.0

4. Because I want to use Plsql, so the computer installed 32-bit and 64-bit Instantclient,plsql connection Orcale method of online data a lot, according to the above is good,

Installed after the installation of the 64-bit instantclient, very simple, the tnsnames configuration, placed in a directory with Oci.dll, and then the directory of all the files copied and pasted into Python site-package, my is C + + Python27\lib\site-packages, this connection is successful.

Because my is 64 bit, if want to use Python to connect Orcale and want to use Plsql, can be like the 4th, I see online said in another computer installed again remote, actually no need, I also did not configure environment variable, just put 64 bit of instanclient directory All the files are copied to the Python site-package.

Installed for a long time, finally succeeded, long sigh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Remember: The first time you install Python cx_oracle encounters the pit to avoid forgetting