Главная » Linux

Installing instant client oracle windows

Содержание
  1. Installing instant client oracle windows
  2. Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit
  3. Version 19.10.0.0.0
  4. Download
  5. Description
  6. Download
  7. Description
  8. Download
  9. Description
  10. Version 18.5.0.0.0
  11. Download
  12. Description
  13. Instant Client Installation for Microsoft Windows 64-bit
  14. Installing instant client oracle windows
  15. Free, light-weight, and easily installed Oracle Database tools, libraries and SDKs
  16. Oracle Instant Client
  17. What’s New
  18. Oracle Linux has Instant Client RPMs
  19. Instant Client is available for Docker
  20. Instant Client Features
  21. Instant Client applications are cloud ready
  22. Installing instant client oracle windows
  23. Oracle Instant Client ODBC Installation Notes
  24. Installing Oracle Instant Client Basic and Basic Lite
  25. Installing Oracle Instant Client ODBC
  26. On Windows
  27. Environment setup for ODBC applications
  28. Contents of the Oracle Instant Client ODBC Package
  29. Patching Oracle Instant Client ODBC
  30. Uninstalling Oracle ODBC Instant Client
  31. Recommended unixODBC Driver Manager versions for Linux/UNIX

Installing instant client oracle windows

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.

Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit

See the Instant Client Home Page for more information about Instant Client.

The installation instructions are at the foot of the page.

Oracle Client-to-Oracle Database version interoperability is detailed in Doc ID 207303.1. For example, applications using Oracle Call Interface 19 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.

Version 19.10.0.0.0

Base — one of these packages is required

Download

Description

All files required to run OCI, OCCI, and JDBC:OCI applications

(82,565,845 bytes) (cksum — 2615031909)

Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support

(42,294,233 bytes) (cksum — 3532277538)

Tools — optional packages

Download

Description

The SQL*Plus command line tool for SQL and PL/SQL queries

(973,448 bytes) (cksum — 2154713824)

Includes Data Pump, SQL*Loader and Workload Replay Client

(1,206,710 bytes) (cksum — 4031943553)

Development and Runtime — optional packages

Download

Description

Additional header files and an example makefile for developing Oracle applications with Instant Client

(1,859,518 bytes) (cksum — 3684376259)

Additional support for Internationalization under JDBC

(1,586,269 bytes) (cksum — 445389429)

Additional libraries for enabling ODBC applications

(862,815 bytes) (cksum — 263003309)

Precompiler Package Precompiler Downloads Additional files for Pro*C and Pro*COBOL

Version 18.5.0.0.0

Base — one of these packages is required

Download

Description

All files required to run OCI, OCCI, and JDBC:OCI applications

(77,769,261 bytes) (cksum — 1317689833)

Instant Client Installation for Microsoft Windows 64-bit

See the Instant Client Home Page for more information about Instant Client packages.

Client-server version interoperability is detailed in Doc ID 207303.1. For example, Oracle Call Interface 19, 18 and 12.2 can connect to Oracle Database 11.2 or later. Some tools may have other restrictions.

  1. Download the appropriate Instant Client packages for your platform. All installations require the Basic or Basic Light package.
  2. Unzip the packages into a single directory such as C:\oracle\instantclient_19_3
  3. Add this directory to the PATH environment variable. If you have multiple versions of Oracle libraries installed, make sure the new directory occurs first in the path. Restart any terminal windows or otherwise make sure the new PATH is used by your applications.
  4. Download and install the correct Visual Studio Redistributable from Microsoft. Instant Client 19 requires the Visual Studio 2017 redistributable. Instant Client 18 and 12.2 require the Visual Studio 2013 redistributable. Instant Client 12.1 requires the Visual Studio 2010 redistributable.
  5. If you intend to co-locate optional Oracle configuration files such as tnsnames.ora, sqlnet.ora, ldap.ora, or oraaccess.xml with Instant Client, then create a subdirectory such as C:\oracle\instantclient_19_3\network\admin

