Win7 Ultimate (64-bit) installation method of oracle11g in the environment

My environment:

Operating system: Windows7 flagship Edition (64-bit)

Database: 64-bit oracle11g (WIN64_11GR2)

Pl/sql:pl/sql Developer v9.0.1

Preparatory work:

1. Download oracle11g (Microsoft Windows (x64))

Download path: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Download the Win64_11gr2_database_1of2.zip and win64_11gr2_database_2of2.zip two compressed files here.

2. Download PL/SQL

Download path: Http://download.allroundautomations.com/plsqldev901.exe

Registration machine Download Path: http://download.csdn.net/detail/xu395422824/4165867

Installation steps (from the network):

1, into the database decompression directory, double-click on the "setup.exe" file, wait a moment to appear as follows the "Configure Security Update" interface, cancel "I want to accept security updates through my Oracle support", click "Next" in the subsequent "No e-mail" The warning dialog box is in the midpoint "yes".

2. In the Select Installation Options window, select Create and configure database, and click Next.

3. In the System Classes window, select Desktop class and click Next.

4, in the "Typical installation Configuration" window, select the base directory to install Oracle, the database version Select "Enterprise Edition", the character set select "Default Value" and enter a unified password (the password at Oracle has its own recommendations), click "Next."

5. In the "Perform Prerequisite check" window (skipped when I installed it, it may be because the check all succeeds directly into the next step), click Next.

6. In the Overview window, click Finish to install (the Oracle installation is slow).

7. Installation process:

8, after the installation of the program will be created database (also need some time):

9, after the creation of the database, the following will appear "Database Configuration Assistant" interface, click "Password Management" can lock and unlock users and set the user password, after the modification is complete, click "OK". When the installation is complete, click "Close" to exit the Setup program.

installation of PL/SQL developer

Install the previously downloaded Plsqldev901.exe to the computer, double-click Run, and you will find that there are no DB instances in the login window.

Cause: The previously installed Oracle is 64-bit, and of course its oci.dll is also 64-bit, so 32-bit application PL/SQL developer cannot be loaded.

Workaround: You can install a 32-bit Oracle Client

Download path: http://www.oracle.com/technetwork/topics/winsoft-085727.html

There are a variety of client downloads, select 32-bit clients that match oracle11g, such as Instantclient-basic-win32-11.2.0.1.0.zip.

Installation steps:

1. Extract the previous downloaded 32 bits to a directory, such as D:\oracle\product\instantclient_11_2;

2. Copy the Tnsnames.ora (located in%oracle_home%\network\admin) from the Oracle installation directory to this directory.

3. Enter PL/SQL (no login is allowed), select Tools "Preferences". menu, set Oracle_home and OCI library to the first step to install the 32-bit client directory as shown in:

4. After completing the above steps, you need to set PL/SQL startup, here are two ways:

Method One

Create a new BAT file under the Plsql Developer directory with the following content:

@echo off

Set Path=d:\oracle\product\instantclient_11_2

Set Oracle_home=d:\oracle\product\instantclient_11_2

Set Tns_admin=d:\oracle\product\instantclient_11_2

Set Nls_lang=american_america. Zhs16gbk

Start Plsqldev.exe

Note the first half of the 1:nls_lang must be American_america, because instant client does not support other languages, the second half can be adjusted according to the character set of your database, and Al32utf8 can be set if the database uses Al32utf8.

Note 2: The path varies with the installation client, which is the decompression directory in step 1th.

Use the bat file instead of the PL/SQL shortcut to start Plsql Developer.

Method Two

Add an environment variable for WINDOWS7 (if you already have a corresponding environment variable add value):

1, the environment variable Nsl_lang, the value is American_america. ZHS16GBK (online is used simplified Chinese_china. ZHS16GBK, I tried a bit, will appear in Chinese garbled situation);

2, the environment variable tns_admin, the value is D:\oracle\product\instantclient_11_2;

Start PL/SQL.

Also: If you want to support Chinese perfectly, then:

(a) the operating system must support Chinese! and preferably GBK encoded.

(b) When installing the database, be sure to choose the Chinese character set ZHS16GBK, otherwise there are many problems.

Win7 Ultimate (64-bit) installation method for oracle11g (RPM)