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

This article introduces the relevant knowledge of "what is the operation method of PLsql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

You can connect to ORACLE11g without installing oracle client PLSQL11 64-bit

Demand:

The local development environment needs to connect to the Oracle database through PLSQL, but does not want to install hundreds of megabytes of oracel clients alone.

Environment:

WIN10 Enterprise 64-bit, PLSQL11 64-bit installer and oracle instantclient-basic-windows.x64-11.2.0.4.0

Note: PLSQL and oracle instantclient must be both 32-bit or 64-bit, otherwise PLSQL will initialize the oci.dll error.

Download the file:

Oracle instantclient-basic-windows.x64-11.2.0.4.0

Please go back to OorIst in the background or download the Oracle11G package.

PLSQL software download

Please go back to PLSQL in the background or download the Oracle11G package.

(contains cracking)

Solution:

1. Download the file instantclient-basic-win64-11.2.0.1.0 provided on the official website of oracle. Baidu network disk has been provided, which can avoid the trouble of logging in oracle.

two。 Decompress configuration instantclient

After downloading, extract the file to D:\ instantclient_11_2, and create a new file tnsnames.ora in the directory. The contents of the file are as follows:

11G =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST =

192.168.6.6) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = YHT)

)

)

Please change the content of the yellow area and the oracle hostname / service name according to the installation configuration of the local oracle.

3. Set operating system environment variables

TNS_ADMIN=D:\ instantclient_11_2

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

It is recommended to restart the computer if necessary after configuring the system environment variables.

4. Configure PLSQL

Start PLSQL, click "cancel" to enter the PL/SQL main interface, click "Tools-- Preferences", and modify the Oracle main directory name and OCI library directory.

5. Log in to PLSQL (system user)

# remember to open the listener

This is the end of the content of "what is the operation method of PLsql". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.