Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle Linux 7.1 install Oracle 12C RAC     - MongoDB simple replication configuration (Database)

- Elasticsearch 2.20 Highlight (Server)

- Java object initialization (Programming)

- Implement Oracle dynamic registration of non-standard port 1521 (Database)

- Oracle background processes daemons (Database)

- Sniffer install applications in Linux supplement (Linux)

- Minimum period string problem (Programming)

- Xtrabackup creates a slave node without downtime (Database)

- DRBD switchover (Server)

- Linux Fundamentals of the memory management mechanism (Linux)

- Linux basic articles of the boot process (Linux)

- Sublime Text - Opens the current file in a browser (Linux)

- Linux IPTables anti-DDOS attack Shell Scripting (Linux)

- Getting the Linux shell variable test (Programming)

- Linux kernel boot to retain large memory method summary (Linux)

- Linux Beginner Guide: Installing packages on Ubuntu and Fedora (Linux)

- Oracle 11G R2 DataGuard structures (Database)

- Java, boolean operators & =, | = ^ = use (Programming)

- How to use awk command in Linux (Linux)

- Java NIO2: Buffer (Programming)

 
         
  Oracle Linux 7.1 install Oracle 12C RAC
     
  Add Date : 2018-11-21      
         
         
         
  OS environment:

[Root @ rac12c1 ~] # uname -a

Linux rac12c1 3.8.13-55.1.6.el7uek.x86_64 # 2 SMP Wed Feb 11 14:18:22 PST 2015 x86_64 x86_64 x86_64 GNU / Linux

IP Planning:

[Root @ rac12c1 ~] # cat / etc / hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

# Public IP for Oracle 12C RAC

172.16.30.221 rac12c1.localdomain rac12c1

172.16.30.222 rac12c2.localdomain rac12c2

# Private IP for Oracle 12C RAC

192.168.30.221 rac12c1pri.localdomain rac12c1pri

192.168.30.222 rac12c1pri.localdomain rac12c2pri

# Virtual IP for Oracle 12C RAC

172.16.30.223 rac12c1vip.localdomain rac12c1vip

172.16.30.224 rac12c2vip.localdomain rac12c2vip

#SCAN

172.16.30.225 rac12c-scan.localdomain rac12c-scan

Disable Selinux:

[Root @ rac12c1 ~] # cat / etc / selinux / config

# This file controls the state of SELinux on the system.

# SELINUX = can take one of these three values:

# Enforcing - SELinux security policy is enforced.

# Permissive - SELinux prints warnings instead of enforcing.

# Disabled - No SELinux policy is loaded.

SELINUX = disabled

# SELINUXTYPE = can take one of three two values:

# Targeted - Targeted processes are protected,

# Minimum -. Modification of targeted policy Only selected processes are protected.

# Mls - Multi Level Security protection.

SELINUXTYPE = targeted

[Root @ rac12c1 ~] # setenforce 0

Modify / dev / shm size of 8G

tmpfs / dev / shm tmpfs rw, exec, size = 2048M 0 0

[Root @ rac12c1 ~] # mount -o remount / dev / shm /

Disable the firewall:

[Root @ rac12c1 ~] # systemctl start firewalld.service

[Root @ rac12c1 ~] # systemctl stop firewalld.service

[Root @ rac12c1 ~] #] # systemctl disable firewalld.service

rm '/etc/systemd/system/basic.target.wants/firewalld.service'

rm '/etc/systemd/system/dbus-org.Fedoraproject.FirewallD1.service'

Restart each node operating system and check each node network connectivity:

 

[Root @ rac12c1 ~] # ping rac12c2pri

[Root @ rac12c1 ~] # ping rac12c2

,,,

Configuring YUM:

[Root @ rac12c1 ~] # cat /etc/yum.repos.d/base.repo

[Ol7_latest]

name = Oracle Linux $ releasever Latest ($ basearch)

baseurl = file: /// mnt

gpgkey = file: /// etc / pki / rpm-gpg / RPM-GPG-KEY-oracle

gpgcheck = 0

