Chapter 2nd installation and configuration of Oracle

2nd. Installation and configuration of Oracle 1.1 knowledge points for learning

1. The Oracle database can be successfully installed;

2. Understand the role of primary system services in Oracle.

2.1 Specific content (emphasis) 2.1.1 Introduction

Oracle It is not charged at the time of use, if you use in the work, you must remember to pay (in the entire enterprise operation, the data is more important than the platform!!!) ）。

Oracle's content is divided into two parts: the development section, the Management Section, and the focus on the development section.

2.1.2 Pre-Installation Preparation

If you want to get the Oracle Installer can log in: www.oracle.com on the download, download the time to understand your operating system version: 32-bit (x86), or 64-bit.

The download is two files, but these two files need to be installed to a file (the two packages are extracted to a folder at the same time to complete). However, the operation is strongly recommended before installation:

1. First install the VMware Workstation Pro virtual machine (Installation step "Next", "Next", here is no longer elaborated);

2. Install the Win 7 system in the virtual machine, note: If directly installed on the real host, the real machine has a certain impact on the operation, to avoid the real machine reload system must use virtual machine to install learning Oracle;

3. There are a large number of Win7.iso image files on the Internet, 9.9 Chengdu is unable to install on the virtual machine: So for everyone to quickly install the virtual machine, and Win 7 is also small enough and easy to use.

Windows 7-32-bit virtual machine image files:

Http://pan.baidu.com/s/1gePTTTL Mm:ayxx

Free installation, easy to use!!!

4. Close the firewall on the virtual machine;

5. Disconnect the Internet as much as possible.

2.1.2 officially begins installation of Oracle 11g:

Execute the "setup.exe" command directly:

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/174741_LB4S_3111397.png "width=" 355 "height=" 238 "alt=" 174741_lb4s_3111397.png "/>650" this.width=650; "src=" https://static.oschina.net/uploads/ Space/2017/0528/174755_6mmn_3111397.png "width=" 358 "height=" 268 "alt=" 174755_6mmn_3111397.png "/>

You will first be asked if you want to receive updates from Oracle. Select next to not receive update information.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/174812_MEHQ_3111397.png "width=" 278 "height=" 138 "alt=" 174812_mehq_3111397.png "/> Select" Yes ". 650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/174818_lcAg_3111397.png "width=" 329 "height=" 248 "alt=" 174818_lcag_3111397.png "/>

Oracle itself is just a software platform that needs to be configured for the database after the Oracle platform installation is complete, so you'll be asked if you need to create a new database. If this is the first installation, select Create and configure Database

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/174837_PnUU_3111397.png "width=" 333 "height=" 251 "alt=" 174837_pnuu_3111397.png "/> Here we select the" server "type, after" next ". 650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/174855_omsW_3111397.png "width=" 335 "height=" 251 "alt=" 174855_omsw_3111397.png "/>

This time we are not involved in the management of RAC in Oracle, note: RAC management is the essence of ORACLEDBA, in the enterprise we will be aix+oracle configuration, our database can not just support a service that will require RAC management, we first learn the development section, No RAC management is required.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/174940_Ky7s_3111397.png "width=" 342 "Height=" alt= "174940_ky7s_3111397.png"/> for easy configuration, select "Advanced Installation" when installing at this point.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175006_vF0j_3111397.png "width=" 344 "height=" 258 "alt=" 175006_vf0j_3111397.png "/>

Select Install "Enterprise Edition", this installation package is the most complete.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175017_ltVV_3111397.png "width=" 344 "height=" 258 "alt=" 175017_ltvv_3111397.png "/>

