Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Deployment of Oracle11.2.0.4RAC under OEL7.2

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Deployment of Oracle11.2.0.4RAC under OEL7.2

A brief description of the installation steps

U OEL7.2 operating system installation

U RAC installation environment configuration

U ORACLE CRS installation

U ORACLE DB software installation

U ORACLE instance installation

U environmental inspection

II. Installation of OEL7.2 operating system

1 insert the OEL7.2 operating system installation CD or load the ISO file

2 boot the installation CD, enter and start the installation

3 choose the operating system language-continue

4 time zone choose Asia-Shanghai-DONE

5 language support selection-english and simplified Chinese

6 Security policy-off

7 Software selection-server with gui

8 Select installation disk

9 Network and hostname configuration

10 start the installation

11 log in after completing the installation of the operating system

III. Configuration of RAC installation environment

1 add users, groups and configuration permissions

Groupadd oinstall

Groupadd dba

Groupadd oper

Groupadd asmadmin

Groupadd asmdba

Groupadd asmoper

Useradd-g oinstall-G dba,asmdba,asmadmin,asmoper grid

Useradd-g oinstall-G dba,oper,asmdba oracle

Usermod-g oinstall-G dba,oper,asmdba oracle

Passwd grid

Passwd oracle

Id oracle

Id grid

Mkdir-p / u01/app/11.2.0/grid

Mkdir-p / u01/app/grid

Chown-R grid:oinstall / u01 /

Mkdir-p / u01/app/oracle

Chown-R oracle:oinstall / u01/app/oracle

Chmod-R 775 / u01 /

2 modify operating system environment variables:

Oracle user

Vi .bash _ profile

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_CRS_HOME=/u01/app/grid

Export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

Export ORACLE_SID=orcl1

Export ORACLE_TERM=xterm

Export PATH=/usr/sbin:$PATH

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 NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Grid user

Export ORACLE_SID=+ASM1

Export ORACLE_BASE=/u01/app/grid

Export ORACLE_HOME=/u01/app/11.2.0/grid

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Export NLS_DATE_FORMAT= "yyyy-mm-dd HH24:MI:SS"

Export PATH=$ORACLE_HOME/bin:$PATH

3 copy the installation file to the server

Mkdir / mnt/cdrom

Mount-o username=administrator,password=123 / / 1.1.1.1/iso / mnt/cdrom

Copy the file to the server / U01 directory for decompression

4 install cvuqdisk

[root@his1 rpm] # rpm-ivh cvuqdisk-1.0.9-1.rpm

Preparing... # # [100%]

Using default group oinstall to install package

Updating / installing...

1:cvuqdisk-1.0.9-1 # #

5 installation package query

Rpm-Q-- qf'% {NAME} -% {VERSION} -% {RELEASE} (% {ARCH})\ n 'binutils\

Elfutils-libelf\

Elfutils-libelf-devel\

Gcc\

Gcc-c++\

Glibc\

Glibc-common\

Glibc-devel\

Glibc-headers\

Ksh\

Libaio\

Libaio-devel\

Libgcc\

Libstdc++\

Libstdc++-devel\

Make\

Sysstat\

UnixODBC\

UnixODBC-devel

6 install missing installation package

Rpm-ivh elfutils-libelf-devel-0.163-3.el7.x86_64.rpm

Rpm-ivh libaio-devel-0.3.109-13.el7.x86_64.rpm

Rpm-ivh unixODBC-2.3.1-11.el7.x86_64.rpm

Rpm-ivh unixODBC-devel-2.3.1-11.el7.x86_64.rpm

Rpm-ivh ksh-20120801-22.el7_1.2.x86_64.rpm

7 Firewall configuration:

Turn off firewall:

Systemctl stop firewalld.service # stop firewall

Systemctl disable firewalld.service # prevents firewall from booting

Firewall-cmd-- state # View the default firewall status (show notrunning when turned off and running when turned on)

8 Selinux configuration

