In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.