enabled = 1

Install oracle-related dependencies:

[Root @ rac12c1 ~] # yum install oracle-rdbms-server-12cR1-preinstall -y

Create user groups and users, based on the step operation created oinstall 54321 dba 54322 User Group) and user oracle (54321), so do the following to create a relevant user groups and users

Add Group

[Root @ rac12c1 ~] # groupadd -g 54323 oper

[Root @ rac12c1 ~] # groupadd -g 54325 asmdba

[Root @ rac12c1 ~] # groupadd -g 54328 asmadmin

[Root @ rac12c1 ~] # groupadd -g 54329 asmoper

Adding grid users

[[Root @ rac12c1 ~] # useradd -u 54322 -g oinstall -G dba, asmdba, asmadmin, asmoper grid

Set a password for the user oracle and grid

 

[[Root @ rac12c1 ~] #passwd oracle

[Root @ rac12c1 ~] # passwd grid

Ensure that the oracle is oper, asmdba group members

 

[Root @ rac12c1 ~] # usermod -g oinstall -G dba, oper, asmdba oracle

 Modify user resource limits: grid soft nofile 1024

 grid hard nofile 65536

 grid soft nproc 16384

 grid hard nproc 16384

 grid soft stack 10240

 grid hard stack 32768

 grid hard memlock 134217728

 grid soft memlock 134217728

#

# # Oracle user

 oracle soft nofile 1024

 oracle hard nofile 65536

 oracle soft nproc 16384

 oracle hard nproc 16384

 oracle soft stack 10240

 oracle hard stack 32768

 oracle hard memlock 13217728

 oracle soft memlock 134217728

# End of file

Modify kernel parameters,

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

[Root @ rac12c1 ~] # / sbin / sysctl -p

Installation oracleasm-support and oracleasmlib, configure the shared disks.

[Root @ rac12c1 ~] # rpm -qa | grep oracleasm

kmod-oracleasm-2.0.8-8.el7.x86_64

oracleasm-support-2.1.8-3.el7.x86_64

oracleasmlib-2.0.8-2.el7.x86_64

http://www.oracle.com/technetwork/server-storage/linux/asmlib/ol7-2352094.html download ASMLIB package.

[Root @ rac12c1 ~] # /etc/init.d/oracleasm configure -i

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver. The following questions will determine whether the driver is

loaded on boot and what permissions it will have. The current values

will be shown in brackets ( '[]'). Hitting < ENTER> without typing an

answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface [grid]: grid

Default group to own the driver interface [asmadmin]: asmadmin

Scan for Oracle ASM disks on boot (y / n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver: [OK]

Scanning the system for Oracle ASMLib disks: [OK]



 

[Root @ rac12c1 ~] # / usr / sbin / oracleasm configure

ORACLEASM_UID = grid

ORACLEASM_GID = asmadmin

ORACLEASM_SCANBOOT = true

ORACLEASM_SCANORDER = ""

ORACLEASM_SCANEXCLUDE = ""

ORACLEASM_USE_LOGICAL_BLOCK_SIZE = "false"

[Root @ rac12c1 ~] # tail -2 /etc/pam.d/login

session required /lib64/security/pam_limits.so

session required pam_limits.so

Configuring DNS:

[Root @ rac12c1 ~] # vim /etc/resolv.conf

# Generated by NetworkManager

search localdomain

Disable the NTP service:

 

[Root @ rac12c1 ~] # / sbin / service ntpd stop

[Root @ rac12c1 ~] #chkconfig ntpd off

[Root @ rac12c1 ~] #mv /etc/ntp.conf /etc/ntp.conf.org

[Root @ rac12c1 ~] #rm /var/run/ntpd.pid

Setting up an installation directory:

[Root @ rac12c1 ~] #mkdir -p /u01/app/12.1.0/grid

[Root @ rac12c1 ~] #mkdir -p / u01 / app / grid

[Root @ rac12c1 ~] #mkdir -p / u01 / app / oracle

[Root @ rac12c1 ~] #mkdir -p /u01/app/oracle/product/12.1.0/db_1[root@rac12c1 ~] #chown -R grid: oinstall / u01

[Root @ rac12c1 ~] #chown oracle: oinstall / u01 / app / oracle

[Root @ rac12c1 ~] ## chmod -R 775 / u01 /

Partition, configure the shared disks:

twenty one
twenty two
 

[Oracle @ rac12c1 ~] $ ls -l / dev / sd *

brw-rw ---- 1 root disk 8, 0 Aug 21 18:33 / dev / sda

brw-rw ---- 1 root disk 8, 1 Aug 21 18:33 / dev / sda1

brw-rw ---- 1 root disk 8, 2 Aug 21 18:33 / dev / sda2

brw-rw ---- 1 root disk 8, 3 Aug 21 18:33 / dev / sda3

brw-rw ---- 1 root disk 8, 16 Aug 22 20:27 / dev / sdb

brw-rw ---- 1 root disk 8, 17 Aug 22 20:27 / dev / sdb1

brw-rw ---- 1 root disk 8, 32 Aug 21 22:47 / dev / sdc

brw-rw ---- 1 root disk 8, 33 Aug 21 22:47 / dev / sdc1

brw-rw ---- 1 root disk 8, 48 Aug 21 22:47 / dev / sdd

brw-rw ---- 1 root disk 8, 49 Aug 21 22:47 / dev / sdd1

brw-rw ---- 1 root disk 8, 64 Aug 21 22:47 / dev / sde

brw-rw ---- 1 root disk 8, 65 Aug 21 22:47 / dev / sde1

[Oracle @ rac12c1 ~] $ /etc/init.d/oracleasm createdisk CRS / dev / sdc1

[Oracle @ rac12c1 ~] $ /etc/init.d/oracleasm createdisk DATA1 / dev / sd1

[Oracle @ rac12c1 ~] $ /etc/init.d/oracleasm createdisk DATA2 / dev / sde1

[Root @ rac12c1 ~] # /etc/init.d/oracleasm scandisks

Scanning the system for Oracle ASMLib disks: [OK]

[Root @ rac12c1 ~] # /etc/init.d/oracleasm listdisks

CRS

DATA1

DATA2

Another node, shared disk scan.

Configure the user environment variables:

[Root @ rac12c1 ~] # cat /home/grid/.bash_profile

# .bash_profile

# Get the aliases and functions

if [-f ~ / .bashrc]; then

 . ~ / .bashrc

fi

# User specific environment and startup programs

PATH = $ PATH: $ HOME / .local / bin: $ HOME / bin

export PATH

export ORACLE_BASE = / u01 / app / grid

export ORACLE_HOME = / u01 / app / 12.1.0 / grid

export ORACLE_SID = + ASM1

export PATH = $ ORACLE_HOME / bin: $ PATH

export LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib

export CLASSPATH = $ ORACLE_HOME / JRE: $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib

export DISPLAY =: 0.0

umask = 022

alias asmcmd = 'rlwrap asmcmd'

[Root @ rac12c1 ~] # cat /home/oracle/.bash_profile

# .bash_profile

# Get the aliases and functions

if [-f ~ / .bashrc]; then

 . ~ / .bashrc

fi

# User specific environment and startup programs

PATH = $ PATH: $ HOME / .local / bin: $ HOME / bin

export PATH

PATH = $ PATH: $ HOME / bin

export ORACLE_BASE = / u01 / app / oracle

export ORACLE_HOME = / u01 / app / oracle / product / 12.1.0 / db_1

export ORACLE_SID = crmdb1

export PATH = $ ORACLE_HOME / bin: $ PATH

export LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib

export CLASSPATH = $ ORACLE_HOME / JRE: $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib

export DISPLAY =: 0.0

umask = 022

export PATH

alias sqlplus = 'rlwrap sqlplus'

alias rman = 'rlwrap rman'

Cvuqdisk installation package

[Root @ rac12c1 ~] # rpm -ivh cvuqdisk-1.0.9-1.rpm
Start the installation GRID = "Software Installation Data => install the database.

[Grid @ rac12c1 rpm] $ crsctl stat res -t

-------------------------------------------------- ------------------------------

Name Target State Server State details

-------------------------------------------------- ------------------------------

Local Resources

-------------------------------------------------- ------------------------------

ora.CRS.dg

              ONLINE ONLINE rac12c1 STABLE

              ONLINE ONLINE rac12c2 STABLE

ora.DATA.dg

              ONLINE ONLINE rac12c1 STABLE

              ONLINE ONLINE rac12c2 STABLE

ora.LISTENER.lsnr

              ONLINE ONLINE rac12c1 STABLE

              ONLINE ONLINE rac12c2 STABLE

ora.asm

              ONLINE ONLINE rac12c1 Started, STABLE

              ONLINE ONLINE rac12c2 Started, STABLE

ora.net1.network

              ONLINE ONLINE rac12c1 STABLE

              ONLINE ONLINE rac12c2 STABLE

ora.ons

              ONLINE ONLINE rac12c1 STABLE

              ONLINE ONLINE rac12c2 STABLE

-------------------------------------------------- ------------------------------

Cluster Resources

-------------------------------------------------- ------------------------------

ora.LISTENER_SCAN1.lsnr

      1 ONLINE ONLINE rac12c1 STABLE

ora.MGMTLSNR

      1 ONLINE ONLINE rac12c1 169.254.109.218 192.

                                                            168.30.221, STABLE

ora.crmdb.db

      1 ONLINE ONLINE rac12c2 Open, STABLE

      2 ONLINE ONLINE rac12c1 Open, STABLE

ora.cvu

      1 ONLINE ONLINE rac12c1 STABLE

ora.mgmtdb

      1 ONLINE ONLINE rac12c1 Open, STABLE

ora.oc4j

      1 ONLINE ONLINE rac12c1 STABLE

ora.rac12c1.vip

      1 ONLINE ONLINE rac12c1 STABLE

ora.rac12c2.vip

      1 ONLINE ONLINE rac12c2 STABLE

ora.scan1.vip

      1 ONLINE ONLINE rac12c1 STABLE

-------------------------------------------------- ------------------------------

[Oracle @ rac12c1 ~] $ srvctl status database -d crmdb

Instance crmdb1 is running on node rac12c1

Instance crmdb2 is running on node rac12c2

SQL> select a.name, a.open_mode, b.instance_name from gv $ database a, gv $ instance b where a.inst_id = b.inst_id;

NAME OPEN_MODE INSTANCE_NAME

--------- -------------------- ----------------

CRMDB READ WRITE crmdb1

CRMDB READ WRITE crmdb2

SQL> select * from v $ version where rownum = 1;

BANNER CON_ID

-------------------------------------------------- -------------------------------------------------- ----------

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
     
         
         
         
  More:      
 
- The next key to install Linux bash script PowerShell (Linux)
- Linux crontab (Linux)
- Linux Network Programming - libnet Guide (Programming)
- Spark parquet merge metadata problem (Server)
- Linux, grep, sed usage (Linux)
- Java reflection by calling the class method (Programming)
- C ++ pointer of the (error-prone model) (Programming)
- Golang use Oracle database on Ubuntu 14.04 (Linux)
- AngularJS achieve picture upload feature (Programming)
- Python exception summary (Programming)
- Linux, see picture not resolve the problem (Linux)
- Oracle 11G using DG Broker create DataGuard (Database)
- SecureCRT remote connection Ubuntu fails to solve the case (Linux)
- Python developer of time-saving method (Programming)
- Oracle capability i / o (stress test database server i / o performance) (Database)
- Installing Linux and Windows 10 dual system (Linux)
- Zabbix configuration of SNMP (Server)
- Ubuntu 12.04 installed OpenCV 2.3.1, binary image (Linux)
- Ubuntu Server (Ubuntu 14.04 LTS 64-bit) installation libgdiplus 2.10.9 error solution (Linux)
- Ubuntu: HDF5 error: HDF5 header version does not match with the HDF5 library (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.