Modify / etc/sysconfig/selinux to ensure SELINUX=disabled, and then execute setenforce 0 or reboot server to take effect minimum configuration

Set SElinux to PERMISSIVE mode:

Setenforce 0

Getenforce

9 Hosts file configuration

172.16.0.107 rac1

172.16.0.108 rac2

1.1.1.1 rac1-priv

1.1.1.2 rac2-priv

172.16.0.109 rac1-vip

172.16.0.110 rac2-vip

172.16.0.111 rac-scan

10 modify / etc/sysctl.conf file

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

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

For 64-bit systems with 64GB of RAM:

Kernel.shmmax=34359738368

Kernel.shmmni=4096

Kernel.shmall=16777216

Vm.nr_hugepages=16384

Sysctl-p

11 modify removeIPC parameters

To avoid the new features of linux7.2, remove all IPC objects after a user exits OS completely. You need to modify the following parameters

1)。 Setting / etc/systemd/logind.conf (OEL default)

RemoveIPC=no

2)。 Restart the server or restart systemd-logind

Systemctl daemon-reload

Systemctl restart systemd-logind

12 configuration file system descriptor / etc/security/limits.conf

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 1024

Grid hard nofile 65536

Grid soft stack 10240

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle soft stack 10240

13 configuration / etc/profile, add

If [$USER = "oracle"] | | [$USER = "grid"]; then

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

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Umask 022

Fi

Export PATH=$PATH:/u01/app/11.2.0/grid/bin

14 Vmware workstation add virtual disk

OCR 1G DATA 20G

First add the disk of the HIS1 node, and then add the existing disk to HIS2, and allocate the disk space in advance.

15 Select the disk channel:

Select 1:0 channel for Ocr and 1:1 channel for data.

16 modify the vmx file of HIS1 and HIS2 by adding the following:

Disk.locking= "FALSE"

Disk.EnableUUID= "TRUE"

DiskLib.dataCacheMaxSize= "0"

DiskLib.dataCacheMaxReadAheadSize= "0"

DiskLib.dataCacheMinReadAheadSize= "0"

DiskLib.dataCachePageSize= "4096"

DiskLib.maxUnsyncedWrites= "0"

Scsi1:0.sharedBus= "VIRTUAL"

Scsi1:0.virtualDev= "lsilogic"

Scsi1:0.deviceType= "disk"

Scsi1:1.sharedBus= "VIRTUAL"

Scsi1:1.virtualDev= "lsilogic"

Scsi1:1.deviceType= "disk"

Scsi1:2.sharedBus= "VIRTUAL"

Scsi1:2.virtualDev= "lsilogic"

Scsi1:2.deviceType= "disk"

17 initialize the newly added disk

Restart the HIS2 node after HIS1 initialization, and there is no need to initialize the disk on the HIS2.

Initialize the operation:

18 disk configuration

Test environment cleans up previous data

Dd if=/dev/zero of=/dev/sdb1

Dd if=/dev/zero of=/dev/sdc1

Dd if=/dev/zero of=/dev/sdd1

a. Get the uuid that needs to be bound as an asm disk, and check whether the id on the two servers is consistent

Obtain disk id under multi-path

/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/emcpowerb

/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/emcpowerc

/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/emcpowerd

b. Bind and write udev.rules files

Vi / etc/udev/rules.d/99-oracle-asmdevices.rules

General disk configuration:

KERNEL== "sd?", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/$name", RESULT== "36006016002e045002988e0598f38600b", SYMLINK+= "asm/asm-ocr", OWNER= "grid", GROUP= "asmadmin", MODE= "0660"

KERNEL== "sd?", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/$name", RESULT== "36006016002e04500d187e059be4b8d61", SYMLINK+= "asm/asm-data", OWNER= "grid", GROUP= "asmadmin", MODE= "0660"

KERNEL== "sd?", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/$name", RESULT== "36006016002e045008387e059821bbb14", SYMLINK+= "asm/asm-fra", OWNER= "grid", GROUP= "asmadmin", MODE= "0660"

