oracle11gr2+centos6.3 Database Installation

Source: Internet
Author: User

First, install the necessary operating system installation package
The recommended practice is to maximize the installation when installing the operating system, as the current hardware is negligible for maximizing the impact of the installation on the database server, so you can maximize the installation to avoid adding unnecessary hassles to yourself.

If you do not have a maximized installation, use Yum for an online update installation to ensure that the server is connected properly, based on an Oracle official documentation or a hint that the package is missing from the installation process. Such as:

Yum Install gcc++

ii. New Oracle Users and user groups

#/usr/sbin/groupadd oinstall#/usr/sbin/groupadd dba#/usr/sbin/useradd-g oinstall-g dba Oracle          (#/usr/sbin/userm OD-G oinstall-g dba Oracle) # passwd Oracle

Third, create the installation directory

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

Iv. Modify the corresponding configuration file
Root User Login Modification:

VIM/ETC/SYSCTL.CONFFS.AIO-MAX-NR = 1048576 Fs.file-max = 6815744 Kernel.shmall = 2097152 Kernel.shmmax = 536870912 kernel . Shmmni = 4096 Kernel.sem = 32000, 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  1024x768 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

Five, oracle11g graphical installation
Copy the oracle11g installation package to the corresponding directory, such as/home/oracle/, in performing the decompression to the database folder;
Performing the installation: $/home/oracle/database/runinstaller
If a failed installation package appears while checking the installation package, install it again with the Yum command, and then re-install the database 11g after the installation package is complete.
At the end of the installation, follow the prompts to execute two scripts under root.

Vi. after the installation is complete, configure the database listener and the local database service, firewall

$ netmgr$ netca$ dbca# Setup to configure the corresponding firewall port, or directly turn off the firewall PL/SQL Connectivity Test ...

vii. Oracle Service Auto-start configuration

1. Root user modify Oratab#vi/etc/oratabxx:/opt/oracle/11.2.0:y (n to Y)    --------xx for DB instance name esc:wq! save User modification Dbstart , Dbshut#vi/opt/oracle/11.2.0/bin/dbstartoracle_home_listner= $ORACLE _home (formerly $ $) esc:wq! Save #vi/opt/oracle/11.2.0/ Bin/dbshutoracle_home_listner= $ORACLE _home (formerly $ $) esc:wq! Save 3.root User Add content to rc.local #vi/etc/rc.d/ Rc.local Add the following to the file Su-oracle-c  "lsnrctl start" su-oracle-c  "Dbstart" esc:wq! save 4. Restart #reboot

oracle11gr2+centos6.3 Database Installation

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: 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.