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

Grid install of oracle 19c rac install

2025-01-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

A pre-check:

Minimum requirements for installation:

Red Hat Enterprise Linux 7.4: 3.10.0-693.5.2.0.1.el7.x86_64 or later

At least 8 GB RAM for Oracle Grid Infrastructure installations. (in fact, 4G can also be installed)

SWAP:4G

Installation directory: grid 10G, media installation completed 6.4G

Reference: grid install guide

Https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/server-hardware-checklist-for-oracle-grid-infrastructure.html#GUID-D964EF96-9C9C-4173-A919-F3CAA72180B1

Here is an overview of the environment:

IP: same as 11G, 5 public networks and 2 private networks

Shared storage: 5GB

Operating system: RHEL7.6 x64

Media preparation: V981624-01.zipPowerV981627-01.ziprecoveryV981623-01.zip three compressed files, smaller than 18C; only the for exadata version, downloaded in edelivery.oracle.com, does not come out in the public domain, but there should be no problem with installing it in linux; media changes:

1 the software unzipped directory is the installation directory

2 bring your own JDK 1.8/TFA

3 logfile is adjusted from 50 to 200m by default

Second, network configuration

OS uses the minimum installation, the installation process is slight, and the temporary network is enabled first after the installation is completed:

Nmcli con modify "System eth0" ipv4.addresses 192.168.56.102 24 nmcli con up "System eth0" ip addr show

Set the hostname:

Hostnamectl set-hostname rhel6

Due to the change in the name of the Nic in rhel7, to display eth0,eth2, you need to modify the parameters of the Nic in RHEL 7:

1. Modify / etc/sysconfig/grub or / etc/default/grub. They are a file. You can change anyone. You need to add parameters to the GRUB_CMDLINE_LINUX parameter.

Net.ifnames=0 biosdevname=0

Then:

Grub2-mkconfig-o / boot/grub2/grub.cfg

2. Configure the network card

Mv / etc/sysconfig/network-scripts/ifcfg-enp0s3 / etc/sysconfig/network-scripts/ifcfg-eth0vi / etc/sysconfig/network-scripts/ifcfg-eth0 modified: device=eth0name=eth0

* 3. If not, change / etc/udev/ruled.d/90-eno-fix.rules, and change the NAME= "enp0s3" to eth0

Finally, rebooting the host takes effect:

# disable dhcp 169.254 routing table

Echo "NOZEROCONF=yes" > > / etc/sysconfig/network/etc/init.d/network restart

# RHEL 7 disable Firewall

Systemctl stop firewalldsystemctl mask firewalld

Three configure shared disk properties

Vi / etc/rc.d/rc.local / usr/bin/raw / dev/raw/raw1/ dev/sdb/usr/bin/chown grid:asmadmin / dev/raw/raw1/usr/bin/chmod 660 / dev/raw/raw1chmod + x / etc/rc.d/rc.local

* 4. Create users

If the yum package for oracle is installed first, it will be created automatically

$id oracleuid=54321 (oracle) gid=54321 (oinstall) groups=54321 (oinstall), 54322 (dba), 54323 (oper), 54324 (backupdba), 54325 (dgdba), 54326 (kmdba), 54327 (asmdba), 54330 (racdba) $id griduid=54331 (grid) gid=54321 (oinstall) groups=54321 (oinstall), 54322 (dba), 54327 (asmdba), 54328 (asmoper), 54329 (asmadmin), 54330 (racdba)

This kind of user

Groupadd-g 501 oinstallgroupadd-g 502 dbagroupadd-g 504 asmadmingroupadd-g 506 asmdbagroupadd-g 507 asmoperuseradd-u 501-g oinstall-G asmadmin,asmdba,asmoper griduseradd-u 502-g oinstall-G dba,asmdba oracleecho 'oracle123' | passwd oracle-- stdin;echo' oracle123' | passwd grid-- stdin

-- configure ssh trust relationship

. / oui/prov/resources/scripts/sshUserSetup.sh-user grid-hosts "rhel6 rhel7"-noPromptPassphrase

Or

Ssh-keygen generates user keys and configures mutual trust

Five configure yum software package

Cd / etc/yum.repos.d/

Mkdir bak

Mv Centos. / bak

Directly:

