Shulou(Shulou.com)06/01 Report--

Foreword:

Recently in the study of oracle, here I record the installation and configuration process, according to my method step by step basically no problem, if there is a problem, you can leave a message to discuss and learn from each other.

Installation environment and version:

System version: Redhat 6.5

Oracle version: 11.2.0.4.0

Virtual machine version: Vbox 5.0.2

Configuration requirements:

The suitable size of 1.5 gigabytes memory swap is 2G.

When selecting services, it is recommended to select all, turn off the firewall, and turn off selinux.

I. preparation of the environment before installation

1. To install Oracle server software, you need to install the following software packages (try to configure yum installation, so as to save time)

Yum-y install binutils

Yum-y install compat-libstdc++

Yum-y install glibc

Yum-y install elfutils-libelf

Yum-y install elfutils-libelf-devel

Yum-y install libaio

Yum-y install libgcc

Yum-y install libstdc++

Yum-y install make

Yum-y install compat-libcap1

Yum-y install gcc

Yum-y install gcc-c++

Yum-y install glibc-devel

Yum-y install libaio-devel

Yum-y install libstdc++-devel

Yum-y install sysstat

2. Configure / etc/hosts to correspond the host to the IP (if this is not configured, an error will be reported after the installation)

3. Create and view the users and groups required by oracle

Groupadd-g 310 dba # create dba group

Groupadd-g 311 oinstall # create oinstall group

Mkdir / home/db/oracle # create an oracle user home directory

Useradd-u 500-g oinstall-G dba-d / home/db/oracle oracle # create an oracle user and specify a home directory

Cp / etc/skel/.* / home/db/oracle # copy the environment variable configuration file

Chmod-R 755 oracle:oinstall / home/db/oracle # assign user rights

4. Check whether the nobody user exists. It exists by default.

5. Configure user password

6. Use chkconfig to shut down some unnecessary services, such as:

NetworkManager

Cups

Ip6tables

Postfix

Wait

In principle, if you don't use it, you can close it.

7. Close selinux and iptables

Iptables-F

Iptables-x

Edit / etc/selinux/config, status changes to disabled

8. Modify the / etc/sysctl.conf file and add the following:

# Oracle SETTING

Fs.aio-max-nr = 4194304

Fs.file-max = 6815744

Kernel.shmall = 16777216

Kernel.shmmax = 68719476736

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

Vm.swappiness = 100

Enter the following command to take effect

# sysctl-p

9. Edit / etc/pam.d/login and add the following

# ORACLE SETTING

Session required pam_limits.so

10. Edit / etc/security/limits.conf and add the following

Oracle soft nproc 16384

Oracle hard nproc 16384

Oracle soft nofile 65536

Oracle hard nofile 65536

Oracle soft stack 10240

11. When editing oracle user environment variables, you need to note that the language character sets of different hosts are slightly different.

Where 1 indicates the location where the oracle software is installed, and 2 indicates SID, which is generally the same as the name when building the library.

Note:

I installed the software in the home directory of the oracle user. If there is a prompt, just confirm it directly.

12. Upload the oracle software to the / tmp directory, give oracle permission, and end up with the following figure

Chown oracle:oinstall-R / tmp/database

Chmod + x-R / tmp/database

Second, start to install oracle software. Through the preparation of many previous steps, we can finally start. Are you very happy?

The xmanager software installed and used here, if it is troublesome for the system to install the desktop, it can be executed at the desktop terminal

1. Execute. / runInstaller under the database directory, remove the tick, and then click next.

This step is to configure the security center, which can be updated online and requires the database server to be able to link to the external network.

2. The next page is the relevant settings for the software patch. Select skip software updates to take the next step.

3. Installation options. It is strongly recommended that you choose install database software only to separate software installation from database creation:

4. This document is the creation of a single instance database, so choose to install only the database software.

5. The next page is the choice of product language. This is not a database character set. Choose English is enough. Of course, it doesn't matter if you want to choose Simplified Chinese:

6. The next step is the choice of database software version. Choose the enterprise version according to our needs

7. Install the directory configuration page. If the environment variable $ORACLE_BASE has been set, the directory here will be generated automatically.

8. Create a product inventory and record which oracle products have been installed

9. Sysdba and sysoper permissions will be granted to two operating system user group members who log in to the database through operating system authentication, where the sysoper permission is actually a subset of sysdba. If we created the dba and oper user groups earlier, the default values here will be dba and oper, respectively, but the sysoper permission usually does not need to be set extra, so we did not create this user group before, so the Database Operator Group here is empty. You can also choose other groups such as dba: users of the oinstall group have the right to execute sqlplus to access the database.

10. When you enter the installation test, swap and ip_local_port_rane alarm are prompted here, and you can repair the installation during reconstruction detection.

Of course, this warning can also be ignored by ignore, or the kernel parameter can be modified manually.

Click to start the installation

12. If the previous installation prerequisites meet the requirements, or if no major problems are detected, then the actual installation process will be very smooth.

At the end, the following window pops up, prompting you to use root to complete the execution of the following two scripts:

13. Use root users to execute the above two scripts

Sh / home/db/orainventory/orainstRoot.sh

Sh / home/db/oracle/product/11.2.0/dbhome_1/root.sh

14. Click close to complete the installation on the interface where the installation is completed successfully:

Now that the Oracle 11g software has been installed, you can create the database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.