CentOS6.6 install Oracle11gr2

CentOS6.6 install Oracle11gr2

When I first learned about Oracle and installed Oracle, my resume was so bumpy that I had taken a lot of detours. I also learned about Oracle for a while to close up this article, this article describes the installation and Database Configuration of Oracle Database11g Enterprise Edition Release 11.2.0.1.0-64bit Production on CentOS6.6, the creation of a vmvm, operating system installation, database installation, and installation of tools and software related to Oracle are illustrated in the text.

This article is complete in the following environments:

Windows 7 flagship edition Sevice Pack 1 memory 6G

VMware Workstation 11.0.0

CentOS-6.6-x86_64-bin-DVD1.iso

The Oracle11GR2 software can be downloaded from the Oracle official website.

Linux.x64_11gR2_database_1of2.zip

Linux.x64_11gr2_databasesilicate f2.zip

Xmanager Enterprise 5 (Build 0436)

1. Create a vm in the vm

Step 1: select Custom (advanced)

Step 2: Default

Step 3: Install the operating system later

Step 4: Linux (L) CentOS 64

Step 5: The Virtual Machine name, which can be obtained at will and the location can be used as long as there is free disk space.

Step 6: according to the actual situation of the physical computer, my notebook is a 4-core CPU

Step 7: memory configuration. The minimum value is 1 GB. 2 GB is recommended. My physical memory is 6 GB and 2 GB is allocated here.

Step 8: Use the Host Mode Network

Step 9: Default I/O type

Step 10: Default SCSI for Virtual Disk Type

Step 2: Create a new Virtual Disk

Step 5: store the virtual disk as a single file at a maximum disk size of 50 GB

Step 2: Default

Step 2: View Summary completed

Step 2: configure the virtual machine settings, select the operating system installation media, select CD/DVD (IDE) On the right side, use the ISO image file, and find the ISO of CentOS6.6.

Now the vm configuration is complete ~~~~~~~~~~~~~~~~

2. Operating System Installation

Step 1: open an account for this virtual machine

Step 2: Install or upgrade on existing system

Step 3: Check whether the installation media Skip is tested

Step 4: Next

Step 5: select the language. Here, select Chinese (Simplified ))

Step 6: select the American English style as the keyboard

Step 7: select a storage device

Step 8: because the system is installed on a virtual disk, select YES to ignore all data.

Step 9: by default, the host name is set after the system is installed.

Select the time zone in step 10, Shanghai. Do not select the system clock to use UTC time.

Step 2: Set the operating system root Password

Step 2: ask how to create a disk partition and create a custom Layout

Step 2: Create a partition. A boot partition is 13th M, a root (/) partition is 40G, a tmp partition is 10G, and a swap partition is 200 M, the swap partition is too small. If the swap of Oracle 11G r2 is required to have 1 GB to 2 GB physical memory, the swap is 1.5 times the physical memory. If there is 2 GB to 16 GB physical memory, swap is equal to physical memory. here, I intentionally allocated the swap, and then added the swap size. We recommend that you assign the swap size to a larger value based on the document. You can assign a larger value for installation. you don't need to add swap in the future.

Step 2: Default

Step 2: select the installed Server type Basic Server

Step 2: Start Installation

Step 2: Install and reboot

3. installation environment Configuration

Network Configuration: the network configuration depends on the Virtual Machine network configuration. When installing the vm, we select only the host, so we only need

Set the IP address and subnet mask, and restart the network interface to log on using ssh.

4. Use ssh in xmaanger xshell to connect to Centos. Fill in the username and password, and the cute interface will pop up.

5. Upload the required software for Oracle Installation. On the xshell interface, click "Create File Transfer" and select the file to be uploaded.

The following is the software we just uploaded. If you don't know what it is for, google

6. To facilitate software installation, You need to configure the yum source. The packages required by Oracle are basically included in the ISO file of the installation disc, so you only need to configure

Local yum, so you have to upload the CentOS installation Image

# Mkdir/cdrom

# Mount-t iso9660-o loop/software/CentOS-6.6-x86_64-bin-DVD1.iso/cdrom

# Echo '/software/CentOS-6.6-x86_64-bin-DVD1.iso/cdrom/iso9660 loop 0 0'>/etc/fstab

# Cd/etc/yum. repos. d/

# Rm-rf *

# Vim cdrom. repo add

[Cdrom]

Name = cdrom

