DIY CentOS-6.5 installation oracle11g R2

Source: Internet
Author: User
Tags dba

Self-created:

Step 1 Modify the host name

[Email protected] ~]# sed-i "s/hostname=localhost.localdomain/hostname=oracledb/"/etc/sysconfig/network

[Email protected] ~]# hostname oracledb

Step 2 Add host name and IP corresponding record

[Email protected] ~]# vi/etc/hosts

192.168.204.128 OracleDB

Installation:

Step One: Check if the RPM packages required to install Oracle are present

Check that the RPM Package command required to install Oracle is: RPM-Q the specified RPM package.

The RPM packages you need to check are as follows:

  1. Binutils-2.17.50.0.6
  2. Compat-libstdc++-33-3.2.3
  3. Elfutils-libelf-0.125
  4. Elfutils-libelf-devel-0.125
  5. Elfutils-libelf-devel-static-0.125
  6. GCC-4.1.2
  7. gcc-c++-4.1.2
  8. glibc-2.5-24
  9. glibc-common-2.5
  10. glibc-devel-2.5
  11. glibc-headers-2.5
  12. Kernel-headers-2.6.18
  13. Ksh-20060214
  14. Libaio-0.3.106
  15. Libaio-devel-0.3.106
  16. LIBGCC-4.1.2
  17. Libgomp-4.1.2
  18. LIBSTDC++-4.1.2
  19. LIBSTDC++-devel-4.1.2
  20. Make-3.81
  21. pdksh-5.2.14-1.i386.rpm
  22. Sysstat-7.0.2
  23. unixodbc-2.2.14-12.el6_3.i686.rpm
  24. unixodbc-devel-2.2.14-12.el6_3.i686.rpm

If the above RPM packages are not installed, please find these packages in the ISO file of CentOS5.5 and upload them to the Linux system.

Step Two: Configure the Oinstall Group

Configure the Oinstall group with the following command:

    1. /user/sbin/groupadd oinstall
    1. /user/sbin/Groupadd dba
    2. /user/sbin/groupadd oper

Step four: Create a user Oracle and authorize

Create the user Oracle and authorize the command as follows:

Useradd -G oinstall -G DBA, oper Oracle

Step five: Set the password for the Oracle user

Set the password for the Oracle user, with the following command:

    1. passwd Oracle

Step six: Determine that the nobody user does not exist

To determine that the nobody user does not exist, the command is as follows:

    1. ID Nobody

Step Seven: Edit the sysctl.conf file

Edit the sysctl.conf file with the following command:

    1. VI /etc/sysctl. conf

Add the following content:

  1. Kernel. sem = 32000
  2. FS. File-max = 6815744
  3. NET. IPv4. Ip_local_port_range = 9000 65500
  4. NET. Core. Rmem_default = 262144
  5. NET. Core. Rmem_max = 4194304
  6. NET. Core. Wmem_default = 262144
  7. NET. Core. Wmem_max = 1048576
  8. FS. AIO-max-nr = 1048576

Step eight: Make kernel parameters effective immediately

    1. Sysctl- P

Step nine: Edit the limits.conf file

Use VI to edit the limits.conf file with the following command:

    1. VI/etc/security/limits. conf

Add the following content:

    1. Oracle Soft Nproc 2047
    2. Oracle Hard Nproc 16384
    3. Oracle Soft nofile 1024x768
    4. Oracle Hard Nofile 65536

Step Ten: Edit the Login file

To edit the login file using VI, the command is as follows:

    1. VI /etc/pam. D/login

Add the following options:

    1. Session required Pam_limits. so

Step 11: Create a folder to install Oracle

Create the folder where Oracle is installed, with the following command:

    1. mkdir -p /opt/db/oracle

Step 12: Change Permissions

To change permissions, the command is as follows:

    1. Chown- R Oracle:oinstall /opt/db/oracle
    2. chmod- R 775 /opt/db/oracle

Step 13: Edit Profile

  1. [Email protected] ~]# vi /etc/profile
  2. If [$USER = "Oracle"]; Then
  3. If [$SHELL = "/bin/ksh"]; Then
  4. Ulimit- P 16384
  5. Ulimit- P 65536
  6. Else
  7. Ulimit- u 16384- n 65536
  8. Fi
  9. Umask 022
  10. Fi

Step 14: Edit the. bash_profile file

  1. PATH= $PATH:$HOME/bin; Export PATH
  2. Oracle_base=/opt/oracle; Export oracle_base
  3. Oracle_home= $ORACLE _base/db01; export oracle_home
  4. Oracle_sid=testdb; Export Oracle_sid
  5. PATH=$ORACLE _home/bin: $PATH:$HOME/bin; Export PATH
  6. DISPLAY=192.168.1.88:0.0; Export DISPLAY

Run: source. Bash_profile #立即生效

Step 15: Upload Oracle to/OPT directory

Log in as root or assign/OPT permissions to Oracle:

    1. Chown- R Oracle:oinstall /opt/db/oracle

Step 16: Check the upload status

To view the upload situation, the command is as follows:

    1. CD /opt
    2. Ls

Step 17: Unzip the uploaded Oracle installation package

After uploading, use the unzip command to extract the Oracle installation package (if you do not assign/OPT permissions to Oracle then it will not be able to extract), unzip the command as follows:

    1. Unzip linux_11gr2_database_1of2. zip
    2. Unzip linux_11gr2_database_2of2. zip
    3. Run the script./Runinstaller

After the installation is complete, you will be prompted to execute the following two scripts

Log in with the root user and execute the script in the following two directories


Script path

/opt/oracle/orainventory/orainstroot.sh

/opt/oracle/app/product/11.2.0/dbhome_1/root.sh

Verify

After installation, verify, use system user login, query v$tablespace Name field.

DIY CentOS-6.5 installation oracle11g R2

Related Article

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: info-contact@alibabacloud.com 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.