Standard installation methods for ORACLE 11G under Linux

First, Introduction

The importance of Oracle databases in system operations is self-evident, and the knowledge of operating systems and databases is deepened through familiarity with the installation of Oracle. The environment for this installation test is as follows:

Operating system: CentOS 6.5 X64

Database: Oracledatabase 11g Release 2 (11.2.0.1.0) for Linux x86-64

Second, update the system

By re-setting the system's update source to speed up the subsequent software installation progress, the common upgrade source can be specified by the following command. Add the source of Neusoft through the following ways, after testing the source of the site is more stable than the 163 major companies (there can be 163 of the resources used by people too much to cause slow).

wget Http://mirrors.ustc.edu.cn/fedora/epel/6/x86_64/epel-release-6-8.noarch.rpmwget http://pkgs.repoforge.org/ RPMFORGE-RELEASE/RPMFORGE-RELEASE-0.5.3-1.EL6.RF.X86_64.RPMRPM-IVH EPEL-RELEASE-6-8.NOARCH.RPMRPM-IVH RPMFORGE-RELEASE-0.5.3-1.EL6.RF.X86_64.RPMRPM-IVH http://rpms.famillecollet.com/enterprise/ remi-release-6.rpmrpm--IMPORT/ETC/PKI/RPM-GPG/RPM-GPG-KEY-REMICD/ETC/YUM.REPOS.D/MV CentOS-Base.repo Centos-base.repo.origvim Centos-base.repo

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/54/85/wKioL1SFWY6C6J_FAAUErlkuDjs032.jpg "title=" Image001.png "alt=" wkiol1sfwy6c6j_faauerlkudjs032.jpg "/>

If you are prompted to epel a file download failure while updating the cache, you can manually modify the Epel source to a Neusoft network resource, as shown below.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/54/87/wKiom1SFWSGygNYmAANePJA-xAA514.jpg "title=" Image002.png "alt=" Wkiom1sfwsgygnymaanepja-xaa514.jpg "/>

Unless you use the silent way to install the database, you need the support of the graphical interface, for a system that only has a character interface installed, you can install the X graphics component by using the following instructions, you can perform the Yum cache instructions before starting the installation.

Yum Makecacheyum grouplistyum groupinstall ' X windowsystem '-y yum groupinstall ' GNOME Desktop environment '-y yum update

Third, check the hardware requirements

3.1 Memory requirements

The minimum memory requirement is 1G, which can be used to view the memory of the system by the following instructions.

grep memtotal/proc/meminfogrep Swaptotal/proc/meminfo

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/87/wKiom1SFWVSBdDFUAAD-jW2OJdY305.jpg "title=" Image003.png "alt=" Wkiom1sfwvsbddfuaad-jw2ojdy305.jpg "/>

3.2 System Architecture

Ensure that the system is within the scope supported by Oracle and be aware of the corresponding CPU architecture (32-bit vs. 64-bit difference)

Uname–r

3.3 Disk Requirements

where/TMP's temporary directory requires a minimum of 1G of space, other database installation and database file size requirements are as follows:

Df–h/tmpdf–h

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/54/85/wKioL1SFWiDSPh-_AADWixbxgNM286.jpg "style=" float: none; "title=" Image004.png "alt=" Wkiol1sfwidsph-_aadwixbxgnm286.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/54/87/wKiom1SFWY2CnzAdAAC83bmUmVE103.jpg "style=" float: none; "title=" Image005.png "alt=" Wkiom1sfwy2cnzadaac83bmumve103.jpg "/>

3.4 Display Requirements

1024x768

Iv. Checking the software requirements

4.1 Package Requirements

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/85/wKioL1SFWj_TgVZ1AAP-l22pDn4963.jpg "title=" Image006.png "alt=" Wkiol1sfwj_tgvz1aap-l22pdn4963.jpg "/>

4.2 Network Settings

Network settings need to pay attention to the host name access, you can use the following instructions to reconfigure or increase the server hostname information.

Oracle_hostname=somehost.us.example.comexport Oracle_hostname

