Windows 7 Oracle 10g installation and PL/SQL developer Installation

 

1. Oracle10g installation, relatively simple

1. Go to the Oracle website to download the Oracle version of Vista:Oracle Database 10GRelease 2 (10.2.0.4) for Microsoft Windows Vista x64 and Microsoft Windows Server 2008x64

2.decompress the downloaded Installation File 10204_vista_w2k8_x64_production_db.zip

3. Modify the verification file to support Windows 7

Modify/stage/prereq/DB/refhost. xml

Join<! -- Microsoft Windows 7 -->
<Operating_system>
<Version value = "6.1"/>
</Operating_system>

 

Modify/install/oraparam. ini and add 6.1, Windows = 5.0, 5.1, 5.2, 6.0, 6.1

4. If the IP address of the NIC is dynamically allocated, a warning will be reported during installation. You can ignore this issue. If you feel uncomfortable, the solution is as follows:

Add Microsoft loopback Adapter
Open Device Manager, right-click the computer name in the Device Manager window, and choose add obsolete hardware.
Install the hardware I manually selected from the list-> select "network adapter"->
Select Microsoft loopback adapter under Microsoft to complete the addition.
Change to a fixed IP address and set it at will, for example, 192.168.1.6.

5. Smooth Installation

 

Ii. PL/SQL developer Installation

1. Download and install

Http://allroundautomations.swmirror.com/plsqldev802.exe

The registration code is self-searched, and many of them have registration machines.

Note: Do not install it in the default C:/program files (x86) directory. Otherwise, an error is reported because the path with () cannot be parsed.

2. the following error is reported when PL/SQL developer is started.

 

 

The reason is that OCI. dll is 64-bit and 32-bit.ProgramPLSQL developer cannot load it. I searched for the solution on the Internet: I can install a 32-bit Oracle client to solve the problem. I generally cannot use the client function. I don't want to install it when it is too big. Later I referred to this articleArticleFree of installation of Oracle client software-use PL/SQL configuration to log on.

3. DownloadOracle client packageHttp://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

Download instantclient-basic-win32-10.2.0.4.zip.

4. decompress the package to C:/oracle_client. The OCI directory is C:/oracle_client/instantclient_10_2.

5. Start PL/SQL developer and click Cancel. Do not log on. Configure ORACLE_HOME and OCI library in connection under tools/perferences, as shown below:

 

 

Oraclehome: oradb10g_home1

OCI Library: C:/oracle_client/instantclient_10_2/OCI. dll

6. Set system environment variables

Tns_admin = C:/Oracle/product/10.2.0/db_1/Network/admin

Nls_lang = american_america.zhs16gbk

Note: The first half of nls_lang must be american_america, Because instant client does not support other languages. The latter half can be adjusted based on the character set of your database. If the database uses al32utf8, you can set al32utf8.

7. Start PL/SQL developer. OK is okay.