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

Implementation example of go operation etcd

etcdIt is an open-source, distributed key value pair data storage system, which provides shared configuration, service registration and discovery. This paper mainly introduces the installation and use of etcd. Etcdetcd introduction etcdIt is an open source and highly available distributed key value storage system developed with go language, which can be used to configure sharing […]