This is the default Oracle client configuration directory for applications linked with this Instant Client.

Alternatively, Oracle client configuration files can be put in another, accessible directory. Then set the environment variable TNS_ADMIN to that directory name.

Installing instant client oracle windows

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.

Free, light-weight, and easily installed Oracle Database tools, libraries and SDKs

Oracle Instant Client enables development and deployment of applications that connect to Oracle Database, either on-premise or in the Cloud. The Instant Client libraries provide the necessary network connectivity and advanced data features to make full use of Oracle Database. The libraries are used by the Oracle APIs of popular languages and environments including Python, Node.js, Go, PHP and Ruby, as well as providing access for Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), JDBC-OCI, ODBC and Pro*C applications. Tools included in Instant Client, such as SQL*Plus, SQL*Loader and Oracle Data Pump, provide quick and convenient data access.

Oracle Instant Client

What’s New

Oracle Linux has Instant Client RPMs

Instant Client RPM packages for Oracle Linux can now be installed from yum.oracle.com for Oracle Linux 8 and Oracle Linux 7. Older releases are available for Oracle Linux 8, Oracle Linux 7 and Oracle Linux 6.

Instant Client is available for Docker

Dockerfiles are available on GitHub.

Instant Client Features

  • Free to download, deploy and distribute
  • Small footprint
  • ZIPs available for quick, one-step install
  • RPM Packages also available for Linux, and DMG Packages for macOS
  • Same libraries as full Oracle Database or Oracle Client
  • Includes tools such as SQL*Plus, SQL*Loader and Data Pump
  • Widely used and tested

Instant Client applications are cloud ready

Deploy applications using Instant Client in the cloud, or connect to a cloud database.

Whether your applications are in the cloud or on-premise, you can install Instant Client and connect to cloud databases. Follow the normal installation process for your operating system. Some cloud-specific references are shown below.

Installing instant client oracle windows

По Вашему запросу ничего не найдено.

Рекомендуем сделать следующее:

  • Проверьте правильность написания ключевых слов.
  • Используйте синонимы введенных Вами ключевых слов, например “приложение” вместо “программное обеспечение”.
  • Попробуйте воспользоваться одним из популярных поисковых запросов ниже.
  • Начните новый поиск.
Актуальные вопросы

Oracle Instant Client ODBC Installation Notes

Oracle’s Instant Client ODBC software is a standalone package that offers the full functionality of the Oracle ODBC driver (except the Oracle service for Microsoft Transaction Server) with a simple install.

The ODBC driver has Oracle’s standard client-server version interoperability, see Support Doc ID 207303.1. For example Instant Client ODBC 19c can connect to Oracle Database 11.2 or later.

Installing Oracle Instant Client Basic and Basic Lite

Instant Client ODBC requires the Oracle Instant Client Basic or Basic Light package (depending on your locale requirements) also be installed. Download the desired package from OTN for your operating system and follow the installation instructions on the download page. For example, unzip the package to C:\instantclient_19_3 on Windows, unzip to /opt/oracle/instantclient_19_3 on Linux or other platforms, or use yum to install the RPM packages on Linux.

More details on Oracle Instant Client is in the Oracle Call Interface Programmer’s Guide.

Installing Oracle Instant Client ODBC

On Linux and UNIX

1. Download Install the Instant Client Basic or Basic Light package as described above.

2. Download the Instant Client ODBC package. Unzip it in the same directory as your Basic or Basic Light package. Or, if using the RPM package on Linux, install it with yum .

3. Install the unixODBC driver manager if it is not already available. Refer to the «Recommended unixODBC Driver Manager version» section in this document for more information.

4. Execute odbc_update_ini.sh from the Instant Client directory.

