Win7_32 bit plsql connect to remote database (no Oracle installed locally)

1. Tools: Download Oracle Client Address:

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

Select the corresponding version,

Http://www.oracle.com/technetwork/topics/winsoft-085727.html find the corresponding version, download.

Download Plsql Developer: Just a search, you can download it.

2. After installing Plsql Developer, open the Plsql, as

The configuration method is as follows:

Click Cancel to enter the Plsql:

Write the extracted path to the Oracle client file that was downloaded in the first step in Orcale Home (preferably not in Chinese)

Create a new two folder and a file in the directory as follows: (Network ADMIN Tnsnames.ora)

The configuration in Plsql is as follows:

Click OK or Apply

Restart Plsql will appear the following interface;

Enter the relevant information, login if successful, if unsuccessful, add the following in the Tnsnames.ora file:

ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

Red font for user-defined, believe you should know what it means,

Then save, then reopen Plsql, and then no more. The database should already be connected.

Win7_32 bit plsql connect to remote database (no Oracle installed locally)