Baseurl = file: // cdrom

Enabled = 1

Gkgcheck = 1

Gpgkey = file: // etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6

# Yum clean all

# Yum makecache all

7. install some basic Linux Development Kits

# Export LANG = en_US.UTF-8

# Yum grouplist

The export command is used to set the current session language environment to English, because the next command yum grouplist is too ugly to list the software package group as Chinese.

# Yum groupinstall-y "Desktop Platform Development" "Development tools" "Compatibility libraries"

To make the Oracle Installation interface appear on our local desktop, We have to install

Yum-y install TPD

Yum-y install xdpyinfo

8. Preparations for Oracle Installation

Oracle official documentation location:

Http://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm

# Groupadd oinstall

# Groupadd dba

# Useradd-g oinstall-G dba oracle

# Id oracle

Uid = 500 (oracle) gid = 500 (oinstall) groups = 500 (oinstall), 501 (dba)

# Mkdir-p/u01/app/oracle

# Chown-R oracle. oinstall/u01

# Chmod-R 775/u01

No one understands these commands.

Configure Kernel Parameters and resource limits

# Vim/etc/sysctl. conf

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

# Sysctl-p

Change shell limits

# Vim/etc/security/limits. conf

Oracle soft nproc 2047

Hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

You must also add the following content to vim/etc/pam. d/login.

# Vim/etc/pam. d/login

Session required/lib/security/pam_limits.so

Change logon script

Add the following content to/etc/profile

If [$ USER = "oracle"]; then

If [$ SHELL = "/bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

# Unzip linux.x64_11gR2_database_1of2.zip-d/tmp/

# Unzip linux.x64_11gR2_database_1of2.zip-d/tmp/

# Chown-R oracle. oinstall/tmp/database/

Solution to garbled oracle Installation Interface

Mkdir-p/usr/share/fonts/zh_CN/TrueType

[Root @ Oracle ~] # Cp/software/zysong. ttf/usr/share/fonts/zh_CN/TrueType

Add the ing between the host name and IP address to the/etc/hosts file. Otherwise, an error occurs during installation.

# Echo '1970. 168.23.200 Oracle. Study '>/etc/hosts

Add a new swap partition with a size of 10 and a partition type of 82

# Fdisk/dev/sdb

# View the current situation of swap in swapon-s

# Mkswap/dev/sdb1 set swap

# Swapon/dev/sdb1

[Root @ Oracle ~] # Swapon-s

Filename Type Size Used Priority

/Dev/sda5 partition 1021948 0-1

/Dev/sdb1 partition 10490408 0-2

Mount on and set priority

# Vim/etc/fstab

# Echo "/dev/sdb1 swap defaults, pri = 1 0 0">/etc/fstab

Pri is the priority, and the newly added swap is displayed.

After the configuration is complete, the next step is to start Oracle Installation. You must restart the machine before the next step.

9. Oracle Installation

# Xhost +

Access control disabled, clients can connect from any host

# Su-oracle

$ W

19:34:08 up 6 min, 1 user, load average: 0.11, 0.08, 0.03

User tty from login @ IDLE JCPU PCPU WHAT

Root pts/0 192.168.23.1 0.00 s 0.19 s 0.00 s w

$ Export DISPLAY = 192.168.23.1: 0.0

$ Cd/tmp/database/

$./RunInstaller

The following cute Chinese graphic interface came out:

Only install database software

Single-instance Database Installation

Default

Enterprise Edition

Installation location

Base Directory:/u01/app/oracle

Software location:/u01/app/oracle/product/11.2.0/db_1

Create a product list

Privileged operating system group: Default

Run the prerequisite check: only 64-bit packages need to be installed here, and 32-bit packages can be ignored

# Yum-y install elfutils-libelf-devel unixODBC-devel libaio-devel

# Cd/software/

# Yum localinstall pdksh-5.2.14-37.el5_8.1.x86_64.rpm

Start installation:

Installation Process:

Run the following two scripts as the root user:

Installation completed:

10. Add environment variables for oracle users

Export ORACLE_BASE =/u01/app/oracle

Export ORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1

Export PATH = $ ORACLE_HOME/bin: $ PATH

Export LD_LIBRARY_PATH $ ORACLE_HOME/lib:/usr/lib64

Now that the Oracle installation is complete, you need to create a database instance.
Http://werewolftj.blog.51cto.com/1606482/1630684