Install ORACLE 11G R2 under OEL6.1

Source: Internet
Author: User

Oracle 11.2.0.3 is selected for this installation. A total of seven installation packages are downloaded. The first two installation packages must be used for separate database installation. The installation steps are as follows:

1. Copy the database file to the server.
Cp p10404530_112030_Linux-x86-64 _ {,} */u01/

2. decompress the database file
Unzip p10404530_112030_Linux-x86-64_1of7.zip
Unzip p10404530_112030_Linux-x86-64_2of7.zip

3. Check/etc/hosts
Add the host name information to the hosts file.

Disable sendmail and iptables

Chkconfig-list iptables

Chkconfig-list sendmail

Service sendmail stop

Service iptables stop

4. Create users and groups
Useradd oracle

Passwd oracle

Groupadd dba

Usermod-G dba oracle

Chown-R oracle: dba/u01/
Chmod-R 755/u01/

Check whether the following patch has been installed (mounting the iso file, using the mount-o loop path/mnt/iso)

Binutils-2.15.92.0.2-18

Compat-libstdc ++-33.2.3-47.3

Elfutils-libelf-0.97-5

Elfutils-libelf-devel-0.97-5

Glibc-2.3.9.4-2.19

Glibc-common-2.3.9.4-2.19

Glibc-devel-2.3.9.4-2.19

Gcc-3.4.5-2

Gcc-c ++-3.4.5-2

Libaio-devel-0.3.105-2

Libaio-0.3.105-2

Libgcc-3.4.5

Libstdc ++-3.4.5-2

Libstdc +-devel-3.4.5-2

Make-3.80-5

Sysstat-5.0.5

UnixODBC-2.2.11

UnixODBC-devel-2.2.11
[Root @ erp1 Packages] # rpm-ivh binutils-2.20.51.0.2-5.28.el6.x86_64.rpm compat-libstdc ++-33-3.2.3-69.el6.x86_64.rpm elfutils-libelf-0.152-1.el6.x86_64.rpm elfutils-libelf-devel-0.152-1.el6.x86_64.rpm glibc-common-2.12-1.47.el6.x86_64.rpm glibc-devel-2.12-1.47.el6.x86_64.rpm gcc-4.4.6-3.el6.x86_64.rpm gcc-c ++-4.4.6-3. el6.x86 _ 64.rpm libaio-devel-0.3.107-10.el6.x86_64.rpm libaio-0.3.107-10.el6.x86_64.rpm libgcc-4.4.6-3.el6.x86_64.rpm libstdc ++-4.4.6-3. el6.x86 _ 64.rpm libstdc ++-devel-4.4.6-3.el6.x86_64.rpm make-3.81-19.el6.x86_64.rpm sysstat-9.0.4-18.el6.x86_64.rpm unixODBC-2.2.14-11.el6.x86_64.rpm unixODBC-devel-2.2.14-11.el6.x86_64.rpm compat-libcap1-1.10-1.x86_64.rpm ksh-20100621-12.el6.x86_64.rpm compat-libstdc ++-33-3.2.3-69.el6.x86_64.rpm libaio-devel-0.3.107-10.el6.x86_64.rpm

5. Modify/etc/sysctl. conf and add the following content:

Kernel. shmmax = 4294967295

# Controls the maximum number of shared memory segments, in pages

Kernel. shmall = 2097152

Kernel. shmmni = 4096

# Semaphores: semmsl, semmns, semopm, semmni

Kernel. sem = 250 32000 100 128

Fs. file-max = 65536

Net. ipv4.ip _ local_port_range = 1024 65000

Net. core. rmem_default = 4194304

Net. core. rmem_max = 4194304

Net. core. wmem_default = 262144

Net. core. wmem_max = 262144

Run

/Sbin/sysctl-p

6. Modify/etc/security/limits. conf and add the content.

Oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

7. Modify/etc/pam. d/login and add the content.

Session required/lib/security/pam_limits.so // this parameter is not required for 64-bit systems.

Session required pam_limits.so

8. Modify/etc/profile and add content

If [$ USER = "oracle"]; then

If [$ SHELL = "/bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

9. log on to the oracle database and modify the. bash_profile file.

Su-oracle

Vi. bash_profile Add the following content

# DISPLAY = localhost: 0.0

# Export DISPLAY

Export ORACLE_SID = center

Export ORACLE_BASE =/u01/app/oracle

Export ORACLE_HOME =/u01/app/oracle/product/11.2.0./db_1

Export ORA_CRS_HOME =/u01/app/product/crs_1

Export ORACLE_ADMIN = $ ORACLE_BASE/admin

Export ORACLE_HOME_LISTNER = $ ORACLE_HOME

Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ ORACLE_HOME/jlib

Export JAVA_HOME = $ ORACLE_HOME/jdk

Export PATH = $ PATH: $ ORACLE_HOME/bin:/usr/sbin:/usr/local/sbin:/usr/lib: $ JAVA_HOME/bin: $ ORA_CRS_HOME/bin:
Description of related parameter files:

A) vi/etc/sysctl. conf
Kernel. shmall is the physical memory divided by pagesize;

