) No installation of the Oracle client using PL/SQL to connect to Oracle

Installation-free Oracle Client usage PL/SQL Connection Oracle As we all know PL/SQL Connection Oracle To install Oracle Client software. Have you ever thought about not installing Oracle Client direct connection Oracle What about it?

ExploitationOracleProvidedInstant Client package

You only need Oracle Download Instant Client package This software does not need to be installed, as long as the decompression can be used, very convenient, even if you reinstall the system can still be used.
: Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html, Download this, Instant Client package-Basic Package. Decompress the package to any directory and create Network Folder, and then create a folder Admin Folder, and then Admin Internal setup Tnsnames. ora File, the content is as follows:
Yourdatabasename =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = yourhostip) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = yoursid)
)
)

For example:

# Tnsnames. ora network configuration file: C:/Oracle/ora90/Network/admin/tnsnames. ora

# Generated by Oracle configuration tools.

Lilo =

(Description =

(Address_list =

(Address = (Protocol = TCP) (host = 10.33.220.157) (Port = 1521 ))

)

(CONNECT_DATA =

(SERVICE_NAME = lilo)

)

)

Extproc_connection_data =

(Description =

(Address_list =

(Address = (Protocol = IPC) (Key = extproc0 ))

)

(CONNECT_DATA =

(SID = plsextproc)

(Presentation = Ro)

)

)

Here, you can configure it based on your actual situation. Then open PL/SQL , In Perference Set in OCI Library And ORACLE_HOME , My settings are OCI library = C:/oracleclient/OCI. dll, ORACLE_HOME = C:/oracleclient .
According to your actual configuration, C:/oracleclient It is actually the path of the downloaded package.

The configuration is basically complete.BatBatch Processing to solve Character Set garbled issues:

Write a batchPLSQL. batPut inPlsqldeveloperThe content in the installation directory is as follows:
Set nls_lang = simplified chinese_china.zhs16gbk
Plsqldev.exe
This character set refers to the server-side character set.
----

Permanent character set:
Set nls_lang = simplified chinese_china.zhs16cgb231280
Set nls_lang = simplified chinese_china.zhs16gbk
Set nls_lang = simplified chinese_china.utf8

Note:

instantclient-basic-win32-11.1.0.6.0.zip - Oracle 9i the above versions (excluding Oracle9i )

instantclient-basic-win32-10.2.0.1.zip - Oracle8i and Oracle9i .
do not select 64-bit. Currently, PL/SQL developer does not support 64-bit link.