PLSQL developer installation and use, win7 can also

1. Download Software

Download PLSQL developer (online search, such as csdn, with Sn)

Download the Oracle client (10 GB from the Oracle official website, Mb is not available)

 

2. Install software

Install the Oracle client and PLSQL Developer Software respectively.

Install oracle on Windows 7 as an administrator in XP-compatible mode.

You can select the real-time client or administrator Version during installation.

 

3. Configuration

Select the administrator Version for installation. The configuration file of the Oracle client is installed in the "D:/Oracle/product/10.2.0/client_2/Network/admin" directory by default and is named "tnsnames. ora"

Select the real-time client version and create the corresponding directory ("/Network/admin ")

 

Tnsnames. ora reference format:
Orcl_192.168.250.214 =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.250.214) (Port = 1521 ))
)
(CONNECT_DATA =
(SID = orcl)
(Server = dedicated)
)
)