Table Of Content
I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine. I had her send me her tnsnames.ora from her PC. The entry I wanted was as follows (some letters replaced with xxx for security reasons): xxxora2prod2 = (DESCRIPTION=. Oracle 7.0 - June 1992 Database Integrity Constraints ( primary keys, foreign keys, check constraints, default values) Stored procedures and functions, procedure packages. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
1- What is Oracle Client?
If you have 2 computers A and B. Computer B is installed Oracle Database. Standing at computer A, if you want to work withthe Oracle database at Computer B, Computer A needs to be installed Oracle Client.
These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. I have an old 32-bit software program that connects to an Oracle database but only works with the Microsoft ODBC driver for Oracle. The Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3(or greater.
Oracle Client is part of Oracle Database software. It is not a database, but, it helps talk with an Oracle database.
2- Download Oracle Client
The latest version of Oracle Client is 12.x, which can work with any different versions of Oracle Database (10, 11, 12), therefore, you should download this version.
To download the Oracle Client, visit the following address
Here, you have two choices for downloading such as Oracle Client 32bit or Oracle Client 64bit. If you want to work with the visual tools such as PL/SQL Developer, Toad, .. you should download and install 32bit version.
Oracle Client Download 12.2
Here, I will download the 32bit version. Downloading requires you to log in with an account. If you do not have an account, you can register for free.
Downloaded results:
3- Installing Oracle Client
Extract the file downloaded in the above step by you.
You have 4 options to install:
This installation type installs only the shared libraries required by Oracle Call Interface applications that use the Instant Client feature. It requires much less disk space than the other Oracle Client installation types.
Note: If you select Instant Client install type, then you cannot apply software updates during the installation session. To download and apply the latest software updates, you must select Administrator, Runtime, or Custom install type.
This installation type installs the Oracle Enterprise Manager Standalone Console, Oracle networking services, and client software that enables applications or individuals to connect to an Oracle database. It also installs development tools that you can use to develop applications.
This installation type installs a limited number of components for a database application user. With the exception of Oracle Enterprise Manager Standalone Console, it installs the same components as the Administrator installation type.
This installation type allows you to select the client applications and utilities that you want to install.
- Oracle base: C:/oracleclient_12
OK, Oracle Client has been installed successfully.
4- Configuring TNSNAME
Trước hết, hãy kiểm tra để đảm bảo Server hoạt động tốt.
To be able to connect to a database located in another computer, you need to configure TNSNAME. Create a file named tnsnames.ora located in the folder:
Oracle 7.3.3
- C:oracleclient_12product12.2.0client_1networkadmin