5. Set any Oracle Globalization variables required for your locale. See the Oracle Database Globalization Support Guide for more information. For example on Linux you could set export NLS_LANG=JAPANESE_JAPAN.JA16EUC to work in the JA16EUC character in Japanese.

Parameter Description
ODBCDM_Home unixODBC driver manager home directory path
Install_Location* Oracle Instant Client directory path. The default path is the current directory
Driver_Name* Driver name to identify the Oracle ODBC driver residing in current Oracle Instant Client home. The default name will be like «Oracle 19c ODBC driver»
DSN* Sets ODBC DSN name. The default name will be «OracleODBC-19c»
ODBCINI* Directory path of the .odbc.ini file. The default path is the user’s home directory, for example

* — Optional parameters

On Windows

  1. Install the Instant Client Basic or Basic Light package, as described above.
  2. Download the Instant Client ODBC package. Unzip it in the same directory as your Basic or Basic Light package.
  3. Execute odbc_install.exe from the Instant Client directory. If Instant Client is 11g or lower, start the command prompt with the Administrator privilege. To install with Japanese language support, execute the command odbc_install.exe JA .

Environment setup for ODBC applications

An ODBC application has to load the Oracle Instant Client ODBC driver’s shared library file (see next section) to connect to Oracle Database. On Linux/Unix the directory path of the shared library should be set in the environment variable LD_LIBRARY_PATH, or platform equivalent. It can also be configured in /etc/ld.so.conf. On Windows it should be set in the PATH environment variable.

Refer to the topics Environment Variables for OCI Instant Client and Database Connection Strings in the Oracle Call Interface Programmer’s Guide for setting up the Database Connection string and related environment variables like TNS_ADMIN, TWO_TASK, LOCAL etc.

Contents of the Oracle Instant Client ODBC Package

Description Linux and UNIX Windows
Oracle ODBC driver shared library libsqora.so.XX.Y. For example libsqora.so.19.1 sqora32.dll
Installation file odbc_update_ini.sh odbc_install.exe, odbc_uninstall.exe
Oracle ODBC driver configuration dialog window (GUI) Not available sqoras32.dll, sqresus.dll, sqresja.dll
Help System help/ help/

Patching Oracle Instant Client ODBC

Note: Backup the Oracle ODBC driver shared library and other files before patching them.

On Linux and UNIX Patching the Instant Client ODBC driver on Linux/UNIX can be done by generating the Instant Client ODBC package and Basic or Basic Light package in a patched ORACLE_HOME. The procedure for patching and generating Instant Client ODBC, Basic and Basic Light packages is given in the Oracle Call Interface Programmer’s Guide. These new packages should then be unzipped into the Instant Client directory that needs to be patched. This method of patching is recommended.

Alternatively the Oracle Instant Client ODBC driver can be patched by copying the files that are listed below from a patched ORACLE_HOME:

  • ODBC driver shared library file:
    For 19c: libsqora.so.19.1
    For 18c: libsqora.so.18.1
    For 12c: libsqora.so.12.1
    For 11g: libsqora.so.11.1
  • Required additional files when using Oracle Instant Client Basic:
    For 19c: libociei.so, libclntshcore.so.19.1, libclntsh.so.19.1, libnnz19.so, libons.so
    For 18c: libociei.so, libclntshcore.so.18.1, libclntsh.so.18.1, libnnz18.so, libons.so
    For 12c: libociei.so, libclntshcore.so.12.1, libclntsh.so.12.1, libnnz12.so, libons.so
    For 11g: libclntsh.so.11.1, libociei.so, libnnz11.so
  • Required additional files when using Oracle Instant Client Basic Light:
    For 19c: libclntsh.so.19.1, libclntshcore.so.19.1, libociicus.so, libnnz19.so, libons.so
    For 18c: libclntsh.so.18.1, libclntshcore.so.18.1, libociicus.so, libnnz18.so, libons.so
    For 12c: libclntsh.so.12.1, libclntshcore.so.12.1, libociicus.so, libnnz12.so, libons.so
    For 11g: libclntsh.so.11.1, libociicus.so, libnnz11.so

