\t \t One. Installation Installation centos6.5 x86 centos 6 x86, select desktop, select " Development " tick " tools " and " add-on development " two. Memory 2G, swap partition 4200M II. 1. ora required libraries installed installation system package rpm -q binutils-2.20.51.0.2 compat-libcap1 compat-libstdc ++ - 4.4.7 glibc-2.12 glibc- - 33-3.2.3 gcc-4.4.7 gcc-c ++ Devel-2.12 libgcc libstdc++- libstdc++-devel libgcc libstdc++- libstdc++-devel libaio-0.3.107 libaio-devel-0.3.107 make-3.81 sysstat-9.0.4 missing three rpm -ivh compat-libcap1-1.10-1.i686 .rpm compat-libstdc++-33-3.2.3-69.el6.i686.rpm libaio-devel-0.3.107-10.el6.i686.rpm2. Install database driver package rpm -q unixODBC-2.2.14 unixODBC-devel -2.2.14rpm -ivh unixODBC-2.2.14*.rpm unixODBC-devel-2.2.14*.rpm3. Install the ksh package. According to the official documentation, the ksh package is installed incorrectly. The version may be too high and incompatible. Wget ftp://sdgtxuyong:
[email protected]/tools/database/oracle11/ksh-20100621-18.el5.i386.rpmwget ftp://sdgtxuyong:
[email protected]/tools/database/oracle11/pdksh- 5.2.14-37.el5_8.1.i386.rpmrpm -ivh ksh-20100621-18.el5.i386.rpmrpm -ivh pdksh-5.2.14-37.el5_8.1.i386.rpm4. Install fonts to resolve installation time Chinese garbled lack of " easy to Times New Roman 18030 " v2.01mkdir -p /usr /share /fonts /zh_CN /TrueTypecd /usr /share /fonts /zh_CN /TrueTypewget ftp: //sdgtxuyong:
[email protected]/tools/database /oracle11/zysong.ttf5. Close iptableschkconfig iptables offchkconfig ip6tables off three. Modify the centos kernel 1. Modify the control file vim /etc/sysctl.confkernel.shmmni = 8192kernel.sem =250 32000 100 128fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 10485762. Modify the license file vim /etc/security/limits.conf* soft nproc 2047* hard nproc 16384* soft nofile 1024* hard nofile 655363 modifying login security file vim /etc/pam.d/loginsession required pam_limits.so4. modify selinuxvim /etc /selinux /configSELINUX = disabled5. modify the host name vim /etc /hosts delete all other entries, leaving only a 192.168.7.72 Ora.tralinhotel.cn ora four. Create user groups and directory structures, etc. 1. Create users and groups, and set passwords groupadd oinstallgroupadd dbagroupadd opergroupadd asmadminuseradd -g oinstall -G dba,oper,asmadmin oraclepasswd oracle2.Build directory structure mkdir -p /u01/app/oracle/product/11.2.0/mkdir /u01/oradatachmod -R 755 /u01chown -R oracle.oinstall /u013.Modify the environment variable vim /home/oracle/.bash_profileexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME =$ORACLE_BASE/product/11.2.0/export ORACLE_SID=oraexport PATH=$PATH:$ORACLE_HOME/bin:/usr/local/sbin:/usr/local/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/Lib:/usr/local/libexport CLASS_PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport LANG="zh_CN.UTF-8"export ORACLE_TERM=vt100if [ $USER = "oracle" ] ; Thenif [ $SHELL = "/bin/ksh" ] ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi4. Immediately effective in the terminal running /sbin/sysctl -p five. Installation ora11g2r1 download ora11g2rsu - oraclewget ftp: //sdgtxuyong:
[email protected]/tools/database/oracle11/linux_11gR2_database_1of2.zipwget ftp: //sdgtxuyong:
[email protected]/tools/database/oracle11/linux_11gR2_database_2of2.zipunzip linux_11gR2_database_1of2 .zipunzip linux_11gR2_database_2of2.zip2. To the ui interface, open xhost+xhost +3 with root. Install ora11g2rsu - oraclecd database./runInstaller4. Modify the partition size of tmpfs vim /etc/fstabtmpfs default, size=6g 0 0 6. Install sqlplus page flipping program and help patch 1.sqlplus page flipping program wget ftp://sdgtxuyong:
[email protected]/tools/database/oracle11/rlwrap-0.37.tar.gztar zxvf rlwrap-0.37.tar.gz. /configuremake && make install write user environment variable # echo 'alias sqlplus="rlwrap sqlplus"'" /home/oracle/.bash_profile2.Install help help login with system@?/sqlplus/admin/help/hlpbld .sql helpus.sql usage: help shutdown3. Certificate bug, browser prompt key length is too short, can not use the web version management certutil -setreg chain\\minRSAPubKeyBitLength 512 seven. Self-starting script (###to be continued) eight. Commonly used command sqlplus /as sysdba1. Open and close startup nomount mount openalter database mount openshutdown immediate2. Listening service lsnrctl3. Open oem monitoring command emctl start