Oracle11g R2 installation tutorial (very detailed)

Time:2021-6-25

Generally, the slightly larger enterprises are using Oracle database. Compared with MySQL, there are some differences in syntax, but it is still worth learning

  • First, go to the official website to download the 11g R2 version, which is relatively popular( Many companies are also using it.)
    在这里插入图片描述

  • Here I have downloaded:
    Link:https://pan.baidu.com/s/1yZj2JBgiL7dDGjCqa6Vjpw
    Extraction code: 0n8w

  • Start the installation below:

  • After decompression:
    在这里插入图片描述

  • As shown below, click “yes” directly.
    在这里插入图片描述

  • Then the following interface will appear, you can fill in your email address, but you will receive some email. Determine whether you want to use my Oracle support according to your own situation (I canceled the check when I installed it), and then click to go to the next step.
    在这里插入图片描述-Click “yes”
    在这里插入图片描述

  • choiceCreate and configure databasesAfter installation, a database instance will be created automatically.
    在这里插入图片描述

  • Choose hereDesktop class, select the server class if you are installing on Windows Server.
    在这里插入图片描述

  • For typical installation, it is recommended that you only need to select the Oracle base directory by yourself, and the directory path should not have Chinese or other special characters. The global database name can be set by default, and the password can be set by yourself (because Oracle has its own password principle, it will prompt you that your password does not conform to the rules. If it is only used for personal learning, you can ignore it, and you don’t have to care about the Security). The version is generally selectedEnterprise EditionYou can also select UTF-8 as the character set (because the range of UTF-8 is larger than that of GBK), and other defaults are OK.
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述

  • When the password does not conform to the rules, you can set the password in the form of (upper case + lower case + number) to pass the verification. You can also skip directly and click next.
    在这里插入图片描述
    在这里插入图片描述

  • next step
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述

  • Waiting for installation progress bar
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述

  • After the instance database is created, all accounts are locked by default and are not available (exceptsysandsystemClick the password management on the right to display theScottUsers can unlock (click √) and input their own password, which is generallytiger

  • takesysandsystemUser password reset for

  • takeshandscottRemove the check of the account and reset the password

  • takeHRAfter unlocking and setting the corresponding password, click OK.
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述
    在这里插入图片描述

  • Click “yes”
    在这里插入图片描述
    在这里插入图片描述

  • Oracle installation complete
    在这里插入图片描述

  • Unlocked user and default password:
    在这里插入图片描述

  • After the installation of Oracle, the related services of Oracle will be set to start automatically, but in this way, the startup speed of the computer is too slow, so it is recommended to set all Oracle services to start manually.
    在这里插入图片描述

  • Only two services need to be started each time

  1. OracleOraDb11g_home1TNSListener: is a listening service. If you want to connect to Oracle database through programs or different clients, this service must be started, otherwise it cannot be connected

  2. OracleServiceORCL: instance service of database. Its naming standard is as follows:OracleServiceSIDWhenever a database is added to the system database, a similar service name will appear automatically. By default,SIDThe name of the database is exactly the same as the name of the databaseSIDMy name

Recommended Today

Learn more about webpack 5

Development and production construction of webpack In essence, there are two modes of building JavaScript applications: development and production. Previously, you started using webpack dev server in your local development environment using development mode. You can change the source code, and webpack bundles it again. Webpack dev server will show you the latest development version […]