Oracle 11g R2 for Win7 flagship edition (64-bit) Installation Steps, 11gwin7

Oracle 11g R2 for Win7 flagship edition (64-bit) Installation Steps, 11gwin7

Databases have many versions. Which one should I learn?

Everything is rational. Although there are many database versions, the essence is the same. The changes are just representations. You are an oracle7 expert and must be an oracle11g expert. Oracle Database is becoming more and more popular. The following describes how to install Oracle 11g R2 for Win7 flagship edition (64-bit:

1. Download Oracle 11g R2 for Windows

: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
The package contains two packages: win64_11gr2_database_1of2.zip,win64_11gr2_database5of2.zip.
Note:

Copy \ win64_11gr2_database204 F2 \ database \ stage \ Components \ * to the \ win64_11gR2_database_1of2 \ database \ stage \ Components directory; otherwise, the following error occurs:

File E: \ app \ xxj \ product \ 11.2.0 \ dbhome_1 \ owb \ external \ oc4j_applications \ applications \ WFMLRSVCApp. ear not found

2. decompress the two packages to the same directory, that is, extract databasefiles. Then, click "Unzip setup.exe" in a single click:

3. In the displayed "configuration Security Update" window, cancel "I want to accept security updates through My Oracle Support" and click "Next ":

4. In the "Installation Options" window, select "Create and configure Database" and click "Next ":

5. In the "system class" window, select "desktop class" and click "Next ":

6. In the "typical installation" window, select the Oracle base Directory, select "Enterprise Edition" and "Default Value", enter the same password as Oracle11g, and click "Next ":

7. In the "prerequisite check" window, click "Next ":

8. In the "summary" window, click "finish" to install:

9. The installation process is as follows:

 

10. After the Database is created, the following "Database Configuration Assistant" interface appears:

Select "password management" to view and modify the following users:
(1) Common users:SCOTT(Password:Tiger) 
(2) Common administrator:SYSTEM(Password:Manager) 
(3) Super administrator:SYS(Password:Change_on_install) 
After the modification is complete, click OK ".

 

11. OracleAfter the installation is complete, services are registered in the system.The following two services must be started. OtherwiseOracleWill not work properly: 

(1) OracleOraDb11g_home1TNSListener: Listener service. If the client wants to connect to the database, this service must be enabled. This service also takes effect in program development.
(2) OracleServiceORCL: indicates the master service of the database. Naming rule: OracleService database name. This service must be enabled; otherwise, Oracle cannot be used at all.

12. After the installation, the Oracle oci. dll is 64-bit,

1. Download the Oracle Client Package from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html. 【Instantclient-basic-nt-11.2.0.2.0.zip]

 

2. Unzip the instantclient-basic-nt-11.2.0.2.0.zip to c: \ oracle, And the directory where oci. dll is located is: c: \ oracle \ instantclient_11_2 \

3. Set Environment Variables

TNS_ADMIN = c: \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN

NLS_LANG = AMERICAN_AMERICA.ZHS16GBK (Note:NLS_LANGThe first half must beAMERICAN_AMERICABecauseInstant clientOther languages are not supported. The latter half can be adjusted based on the character set of your database.AL32UTF8, You can setAL32UTF8)

4. Start PL/SQL Developer and click "cancel". Choose "Tools"> "Perferences"> "Connection" to modify the configurations of Oracle_Home and OCI Library:
OracleHome: OraDb11g_home1
OCI library: C: \ oracle \ instantclient_11_2 \ oci. dll

5. Restart PL/SQL and log on to the corresponding database. The connection is normal and the problem is solved successfully!