CentOS5.2x86 Oracle11gR2 Installation notes

CentOS5.2x86 Oracle11gR2 Installation notes

CentOS 5.2x86 install Oracle 11g R2 notes

1. Install CentOS
2. Install the library required by ora
3. Modify the centos Kernel
4. create user groups and directory structures
5. Install ora11g2r
6. Install the SQL plus paging program and help patch
7. self-starting script
8. Common commands

1. Install CentOS 5.2 32bit.
1. 2 GB of memory, 3 GB of Swap partition (3200 MB is about 1.5 times the memory target error is reported, and the value is adjusted to 4500 MB to be tested)
2. In the application, do not select "office/efficiency rate", "games and entertainment", "Video and Audio"
3. In development, check "development tools" and "Development Database" (after this check box is selected, 3 packages are missing)
4. Disable Selinux and iptables
5. Install the vmware Enhancement Tool and set the resolution to 1024*768
6. Load the optical drive mount-r/dev/hdc/media (mount the optical drive in read-only mode) umount/dev/hdc

2. Install the library required by ora
1. Mount the CentOS installation disk
2. Check whether the package is installed.
Rpm-q binutils-2.17.50.0.6 compat-libstdc ++-33-3.2.3 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 glibc-2.5-24 glibc-common-2.5 gcc-c ++-4.1.2 glibc-devel-2.5 glibc-headers-2.5 ksh-20060214 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.2 kernel-headers-2.6.18 libgomp-4.1.2 libstdc ++- 4.1.2 libstdc ++-devel-4.1.2 make-3.81 sysstat-7.0.2

3. Install the library package
Three missing
Rpm-ivh compat-libstdc ++-33-3.2.3 *. rpm libaio-devel-0.3.106 *. rpm sysstat-7.0.2 *. rpm

4. Install the database driver
Rpm-q unixODBC-2.2.11 unixODBC-devel-2.2.11
Rpm-ivh unixODBC-2.2.11 *. rpm unixODBC-devel-2.2.11 *. rpm

5. Installation Package
Yum install pdksh
(Vim/etc/yum. conf keepcache = 1 changed to save the download package ksh-20100621-18.el5.i386.rpm pdksh-5.2.14-37.el5_8.1.i386.rpm
)

3. Modify the Linux Kernel

1. Modify the control file
Vim/etc/sysctl. conf

Kernel. shmmni = 8192
Kernel. sem = 250 32000 100 128
Fs. file-max = 6815744
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 4194304
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048576
Fs. aio-max-nr = 1048576

2. Modify the license file
Vim/etc/security/limits. conf

* Soft nproc 2047
* Hard nproc 16384
* Soft nofile 1024
* Hard nofile 65536

3. Modify the login security file
Vim/etc/pam. d/login

Session required pam_limits.so

4. Modify selinux (modified, check)
Vim/etc/selinux/config

SELINUX = disabled

5. Modify the Host Name

Vim/etc/hosts delete all other entries and leave only one

192.168.7.72 ora.tralinw..cn ora

4. create user groups and directory structures
1. Create users and groups and set passwords

Groupadd oinstall
Groupadd dba
Groupadd rule
Groupadd asmadmin
Useradd-g oinstall-G dba, role, asmadmin Oracle
Passwd oracle

2. Create a directory structure
Mkdir-p/u01/app/oracle/product/11.2.0/
Mkdir/u01/oradata
Chmod-R 755/u01
Chown-R oracle. oinstall/u01

3. Modify Environment Variables
Vim/home/oracle/. bash_profile

Export TMP =/tmp
Export TMPDIR = $ TMP
Export ORACLE_BASE =/u01/app/oracle
Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/
Export ORACLE_SID = ora
Export PATH = $ PATH: $ ORACLE_HOME/bin:/usr/local/sbin:/usr/local/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/local/lib
Export CLASS_PATH = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib
Export LANG = "zh_CN.UTF-8"
Export ORACLE_TERM = vt100
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi

4. takes effect immediately
Run/sbin/sysctl-p on the terminal

5. Install oracle 11g2r
1. Download ora11g2r
Su-oracle
Wget ftp: // sdgtxuyong: xxxxx@192.168.7.66/tools/database/oracle11/linux_11gR2_database_1of2.zip
Wget ftp: // sdgtxuyong: xxxxx@192.168.7.66/tools/database/oracle11/linux_11gr2_databasesilicate f2.zip
Unzip linux_11gR2_database_1of2.zip
Unzip linux_11gr2_database204 f2.zip

2. Go to the ui and use root to enable xhost +
Xhost +

3. Install ora11g2r
Su-oracle
Cd database
./RunInstaller

4. Modify the size of the tmpfs partition (the system prompts that the xx buffer is too small. It has been installed three times in centos6 and no error is reported, but an error is reported in centos5)
Vim/etc/fstab

Tmpfs default, size = 6g 0 0

6. Install the SQL plus paging program and help patch
1. sqlplus paging Program
Wget ftp: // sdgtxuyong: xxxxx@192.168.7.66/tools/database/oracle11/rlwrap-0.37.tar.gz
Tar zxvf rlwrap-0.37.tar.gz
./Configure

Make & make install

Write User System Variables
# Echo 'Alias sqlplus = "rlwrap sqlplus" '>/home/oracle/. bash_profile

2. Install help to log on with system
@? /Sqlplus/admin/help/hlpbld. SQL helpus. SQL
Usage: help shutdown

3. Certificate bug
Certutil-setreg chain \ minRSAPubKeyBitLength 512

VII. self-starting script (### to be continued)