Wget http://yum.oracle.com/public-yum-ol7.repo

Modify the ol7_latest in it

Or create a new repo file:

[ol7_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl= https://yum.oracle.com/repo/OracleLinux/OL7/latest/$basearch/gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oraclegpgcheck=0enabled=1

Due to the minimum installation, additional packages are required:

Yum install oracle-database-preinstall-18cyum-y install gcc*yun-y install xhost+

Of course, you can also use the traditional mount image as the yum source.

Mount-o loop / tmp/rhel-server-6.6-x86_64-dvd.iso / mediavi / etc/yum.respos.d/dvd.repo [c6-media] name=CentOS-$releasever-Mediabaseurl= file:///mediagpgcheck=0enabled=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6wget-O / etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.reporpm-Q-qf'% {NAME} -% {VERSION} -% {RELEASE} (% {ARCH})\ n 'rpm-Q-- qf' {NAME} -% {VERSION} -% {RELEASE} (% {ARCH})\ n'bc\ binutils\ compat-libstdc++\ dtrace-modules-headers\ dtrace-modules-provider-headers\ dtrace-utils\ elfutils-libelf\ elfutils-libelf-devel\ fontconfig-devel\ glibc\ glibc-devel\ ksh\ libaio\ libaio-devel\ libdtrace-ctf-devel\ libX11\ libXau\ libXi\ LibXtst\ libXrender\ libXrender-devel\ libgcc\ librdmacm-devel\ libstdc++\ libstdc++-devel\ libxcb rpm-Q-qf'% {NAME} -% {VERSION} -% {RELEASE} (% {ARCH})\ n 'binutils compat-libstdc++-33 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 | grep-I "not installed" | awk' {print $2}'| xargs yum install-y

If you need to upgrade the glibc,libstdc++ library to version 2.14 to 4.5 or below for RHEL6

Check the version: ```

Ldd-version

[grid@rhel6 grid] $strings / usr/lib64/libstdc++.so.6 | grep GLIBCXX

GLIBCXX_3.4

GLIBCXX_3.4.1

GLIBCXX_3.4.2

GLIBCXX_3.4.3

GLIBCXX_3.4.4

GLIBCXX_3.4.5

GLIBCXX_3.4.6

GLIBCXX_3.4.7

GLIBCXX_3.4.8

GLIBCXX_3.4.9

GLIBCXX_3.4.10

GLIBCXX_3.4.11

GLIBCXX_3.4.12

GLIBCXX_3.4.13

GLIBCXX_FORCE_NEW

GLIBCXX_DEBUG_MESSAGE_LENGTH

* * six configuration hosts**

Vi / etc/hosts

127.0.0.1 localhost

# eth0-PUBLIC

192.168.56.101 rhel7

192.168.56.102 rhel6

# VIP

192.168.56.103 rhel7-vip

192.168.56.104 rhel6-vip

# eth2-PRIVATE

10.0.2.15 rhel7-pvt

10.0.2.16 rhel6-pvt

192.168.56.105 rac-scan

* * Seven configuration parameters * * can be ignored after RHEL7 yum install

Vi / etc/sysctl.conf

Kernel.shmall = 4294967296

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Fs.file-max = 6815744

Net.ipv4.ip_local_port_range = 9000 65000

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

Kernel.panic_on_oops=1

# sysctl-p

# adjust shm:

Tmpfs / dev/shm tmpfs defaults,size=3000M 00

Mount-o remount / dev/shm

Modify the limit parameter: / etc/security/limits.conf

Grid soft nproc 4096

Grid hard nproc 16384

Grid soft nofile 4096

Grid hard nofile 65536

Oracle soft nproc 4096

Oracle hard nproc 16384

Oracle soft nofile 4096

Oracle hard nofile 65536

RHEL6 note that situations that may not take effect need to be modified: `/ etc/security/limits.d/90- nproc.conf` source details refer to: http://blog.yufeng.info/archives/2568

Vi / etc/pam.d/login

Session required pam_limits.so

Vi / etc/profile

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

# close selinuxsetenforce 0vi / etc/sysconfig/selinux, and change the target parameter to disabled**8 configuration environment variable * *

Export ORACLE_HOME=/data/grid

Export ORACLE_BASE=/u01/grid

Export ORACLE_SID=+ASM2

Export DISPLAY=192.168.56.1:0.0

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

* * 9 installation * * perform pre-installation check `. / runcluvfy.sh stage-pre crsinst-n rhel6 Rhel7-verbose` > Verifying DNS/NIS name service.. failed > PRVG-2058: The 'hosts' entries in the existing "/ etc/nsswitch.conf" files are > inconsistent. > "hosts" entry was found as "hosts: files dns myhostname" on nodes: rhel7 > "hosts" entry was found as "hosts: files dns" on nodes: rhel6 > > Verifying Daemon "avahi-daemon" not configured and running.. failed > Verifying RPM Package Manager database.. information > PRVG-11250: The check "RPM Package Manager database" was not performed because it needs' root' user privileges. One is that the order of DNS parsing files is inconsistent, and the other is that avahi-daemon is not configured. Check out the avahi explanation: Avahi allows programs to publish and learn about services and hosts on a local network without the need for manual network configuration. For example, when a user connects his computer to a local area network, if his machine runs an Avahi service, the Avahi program broadcasts automatically, thus discovering available printers, shared files, and other users who can chat with each other in the network, which is a bit like receiving all kinds of network advertisements in the local area network. In this case, you can ignore it first; run: `. / gridSetup.sh` Note: select asm&private when you select the network first. Ausizedefaults to 4MB, and other installations are basically the same as before. Check the installation log: `tail-30f / data/grid/install/root_rhel7_2019-02-23 data/grid/install/root_rhel7_2019 13-05-05-377719388.log` to view the ohasd log:

Tail-30f $ORACLE_BASE/diag/crs/rhel7/crs/trace/ohasd.trc

Tail-30f $ORACLE_BASE/diag/crs/rhel7/crs/trace/ohasd_orarootagent_root.trc

* * 10 View resource status * * > [grid@rhel6 bin] $crsctl stat res-t > > Name Target State Server State details > > Local Resources > > ora.LISTENER.lsnr > ONLINE ONLINE rhel6 STABLE > ONLINE ONLINE rhel7 STABLE > ora.chad > ONLINE ONLINE Rhel6 STABLE > ONLINE ONLINE rhel7 STABLE > ora.net1.network > ONLINE ONLINE rhel6 STABLE > ONLINE ONLINE rhel7 STABLE > ora.ons > ONLINE ONLINE rhel6 STABLE > ONLINE ONLINE rhel7 STABLE > > Cluster Resources > > ora.ASMNET1LSNR_ASM.lsnr (ora.asmgroup) > 1 ONLINE ONLINE rhel7 STABLE > 2 ONLINE ONLINE rhel6 STABLE > 3 OFFLINE OFFLINE STABLE > ora.DATA.dg (ora.asmgroup) > 1 ONLINE ONLINE rhel7 STABLE > 2 ONLINE ONLINE rhel6 STABLE > 3 OFFLINE OFFLINE STABLE > ora.LISTENER_SCAN1.lsnr > 1 ONLINE ONLINE rhel7 STABLE > ora.asm (ora.asmgroup) > 1 ONLINE ONLINE rhel7 Started STABLE > 2 ONLINE ONLINE rhel6 Started STABLE > 3 OFFLINE OFFLINE STABLE > ora.asmnet1.asmnetwork (ora.asmgroup) > 1 ONLINE ONLINE rhel7 STABLE > 2 ONLINE ONLINE rhel6 STABLE > 3 OFFLINE OFFLINE STABLE > ora.cvu > 1 ONLINE ONLINE Rhel7 STABLE > ora.qosmserver > 1 ONLINE ONLINE rhel7 STABLE > ora.rhel6.vip > 1 ONLINE ONLINE rhel6 STABLE > ora.rhel7.vip > 1 ONLINE ONLINE rhel7 STABLE > ora.scan1.vip > 1 ONLINE ONLINE rhel7 STABLE > check memory usage during installation In fact, 4GB can be installed to complete grid.

[grid@rhel6 bin] $free-m

Total used free shared buff/cache available

Mem: 3789 1339 386 653 2063 1579

Swap: 2047 0 2047

Check OCR usage:

ASMCMD > lsdg

State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 512 4096 4194304 5120 4784 0 4784 0 Y DATA/

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