Kernel. shmmax is half of the physical memory;

Fs. file-max is 512 multiplied by processes (for example, 128 processes );

Net. ipv4.ip _ local_port_range/net. core. rmem_default/net. core. rmem_max parameters are set differently from those in the official documentation, which was changed according to the latest requirements of metalink 343431.1;

Net. ipv4.tcp _ rmem/net. ipv4.tcp _ wmem parameters do not need to be set in general, unless they require a lot of network transmission for Dataguard/Streams;

Set other parameters as required in the official documentation.

# Vi/etc/sysctl. conf

Kernel. shmall = 2097152

Kernel. shmmax = 2147483648

Kernel. shmmni = 4096

Kernel. sem = 250 32000 100 128

Fs. file-max = 65536

Net. ipv4.ip _ local_port_range = 9000 65000

Net. core. rmem_default = 4194304

Net. core. rmem_max = 4194304

Net. core. wmem_default = 262144

Net. core. wmem_max = 262144

After modification, make the parameter take effect:

#/Sbin/sysctl-p

Shmmax is one of the most important parameters in core parameters. It is used to define the maximum value of a single shared memory segment,

The shmmax setting should be large enough to accommodate the entire SGA under a shared memory segment. setting too low may lead to the need to create multiple shared memory segments, this may cause a reduction in system performance.

The kernel. shmall parameter controls the number of pages in the shared memory. Linux shared memory page size: 4 kb, within share

The size of the memory segment is an integer multiple of the size of the shared memory page. The maximum size of a shared memory segment is 16 GB, so the number of pages to be shared is 16 GB/4KB = 16777216KB/4KB = 4194304 page), that is, 16 GB physical memory in 64-bit systems, set kernel. shmall = 4194304 meets the requirements (almost twice the original 2097152 ). In this case, you can adjust the shmmax parameter to 16 GB. You can also modify SGA_MAX_SIZE and SGA_TARGET to 12 GB. The maximum SGA size you want to set is also 2 GB ~ 14G and so on. It also coordinates PGA parameters and other memory usage such as OS, and cannot be set to too full, such as 16G ).

Kernel. shmmni ----

Shmmni Kernel Parameter is the maximum number of shared memory segments. Note that this parameter is not shmmin, yes

Shmmni, shmmin indicates the minimum memory segment size ). The shmmni default value is 4096, which is generally enough.

Before installing Oracle, you usually need to set the kernel. sem parameter. The following is a brief introduction:

Sem is the abbreviation of semaphores. view the current settings.

[Oracle @ ebsse oracle] $ cat/proc/sys/kernel/sem

250 32000 100 128

4 data records correspond

SEMMSL SEMMNS SEMOPM SEMMNI

For example, when the PROCESSES parameter settings in the Oracle DB initialization parameter file are large, you need to adjust the SEMAPHORES settings.

SEMMSL should be set to the maximum PROCESSES parameter + 10 for each instance on the server. For example, when the maximum PROCESSES parameter is 5000, SEMMSL should be set to 5010.

SEMMNS parameter should be set to SEMMSL * SEMMNI, SEMMSL is 5010, SEMMNS parameter should be 5010*128) = 641280.

The SEMOPM parameter should be set to the same as the SEMMSL parameter. In this example, the SEMOPM parameter should be set to 5010.

Modify the current SEMAPHORES parameter settings:

[Oracle @ ebsse oracle] $ su

Password:

[Root @ ebsse Oracle] # echo "5010 641280 5010 128" & gt;/proc/sys/kernel/sem

[Root @ ebsse Oracle] # cat/proc/sys/kernel/sem

5010 641280 5010 128

To enable automatic application at startup, add the following in/etc/sysctl. conf:

Kernel. sem = 5010 641280 5010 128

SEMMNI 100 Defines the maximum number of semaphore sets in the entire system.

SEMMNS 256 Defines the maximum semaphores on the system. this setting is a minimum recommended value, for initial installation only. the SEMMNS parameter shocould be set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, and then adding an additional 10 for each database.

SEMOPM 100 Defines the maximum number of operations for each semop call.

Semms L 100 Defines the minimum recommended value, for initial installation only.

SHMMAX 2147483648 Defines the maximum allowable size of one shared memory segment. 2 GB for SMP kernel. The recommended size is half the RAM size.

SHMMIN 1 Defines the minimum allowable size of a single shared memory segment.

SHMMNI 100 Defines the maximum number of shared memory segments in the entire system.

SHMSEG 4096 Defines the maximum number of shared memory segments one process can attach.

SHMVMX 32767 Defines the maximum value of a semaphore.