EMC multipath disk configuration:

KERNEL== "emcpower?", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/$name", RESULT== "36006016002e045002988e0598f38600b", SYMLINK+= "asm-ocr", OWNER= "grid", GROUP= "asmadmin", MODE= "0660"

KERNEL== "emcpower?", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/$name", RESULT== "36006016002e04500d187e059be4b8d61", SYMLINK+= "asm-fra", OWNER= "grid", GROUP= "asmadmin", MODE= "0660"

KERNEL== "emcpower?", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-whitelisted-replace-whitespace-device=/dev/$name", RESULT== "36006016002e045008387e059821bbb14", SYMLINK+= "asm-data", OWNER= "grid", GROUP= "asmadmin", MODE= "0660"

c. Check whether the binding is successful

Udevadm test / sys/block/emcpowerb

Udevadm info-query=all-path=/sys/block/emcpowerb

Udevadm info-query=all-name=asm-ocr

Udevadm test / sys/block/emcpowerc

Udevadm info-query=all-path=/sys/block/emcpowerc

Udevadm info-query=all-name=asm-fra

Udevadm test / sys/block/emcpowerd

Udevadm info-query=all-path=/sys/block/emcpowerd

Udevadm info-query=all-name=asm-data

d. Restart the udev service

Udevadm control-reload-rules

e. Check device binding

Ll / dev/asm*

f. Modify asm disk permissions

Chown-h grid:asmadmin / dev/asm/*

Fourth, install Oracle CRS

1 use grid users to execute the installation package

. / runInstaller

2 skip software updates

3 install and configure cluster grid

4 language selection

5 Cluster node and ssh configuration-Select setup

6 complete the installation

7 execute the relevant script

Configure the ohas service:

Before executing the root.sh script, add the ohas service:

A) cd / etc/systemd/system/

Touch ohas.service

B) Edit the file ohas.service to add the following text

[Unit]

Description=Oracle High Availability Services

After=syslog.target

[Service]

ExecStart=/etc/init.d/init.ohasd run > / dev/null 2 > & 1 Type=simple

Restart=always

[Install]

WantedBy=multi-user.target

C) run the following command (as root):

Systemctl daemon-reload

Systemctl enable ohas.service

Systemctl start ohas.service

D) run root.sh

After executing the root.sh script, start the ohas service when the following prompt appears:

:

Installing Trace File Analyzer

OLR initialization-successful

Start the ohas service:

Query if the installer has created the / etc/init.d/init.ohasd file, and if so, run the ohas service:

Systemctl start ohas.service

Node 2 executes root.sh

When Adding Clusterware entries to inittab is displayed

Start the ohas service:

Query if the installer has created the / etc/init.d/init.ohasd file, and if so, run the ohas service:

Systemctl start ohas.service

8 check the service status after completion

5. Install database software

1 create a related asm disk group

2 Oracle users run. runInstall

3 choose to install only database software

4 choose to install the instance on both servers

5 configure oracle user equivalence

6 Select installation language

7 install Enterprise Edition

8 ignore partial check error

9 an error was reported during installation

To fix this error edit $ORACLE_HOME/sysman/lib/ins_emagent.mk, search for the line

$(MK_EMAGENT_NMECTL)

And replace the line with

$(MK_EMAGENT_NMECTL)-lnnz11

Then click "Retry" button

Create a database instance

1 Oracle user executes dbca to create database instance

2 enter the name of the created instance

3 configure Em

4 configure user password

5 Select oms and data file storage disk group

6 configure archiving and flashback area

7 memory configuration

8 error report, Tip not / dev/shm space is too small

Execute on his and his2

Sudo mount-o size=3168M-o remount / dev/shm

9 concurrency configuration

10 configure character set

11 start installing the database

12 complete the database installation

VII. Inspection of the installation environment

1 check the startup of the cluster service

2 check the monitoring status

3 use different ip to connect to the database, verify that the login is normal, and the installation is over.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report