rhel7.4 Installing Oracle 11G

first, the operating system

Red Hat 7.4

Oracle Database version

11.2.0.4

The corresponding file

P13390677_112040_linux-x86-64_1of7.zip-database Software

P13390677_112040_linux-x86-64_2of7.zip-database Software

IP Address Planning:

DNS server:192.168.1.168

IP Address: 192.168.1.212

Second, the basic configuration

1. Modify the host name:

Vi/etc/hostname configuration file or Hostnamectl set-hostname < computer name >a:redhat-212b:redhat-214

2. Dynamic IP modified to static IP

cd/etc/sysconfig/network-scripts/bootproto= "Static" #dhcp改为static

3, modify the network card configuration:

#vi/etc/sysconfig/network-scripts/ifcfg-ens32type=ethernetproxy_method=nonebrowser_only=nobootproto= Staticipaddr=192.168.1.212netmask=255.255.255.0gateway=192.168.1.1dns1=192.168.1.168defroute=yesipv4_failure_ Fatal=noipv6init=noipv6_autoconf=yesipv6_defroute=yesipv6_failure_fatal=noipv6_addr_gen_mode= Stable-privacyname=ens32uuid=8e974238-8aa9-486a-8e02-8f844afc767edevice=ens32onboot=yeszone=public

If DNS is configured at the end of the NIC, you can configure the resolv.conf file

#vim/etc/resolv.confnameserver 218.2.2.2

Restart the network card:

Systemctl Restart Network.service

4. Close the firewall directly

Systemctl Stop Firewalld.service #停止firewallsystemctl disable Firewalld.service #禁止firewall开机启动

5. Turn off SELinux

#vim/etc/selinux/config Modify file selinux=disabled temporarily close #setenforce 0

Third, the Software environment configuration

1. Oracle's Essential development tools

#yum-y install glibc \glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make Sysstat Unixodb C unixodbc-devel pdksh compat-libcap1 compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ smartmontools pdksh COMPAT-LIBSTDC Cvuqdisk

If the swap space is not enough, you can use the following command to increase:

DD If=/dev/zero of=/test bs=1g count=4mkswap-f/testswapon/testfree-m

2, modify the operating system core parameters

Under root user, perform the following steps:

1) Modify the user's shell limit, modify the/etc/security/limits.conf file

Input command: vi/etc/security/limits.conf, press I to enter edit mode, add the following content to the file.

Vi/etc/security/limits.conforacle soft Nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 65536

2) Modify the/etc/pam.d/login file, enter the command: Vi/etc/pam.d/login, press the I key to enter the editing mode, the following content to join the file.

Vi/etc/pam.d/loginsession Required Pam_limits.so

3) Modify the Linux kernel, modify the/etc/sysctl.conf file, enter the command: vi/etc/sysctl.conf, press the I key to enter the editing mode, add the following content to the file

#vim/etc/sysctl.conf Fs.aio-max-nr = 1048576 Fs.file-max = 6815744 Kernel.shmall = 1073741824 Kernel.shmmax = 43980465 11104 Kernel.shmmni = 4096 Kernel.sem = [32000] net.ipv4.ip_local_port_range = 9000 65500 Net.core.rmem_defa Ult = 262144 Net.core.rmem_max = 4194304 Net.core.wmem_default = 262144 Net.core.wmem_max = 1048576

Note: The sysctl.conf file has the following two parameters, remember to comment out

#kernel. Shmmax#kernel.shmall

Make Sysctl Effective

#sysctl-P

3. Create Oracle Users and Groups

#groupadd Oinstall//Create Installation Group #groupadd DBA//Create Management Group #mkdir-p/OPT/APP#USERADD-G oinstall-g dba Oracle//GEN Run User (here Oracle uses default home directory/home/oracle, so no-D refers to home directory) #passwd Oracle//Set the password for Oracle users

Modify Directory Permissions:

#chown-R oracle:oinstall/opt/app#chmod 755-r/opt/app

The installation package will be ready: P13390677_112040_linux-x86-64_1of7-data1.zip p13390677_112040_linux-x86-64_ 2of7-data2.zip is placed in the Oracle User directory, making it a master and genus Group of oracle:oinstall, and extracting

Iv. installation of Oracle 11.2.0.4 software

Switch to Oracle User:

1) Configure environment variables for Oracle users

$ VI. Bash_profile Add #. bash_profile# Get the aliases and Functionsif [-F ~/.BASHRC] at the end of the file; Then. ~/.bashrcfi# User specific environment and startup Programspath= $PATH: $HOME/binexport PATH Add the following information to the end of the file: Export Oracle_ Sid=orclexport oracle_base=/opt/app/oracleexport oracle_home= $ORACLE _base/product/11.2.0/dbhome_1export LD_ Library_path= $ORACLE _home/lib:/usr/libexport path=/opt/app/oracle/product/11.2.0/dbhome_1/bin:/bin:/usr/bin:/ Usr/sbin:/usr/local/bin:/usr/x11r6/binexport path= $ORACLE _home/bin: $PATH:/SBIN/LANG=ZH_CN. UTF-8; Export LANG nls_lang= ' American_america. Al32utf8 '; #LANG =en_us.utf8; Export LANG nls_lang= ' American_america. Al32utf8 ';

2) Start the installation

#su-oracle$ Export display=ip:0.0//ip for you native ip$ xhost +$ export LANG=ZH_CN. utf-8$ CD database$./runinstaller

Run the install script on the decompression database, here and install grid, start the Installation Wizard

We do not fill in the MoS account, not networking meaningless, click Next

We only install the database software here, click Next

Here are the options for cluster installation, one of the following 3 choices:
Select Install Single instance database software and click Next

Select product language, Simplified Chinese and English, click Next

Select database version, default Enterprise Edition, click Next

Configure the Oracle installation directory, the Setup program automatically reads the configuration, automatically selects the Oracle base directory (Oracle Base) and the software locations (software location) due to the configuration of the pre-installation environment variables, click Next

As above, the list of products (Oracle Inventory directory) is automatically selected, click Next

Keep the default, click Next

In the installation check

Post-Test point installation

Execute the following two scripts under the root user and finish the point OK

Installation Complete

V. Database Building Library

1) Input command DBCA will pop up the following screen

Create a library

Select general purpose or transaction processing

Configuring global database Names and SIDS

Configure four built-in Super admin password, recommend unified password, easy to remember

Memory allocation (check using automatic memory management)

Specifying a character Set

Create DATABASE Point completion

After a long wait, when you see this interface, the Oracle Build library is complete

VI. Installation and Monitoring

1) Input command NETCA will pop up the following screen. Create a listening service (acting as an Oracle Server for other Oracle clients to connect to this Oracle server)

2) Configure the local Network service name (acting as Oracle client, connecting to other Oracle servers)

Complete

This completes the Oracle Server installation configuration and looks at the Oracle home directory already has Listener.ora and Tnsnames.ora two files

rhel7.4 Installing Oracle 11G