Do not install Oracle client, connect Oracle with Plsql

Common Oracle-developed tools are SQL Developer and PL-Developer, which personally feel that the former is better than the latter, but larger (more than 300M) occupies resources, and the user experience is generally, while the latter is relatively small (less than 30M), The use of it is also quite handy.

Using PL/SQL to connect the Oracle database, whether local or remote, generally need to install Oracle client (around 500M) is relatively large, and installed on each system is also a bit fastidious, need to modify the corresponding configuration file, a bit troublesome.

How do I achieve the ability to not install Oracle clients and use PL/SQL tools? I have done the following tests and achieved the purpose.

Test environment: Win7 system, not installed Oracle includes client, native virtual machine Linux is equipped with Oracle, and there is an available ORCL instance;

1. Oracle website provides instantclient, download Instantclient-basic package, unpack the package to local, this test is

D:\STUDY\instantclient_10_2;

2. Create a new Sqlnet.ora and Tnsnames.ora two files in this directory

Sqlnet.ora File Contents

---------------------

Sqlnet. Authentication_services= (NTS)

NAMES. Directory_path= (TNSNames, Ezconnect)

Tnsnames.ora File Contents

-------------------------

ORCL =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.146.143 ) (PORT = 1521))

)

(Connect_data =

(service_name = orcl )

)

)

Note: The italic section needs to be configured on demand and should be changed if the port is customized.

3. Configure Environment variables

Variable Name variable value

Tns_admin D:\STUDY\instantclient_10_2

Note: Here the value of the variable is instantclient in the local home directory, if the variable is not configured,

The connection will be error Ora-12154:tns:could not resolve the connect identifier specified.

4. Install the PL/SQL Developer and configure the connection parameters for Oracle:

Open Pl/sql,tools-->preferences, configure connection's Oracle home and OCI library as shown in

5. Restart PL/SQL, login test, ok!

If there is a garbled problem, please click: http://gang-chen.iteye.com/blog/2005546

Also attached:

PL/SQL developer:http://www.allroundautomations.com/bodyplsqldevreg.html

instantclient-basic-win32:http://pan.baidu.com/share/link?shareid=514153&uk=3255414737

You can also go to Oracle official website to download instantclient other versions, but not very stable, and sometimes download failed.

Resources:

Http://wenku.baidu.com/link?url= Hdnssee21lybvzoe7ih2-buaw-2hm7pokqu23i6lkzad-i3nepjprctztlyo1egvm4nfcvdra7dqq9fwwtvl2yjp06b4aqzvim9tjmko9lw

Quote Original: https://www.cnblogs.com/zhwl/p/3727565.html

Blog is to remember that they are easy to forget things, but also a summary of their work, the article can be reproduced, without copyright. Hope to do their own efforts to do better, we work together to improve!

If there is any problem, welcome to discuss together, code if there is a problem, you are welcome to the great God!

Do not install Oracle client, connect Oracle with Plsql