Tuesday, November 28, 2023

Oracle Instant Client 21c Installation in windows 11 64 Bit

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/en/openpages/8.2.0?topic=client-installing-oracle-instant-windows#taskwp1688_ora_inst_sw_windows__postreq__1

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

Python Basic to Advanced Learnings ( Day 3 )

Algorithm in python Definition An algorithm is a list of steps or statements that can be converted into code and executed by a computer....

Popular Posts