4.3 Users and Groups

Users and corresponding groups in the Oracle installation and configuration process has strict differences, there are OSDBA, osoper, etc., wherein OSDBA is mainly used in the installation operation, osoper corresponding to the daily configuration. For cases where Oracle has previously been installed, it is possible to detect the configuration content in Orainst.loc by detecting the corresponding groups and users through the following directives:

More/etc/orainst.locinventory_loc=/u01/app/orainventoryinst_group=oinstallgrep Oinstall/etc/group

For cases where there is no Orainst.loc (Oracle is not installed), the corresponding installation group should be created first.

/usr/sbin/groupadd oinstall/usr/sbin/groupadd-g 502 dba/usr/sbin/groupadd-g 505 oper/usr/sbin/useradd-u 502-g Oinstal L-G Dba,asmdba,[oper] ORACLEPASSWD Oracle

You can re-change and view the properties of an Oracle user with the following directives.

/usr/sbin/usermod-g oinstall-g Dba,asmdba[,oper] Oracleid Oracle

4.4 Shell Environment

In order to ensure the performance of the system, the installation user's shell environment needs to be reconfigured before starting the installation, first in the/etc/security/ The Oracle user's shell configuration is added to the limits.conf file, and then the verification content is added, and finally the profile parameters of the Oracle user need to be reconfigured. as shown below.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/54/85/wKioL1SFWpihmEB3AAFrq9d4L4c928.jpg "title=" Image007.png "alt=" Wkiol1sfwpihmeb3aafrq9d4l4c928.jpg "/>

Vi/etc/security/limits.conforacle soft Nproc 2047oracle hard Nproc 16384oracle Soft nofile 1024oracle Hard Nofile 65536

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/85/wKioL1SFWruT5Y6VAAEI1ol8Zzw151.jpg "title=" Image008.png "alt=" Wkiol1sfwrut5y6vaaei1ol8zzw151.jpg "/>

Vim/etc/pam.d/loginsession Required Pam_limits.so

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/87/wKiom1SFWjyD1Ck0AADVRjbQuyE482.jpg "title=" Image009.png "alt=" Wkiom1sfwjyd1ck0aadvrjbquye482.jpg "/>

4.5 Kernel Parameters

During the installation of the database, you can build and run a test script to check the kernel parameters of the system, or you can check the contents of the control itself. It is important to note that the data given in the table is the lowest value and does not need to be modified if the system actually sets a value larger than the content in the project.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/54/87/wKiom1SFWleADPmLAANP0pa0Ugk470.jpg "style=" float: none; "title=" Image010.png "alt=" Wkiom1sfwleadpmlaanp0pa0ugk470.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/54/85/wKioL1SFWuri_t99AAIDmpS7QTU384.jpg "style=" float: none; "title=" Image011.png "alt=" Wkiol1sfwuri_t99aaidmps7qtu384.jpg "/>

The following instructions can be used to detect whether the original kernel settings are normal, as shown in.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/54/87/wKiom1SFWn3hVnFjAAJN5B-OaTI352.jpg "title=" Image012.png "alt=" Wkiom1sfwn3hvnfjaajn5b-oati352.jpg "/>

You can modify the/etc/sysctl.conf file to set the corresponding parameter values, after the modification is complete, save the changes by the appropriate instructions, and then again detect the success of the settings, as follows:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/87/wKiom1SFWpbi2g8sAAG-XSDO-XY671.jpg "title=" Image013.png "alt=" Wkiom1sfwpbi2g8saag-xsdo-xy671.jpg "/>

VI/ETC/SYSCTL.CONFFS.AIO-MAX-NR = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 32000 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_ Default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586/sbin/sysctl–p/ Sbin/sysctl–a

4.6 Oracle User Environment

Su–oracleoracle_base=/opt/oracleoracle_sid=oracleexport Oracle_base Oracle_sid

Not to be continued ...

This article is from the "virtual reality" blog, be sure to keep this source http://waringid.blog.51cto.com/65148/1587580

Standard installation methods for ORACLE 11G under Linux