Oracle11gR2 + CentOS6.3 database installation, centos6.3 installation tutorial

Oracle11gR2 + CentOS6.3 database installation, centos6.3 installation tutorial
1. install necessary OS installation packages
We recommend that you install the operating system to the maximum extent, because the impact of current hardware on the maximum installation on the database server is negligible, to avoid unnecessary trouble.

If the installation is not maximized, use yum for online update and installation according to the official oracle documents or the prompt that a package is missing during the installation process to ensure that the server can be connected to the Internet normally. For example:

yum install gcc++

2. Create oracle users and user groups

# /usr/sbin/groupadd oinstall# /usr/sbin/groupadd dba# /usr/sbin/useradd -g oinstall -G dba oracle          (# /usr/sbin/usermod -g oinstall -G dba oracle)# passwd oracle

3. Create an installation directory

# mkdir -p /home/oracle/app/# chown -R oracle:oinstall /home/oracle/app/# chmod -R 775 /home/oracle/app/

4. Modify the corresponding configuration file
Root User Logon modification:

vim /etc/sysctl.conffs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 --------------------------------------vim /etc/security/limits.conforacle                   soft      nproc     2047 oracle                   hard      nproc     16384oracle                soft     nofile  1024 oracle                hard     nofile  65536 oracle                soft     stack    10240

Switch to oracle user modification:

vim .bash_profilePATH=$PATH:$HOME/binexport ORACLE_BASE=/home/oracle/app/oracleexport ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1export ORACLE_SID=ahqyexport umask=022export PATH=$PATH:$ORACLE_HOME/binexport NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"source .bash_profile

5. graphical installation of oracle11g
Copy the Oracle11g installation package to the corresponding directory, for example,/home/oracle/. decompress the package to the Database folder;
Install: $/home/oracle/database/runInstaller
If an installation package fails during the check of the installation package, run the yum command again to install the package. After the installation package is complete, run the database 11g again.
At the end of the installation, execute the script under root as prompted.

6. After the installation is complete, configure the Database Listener and the local database service and Firewall

$ Netmgr $ netca $ dbca # setup configure the corresponding firewall port, or directly turn off the firewall pl/SQL connectivity test...

VII. ORACLE service Automatic startup configuration

1. the root user changes oratab # vi/etc/oratabxx:/opt/oracle/11.2.0: Y (N is changed to Y) -------- xx is the database instance name Esc: wq! Save 2. oracle users modify dbstart, dbshut # vi/opt/oracle/11.2.0/bin/dbstartORACLE_HOME_LISTNER = $ ORACLE_HOME (originally $1) Esc: wq! Save # vi/opt/oracle/11.2.0/bin/dbshutORACLE_HOME_LISTNER = $ ORACLE_HOME (originally $1) Esc: wq! Save 3. the root user adds the content to rc. # vi/etc/rc. d/rc. local Add the following content to the file: su-oracle-c "lsnrctl start" su-oracle-c "dbstart" Esc: wq! Save 4. Restart # reboot