SEMMSL: Maximum number of semaphores in each semaphores set: 200

SEMMNS: the maximum number of semaphores in the system is 20000.

SEMOPM: the maximum number of operations contained in each semop call is 200.

SEMMNI: Minimum number of semaphores in the system: 100

Example:

Linux X86-64 operating system, Oracle 10G Database, from 8G to 16G, the kernel. after the shmmax parameter is changed to 17179869184 (16 GB), it is found that as long as the sga_max_size and sga_target parameters are modified to exceed 8 GB, Oracle will report that the memory is insufficient to start, and check the other two parameters related to the shared memory parameters: kernel. shmall and kernel. shmmni, kernel. the shmall parameter controls the number of pages in the shared memory, kernel. the shmmni parameter controls the total number of shared memory segments. The current parameter value is 4096, which is large enough. The problem should be indicated by the kernel. on shmall, divide the value by 8589934592 (8G) and the result is 2097152. The page size is 4 K. To adjust SGA to a value greater than 8G, we need to increase the kernel. after the shmall parameter is adjusted to 2 times (4194304) of the current value, the sga can be successfully set to 13 Gb.

B) Appendix 2: linux limits. conf configuration

The limits. conf file is actually the configuration file of pam_limits.so in the Linux PAM plug-in Authentication module and Pluggable Authentication Modules, and is only applicable to a single session.

The limits. conf format is as follows:

Username | @ groupname type resource limit

Username | @ groupname: Set the user name to be restricted. The group name is preceded by @ and the user name. You can also use wildcard * to restrict all users.

Type: soft, hard, and-. soft indicates the setting value that takes effect for the current system. Hard indicates the maximum value that can be set in the system. Soft cannot be more restrictive than hard. -Indicates that both soft and hard values are set.

Resource:

Core-restrict the size of kernel files

Date-maximum data size

Fsize-Maximum File Size

Memlock-maximum memory address space locked

Nofile-Maximum number of opened files

Rss-maximum persistent setting size

Stack-maximum stack size

Cpu-maximum CPU time in minutes

Noproc-Maximum number of processes

As-address space limit

Maxlogins-Maximum number of logins allowed by this user

To make the limits. conf file take effect, make sure that the pam_limits.so file is added to the Startup File. View the/etc/pam. d/login file:

Session required/lib/security/pam_limits.so

 

10. log on with an oracle user, enter startx, enter the graphical interface, and then enter the installation directory./runInstaller to start installation.

 

11. Configure Security Updates

650) this. width = 650; "style =" border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/19524554M-0.png "" 558 "height =" 345 "/>

12. Skip Software Update Configuration

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952453212-1.png "" 558 "height =" 416 "/>

13. Select create database as the installation option

650) this. width = 650; "style =" border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952452647-2.png "" 558 "height =" 416 "/>

14. Select the server type for the system type

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/19524562F-3.png "" 558 "height =" 416 "/>

15. Install a single instance Database

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952454V6-4.png "" 558 "height =" 416 "/>

16. Select whether to customize the installation.

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/195245E64-5.png "" 558 "height =" 416 "/>

17. Select the product language, both english and simple chinese.

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952456124-6.png "" 558 "height =" 416 "/>

18. Select Enterprise Edition for the database version

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952451G9-7.png "" 558 "height =" 416 "/>

19. The installation path is subject to the configuration in the environment variable.

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952453O8-8.png "" 558 "height =" 345 "/>

20. Select an oracle Installation Group

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952453958-9.png "" 558 "height =" 345 "/>

21. Select the database type as the oltp type

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952455618-10.png "" 558 "height =" 416 "/>

22. Enter the database instance name as needed

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952452V1-11.png "" 558 "height =" 416 "/>

23. Select Character Set and other parameters

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952452914-12.png "" 558 "height =" 416 "/>

24. Select a file system and do not use asm for the moment.

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/195245C11-13.png "" 558 "height =" 416 "/>

25. Set the system account password

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952454243-14.png "" 558 "height =" 416 "/>

26. Select the database administrator Group

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952455a4-15.png "" 558 "height =" 416 "/>

27. Installation check

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952452C2-16.png "" 558 "height =" 416 "/>

28. Start Installation

650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/19524521a-17.png "" 558 "height =" 416 "/>

29. A prompt box will pop up asking to run u01/oraInventory/oraInstRoot. sh and/u01/oracle/root. sh. The installation will end after the ROOT user executes these two files.
650) this. width = 650; "style =" background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; border-top: 0px; border-right: 0px; padding-top: 0px "title =" image "border =" 0 "alt =" image "src =" http://www.bkjia.com/uploads/allimg/131229/1952454319-18.png "" 558 "height =" 428 "/>

This article is from the "Technical blog" blog, please be sure to keep this source http://tianzt.blog.51cto.com/459544/929838

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.