On Windows Patching the Instant Client ODBC driver on Windows can be done only by manually copying the ODBC driver shared library files and supporting library files from a patched ORACLE_HOME or from an unpacked Oracle Database Bundle patch. These should be copied into the Instant Client directory. Generating an Instant Client ODBC package is not available on Windows.

The files that must be copied to the Instant Client directory:

  • ODBC driver shared library files: sqora32.dll, sqoras32.dll, sqresus.dll, sqresja.dll
  • Required additional files when using Oracle Basic Instant Client:
    For 19c: oraociei19.dll, orannzsbb19.dll, oci.dll, oraons.dll, ociw32.dll, oraociei19.sym, orannzsbb19.sym, oci.sym, ociw32.sym
    For 18c: oraociei18.dll, orannzsbb18.dll, oci.dll, oraons.dll, ociw32.dll, oraociei18.sym, orannzsbb18.sym, oci.sym, ociw32.sym
    For 12c: oraociei12.dll, orannzsbb12.dll, oci.dll, oraons.dll, ociw32.dll, oraociei12.sym, orannzsbb12.sym, oci.sym, ociw32.sym
    For 11g: oraociei11.dll, orannzsbb11.dll, oci.dll, ociw32.dll, oraociei11.sym, orannzsbb11.sym, oci.sym, ociw32.sym
  • Required additional files when using Oracle Basic Light Instant Client:
    For 19c: oraociicus19.dll, orannzsbb19.dll, oci.dll, oraons.dll, ociw32.dll, oraociicus19.sym, orannzsbb19.sym, oci.sym, ociw32.sym
    For 18c: oraociicus18.dll, orannzsbb18.dll, oci.dll, oraons.dll, ociw32.dll, oraociicus18.sym, orannzsbb18.sym, oci.sym, ociw32.sym
    For 12c: oraociicus12.dll, orannzsbb12.dll, oci.dll, oraons.dll, ociw32.dll, oraociicus12.sym, orannzsbb12.sym, oci.sym, ociw32.sym
    For 11g: oraociicus11.dll, orannzsbb11.dll, oci.dll, ociw32.dll, oraociicus11.sym, orannzsbb11.sym, oci.sym, ociw32.sym

Note: While copying from the Oracle Database Bundle patch, some of the files above may be missing. This implies that those files are unchanged and do not need to be patched.

Uninstalling Oracle ODBC Instant Client

On Linux and UNIX

The procedure to uninstall Instant Client ODBC on Linux/UNIX is:

  1. Remove the Oracle ODBC driver entry from the odbcinst.ini file of the unixODBC driver manager. The default name of this entry is like [Oracle 19c ODBC driver].
  2. Remove the DSN entry of the Oracle ODBC driver from odbc.ini . The default name of the DSN entry is like [OracleODBC-19c] .
  3. Delete all files and directories in the Instant Client ODBC directory.

On Windows

The procedure to uninstall Instant Client ODBC on Windows is:

  1. Remove the DSN associated with the Oracle ODBC driver in the ODBC Data Source Administrator (odbcad32) console.
  2. Execute odbc_uninstall.exe from the Instant Client ODBC directory.
  3. Delete all files and directories in the Instant Client ODBC directory.

For Instant Client 18 and 19:

Platform unixODBC Driver Manager Version
Linux 32bit, 64bit 2.3.4
Solaris SPARC64 32bit, 64bit 2.3.4
Solaris 32bit, 64bit 2.3.4
AIX 5L 32bit, 64bit 2.3.4
HP IA64 32bit, 64bit 2.3.4
z/Linux 31bit, 64bit 2.3.4

For Instant Client 12.1 and 12.2:

Читайте также:  Лицензионный диск windows 10 64 bit
Оцените статью
© 2024 Советы по настройке компьютера