Choose to fill in the appropriate installation path (because we are running in the virtual machine, in fact, it doesn't matter where to install).

Here we install under the C drive:C:\D\ProTools\Oracle11g\product\11.2.0\dbhome_1

The previous section is what we provide, and then the installation directory itself provided by itself this saves all Oracle execution paths:\product\11.2.0\dbhome_1

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175102_5z9b_3111397.png "width=" 365 "height=" 274 "alt=" 175102_5z9b_3111397.png "/> Select the default" General purpose/Transaction processing ".

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175116_CnFn_3111397.png "width=" 366 "height=" 274 "alt=" 175116_cnfn_3111397.png "/> Here the name of the database is uniformly defined as" tomge ", before we chose to create a new database, so here will be asked to enter the name of the database we are creating.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175129_IJmb_3111397.png "width=" 368 "height=" 276 "alt=" 175129_ijmb_3111397.png "/> Set the character encoding in the Character Set tab to UTF-8 encoding, if we do not set here, to the development of the later time there may be garbled in Chinese.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175222_0NYA_3111397.png "width=" 364 "height=" 273 "alt=" 175222_0nya_3111397.png "/> The" Create a database with sample schema "in the Instance Scenario tab. Note: Considering the convenience of learning, it is required to create all the sample data

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175256_5cyW_3111397.png "width=" 271 "height=" 203 "alt=" 175256_5cyw_3111397.png "/>650" this.width=650; "src=" https://static.oschina.net/uploads/ Space/2017/0528/175301_k2dk_3111397.png "width=" 273 "height=" 204 "alt=" 175301_k2dk_3111397.png "/>

The next two steps are to go by default.

2.1.3 Setting a password

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175311_Cjwi_3111397.png "width=" 325 "height=" 239 "alt=" 175311_cjwi_3111397.png "/> for ease of administration, all usernames and passwords are set to" oracleadmin "(all lowercase, but note the input standard for passwords that are not part of Oracle)

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175327_2qtR_3111397.png "width=" 460 "height=" 347 "alt=" 175327_2qtr_3111397.png "/> If the check fails, select Ignore. 650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175346_obii_3111397.png "width=" 451 "height=" 343 "alt=" 175346_obii_3111397.png "/>

Now that the installation has started, the database is created, and each database requires additional configuration.

Then we want to choose the Password Management service:

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175358_epcQ_3111397.png "width=" 306 "Height=" 309 "alt=" 175358_epcq_3111397.png "/>

Click Password Management to enter the settings:

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175416_Ideq_3111397.png "width=" 340 "height=" 226 "alt=" 175416_ideq_3111397.png "/>

Note: This place "√" means lock, and after clicking "" No √ means unlocking.

The main operation of the following several users (set the classic password of Oracle) Note in the actual production environment I our settings must not be the following password:

L Super Administrator: Sys/change_on_install;

L General Manager: System/manager;

L Ordinary Users: Scott/tiger, note: This user needs to unlock;

L Big Data Users (sample database only): sh/sh, note: This user needs to unlock;

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175432_09Or_3111397.png "width=" 226 "Height=" alt= "175432_09or_3111397.png"/>

Here is a hint that our password is not standard;

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175441_U33n_3111397.png "width=" 321 "height=" 241 "alt=" 175441_u33n_3111397.png "/>

This time only indicates that the Oracle software installation is complete and the database is installed. Select "Close" to complete the installation.

2.1.4 Complete the following setup methods for Oracle 11g installation:

However, after the installation is complete, it registers the following in the Windows system:

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175453_zXa7_3111397.png "width=" 152 "Height=" "alt=" 175453_zxa7_3111397.png "/>650" this.width=650; "src=" https://static.oschina.net/uploads/ Space/2017/0528/175500_x9dc_3111397.png "width=" 439 "height=" 312 "alt=" 175500_x9dc_3111397.png "/>650) this.width=650, "src=" Https://static.oschina.net/uploads/space/2017/0528/175508_dCmH_3111397.png "width=" 439 " height= "161" alt= "175508_dcmh_3111397.png"/>

Oracle's related services are set to start automatically after the installation is complete, but this can cause our programs to execute too slowly (the computer starts too slowly). Therefore, it is strongly recommended that the "Startup type" here be changed to "manual" for all "automatic"

Each time you start up, you only need to start two services:

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175529_a5C3_3111397.png "width=" 554 "Height=" alt= "175529_a5c3_3111397.png"/>

Oracleoradb11g_home1tnslistener: Is the monitoring service, if you want to connect to our Oracle database through a program or a different client, the service must be started, otherwise it cannot connect If this service is only operated on this machine, Oracle can not be used. The two services are started in order to train everyone's habitual.

ORACLESERVICETOMGE: the instance service of the database, its named standard: OracleserviceSID comes from, the previous settings are as follows:

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175555_Zqkv_3111397.png "width=" 350 "Height=" alt= "175555_zqkv_3111397.png"/>

|-In the default case, the name of the SID is exactly the same as the name of the database, and the name of the SID is used on the network;

|-Whenever a database is added to the system, a similar name will appear automatically.

Oracle's Oraclejobscheduler tomge service problem? Why is the service "disabled"?

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175613_7JFx_3111397.png "width=" 500 "Height=" alt= "175613_7jfx_3111397.png"/>

Database work schedule scheduling, generally do not schedule the work schedule does not need to start, why default is disabled? Because it consumes a lot of system resources when it is started.

Note (Key Mastery):

Oracle's two services:

|-If you want to connect through the program, you must start the monitoring service;

|-all data is stored in the instance service.

2.1.5 Oracle 11g Offload method:

Oracle may not install successfully immediately after uninstallation.

1. Oracle normal installation completed;

|-Use the uninstall program provided by Oracle.

650) this.width=650; "src=" Https://static.oschina.net/uploads/space/2017/0528/175634_lJrv_3111397.png "width=" 262 "height=" 181 "alt=" 175634_ljrv_3111397.png "/>

|-Restart the computer and enter Safe Mode (press and hold F8 at startup);

|-find the corresponding disk path on the system and delete it;

|-run the registry command "Regedit.exe" (Windows key + R to open the Run function);

|-Search all Oracle-related content and delete (Ctrl + F to open search);

|-Restart the computer, you can re-install;

|-Restart the computer and enter Safe Mode (press and hold F8 at startup);

2. Oracle Installation failed:

|-find the corresponding disk path on the system and delete it;

|-run the registry command "Regedit.exe" (Windows key + R to open the Run function);

|-Search all Oracle-related content and delete (Ctrl + F to open search);

|-Restart the computer, you can re-install;

|-Restart the computer and enter Safe Mode (press and hold F8 at startup);

3.1 Summary

3.1.1. Oracle 11g installation issues;

3.1.2. Oracle 11g offload problem;

3.1.3. Two services for Oracle 11g:

1) If you want to connect through the program, you must start the monitoring service;

2) All data is stored in the instance service.

This article is from the "King Kong Rebirth Road" blog, please be sure to keep this source http://tangxuantao.blog.51cto.com/12630728/1930470

Chapter 2nd installation and configuration of Oracle