1,: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html
2, Decompression: for example: d:/instantclient_11_2
3. Create a new network under the D:/instantclient_11_2 directory, create a new admin directory under the network directory, create a new Tnsnames.ora in the Admin directory, and then edit the following:
remoteoracle=
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
4. Add an environment variable named Tns_admin and the value is the path where the Tnsnames.ora file is located. For example, my machine is: d:/instantclient_11_2/network/admin
5. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbk
If you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.
SELECT * from Nls_instance_parameters;
View the value of Nls_language
Nls_language
Nls_territory
6. 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
7, restart the PL/SQL Developer, the hostname will appear in the PL/SQL Developer list, enter the user name password, you can log in to the remote Oracle 11g database.
Note: PL/SQL Developer 10.0.5.1710 + instantclient-basic-nt-12.1.0.1.0 win7 under configuration success!
