Windows System installation Oracle 11g database graphics and text tutorials _oracle

A. Download

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html below two website source this official download page net.

Win 32-bit operating system download address: Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip http:// Download.oracle.com/otn/nt/oracle11g/112010/win32_11gr2_database_2of2.zip

Win 64-bit operating system download address: Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip http:// Download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_database_2of2.zip

(Oracle Account/password: 1603869780@qq.com/qwe123qwe)

Two. Installation

1. Extract the files, select the two packages together, and-> the mouse right click to extract the current folder as shown

2. Extract the two to the same path, as shown in figure:

3. To the corresponding decompression path above, find the executable installation file "setup.exe" double-click Install. As shown in figure:

4. Install the first step: Configure security updates, this step can be your own e-mail address to fill in (also can not fill in, just received some useless mail only).

Cancel the following "I want to accept security update (W) via my Oracle support." As shown in figure:

5. Security options, directly select the default to create and configure a database (after installing the database management software, the system will automatically create a database instance). As shown in figure:

6. System class, directly select the default desktop class on it. (If the computer is installed on a personal laptop or personal computer using this option) Figure:

7. Typical installation. Important step. It is recommended that you only update the Oracle base directory and that the directory path does not contain Chinese or other special characters. The global database name can be default and password password must be kept in mind. Password input, there are prompt warning, do not conform to oracel recommendations without the tube. (Because Oracel's recommended password rules are cumbersome, they must be uppercase and lowercase letters plus a number, and must be more than 8 digits.) Trouble, you can enter the usual habit of a short password can be) as shown:

8. If the password entered is short and simple, the installation will be prompted as follows. Just confirm Y to continue the installation. As shown in figure:

9. Prerequisite checks. The installer checks to see if the hardware and software system meets the minimum requirements for installing this Oracle version. It's OK to go directly to the next step. As shown in figure:

Can all be ignored.

10. Some related selection configuration information before the installation of the profile. Can be saved as a file or do not save the file directly point to complete. As shown in figure:

11. Install the product automatically, do not tube. As shown in figure:

12. After the database management software files and the DBMS files are installed, the database that installs the ORCL name of the default front of the instance database is automatically created. As shown in figure:

13. The instance database was created and the system defaults to locking all accounts (except SYS and system accounts available), suggesting the right password management, unlocking the usual Scott account and entering the password. As shown in figure:

14. Unlock Scott account, remove the front green tick, and enter the password. You can also enter the usual short password, do not have to press Oracle recommended 8-bit above the size of the number, trouble. Oh. As shown in figure:

Note: Sys/system, while modifying the new password, confirm the password.

15. Similarly, passwords that do not conform to rules are prompted. Don't worry about it, go on Y. As shown in figure:

16. Installation successful, complete. It's easy, hehe. As shown in figure:

Three. After installation, enter the test by beginning, in the application "Oracle 11g"-> "Application Development"-> "SQL Developer or SQL Plus" connection. Note that the first time, using SQL Developer, you will be prompted to specify the path of Java.exe, do not specify your own java_home (I just don't know, specify a JDK6, end said incompatible. You can use the JDK path below the Oracel installation path specifically: Figure:

Of course, if not careful, the choice is wrong. Select the advanced version in Java_home, open SQL Developer errors after the error is not compatible, there are ways to solve. You can find the "sqldeveloper.conf" file in the "F:\app\Administrator\product\11.2.0\dbhome_2\jdk\jre\bin" path and then open it and find the value that setjavahome matches. Deletes the following configuration content. The guarantee prompts that the read-only file is not overwritten for saving. This can be saved to the desktop, and then back to the bin directory to delete the file, and then copy the file on the desktop, and then open, select Java.exe. It's good to choose right now.

Four. Problems encountered during installation

1. Template General-purpose.dbc does not exist. Make an existing template for the database creation operation. File F:\app\Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em.ear not found

F:\app\Administrator\product\11.2.0\dbhome_2\ctx\admin\dr0ulib\sql\sbs File not found F:\app\Administrator\product\11.2.0 \DBHOME_2\BIN\DB2GC F:\app\Administrator\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole\config\ System-application.xml F:\app\Administrator\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole\config\ System-jazn-data.xml F:\app\Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em.ear F:\app\ Administrator\product\11.2.0\dbhome_2\oc4j_applications\applications\em\em.war [NS-20802]Oracle Net Configuration Assistant failure

Workaround: After downloading, there are 2 installation packages.

After decompression, the second package is extracted to the corresponding directory under the database of the first decompression package. To install again

2. What to do if an unexpected error occurs when the input of [INS-08109] validation status ' getocmdetails ' occurs when Oracle Database 11g is installed, as shown below:

Workaround: Remove the option that I want to receive updates through my Oracle support.

This will not have to enter the email address.

3. Perform a prerequisite check for all failed errors, as shown in the following figure:

The above is a small series to introduce the Windows System installation Oracle 11g database graphics and text tutorials, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!