Oracle 11g installation steps in detail

The October Nanjing Rainy Weather Library spent a little more about the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's shoes to improve the installation efficiency. Mutual convenience and common progress! Oracle Two files There is a need to leave a message give you

First, Oracle download

Note that Oracle is divided into two files, and after downloading, two files are extracted to the same directory. In the path name, it is best not to appear in Chinese, and do not appear spaces and other irregular characters.

Official address:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html the following two Web site source this official download page Web.

Win 32-bit operating system:

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:

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

Second, Oracle Installation

1. Unzip the file, select the two compressed package together, right click and unzip the file

2. Unzip the two into the same path,

3. To the appropriate decompression path above, find the executable installation file "setup.exe" double-click the installation.

4. Install the first step: Configure the security update, this step can fill in the e-mail address (also can not fill in, just received some useless mail only). Cancel the "I want to accept security update (W) through my Oracle support" below.

5. Security options, directly select Create and configure a database by default (after the database management software is installed, a database instance is created automatically).

6. The system class, directly select the default desktop class is ready. (If the computer you are installing to is a personal notebook or personal computer Use this option)

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 defaulted, and password passwords must be kept in mind. Password input, there is a warning, do not comply with ORACEL recommendations without tube. (because the password rules recommended by Oracel are cumbersome, they must be uppercase and lowercase plus numbers, and must be more than 8 digits.) Trouble, you can enter the usual oneself habit of short password can be)

8. If the password entered is short and simple, the installation will prompt the following. Just confirm Y to continue with the installation.

9. Prerequisite checks. The installer checks to see if the hardware and software system meets the minimum requirements for installing this Oracle version. The immediate next step is OK.

10. Outline some relevant selection configuration information prior to installation. You can save the file or do not save the file directly to the point of completion.

11. Install the product automatically, without tube.

12. After the database management software files and DBMS files are installed, a database that installs the ORCL name of the previous instance database is automatically created.

13. The instance database is created, the default is to lock all the accounts are unavailable (except SYS and the SYSTEM account is available), it is recommended to point to the right of password management, the common Scott account to unlock and enter the password.

14. Unlock the Scott account, remove the green tick from the front, and enter the password. You can also enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle recommends. Oh.

15. Similarly, passwords that do not conform to the rules are prompted. Don't worry about it, continue Y.

16. The installation is successful and complete. It's simple, hehe.

Third, after installation, enter the small test.

You can start by using the "Oracle 11g", "Application Development", "SQL Developer or SQL Plus" connection in the application.

Note For the first time, when you use SQL Developer, you are prompted to specify the path to Java.exe, so don't specify your own java_home here (I just don't know, specify a JDK6, end up saying incompatible.) ) You can use the JDK path under the Oracel installation path

D:\Installation\oracle\product\11.2.0\dbhome_1\jdk\jre\bin (My Notebook)

specific is:.

Of course, if you are not careful, choose the wrong. Select the Java_home in the Advanced version, open SQL Developer error after the incompatibility, there are ways to solve. Can be in

Open after "sqldeveloper.conf" file found under "F:\app\chen\product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\bin" path

Locate the value that Setjavahome matches, and delete the following configuration. The guarantee will prompt that the read-only file cannot be overwritten and saved. You can save it to the desktop, then go back to the bin directory to remove the file, and then copy the file on the desktop, and then open, re-select Java.exe. It's good to choose right now.

--------------------------------------------------------------------------------------------------------------- -----------------------

After installing the 64-bit version of ORACLE11GR2, discover the path to the configuration Java.exe when you start SQL Developer, and locate the path that is generated after Oracle comes with Java.exe "C:\app\ user name \product\11.2.0\dbhome_1 \JDK "But the error message pops up:

－－－－－－－－－－－－－－－－－－－－－－－－－－
Unable to find a Java Virtual machine
To point-a location of a Java virtual machine,please refer to the Oracle9i Jdeveloper Install Guide (jdev\install.html)
－－－－－－－－－－－－－－－－－－－－－－－－－－

Because there is no chance of reconfiguration, we have to install directory "C:\app\ username \product\11.2.0\dbhome_1\sqldeveloper0\sqldeveloper\bin" Locate the configuration file sqldeveloper.conf, and modify the "Setjavahome" entry to "Setjavahome C:\Program files\java\jdk1.6.0_21", which is another JDK that is installed separately, and the result is the same.

The JDK path "Setjavahome C:\Users\ username \appdata\local\genuitec\common\binary\" is configured as MyEclipse8.5. com.sun.java.jdk.win32.x86_1.6.0.013 ", all normal, is wondering when, to the network search, find" Http://forums.oracle.com/forums/thread.jspa? messageid=4449178 "was finally inspired to figure out what was going on.

Oracle in the manufacture of 64-bit version of the time did not pay attention to ORACLE11GR2 SQL Developer is 1.5.5.59.69 version, does not support the 64-bit version of the JDK, exactly 64 Oracle with the JDK and "C:\Program Files" The JDK in is 64-bit. If you install a separate JDK in the "C:\Program Files (x86)" In the description is 32-bit version, is available. Why MyEclipse's JDK is available, because MyEcipse8.5 does not have a 64-bit version (including the latest 8.6), so the JDK is of course the 32-bit version. Do you understand?

Take a look at the solution:

Now that you've decided to use the 64-bit version of ORACLE11GR2:

(1) Install a 32-bit version of the JDK can be directly configured;

(2) Upgrade SQL developer to 2.1, the original "C:\app\ user name \product\11.2.0\dbhome_1" under the deletion, download (http://download.oracle.com/otn/java/ Sqldeveloper/sqldeveloper64-2.1.1.64.45-no-jre.zip) come back directly and unzip to get a Sqldeveloper folder in the same location. At this point, you can configure the JDK under "C:\Program Files", and Oracle's own JDK is still not available because the 2.1 version of SQL Developer requires more than 1.6.0_04 jdk. The JDK version of ORACLE11GR2 comes with only 1.5.0_17.

It's not over yet, there's a little problem. The "SQL Developer" in the Start menu is a pointer to the C:\app\ user name \product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\bin \sqldeveloper.bat ", this can't start, maybe your machine can start, someone on the network said this problem, open this file a look, the content is:

Java-xmx640m-xms128m-xverify:none-doracle.ide.util.addinpolicyutils.override_flag=true-dsun.java2d.ddoffscreen =false-dwindows.shell.font.languages=-xx:maxpermsize=128m-dide.asserttracingdisabled=true- Doracle.ide.util.addinpolicyutils.override_flag=true-djava.util.logging.config.file=logging.conf-dsqldev.debug =false-dide.conf= "./sqldeveloper.conf"-dide.startingcwd= "."-classpath. /.. /ide/lib/ide-boot.jar Oracle.ide.boot.Launcher

The solution is: Change the front "-xmx640m" to "-xmx512m". But running this command, click on the "Yes" that allows the program to run, nothing happens, but running the bat file directly in Explorer pops up a DOS-like window with a lot of information displayed and a window pops up. This does not feel good to run, so continue to retrofit:

On the Start menu, on the SQL Developer, right-click on the attribute to select the C:\app\ user name in the target \product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\bin\ Sqldeveloper.bat "modified to" C:\app\ User name \product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloperw.exe ".

As for the default run "Sqldeveloper.bat", there should be a reason, know that the principle can be supplemented by.

Oracle 11g installation steps in detail