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