Shulou(Shulou.com)06/01 Report--

Oracle 11g Lite client configuration

ORACLE is generally deployed on the server, and on the client side, you need to use connection tools such as PL/SQL Developer to connect to the ORACLE on the server.

At this time, it is often necessary to install a hundred megabytes of ORACLE on the client and then configure the PL/SQL Developer support through the ORACLE network configuration wizard.

And if we just need to link oracle to perform general add, delete, modify and search operations, we do not need to install a complete oracle client at all, but just install a tool provided by ORACLE instantclient-basic (compression package 33m), we can use PL/SQL Developer to connect to the ORACLE on the server to operate.

Installation steps: 1. Download the installation tool first

You can go to my network disk to share the link to download: Baidu network disk password: enxt

You can also download it from oracle's official website:

Oracle thin client: instant-client

You can download the corresponding version of your system.

two。 Installation 1) extract the Oracle 32-bit thin client to D:\ Oracle\, folder name instantclient_11_22) configure environment variable # add TNS_ADMIN and corresponding path TNS_ADMIND:\ Oracle\ instantclient_11_2# add oracle directory ORACLE_HOMED:\ Oracle\ instantclient_11_2# add oracle character set NLS_LANGSIMPLIFIED CHINESE_CHINA.ZHS16GBK# add Path%ORACLE_HOME%\ bin at the beginning of the Path variable 3) create a tnsnames.ora file under D:\ Oracle\ instantclient_11_2 and fill in the configuration file # tnsnames.ora Network Configuration File: / oracle/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.# below is a sample link Add DB10 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.10) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = ecom)) 4) unpack the PLSQL_Developer8.0 file to D:\ Oracle\ according to your actual situation, and open the pl/sql software to make the following configuration

Open the software-tools-preferences-connect-check connection check box and type √

Configure D:\ Oracle\ instantclient_11_ 2OCI library configuration D:\ Oracle\ instantclient_11_2\ oci.dll5) under the Oracle home directory and reopen the software.

This is the end of the article. Thanks for watching.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.