PL/SQL configuration

1. Download Instant Client

Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

Choose a different instant client version based on your operating system

Download back is a compressed file, extracted after the folder called: D:/instantclient_11_2. Put it in the directory you like. For example: d:/instantclient_11_2

2. Add Monitoring

Create a new directory network under the D:/instantclient_11_2 directory, create a new admin directory under the network directory, create a new file Tnsnames.ora in the Admin directory, and use a text editor to open and write the following:

mwdb =
(DESCRIPTION =
??? (Address_list =
????? (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521))
??? )
??? (Connect_data =
????? (service_name =mwdb)
??? )
)

First Yellow block: Indicates the local hostname that defines the remote server

Second yellow block: Remote DB instance Name

3. Add Environment variables

Add the environment variable named Tns_admin, which has a value of Tnsnames.ora file path. For example, my machine is: d:/instantclient_11_2/network/admin

Add an environment variable oracle_home with a value of d:/instantclient_11_2

?

4. Download and install the PL.SQL.Developer configuration app
Configure Tools->preferences->connection

Oracle Home
D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci.dll

The PL/SQL developer in Chinese is

Tools--Preferences--Connect

Oracle Home Directory

D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci.dll

5, close PL/SQL Developer, restart Developer.

The hostname will appear in the PL/SQL developer list, enter the user name password, and you will be able to log in to the remote Oracle 11g database.

?

Supplemental Instant Client Instructions

Oracle? Instant?client? is a simple client provided by Oracle, supporting multiple platforms.? Available for download from the Oracle Web site.
Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

Include the following:

Instant?client? Package?-? Basic? Run OCI,? OCCI,? and Jdbc-oci all the files that the application needs.?

Instant?client? Package?-? Basic? Lite: Contains only English error messages, only UNICODE,?ASCII,? Western European character set.?

Instant?client? Package?-? Jdbc? Supplement?? Increased XA, internationalization, and rowset operations for JDBC.

Instant? Client? Package?-? Sql?*plus? contains Sqlplus and required library files

Instant?client? Package?-? SDK? using instant? Client development Oracle? The header file and example makefile the application requires

Instant?client?package?-? ODBC? What libraries are required to use ODBC? Not all platforms have.? Linux platform contains.?

Basic and Basic? Lite Two must choose one,? Other packages are optional.? Did I download it? Basic,? Jdbc?supplement, huh? Sql?*plus, huh? Sdk? Odbc.? After decompression and placed in a folder,? In this folder to create a file Tnsnames.ora,? Set environment variables Ld_library_path and tns_admin point to the extracted directory, you can use Sqlplus.

PL/SQL configuration