Use oracle on Windows 7

Reading the title of this article seems very common. You may ask: is there a problem with Oracle on Windows 7? The answer is: yes. After a while, I finally finished it today and shared it with everyone.

 

Windows 7 is used now. Since ORACLE data is checked sometimes, PL/SQL developer is installed. Because this tool requires support from the Oracle client, I have installed the Oracle 10.2 client on hand. When configuring the connection test, the system always prompts that the descriptor cannot be identified. I checked a lot of data on the Internet, such as modifying the configuration file in the installation program before the installation, changing the compatibility of setup.exe, using the Administrator for installation, and so on. Today is Friday, just clean and work overtime.

 

On the official Oracle website, I saw that 10.2 does not support Windows 7, but also 11.2, supports Windows 7, so download a 11.2, but once again, the installation program is 2g, too large. I only need a client. I have heard that the Instant Client is relatively small (49 m) and can support OCI calls by PL/SQL developer. Download Instant Client 11.2. Due to intranet restrictions, you cannot download it. Therefore, you can log on to the Internet through the Remote Desktop, download it, upload it through the QQ transfer station, and then download it from the transfer station through the Intranet.

 

A compressed package, decompress it and check it. There is no instruction document, so you can find instructions from the Internet. Baidu cannot find the package. Google has found the package and configured the package according to the instructions. The steps are as follows:

1. Download Oracle Database Instant Client 11.2 from the official Oracle website (you need an oralce account and register one if you do not have one );

2. decompress the compressed package to the local directory, for example, D:/oracle.

3. Add the installation directory (D:/Oracle) to the Windows system variable path;

4. added the winows user variable nls_lan = American. Americ. utf8 (which is usually the same as your database)

5. added the Windows system variable tns_admin = D:/Oracle (installation directory)

6. Create a file named tnsnames. ora in the installation directory. The content is as follows:

S5 =

(Description =

(Address = (Protocol = TCP) (host = 192.168.1.5) (Port = 1521 ))

(CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = orcl ))

)

 

(All the above content are hand-written to achieve the silent write effect.) The following describes the variables to be modified:

S5: Local Service name

192.168.1.5: IP address of the Database Server

1521: database server port

Orcl: Global Database Name

 

Open PLSQL developer, click Cancel on the login page, click the menu tool-preference, enter the installation path D:/oracle in the "OCI Database" option, restart PLSQL developer, and select the service name, enter the user name and password. login successful!