PL/SQL DEVELOPER11 configuration Client

supplied PL/SQL Developer11 Chinese version

1, first to the Oracle website download Instant Client:

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Choose a different instant client version based on your operating system

The download will be a compressed file, after extracting the folder called: Instantclient_12_1. Put it in your favorite directory. For example: E:\Program files\plsql developer\instantclient_12_1

2, in the E:\Program files\plsql developer\instantclient_12_1 directory under the new directory network, in the network directory under the new admin directory, Create a new file Tnsnames.ora in the admin directory,

Use a text editor to open the write to the following:

Connection Name =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.132 ) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL )
)
)

First Yellow block: Indicates the local hostname (optional input) that defines the remote server

Second yellow block: The IP address of the remote database

Third yellow child block: Remote db Instance Name

Right-click My Computer select Properties, advanced, environment variables, system variables

Add the following two variables

Tns_admin E:\Program Files\plsql Developer\instantclient_12_1\network\admin

Nls_lang simplified Chinese_china. Zhs16gbk

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

Oracle Home
E:\Program Files\plsqldeveloper\instantclient_12_1

OCI Library

E:\Program Files\plsql Developer\instantclient_12_1\oci.dll

The PL/SQL developer in Chinese is

Tools--Preferences--Connect

Oracle Home Directory

E:\Program Files\plsql Developer\instantclient_12_1

OCI Library

E:\Program Files\plsql Developer\instantclient_12_1\oci.dll

6, close Pl/sqldeveloper, 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.

1 network connection IPV4 set static IP
IP Address: 192.168.1.111 (111 can be modified to their own 1-255)
Subnet Mask: 255.255.255.0
Default Thunder: 192.168.1.1
Preferred DNS server: 192.168.1.1
After the modification remember the main win7 ping 192.168.1.111 ping to continue back.

2. Modify: \app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora
Sid_name = Clrextproc changed to Sid_name = ORCL ORCL is the instance name
HOST = localhost changed to host= 192.168.1.111

3. Modify: \app\admin\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
Two host = localhost changed to host = 192.168.1.111
SID = Clrextproc changed to sid= ORCL

OK, restart Oracle, listen, the plsql on the main Win7 can connect to the database on the virtual machine remotely.

PL/SQL DEVELOPER11 configuration Client