1. Oracle download
Note that Oracle is divided into two files, and after downloading, the two files can be extracted to the same directory. It is best not to appear Chinese in the path name, nor to appear irregular characters such as spaces.
Official address:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html以下两网址来源此官方下载页网。
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
2. Oracle installation
1. Unzip the file, select the two compressed packages together, right-click -> unzip the file as shown in the picture
2. The two are decompressed into the same path, as shown in the figure:
3. Go to the corresponding extraction path and find the executable installation file [ setup.exe ] and double-click to install. As shown in the figure:
4. Install the first step: Configure security updates, you can fill in your email address (or you can leave it out, just receive some useless emails). Clear "I want to receive security updates (W) through My Oracle Support" below. As shown in the figure:
5. Security option, 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 the figure:
6. System class, just select the default desktop class. (If the computer is installed, use this option for personal notebooks or personal computers) As shown in the figure:
7. Typical installation. Important steps. It is recommended to update the Oracle base directory and do not contain Chinese or other special characters. The global database name can be defaulted, and the password password must be remembered. When entering the password, there is a warning, if it does not meet the Oracel recommendations, do not worry. (Because the password rules suggested by Oracel are more cumbersome, they must be uppercase letters plus lowercase letters and numbers, and they must be more than 8 digits.) troublesome, you can enter the short password you are used to) As shown in the picture:
8. If the password entered is short and simple, it will be prompted as follows during installation. Just confirm Y directly and continue the installation. As shown in the figure:
9. Prerequisite check. The installer checks that the hardware and software systems meet the minimum requirements to install this Oracle release. Just go to the next step and it's OK. As shown in the figure:
10. Overview Some relevant selection and configuration information before installation. You can save it as a file or click directly to complete it without saving the file. As shown in the figure:
11. Install the product automatically, no matter what. As shown in the figure:
12. After the database management software file and DBMS file are installed, a database with the OCL name in front of the default instance database will be automatically created. As shown in the figure:
13. The instance database is created, and the system locks all accounts by default (except sys and system accounts are available), it is recommended to click on the password management on the right to unlock the commonly used scott account and enter the password. As shown in the figure:
14. Unlock the Scott account, remove the green tick at the front, and enter the password. You can also enter the short password you usually use, and you don't have to add numbers according to Oracle's recommended 8-digit or higher case, which is troublesome. Hehe. As shown in the figure:
15. Again, passwords that do not meet the rules will prompt you. Leave it alone, just continue with Y. As shown in the figure:
16. The installation is successful, and it is complete. Simple, hehe. As shown in the figure:
3. After installation, enter the small test
You can connect via "Oracle 11g" -> "Application Development" -> "Sql Developer or Sql Plus" in the application from the start.
Note that the first time you use SQL Developer, you will be prompted to specify the path of the java.exe, so don't specify your own java_home here (I just didn't know at first, specify a JDK6, and end up saying incompatible). You can use the jdk path below the Oracel installation path specifically: as shown in the figure.
Of course, if you are not careful, you will make the wrong choice. If you choose the advanced version of the java_home, it is not compatible after opening SQL Developer, but there is also a way to solve it. Yes
【F:appchenproduct .2.0dbhome_1sqldevelopersqldeveloperin】路径下找到【sqldeveloper.conf】文件后打开
Find the value that matches SetJavaHome and delete the following configuration content. When guaranteed, it will prompt that read-only files cannot be overwritten. At this time, you can save it as it is on the desktop, and then return to the bin directory to delete the file, then copy the file on the desktop, and then select the java.exe again when you open it. At this time, it is good to choose the right one.
|