Download Oracle Client 11.2 !!BETTER!!
The reason I'm not just using a 12c client for everything (as much as I would like to) is because I can't. This annoying error greets you trying to use expdp a 11.2.0.2 database using the 12c client:
Download Oracle Client 11.2
Starting with 11.2.0.2.0, any subsequent updates can be downloaded from with the installer itself, either as an integrated part of the installation process, or in advance (useful when destined server is restricted from accessing the Internet) by running the installer with the option -downloadUpdates.
As of SAPINST versions of release 6.40/7.00/7.01/7.02 do not allow to install Instant Client 11.2. we have to replace Instant Client 10.2 by Instant Client 11.2 after the SAP installation , according to SAP recommendation All SAP application servers of an SAP system should run with the same version of the instant client. Running a mix of different instant client versions in one SAP system is not recommended
Since September 2018 the instant client RPMs have been freely available on yum.oracle.com. If you are using Oracle Linux and have root access you can install the instant client using Yum with a few simple commands.
Add Oracle 21, 19, 18, 12 or 11.2 client libraries to your operating systemlibrary search path such as PATH on Windows or LD_LIBRARY_PATH onLinux. On macOS use init_oracle_client() in yourapplication to pass the Oracle Client directory name, seeUsing cx_Oracle.init_oracle_client() to set the Oracle Client directory. This is also usable on Windows.
Version 21 client libraries can connect to Oracle Database 12.1 or greater.Version 19, 18 and 12.2 client libraries can connect to Oracle Database 11.2or greater. Version 12.1 client libraries can connect to Oracle Database 10.2or greater. Version 11.2 client libraries can connect to Oracle Database 9.2or greater.
Alternatively, put the files in the network/admin subdirectory of InstantClient, for example in /opt/oracle/instantclient_21_1/network/admin.This is the default Oracle configuration directory for executables linkedwith this Instant Client.
Alternatively, put the files in the network/admin subdirectory of InstantClient, for example in /usr/lib/oracle/21/client64/lib/network/admin.This is the default Oracle configuration directory for executables linkedwith this Instant Client.
Alternatively, put the files in a network\admin subdirectory ofInstant Client, for example inC:\oracle\instantclient_19_11\network\admin. This is the defaultOracle configuration directory for executables linked with thisInstant Client.
For other installation options such as installing through a proxy, seeinstructions above. Make sure the Oracle Client libraries are in the systemlibrary search path because cx_Oracle 7 does not support thecx_Oracle.init_oracle_client() method and does not support loading theOracle Client libraries from the directory containing the cx_Oracle modulebinary.
On Windows, if you are not usinginit_oracle_client(), then restart your command promptand use set PATH to check the environment variable has the correctOracle Client listed before any other Oracle directories.
On macOS, make sure you are not using the bundled Python (use Homebrew or Python.org instead). If you are not usinginit_oracle_client(), then put the Oracle InstantClient libraries in /lib or /usr/local/lib.
cx_Oracle 8.3 was tested with Python versions 3.6 through 3.10. Older versions of cx_Oracle may be used with previous Python releases. You can use cx_Oracle with Oracle 11.2, 12, 18, 19 and 21 client libraries. Oracle's standard client-server version interoperability allows connection to both older and newer databases. For example Oracle 19c client libraries can connect to Oracle Database 11.2.
C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odp /frameworkversion:v4.0.30319 /providerpath:C:\oracle64\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll
C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odp /frameworkversion:v4.0.30319 /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\Oracle.DataAccess.dll
By default, python-oracledb connects directly to Oracle Database. This letsit be used when Oracle Client libraries are not available (such Apple M1 orAlpine Linux), or where the client libraries are not easily installable (suchas some cloud environments). Note not all environments are tested.
The python-oracledb attribute Connection.thin can be used to see whatmode a connection is in. In the Thick mode, the functionoracledb.clientversion() can be used to determine which Oracle Clientversion is in use. The attribute Connection.version can be used todetermine which Oracle Database version a connection is accessing. These canthen be used to adjust the application behavior accordingly. Any attempt touse Oracle features that are not supported by a particular mode or clientlibrary/database combination will result in runtime errors.
This will download and install a pre-compiled binary from PyPI if one is available for yourarchitecture. Otherwise, the source will be downloaded, compiled, and theresulting binary installed. Compiling python-oracledb requires thePython.h header file. If you are using the default python package,this file is in the python-devel package or equivalent.
By default, python-oracledb runs in a Thin mode which connects directly toOracle Database so no further installation steps are required. However, to useadditional features available in Thick mode you needOracle Client libraries installed. Oracle Client versions 21, 19, 18, 12 and11.2 are supported.
Alternatively, put the files in the network/admin subdirectory of InstantClient, for example in /opt/oracle/instantclient_21_6/network/admin.This is the default Oracle configuration directory for executables linkedwith this Instant Client.
By default, python-oracledb runs in a Thin mode which connects directly toOracle Database so no further installation steps are required. However, to useadditional features available in Thick mode you needOracle Client libraries installed. Oracle Client versions 21, 19, 18, 12, and11.2 are supported.
Alternatively, put the files in a network\admin subdirectory of InstantClient, for example in C:\oracle\instantclient_19_11\network\admin.This is the default Oracle configuration directory for executables linkedwith this Instant Client.
To use python-oracledb in Thick mode you must calloracledb.init_oracle_client() in your application, seeEnabling python-oracledb Thick mode. Without this, your application will get the errorDPY-3016: python-oracledb thin mode cannot be used because the cryptographypackage is not installed.
On Windows and macOS, pass the lib_dir library directory parameterin your oracledb.init_oracle_client() call. The parametershould be the location of your Oracle Client libraries. Do not passthis parameter on Linux.
On Windows, if you are not using passing a library directory parameterto oracledb.init_oracle_client(), then restart your commandprompt and use set PATH to check if the environment variable has thecorrect Oracle Client listed before any other Oracle directories.
If you get the error DPY-3010: connections to this database serverversion are not supported by python-oracledb in thin mode whenconnecting to Oracle Database 11.2, then you need to enable Thick mode byinstalling Oracle Client libraries and callingoracledb.init_oracle_client() in your code. Alternatively,upgrade your database.
If you get the error DPI-1072: the Oracle Client library version isunsupported, then review the installation requirements. The Thickmode of python-oracledb needs Oracle Client libraries 11.2 or later.Note that version 19 is not supported on Windows 7. Similar steps shownabove for DPI-1047 may help. You may be able to use Thin mode whichcan be done by removing calls oracledb.init_oracle_client() fromyour code.
How can I install Oracle's imp / exp binaries to my CentOS box without installing an Oracle Server? I'm accessing an existing Oracle database on another machine, so I only need a client here. I already installed sqlplus and its dependencies (oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm, and oracle-instantclient11.2-odbc-11.2.0.3.0-1.x86_64.rpm), but that didn't provide those tools.
To get the export (exp) and import (imp) binaries, install the full Oracle Client, instead of the Instant Client or the full RDBMS. The 11gR2 Client is actually the 4th file of a 7 file set for the full RDBMS. The latest version is 11.2.0.3.0 (659,229,728 bytes, released in Q4 2011 - technically called a "patch set" but it is a complete install). It is not available for public download. (Only the obsolete 11.2.0.1.0 for Linux x86-64 is available publicly).
Instant client packages use the following naming conventions: OCL.SARFor example: OCL10232.SAR (32-bit platform, Release 10.2.0.X) OCL10264.SAR (64-bit platform, Release 10.2.0.X) OCL11232.SAR (32-bit platform, Release 11.2.0.X) OCL11264.SAR (64-bit platform, Release 11.2.0.X)
SAP BR*Tools Release 7.20 are based on release 10.2 and therefore expect the Oracle Instant Client to be installed in the default path for the 10.2 instant client '/oracle/client/10x_64/instantclient'. Therefore, in order to use the 11.2 instant client with SAP BR*Tools 7.20, (temporarily) create the following additional symbolic link:OS> ln -s /oracle/client/11x_64 /oracle/client/10x_64This link is needed only until SAP BR*Tools Release 7.20_EXT are available which then will be based on 11.2 instant client. As soon as SAP BR*Tools Release 7.20_EXT are available, you can replace SAP BR*Tools 7.20 by SAP BR*Tools 7.20_EXT and remove the link again.For a more detailled description of dependencies between SAP BR*Tools and Oracle instant client versions see SAP note 1638356. 350c69d7ab