Installing 21C Oracle Instant Client in Windows 11
Instant Client
Introduction
· 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.
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 Intel x86
· Same libraries as full Oracle
Database or Oracle Client
· Includes tools such as SQL*Plus,
SQL*Loader and Data Pump
· Widely used and tested
Note
: Recommended Version of Instant Client - Oracle recommends using the latest
19c Release Update of Oracle Instant Client or Oracle Database Client. This
is a Long Term Release.
Alternatively
you can use the latest 21c Release Update if you require client features
introduced in this Innovation Release.
Instant Client Packages
Reference
Links are Below
OCI - https://docs.oracle.com/en/database/oracle/oracle-database/23/lnoci/index.html
OCCI - https://docs.oracle.com/en/database/oracle/oracle-database/23/lncpp/index.html
JDBC OCI - https://www.oracle.com/pls/topic/lookup?ctx=dblatest&id=GUID-A8201BD0-BAED-4C54-B53B-C26C5F295B32
SQL*Plus - https://docs.oracle.com/en/database/oracle/oracle-database/23/sqpug/index.html#SQL*Plus%C2%AE
Datapump and
SQL*Loader - https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/index.html#Oracle%C2%AE-Database
WRC - https://www.oracle.com/pls/topic/lookup?ctx=dblatest&id=GUID-5AA30327-74FB-4406-8F7C-5D442F307534
ODBC - https://www.oracle.com/in/database/technologies/releasenote-odbc-ic.html
(odbc_install.exe, odbc_uninstall.exe)
Pro*C - https://docs.oracle.com/en/database/oracle/oracle-database/23/lnpcc/index.html#Pro*C%2FC%2B%2B
Pro*COBOL -
https://docs.oracle.com/en/database/oracle/oracle-database/23/lnpcb/index.html
Oracle Instant Client 21C Installation ( Version 21.12.0.0
)
· Navigate to the below link and download
the below Instant Client Packages.
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
Instant
Client Required Packages : Basic Package, Basic Light Package, SQL*Plus Package, Tools Package, SDK
Package, JDBC Supplement Package, ODBC Package, Precompiler Package
instantclient-basic-windows.x64-21.12.0.0.0dbru.zip - https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-basic-windows.x64-21.12.0.0.0dbru.zip
instantclient-basiclite-windows.x64-21.12.0.0.0dbru.zip - https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-basiclite-windows.x64-21.12.0.0.0dbru.zip
Note
: Login with your oracle registered account to download the packages
instantclient-sqlplus-windows.x64-21.12.0.0.0dbru.zip
- https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-sqlplus-windows.x64-21.12.0.0.0dbru.zip
instantclient-tools-windows.x64-21.12.0.0.0dbru.zip
- https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-tools-windows.x64-21.12.0.0.0dbru.zip
instantclient-sdk-windows.x64-21.12.0.0.0dbru.zip
- https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-sdk-windows.x64-21.12.0.0.0dbru.zip
instantclient-jdbc-windows.x64-21.12.0.0.0dbru.zip
- https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-jdbc-windows.x64-21.12.0.0.0dbru.zip
instantclient-odbc-windows.x64-21.12.0.0.0dbru.zip
- https://download.oracle.com/otn_software/nt/instantclient/2112000/instantclient-odbc-windows.x64-21.12.0.0.0dbru.zip
Precompiler
Download - https://www.oracle.com/database/technologies/instant-client/precompiler-downloads.html
instantclient-precomp-windows.x64-21.12.0.0.0dbru.zip - https://www.oracle.com/database/technologies/instant-client/precompiler-downloads.html#license-lightbox
· Place all the downloaded files under
one folder and extract the files as per the order.
https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html
WINDOWS.X64_213000_client_home.zip - https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html#license-lightbox
· After downloading unzip the 21c
Client libraries under the below path where the instant client files are
extracted.
Note
:This extract is mainly for Oracle Client Libraries for Windows.
· Add System Environment Variables as
per the below format.
Control
Panel àSystem
and Security à System
Click on advanced
system settings
After that
system properties window will open, Click on Environment Variables
Add the
below entries in User Variable and System
Variable, Variable name is path
User
Variable
Path - C:\Instant
Client 21C\instantclient_21_12\bin
System
Variable
ORACLE_HOME
– C:\Instant Client 21C\instantclient_21_12
ORACLE_BASE
– C:\Instant Client 21C\instantclient_21_12
TNS_ADMIN
– C:\Instant Client 21C\instantclient_21_12\network\admin
Testing Oracle Client
Installation
Note
: Please create tnsnames.ora file under ORACLE_HOME/network/admin/ and add the
TNS Entry of your database before testing
· Open CMD and Run as administrator
and check the environment variable is set properly.
C:\Windows\System32>sqlplus system@<DB_SID>
SQL> set lines 100
SQL> set pagesize 100
SQL> SELECT * FROM v$version;
Reference Links
https://www.ibm.com/docs/no/openpages/8.2.0?topic=client-environment-variables-oracle-instant
https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html
https://forum.uipath.com/t/how-to-setup-a-connection-to-oracle-database-with-uipath/106142/10
No comments:
Post a Comment