Win7_32-bit PLSQL connects to the remote database (Oracle is not installed locally), win7_32plsql

Win7_32-bit PLSQL connects to the remote database (Oracle is not installed locally), win7_32plsql

1. Tool: Download Oracle Client address:

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

Select the corresponding version,

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

Download PLSQL Developer: search for it and you can download it.

2. After PLSQL Developer is installed, open PLSQL, as shown in figure

The configuration method is as follows:

Click Cancel to enter PLSQL. The following operations are performed:

Write the decompression path of the oracle client file downloaded in step 1 in Orcale Home (it is best not to have Chinese characters)

Create two folders and one file in the directory and make them into the following directory: (network ADMIN tnsnames. ora)

Configure PLSQL as follows:

Click OK or Apply

After PLSQL is restarted, the following interface is displayed;

Enter the relevant information. If the logon succeeds, OK. If the logon fails, add the following to the tnsnames. ora file:

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

The red font is user-defined. I believe you should know what it means,

Save and re-open PLSQL. Then there is no more. It should have been connected to the database.