How To Install Oracle 19c Instant Client On Windows

0 views

Skip to first unread message

Paulette Dzurilla

unread,

Aug 5, 2024, 8:05:16 AM8/5/24

to pretelvilwu

Myteacher asked to install the oracle instant client with the instruction to run the setup.exe. However, I just couldn't find the setup.exe file after extract the zipped file. Here is all the files I got and another is the instruction.

Introduction

Previous Tech Notes (TNSQ0010 & TNSQ0010a) have described installation of Oracle Instant Client for Mac OSX. Allowing for operating system differences, the installation process for Windows is essentially the same:

Download Instant Client

Oracle Instant Client can be downloaded from www.oracle.com. You can use any of the Instant Client packages listed for your platform provided that they support OCI applications. We recommend Instant Client Basic or Instant Client Basic Lite. You may need to create a free Oracle account if you do not already have one.

Extract files from zip Archive

Once downloaded, create a folder on your local filesystem and open the zip archive. Drag all files from the zip archive and place them into the newly created folder:

Configure tnsnames.ora

Create (or copy) a text file named tnsnames.ora in the location specified by TNS_ADMIN. Existing users of Oracle clientware will be familiar with the formatting requirements of the tnsnames.ora file. In summary, each logon hostname that you define should be formatted as follows:

In the above example, ORA11 will be the logon hostname, and the database service name is 'orcl' (an often-used default name). The port and ip-address should point to your Oracle database server which should be configured to accept the tnsnames naming method.

Verify Connection Settings

When you open Omnis Studio, verify that the Oracle DAM has loaded by looking in the Omnis trace log. If an error indicates that the Oracle DAM could not be loaded, verify the earlier modification to the PATH environment variable is in place. (PATH needs to include the folder containing oci.dll).

I have an old 32-bit software program that connects to an Oracle database but only works with the Microsoft ODBC driver for Oracle. It does not work with the more up-to-date native Oracle ODBC driver.

For clarification, the C:\oracle\instantclient32_12_1 directory I specified contains files like oci.dll and ociw32.dll and belonged to the 32-bit Instant Client install. I guess it doesn't matter for 64-bit, since there is no Microsoft ODBC 64-bit client.

I downloaded the instant client 12.1 installed to d:\instantclient_12_1. Changed path and added TNS_ADMIN. I went to DOS prompt and entered in SQLPLUS it worked but TOAD cannot find the oracle home. Thanks in advance for any help. BTW running Windows 8

I have the same issue on a new installation of Toad 13.0.0.80 (64-bit)on a new laptop - is the Instant Client installed as part of the Toad installation.? On the old laptop I have the 64 bit Instant Client installed. My message on the new laptop is no Oracle client found - it is 64-bit Toad for Oracle version.

The cx_Oracle module loads Oracle Client libraries which communicateover Oracle Net to an existing database. Oracle Net is not a separateproduct: it is how the Oracle Client and Oracle Database communicate.

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.

Instant Client on Windows requires an appropriate Microsoft WindowsRedistributables, see Installing cx_Oracle on Windows. On Linux, the libaio(sometimes called libaio1) package is needed. Oracle Linux 8 alsoneeds the libnsl package.

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.

Locate your Oracle Database username and password, and the databaseconnection string. The connection string is commonly of the formathostname/servicename, using the hostname where the database isrunning, and using the service name of the Oracle Database instance.

cx_Oracle requires Oracle Client libraries. The libraries provide thenecessary network connectivity to access an Oracle Database instance.They also provide basic and advanced connection management and datafeatures to cx_Oracle.

cx_Oracle uses the shared library loading mechanism available on eachsupported platform to load the Oracle Client libraries at runtime. Itdoes not need to be rebuilt for different versions of the libraries.Since a single cx_Oracle binary can use different client versions andalso access multiple database versions, it is important yourapplication is tested in your intended release environments. NewerOracle clients support new features, such as the oraaccess.xml external configurationfile available with 12.1 or later clients, session pool improvements,improved high availability features, call timeouts, and other enhancements.

The cx_Oracle function clientversion() can be used todetermine which Oracle Client version is in use. The attributeConnection.version can be used to determine which Oracle Databaseversion a connection is accessing. These can then be used to adjust applicationbehavior accordingly. Attempts to use Oracle features that are not supported bya particular client/server library combination will result in runtime errors.

This will download and install a pre-compiled binary if one isavailable for yourarchitecture. If a pre-compiled binary is not available, the sourcewill be downloaded, compiled, and the resulting binary installed.Compiling cx_Oracle requires the Python.h header file. If you areusing the default python package, this file is in the python-develpackage or equivalent.

If you use optional Oracle configuration files such as tnsnames.ora,sqlnet.ora or oraaccess.xml with Instant Client, then put the filesin an accessible directory, for example in/opt/oracle/your_config_dir. Then use:

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, for version 18 and earlier, every shell runningPython will need to have the environment variableLD_LIBRARY_PATH set to the appropriate directory for theInstant Client version. For example:

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.

Using cx_Oracle requires Oracle Client libraries to be installed.These provide the necessary network connectivity allowing cx_Oracleto access an Oracle Database instance. Oracle Client versions 19, 18,12 and 11.2 are supported.

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.

If you use optional Oracle configuration files such as tnsnames.ora,sqlnet.ora or oraaccess.xml with Oracle Instant Client, then put thefiles in an accessible directory, for example in/Users/your_username/oracle/your_config_dir. Then use:

Alternatively, put the files in the network/admin subdirectory of OracleInstant Client, for example in/Users/your_username/Downloads/instantclient_19_8/network/admin. This is thedefault Oracle 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 Linux, check the LD_LIBRARY_PATH environment variable containsthe Oracle Client library directory. If you are using Oracle InstantClient, a preferred alternative is to ensure a file in the/etc/ld.so.conf.d directory contains the path to the Instant Clientdirectory, and then run ldconfig.

Locate your Oracle Database user name and password, and the databaseconnection string. The connection string iscommonly of the format hostname/servicename, using the host name wherethe database is running and the Oracle Database service name of the databaseinstance. For example, localhost/FREEPDB1.

When node-oracledb is used in the default Thin mode, it connects directly tothe Oracle Database and does not require Oracle Client libraries. Connectionsin this mode can be made to Oracle Database 12.1 or later.

Not all features are available in all versions or driver modes. Any attempt touse Oracle features that are not supported by a particular mode or clientlibrary/database combination will result in runtime errors.Thenode-oracledb attributes oracledb.thin, pool.thin andconnection.thin can be used to see what mode a connection is in. In theThick mode, the attribute oracledb.oracleClientVersion can be used todetermine which Oracle Client version is in use. The attributeconnection.oracleServerVersionString can be used to determine whichOracle Database version a connection is accessing. These attributes can beused to adjust application feature usage appropriately.