Chi tiết cấu hình môi trường:
Hệ điều hành: Redhat Enterprise Linux 8.4 64 bit
Phiên bản phần mềm Oracle Database cần cài đặt: 21.0.0.0
RAC: CÓ (Thiết lập 3 node)
Để cài đặt Oracle RDBMS RAC 21c, bạn phải cài đặt Oracle Grid Infrastructure (Oracle Clusterware và Oracle ASM) 21c trên cụm máy chủ của mình. Tham khảo liên kết bên dưới để biết hướng dẫn cài đặt phần mềm GRID 21c RAC từng bước.
Những điểm cần kiểm tra trước khi bắt đầu cài đặt cơ sở dữ liệu RAC: Điều kiện tiên quyết:
1) Tôi có đang tải xuống phần mềm Oracle DB đúng phiên bản không?
2) Cơ sở dữ liệu của tôi có được chứng nhận trên hệ điều hành hiện tại
không? 3) Kiến trúc phần mềm cơ sở dữ liệu của tôi là 32 bit hay 64 bit?
4) Kiến trúc hệ điều hành là 32 bit hay 64 bit?
2) Cơ sở dữ liệu của tôi có được chứng nhận trên hệ điều hành hiện tại
không? 3) Kiến trúc phần mềm cơ sở dữ liệu của tôi là 32 bit hay 64 bit?
4) Kiến trúc hệ điều hành là 32 bit hay 64 bit?
5) Phiên bản nhân hệ điều hành có tương thích với phần mềm cần cài đặt không?
6) Máy chủ của tôi đang ở cấp độ hoạt động 3 hay 5?
7) Oracle đặc biệt khuyến nghị nên tắt Transparent HugePages và sử dụng HugePages tiêu chuẩn để nâng cao hiệu suất.
8) Phiên bản Oracle Clusterware phải bằng hoặc lớn hơn phiên bản Oracle RAC Database Software mà bạn đã cài đặt.
9) Sử dụng phần cứng máy chủ giống hệt nhau trên mỗi nút để đơn giản hóa việc bảo trì máy chủ.
Các bước cài đặt phần mềm cơ sở dữ liệu Oracle 21c RAC -- Phần II
Bước 1: Ma trận chứng nhận
Oracle Real Application Clusters 21.0.0.0.0 đã được chứng nhận trên Linux x86-64 Red Hat Enterprise Linux 8 Update 2+
RHEL 8.2 với phiên bản kernel: 4.18.0-193.19.1.el8_2.x86_64 trở lên
Khả năng tương thích 32/64 bit:
- Oracle Real Application Clusters 21.0.0.0 64 Bit tương thích với Linux x86-64 Red Hat Enterprise Linux 8 64 Bit.
- Oracle Real Application Clusters 21.0.0.0 64 Bit không tương thích với Linux x86-64 Red Hat Enterprise Linux 8 32 Bit.
Bước 2: Cấu hình máy chủ
- Cần ít nhất 1 GB dung lượng trống trong thư mục dung lượng đĩa tạm thời (/tmp).
- Không gian trao đổi:
- Từ 4 GB đến 16 GB: Tương đương với RAM
- Hơn 16 GB: 16 GB
Nếu bạn bật HugePages cho máy chủ Linux của mình, thì bạn nên trừ dung lượng bộ nhớ được phân bổ cho HugePages khỏi RAM khả dụng trước khi tính toán dung lượng swap.
- Phân bổ bộ nhớ cho HugePages đủ lớn cho các Vùng Toàn cục Hệ thống (SGA) của tất cả các cơ sở dữ liệu dự kiến chạy trên cụm, và để chứa Vùng Toàn cục Hệ thống cho Kho lưu trữ Quản lý Cơ sở hạ tầng Lưới.
- Theo mặc định, hệ điều hành của bạn bao gồm một mục trong /etc/fstab để gắn kết /dev/shm. Hãy đảm bảo rằng vùng gắn kết /dev/shm có kiểu tmpfs và được gắn kết với các tùy chọn sau:
- đã thiết lập quyền đọc và thực thi cho nó.
- Nếu không có thiết lập noexec hoặc nosuid thì sẽ không được bật.
- Thư mục Oracle home hoặc Oracle base không thể là liên kết tượng trưng, cũng như bất kỳ thư mục cha nào của chúng, cho đến tận thư mục gốc.
# Kiểm tra thông tin chi tiết về hệ điều hành và tệp /etc/hosts trên cả ba nút RAC để xem có thay đổi nào không. [oracle@rac1 ~]$ uname -a Linux rac1.localdomain 4.18.0-305.el8.x86_64 #1 SMP Thu Apr 29 08:54:30 EDT 2021 x86_64 x86_64 x86_64 GNU/Linux [oracle@rac1 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux release 8.4 (Ootpa) [oracle@rac1 ~]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #Public IP 10.20.30.101 rac1.localdomain rac1 10.20.30.102 rac2.localdomain rac2 10.20.30.106 rac3.localdomain rac3 #Private IP 10.1.2.201 rac1-priv.localdomain rac1-priv 10.1.2.202 rac2-priv.localdomain rac2-priv 10.1.2.203 rac3-priv.localdomain rac3-priv #VIP IP 10.20.30.103 rac1-vip.localdomain rac1-vip 10.20.30.104 rac2-vip.localdomain rac2-vip 10.20.30.107 rac3-vip.localdomain rac3-vip #scan IP 10.20.30.105 racscan racscan 10.20.30.110 racscan racscan 10.20.30.115 racscan racscan Verify kernel parameter values on all three rac nodes. [oracle@rac1 ~]$ cat /etc/sysctl.conf | grep -v "#" 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 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 Add below limits parameters on all three rac nodes. [oracle@rac1 ~]$ cat /etc/security/limits.conf | grep -v "#" 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 134217728 oracle soft memlock 134217728 oracle soft data unlimited oracle hard data unlimited Ensure SELINUX is disabled on all three rac nodes. [oracle@rac1 ~]$ cat /etc/selinux/config | grep -v "#" SELINUX=disabled SELINUXTYPE=targeted Create directory structure on all three rac nodes. [root@rac1 ~]$ mkdir -p /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac1 ~]# chown -R oracle:oinstall /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac1 ~]# chmod -R 755 /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac1 ~]$ ls -ld /u01/app/oracle/product/21.0.0/dbhome_1 drwxr-xr-x 2 oracle oinstall 6 Dec 29 02:52 /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac2 ~]# mkdir -p /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac2 ~]# chown -R oracle:oinstall /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac2 ~]# chmod -R 755 /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac2 ~]# ls -ld /u01/app/oracle/product/21.0.0/dbhome_1 drwxr-xr-x 2 oracle oinstall 6 Dec 29 02:55 /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac3 ~]# mkdir -p /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac3 ~]# chown -R oracle:oinstall /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac3 ~]# chmod 755 -R /u01/app/oracle/product/21.0.0/dbhome_1 [root@rac3 ~]# ls -ld /u01/app/oracle/product/21.0.0/dbhome_1 drwxr-xr-x 2 oracle oinstall 6 Dec 29 02:54 /u01/app/oracle/product/21.0.0/dbhome_1 |
Bước 3: Tải xuống các phần mềm bên dưới và giải nén chúng.
- Phần mềm cơ sở dữ liệu RDBMS
- Các bản vá mới nhất với opatch cần thiết
- Phiên bản cluvfy mới nhất
Tải xuống bản vá lỗi mới nhất và phần mềm cluvfy.
Link tải Cluvfy mới nhất:
https://updates.oracle.com/Orion/Services/download/cvupack_linux_ol7_x86_64.zip?aru=25026683&patch_file=cvupack_linux_ol7_x86_64.zip
Thông tin chi tiết bản cập nhật mới nhất:
--> p33859395_210000_Linux-x86-64.zip --- Bản cập nhật GI 21.6.0.0.220419
Ở đây, tôi đã tải xuống phần mềm GI rồi nên có thể lấy các bản vá lỗi cơ sở dữ liệu từ đó. Không cần phải tải xuống phần mềm riêng cho cơ sở dữ liệu nữa.
--> p6880880_210000_Linux-x86-64.zip --- Đây là phiên bản opatch tối thiểu cần thiết để thiết lập. Chúng ta phải sử dụng tiện ích OPatch phiên bản 12.2.0.1.29 trở lên để áp dụng bản vá trên.
# Tạo một thư mục chia sẻ, sao chép phần mềm ở trên vào máy chủ đích và giải nén. [root@rac1 RAC Setup]# cd Oracle\ 21c/ [root@rac1 Oracle 21c Patch Apr-2022]# pwd /media/sf_Software/RAC Setup/Oracle 21c/Oracle 21c Patch Apr-2022 [root@rac1 Oracle 21c]# ll -rwxrwx--- 1 root vboxsf 128964 Jun 18 2022 kmod-25-17.0.1.el8.x86_64.rpm -rwxrwx--- 1 root vboxsf 44884 Jun 18 2022 kmod-redhat-oracleasm-2.0.8-11.0.1.el8.x86_64.rpm -rwxrwx--- 1 root vboxsf 3109225519 Nov 18 2021 LINUX.X64_213000_db_home.zip -rwxrwx--- 1 root vboxsf 2422217613 Nov 18 2021 LINUX.X64_213000_grid_home.zip -rwxrwx--- 1 root vboxsf 27092 Jun 18 2022 oracleasmlib-2.0.17-1.el8.x86_64.rpm -rwxrwx--- 1 root vboxsf 99852 Jun 18 2022 oracleasm-support-2.1.12-1.el8.x86_64.rpm -rwxrwx--- 1 root vboxsf 2754612612 Jun 18 2022 oracle-database-ee-21c-1.0-1.ol8.x86_64.rpm -rwxrwx--- 1 root vboxsf 30772 Jun 18 2022 oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm -rwxrwx--- 1 root vboxsf 124109254 Jun 22 2022 p6880880_210000_Linux-x86-64.zip -rwxrwx--- 1 root vboxsf 1449087073 Jun 22 2022 p33859395_210000_Linux-x86-64.zip -rwxrwx--- 1 root vboxsf 212958593 Jan 13 16:04 cvupack_linux_ol7_x86_64.zip [root@rac1 Oracle 21c]# cp LINUX.X64_213000_db_home.zip /u01/app/oracle/setup [root@rac1 Oracle 21c]# cp p6880880_210000_Linux-x86-64.zip /u01/app/oracle/setup [root@rac1 Oracle 21c]# cp p33859395_210000_Linux-x86-64.zip /u01/app/oracle/setup [root@rac1 Oracle 21c]# cp cvupack_linux_ol7_x86_64.zip /u01/app/oracle/setup [root@rac1 ~]# cd /u01/app/oracle/setup [root@rac1 setup]# ll -rwxr-x--- 1 root root 3109225519 Dec 29 03:24 LINUX.X64_213000_db_home.zip -rwxr-x--- 1 root root 1449087073 Dec 29 03:27 p33859395_210000_Linux-x86-64.zip -rwxr-x--- 1 root root 124109254 Dec 29 03:25 p6880880_210000_Linux-x86-64.zip -rwxr-x--- 1 root root 212958593 Jan 13 16:04 cvupack_linux_ol7_x86_64.zip [root@rac1 setup]# chown oracle:oinstall * [root@rac1 setup]# chmod 755 * [oracle@rac1 setup]$ ls -ltr -rwxr-xr-x 1 oracle oinstall 3109225519 Dec 29 03:24 LINUX.X64_213000_db_home.zip -rwxr-xr-x 1 oracle oinstall 124109254 Dec 29 03:25 p6880880_210000_Linux-x86-64.zip -rwxr-xr-x 1 oracle oinstall 1449087073 Dec 29 03:27 p33859395_210000_Linux-x86-64.zip -rwxr-xr-x 1 oracle oinstall 212958593 Dec 29 03:27 cvupack_linux_ol7_x86_64.zip [oracle@rac1 setup]$ cp -pr LINUX.X64_213000_db_home.zip /u01/app/oracle/product/21.0.0/dbhome_1/ [oracle@rac1 setup]$ cd /u01/app/oracle/product/21.0.0/dbhome_1/ [oracle@rac1 dbhome_1]$ ll -rwxr-xr-x 1 oracle oinstall 3109225519 Dec 29 03:24 LINUX.X64_213000_db_home.zip [oracle@rac1 21.0.0]$ du -sh * 6.7G dbhome_1 [oracle@rac1 dbhome_1]$ unzip LINUX.X64_213000_db_home.zip Archive: LINUX.X64_213000_db_home.zip creating: addnode/ inflating: addnode/addnode.sh inflating: addnode/addnode_oraparam.ini.sbs inflating: addnode/addnode_oraparam.ini inflating: addnode/addnode.pl inflating: root.sh creating: QOpatch/ inflating: QOpatch/qopiprep.bat creating: rdbms/ creating: rdbms/mesg/ inflating: rdbms/mesg/orae.msb inflating: rdbms/mesg/diako.msb inflating: rdbms/mesg/ulko.msb inflating: rdbms/mesg/dgmzhs.msb inflating: rdbms/mesg/dgmca.msb inflating: rdbms/mesg/smgro.msb inflating: rdbms/mesg/opwpl.msb inflating: rdbms/mesg/udesk.msb inflating: rdbms/mesg/dgmth.msb inflating: rdbms/mesg/nidja.msb ... .... linking: jdk/jre/lib/amd64/server/libjsig.so -> ../libjsig.so extracting: install/.img.bin inflating: install/files.lst finishing deferred symbolic links: bin/lbuilder -> ../nls/lbuilder/lbuilder lib/libocci.so -> libocci.so.21.1 lib/libjavavm.a -> ../javavm/jdk/jdk8/lib/libjavavm.a lib/libagtsh.so -> libagtsh.so.1.0 lib/libclntsh.so -> libclntsh.so.21.1 javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar lib/libclntshcore.so -> libclntshcore.so.21.1 jdk/bin/ControlPanel -> jcontrol jdk/jre/bin/ControlPanel -> jcontrol javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts javavm/lib/security/README.txt -> ../../../javavm/jdk/jdk8/lib/security/README.txt javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security jdk/jre/lib/amd64/server/libjsig.so -> ../libjsig.so [oracle@rac1 dbhome_1]$ [oracle@rac1 setup]$ unzip cvupack_linux_ol7_x86_64.zip Archive: cvupack_linux_ol7_x86_64.zip creating: oracore/ creating: oracore/mesg/ inflating: oracore/mesg/ldtja.msb inflating: oracore/mesg/tlemko.msb inflating: oracore/mesg/lemtr.msb inflating: oracore/mesg/lrmnl.msb inflating: oracore/mesg/lpmus.msb inflating: oracore/mesg/lhtus.msb inflating: oracore/mesg/lmms.msb ...... inflating: jdk/jre/bin/java inflating: jdk/jre/bin/keytool inflating: jdk/jre/THIRDPARTYLICENSEREADME-JAVAFX.txt inflating: jdk/jre/Welcome.html inflating: readme.txt [oracle@rac1 setup]$ [oracle@rac1 setup]$ unzip p33859395_210000_Linux-x86-64.zip Archive: p33859395_210000_Linux-x86-64.zip creating: 33859395/ creating: 33859395/33853467/ creating: 33859395/33853467/files/ creating: 33859395/33853467/files/usm/ creating: 33859395/33853467/files/usm/install/ creating: 33859395/33853467/files/usm/install/cmds/ creating: 33859395/33853467/files/usm/install/cmds/bin/ inflating: 33859395/33853467/files/usm/install/cmds/bin/mount.acfs inflating: 33859395/33853467/files/usm/install/cmds/bin/fsck.acfs inflating: 33859395/33853467/files/usm/install/cmds/bin/mkfs.acfs.bin inflating: 33859395/33853467/files/usm/install/cmds/bin/acfssihamount inflating: 33859395/33853467/files/usm/install/cmds/bin/advmutil.bin .... inflating: 33859395/33853705/files/racg/lib/s0clsrmain.o inflating: 33859395/33853705/files/racg/lib/s0clsrmdb.o inflating: 33859395/33853705/files/racg/lib/s0clsreut.o inflating: 33859395/33853705/files/racg/lib/s0clsrdmai.o inflating: 33859395/33853705/files/racg/lib/ins_has.mk inflating: 33859395/33853705/README.txt inflating: 33859395/README.html inflating: PatchSearch.xml [oracle@rac1 setup]$ [oracle@rac1 setup]$ cd /u01/app/oracle/product/21.0.0/dbhome_1 [oracle@rac1 dbhome_1]$ cd OPatch/ [oracle@rac1 OPatch]$ ./opatch version OPatch Version: 12.2.0.1.26 OPatch succeeded. [oracle@rac1 dbhome_1]$ mv OPatch OPatch_old [oracle@rac1 dbhome_1]$ unzip p6880880_210000_Linux-x86-64.zip Archive: p6880880_210000_Linux-x86-64.zip creating: OPatch/ inflating: OPatch/README.txt inflating: OPatch/datapatch inflating: OPatch/emdpatch.pl inflating: OPatch/operr_readme.txt creating: OPatch/scripts/ ....... creating: OPatch/modules/oracle.rsa/ inflating: OPatch/modules/oracle.rsa/cryptoj.jar inflating: OPatch/modules/com.oracle.glcm.patch.opatch-common-api-schema_13.9.5.0.jar inflating: OPatch/modules/com.sun.xml.bind.jaxb-xjc.jar inflating: OPatch/modules/com.oracle.glcm.patch.opatch-common-api-interfaces_13.9.5.0.jar [oracle@rac1 dbhome_1]$ ls -ld OPatch* drwxr-x--- 15 oracle oinstall 4096 Apr 13 2022 OPatch drwxr-xr-x 13 oracle oinstall 303 Jul 28 2021 OPatch_old [oracle@rac1 dbhome_1]$ cd OPatch [oracle@rac1 OPatch]$ ./opatch version OPatch Version: 12.2.0.1.30 OPatch succeeded. |
Bước 4: Cấu hình xác thực SSH hoặc cấu hình không cần mật khẩu hoặc xác thực người dùng cho người dùng oracle .
# Thực hiện các bước dưới đây trên cả ba nút để cấu hình xác thực SSH. [oracle@rac1 ~]$ rm -rf .ssh [oracle@rac2 ~]$ rm -rf .ssh [oracle@rac3 ~]$ rm -rf .ssh [oracle@rac1 ~]$ mkdir .ssh [oracle@rac2 ~]$ mkdir .ssh [oracle@rac3 ~]$ mkdir .ssh [oracle@rac1 ~]$ chmod 700 .ssh [oracle@rac2 ~]$ chmod 700 .ssh [oracle@rac3 ~]$ chmod 700 .ssh [oracle@rac1 ~]$ cd .ssh [oracle@rac2 ~]$ cd .ssh [oracle@rac3 ~]$ cd .ssh [oracle@rac1 .ssh]$ ssh-keygen -t rsa [oracle@rac1 .ssh]$ ssh-keygen -t dsa [oracle@rac2 .ssh]$ ssh-keygen -t rsa [oracle@rac2 .ssh]$ ssh-keygen -t dsa [oracle@rac3 .ssh]$ ssh-keygen -t rsa [oracle@rac3 .ssh]$ ssh-keygen -t dsa [oracle@rac1 .ssh]$ cat *.pub >> authorized_keys.rac1 [oracle@rac2 .ssh]$ cat *.pub >> authorized_keys.rac2 [oracle@rac3 .ssh]$ cat *.pub >> authorized_keys.rac3 [oracle@rac1 .ssh]$ scp authorized_keys.rac1 oracle@rac2:/home/oracle/.ssh/ [oracle@rac1 .ssh]$ scp authorized_keys.rac1 oracle@rac3:/home/oracle/.ssh/ [oracle@rac2 .ssh]$ scp authorized_keys.rac2 oracle@rac1:/home/oracle/.ssh/ [oracle@rac2 .ssh]$ scp authorized_keys.rac2 oracle@rac3:/home/oracle/.ssh/ [oracle@rac3 .ssh]$ scp authorized_keys.rac3 oracle@rac1:/home/oracle/.ssh/ [oracle@rac3 .ssh]$ scp authorized_keys.rac3 oracle@rac2:/home/oracle/.ssh/ [oracle@rac1 .ssh]$ cat *.rac* >> authorized_keys [oracle@rac2 .ssh]$ cat *.rac* >> authorized_keys [oracle@rac3 .ssh]$ cat *.rac* >> authorized_keys [oracle@rac1 .ssh]$ chmod 600 authorized_keys [oracle@rac2 .ssh]$ chmod 600 authorized_keys [oracle@rac3 .ssh]$ chmod 600 authorized_keys [oracle@rac1 .ssh]$ ll [oracle@rac2 .ssh]$ ll [oracle@rac3 .ssh]$ ll [oracle@rac1 .ssh]$ ssh rac1 [oracle@rac1 .ssh]$ ssh rac2 [oracle@rac1 .ssh]$ ssh rac3 [oracle@rac2 .ssh]$ ssh rac2 [oracle@rac2 .ssh]$ ssh rac1 [oracle@rac2 .ssh]$ ssh rac3 [oracle@rac3 .ssh]$ ssh rac3 [oracle@rac3 .ssh]$ ssh rac1 [oracle@rac3 .ssh]$ ssh rac2 |
Bước 5: Chạy cluvfy từ bản cài đặt cluvfy mới nhất và khắc phục sự cố nếu có.
[oracle@rac1 ~]$ cd /u01/app/oracle/setup [oracle@rac1 setup]$ cd bin [oracle@rac1 bin]$ [oracle@rac1 bin]$ ll -rwxrwxr-x 1 oracle oinstall 10113 Oct 28 20:32 cluvfy -rwxrwxr-x 1 oracle oinstall 73480 Oct 28 20:31 lsnodes.bin -r-xr-xr-x 1 oracle oinstall 26904 Oct 28 20:32 oraversion -r-xr-xr-x 1 oracle oinstall 0 Oct 28 20:32 tnsping [oracle@rac1 bin]$ ./cluvfy stage -pre dbinst -n rac1,rac2,rac3 -verbose Performing following verification checks ... Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 3.6491GB (3826396.0KB) 1GB (1048576.0KB) passed rac1 3.6491GB (3826396.0KB) 1GB (1048576.0KB) passed rac3 3.6491GB (3826396.0KB) 1GB (1048576.0KB) passed Physical Memory ...PASSED Available Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 1.7178GB (1801220.0KB) 50MB (51200.0KB) passed rac1 1.3909GB (1458444.0KB) 50MB (51200.0KB) passed rac3 1.6722GB (1753456.0KB) 50MB (51200.0KB) passed Available Physical Memory ...PASSED Swap Size ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 3.5GB (3670012.0KB) 3.6491GB (3826396.0KB) passed rac1 3.5GB (3670012.0KB) 3.6491GB (3826396.0KB) passed rac3 3.5GB (3670012.0KB) 3.6491GB (3826396.0KB) passed Swap Size ...PASSED Free Space: rac2:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /tmp rac2 / 14.9609GB 1GB passed Free Space: rac2:/tmp ...PASSED Free Space: rac1:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /tmp rac1 / 7.2959GB 1GB passed Free Space: rac1:/tmp ...PASSED Free Space: rac3:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /tmp rac3 / 15.1357GB 1GB passed Free Space: rac3:/tmp ...PASSED User Existence: oracle ... Node Name Status Comment ------------ ------------------------ ------------------------ rac2 passed exists(1002) rac1 passed exists(1002) rac3 passed exists(1002) Users With Same UID: 1002 ...PASSED User Existence: oracle ...PASSED Group Existence: dba ... Node Name Status Comment ------------ ------------------------ ------------------------ rac2 passed exists rac1 passed exists rac3 passed exists Group Existence: dba ...PASSED Group Existence: oinstall ... Node Name Status Comment ------------ ------------------------ ------------------------ rac2 passed exists rac1 passed exists rac3 passed exists Group Existence: oinstall ...PASSED Group Membership: oinstall(Primary) ... Node Name User Exists Group Exists User in Group Primary Status ---------------- ------------ ------------ ------------ ------------ ------------ rac2 yes yes yes yes passed rac1 yes yes yes yes passed rac3 yes yes yes yes passed Group Membership: oinstall(Primary) ...PASSED Group Membership: dba ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- rac2 yes yes yes passed rac1 yes yes yes passed rac3 yes yes yes passed Group Membership: dba ...PASSED Run Level ... Node Name run level Required Status ------------ ------------------------ ------------------------ ---------- rac2 5 3,5 passed rac1 5 3,5 passed rac3 5 3,5 passed Run Level ...PASSED Hard Limit: maximum open file descriptors ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- rac2 hard 65536 65536 passed rac1 hard 65536 65536 passed rac3 hard 65536 65536 passed Hard Limit: maximum open file descriptors ...PASSED Soft Limit: maximum open file descriptors ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- rac2 soft 1024 1024 passed rac1 soft 1024 1024 passed rac3 soft 1024 1024 passed Soft Limit: maximum open file descriptors ...PASSED Hard Limit: maximum user processes ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- rac2 hard 16384 16384 passed rac1 hard 16384 16384 passed rac3 hard 16384 16384 passed Hard Limit: maximum user processes ...PASSED Soft Limit: maximum user processes ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- rac2 soft 16384 2047 passed rac1 soft 16384 2047 passed rac3 soft 16384 2047 passed Soft Limit: maximum user processes ...PASSED Soft Limit: maximum stack size ... Node Name Type Available Required Status ---------------- ------------ ------------ ------------ ---------------- rac2 soft 10240 10240 passed rac1 soft 10240 10240 passed rac3 soft 10240 10240 passed Soft Limit: maximum stack size ...PASSED Architecture ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 x86_64 x86_64 passed rac1 x86_64 x86_64 passed rac3 x86_64 x86_64 passed Architecture ...PASSED OS Kernel Version ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 4.18.0-305.el8.x86_64 4.18.0 passed rac1 4.18.0-305.el8.x86_64 4.18.0 passed rac3 4.18.0-305.el8.x86_64 4.18.0 passed OS Kernel Version ...PASSED OS Kernel Parameter: semmsl ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 250 250 250 passed rac2 250 250 250 passed rac3 250 250 250 passed OS Kernel Parameter: semmsl ...PASSED OS Kernel Parameter: semmns ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 32000 32000 32000 passed rac2 32000 32000 32000 passed rac3 32000 32000 32000 passed OS Kernel Parameter: semmns ...PASSED OS Kernel Parameter: semopm ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 100 100 100 passed rac2 100 100 100 passed rac3 100 100 100 passed OS Kernel Parameter: semopm ...PASSED OS Kernel Parameter: semmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 128 128 128 passed rac2 128 128 128 passed rac3 128 128 128 passed OS Kernel Parameter: semmni ...PASSED OS Kernel Parameter: shmmax ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 4398046511104 4398046511104 1959114752 passed rac2 4398046511104 4398046511104 1959114752 passed rac3 4398046511104 4398046511104 1959114752 passed OS Kernel Parameter: shmmax ...PASSED OS Kernel Parameter: shmmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 4096 4096 4096 passed rac2 4096 4096 4096 passed rac3 4096 4096 4096 passed OS Kernel Parameter: shmmni ...PASSED OS Kernel Parameter: shmall ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 1073741824 1073741824 1073741824 passed rac2 1073741824 1073741824 1073741824 passed rac3 1073741824 1073741824 1073741824 passed OS Kernel Parameter: shmall ...PASSED OS Kernel Parameter: file-max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 6815744 6815744 6815744 passed rac2 6815744 6815744 6815744 passed rac3 6815744 6815744 6815744 passed OS Kernel Parameter: file-max ...PASSED OS Kernel Parameter: ip_local_port_range ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed rac2 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed rac3 between 9000 & 65500 between 9000 & 65500 between 9000 & 65535 passed OS Kernel Parameter: ip_local_port_range ...PASSED OS Kernel Parameter: rmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 262144 262144 262144 passed rac2 262144 262144 262144 passed rac3 262144 262144 262144 passed OS Kernel Parameter: rmem_default ...PASSED OS Kernel Parameter: rmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 4194304 4194304 4194304 passed rac2 4194304 4194304 4194304 passed rac3 4194304 4194304 4194304 passed OS Kernel Parameter: rmem_max ...PASSED OS Kernel Parameter: wmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 262144 262144 262144 passed rac2 262144 262144 262144 passed rac3 262144 262144 262144 passed OS Kernel Parameter: wmem_default ...PASSED OS Kernel Parameter: wmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 1048576 1048576 1048576 passed rac2 1048576 1048576 1048576 passed rac3 1048576 1048576 1048576 passed OS Kernel Parameter: wmem_max ...PASSED OS Kernel Parameter: aio-max-nr ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ rac1 1048576 1048576 1048576 passed rac2 1048576 1048576 1048576 passed rac3 1048576 1048576 1048576 passed OS Kernel Parameter: aio-max-nr ...PASSED Package: kmod-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 kmod(x86_64)-25-17.el8 kmod(x86_64)-20-21 passed rac1 kmod(x86_64)-25-17.el8 kmod(x86_64)-20-21 passed rac3 kmod(x86_64)-25-17.el8 kmod(x86_64)-20-21 passed Package: kmod-20-21 (x86_64) ...PASSED Package: kmod-libs-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 kmod-libs(x86_64)-25-17.el8 kmod-libs(x86_64)-20-21 passed rac1 kmod-libs(x86_64)-25-17.el8 kmod-libs(x86_64)-20-21 passed rac3 kmod-libs(x86_64)-25-17.el8 kmod-libs(x86_64)-20-21 passed Package: kmod-libs-20-21 (x86_64) ...PASSED Package: binutils-2.30-49.0.2 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 binutils-2.30-93.el8 binutils-2.30-49.0.2 passed rac1 binutils-2.30-93.el8 binutils-2.30-49.0.2 passed rac3 binutils-2.30-93.el8 binutils-2.30-49.0.2 passed Package: binutils-2.30-49.0.2 ...PASSED Package: libgcc-8.2.1 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 libgcc(x86_64)-8.4.1-1.el8 libgcc(x86_64)-8.2.1 passed rac1 libgcc(x86_64)-8.4.1-1.el8 libgcc(x86_64)-8.2.1 passed rac3 libgcc(x86_64)-8.4.1-1.el8 libgcc(x86_64)-8.2.1 passed Package: libgcc-8.2.1 (x86_64) ...PASSED Package: libstdc++-8.2.1 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 libstdc++(x86_64)-8.4.1-1.el8 libstdc++(x86_64)-8.2.1 passed rac1 libstdc++(x86_64)-8.4.1-1.el8 libstdc++(x86_64)-8.2.1 passed rac3 libstdc++(x86_64)-8.4.1-1.el8 libstdc++(x86_64)-8.2.1 passed Package: libstdc++-8.2.1 (x86_64) ...PASSED Package: sysstat-10.1.5 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 sysstat-11.7.3-5.el8 sysstat-10.1.5 passed rac1 sysstat-11.7.3-5.el8 sysstat-10.1.5 passed rac3 sysstat-11.7.3-5.el8 sysstat-10.1.5 passed Package: sysstat-10.1.5 ...PASSED Package: ksh ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 ksh ksh passed rac1 ksh ksh passed rac3 ksh ksh passed Package: ksh ...PASSED Package: make-4.2.1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 make-4.2.1-10.el8 make-4.2.1 passed rac1 make-4.2.1-10.el8 make-4.2.1 passed rac3 make-4.2.1-10.el8 make-4.2.1 passed Package: make-4.2.1 ...PASSED Package: glibc-2.28 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 glibc(x86_64)-2.28-151.el8 glibc(x86_64)-2.28 passed rac1 glibc(x86_64)-2.28-151.el8 glibc(x86_64)-2.28 passed rac3 glibc(x86_64)-2.28-151.el8 glibc(x86_64)-2.28 passed Package: glibc-2.28 (x86_64) ...PASSED Package: glibc-devel-2.28 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 glibc-devel(x86_64)-2.28-151.el8 glibc-devel(x86_64)-2.28 passed rac1 glibc-devel(x86_64)-2.28-151.el8 glibc-devel(x86_64)-2.28 passed rac3 glibc-devel(x86_64)-2.28-151.el8 glibc-devel(x86_64)-2.28 passed Package: glibc-devel-2.28 (x86_64) ...PASSED Package: libaio-0.3.110 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 libaio(x86_64)-0.3.112-1.el8 libaio(x86_64)-0.3.110 passed rac1 libaio(x86_64)-0.3.112-1.el8 libaio(x86_64)-0.3.110 passed rac3 libaio(x86_64)-0.3.112-1.el8 libaio(x86_64)-0.3.110 passed Package: libaio-0.3.110 (x86_64) ...PASSED Package: nfs-utils-2.3.3-14 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 nfs-utils-2.3.3-41.el8 nfs-utils-2.3.3-14 passed rac1 nfs-utils-2.3.3-41.el8 nfs-utils-2.3.3-14 passed rac3 nfs-utils-2.3.3-41.el8 nfs-utils-2.3.3-14 passed Package: nfs-utils-2.3.3-14 ...PASSED Package: smartmontools-6.6-3 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 smartmontools-7.1-1.el8 smartmontools-6.6-3 passed rac1 smartmontools-7.1-1.el8 smartmontools-6.6-3 passed rac3 smartmontools-7.1-1.el8 smartmontools-6.6-3 passed Package: smartmontools-6.6-3 ...PASSED Package: net-tools-2.0-0.51 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 net-tools-2.0-0.52.20160912git.el8 net-tools-2.0-0.51 passed rac1 net-tools-2.0-0.52.20160912git.el8 net-tools-2.0-0.51 passed rac3 net-tools-2.0-0.52.20160912git.el8 net-tools-2.0-0.51 passed Package: net-tools-2.0-0.51 ...PASSED Package: policycoreutils-2.9-3 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 policycoreutils-2.9-14.el8 policycoreutils-2.9-3 passed rac1 policycoreutils-2.9-14.el8 policycoreutils-2.9-3 passed rac3 policycoreutils-2.9-14.el8 policycoreutils-2.9-3 passed Package: policycoreutils-2.9-3 ...PASSED Package: policycoreutils-python-utils-2.9-3 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- rac2 policycoreutils-python-utils-2.9-14.el8 policycoreutils-python-utils-2.9-3 passed rac1 policycoreutils-python-utils-2.9-14.el8 policycoreutils-python-utils-2.9-3 passed rac3 policycoreutils-python-utils-2.9-14.el8 policycoreutils-python-utils-2.9-3 passed Package: policycoreutils-python-utils-2.9-3 ...PASSED Users With Same UID: 0 ...PASSED Current Group ID ...PASSED Root user consistency ... Node Name Status ------------------------------------ ------------------------ rac2 passed rac1 passed rac3 passed Root user consistency ...PASSED Host name ...PASSED Node Connectivity ... Hosts File ... Node Name Status ------------------------------------ ------------------------ rac1 passed rac2 passed rac3 passed Hosts File ...PASSED Interface information for node "rac1" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ enp0s3 10.20.30.101 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:6C:9A:FB 1500 enp0s3 10.20.30.103 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:6C:9A:FB 1500 enp0s3 10.20.30.105 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:6C:9A:FB 1500 enp0s8 10.1.2.201 10.1.2.0 0.0.0.0 UNKNOWN 08:00:27:7E:D7:1A 1500 Interface information for node "rac3" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ enp0s3 10.20.30.106 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:57:6A:1F 1500 enp0s3 10.20.30.107 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:57:6A:1F 1500 enp0s3 10.20.30.115 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:57:6A:1F 1500 enp0s8 10.1.2.203 10.1.2.0 0.0.0.0 UNKNOWN 08:00:27:2D:59:72 1500 Interface information for node "rac2" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ enp0s3 10.20.30.102 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:79:B4:29 1500 enp0s3 10.20.30.104 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:79:B4:29 1500 enp0s3 10.20.30.110 10.20.30.0 0.0.0.0 UNKNOWN 08:00:27:79:B4:29 1500 enp0s8 10.1.2.202 10.1.2.0 0.0.0.0 UNKNOWN 08:00:27:73:FE:D9 1500 Check: MTU consistency on the private interfaces of subnet "10.1.2.0" Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- rac1 enp0s8 10.1.2.201 10.1.2.0 1500 rac3 enp0s8 10.1.2.203 10.1.2.0 1500 rac2 enp0s8 10.1.2.202 10.1.2.0 1500 Check: MTU consistency of the subnet "10.20.30.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- rac1 enp0s3 10.20.30.101 10.20.30.0 1500 rac1 enp0s3 10.20.30.103 10.20.30.0 1500 rac1 enp0s3 10.20.30.105 10.20.30.0 1500 rac3 enp0s3 10.20.30.106 10.20.30.0 1500 rac3 enp0s3 10.20.30.107 10.20.30.0 1500 rac3 enp0s3 10.20.30.115 10.20.30.0 1500 rac2 enp0s3 10.20.30.102 10.20.30.0 1500 rac2 enp0s3 10.20.30.110 10.20.30.0 1500 rac2 enp0s3 10.20.30.104 10.20.30.0 1500 Source Destination Connected? ------------------------------ ------------------------------ ---------------- rac1[enp0s3:10.20.30.101] rac1[enp0s3:10.20.30.103] yes rac1[enp0s3:10.20.30.101] rac1[enp0s3:10.20.30.105] yes rac1[enp0s3:10.20.30.101] rac3[enp0s3:10.20.30.106] yes rac1[enp0s3:10.20.30.101] rac3[enp0s3:10.20.30.107] yes rac1[enp0s3:10.20.30.101] rac3[enp0s3:10.20.30.115] yes rac1[enp0s3:10.20.30.101] rac2[enp0s3:10.20.30.102] yes rac1[enp0s3:10.20.30.101] rac2[enp0s3:10.20.30.110] yes rac1[enp0s3:10.20.30.101] rac2[enp0s3:10.20.30.104] yes rac1[enp0s3:10.20.30.103] rac1[enp0s3:10.20.30.105] yes rac1[enp0s3:10.20.30.103] rac3[enp0s3:10.20.30.106] yes rac1[enp0s3:10.20.30.103] rac3[enp0s3:10.20.30.107] yes rac1[enp0s3:10.20.30.103] rac3[enp0s3:10.20.30.115] yes rac1[enp0s3:10.20.30.103] rac2[enp0s3:10.20.30.102] yes rac1[enp0s3:10.20.30.103] rac2[enp0s3:10.20.30.110] yes rac1[enp0s3:10.20.30.103] rac2[enp0s3:10.20.30.104] yes rac1[enp0s3:10.20.30.105] rac3[enp0s3:10.20.30.106] yes rac1[enp0s3:10.20.30.105] rac3[enp0s3:10.20.30.107] yes rac1[enp0s3:10.20.30.105] rac3[enp0s3:10.20.30.115] yes rac1[enp0s3:10.20.30.105] rac2[enp0s3:10.20.30.102] yes rac1[enp0s3:10.20.30.105] rac2[enp0s3:10.20.30.110] yes rac1[enp0s3:10.20.30.105] rac2[enp0s3:10.20.30.104] yes rac3[enp0s3:10.20.30.106] rac3[enp0s3:10.20.30.107] yes rac3[enp0s3:10.20.30.106] rac3[enp0s3:10.20.30.115] yes rac3[enp0s3:10.20.30.106] rac2[enp0s3:10.20.30.102] yes rac3[enp0s3:10.20.30.106] rac2[enp0s3:10.20.30.110] yes rac3[enp0s3:10.20.30.106] rac2[enp0s3:10.20.30.104] yes rac3[enp0s3:10.20.30.107] rac3[enp0s3:10.20.30.115] yes rac3[enp0s3:10.20.30.107] rac2[enp0s3:10.20.30.102] yes rac3[enp0s3:10.20.30.107] rac2[enp0s3:10.20.30.110] yes rac3[enp0s3:10.20.30.107] rac2[enp0s3:10.20.30.104] yes rac3[enp0s3:10.20.30.115] rac2[enp0s3:10.20.30.102] yes rac3[enp0s3:10.20.30.115] rac2[enp0s3:10.20.30.110] yes rac3[enp0s3:10.20.30.115] rac2[enp0s3:10.20.30.104] yes rac2[enp0s3:10.20.30.102] rac2[enp0s3:10.20.30.110] yes rac2[enp0s3:10.20.30.102] rac2[enp0s3:10.20.30.104] yes rac2[enp0s3:10.20.30.110] rac2[enp0s3:10.20.30.104] yes Source Destination Connected? ------------------------------ ------------------------------ ---------------- rac1[enp0s8:10.1.2.201] rac3[enp0s8:10.1.2.203] yes rac1[enp0s8:10.1.2.201] rac2[enp0s8:10.1.2.202] yes rac3[enp0s8:10.1.2.203] rac2[enp0s8:10.1.2.202] yes Check that maximum (MTU) size packet goes through subnet ...PASSED subnet mask consistency for subnet "10.1.2.0" ...PASSED subnet mask consistency for subnet "10.20.30.0" ...PASSED Node Connectivity ...PASSED Multicast or broadcast check ... Checking subnet "10.1.2.0" for multicast communication with multicast group "224.0.0.251" Multicast or broadcast check ...PASSED User Mask ... Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- rac2 0022 0022 passed rac1 0022 0022 passed rac3 0022 0022 passed User Mask ...PASSED CRS Integrity ... Clusterware Version Consistency ...PASSED CRS Integrity ...PASSED Cluster Manager Integrity ... Node Name Status ------------------------------------ ------------------------ rac1 running rac2 running rac3 running Cluster Manager Integrity ...PASSED Node Application Existence ... Checking existence of VIP node application (required) Node Name Required Running? Comment ------------ ------------------------ ------------------------ ---------- rac1 yes yes passed rac3 yes yes passed rac2 yes yes passed Checking existence of NETWORK node application (required) Node Name Required Running? Comment ------------ ------------------------ ------------------------ ---------- rac1 yes yes passed rac3 yes yes passed rac2 yes yes passed Checking existence of ONS node application (optional) Node Name Required Running? Comment ------------ ------------------------ ------------------------ ---------- rac1 no yes passed rac3 no yes passed rac2 no yes passed Node Application Existence ...PASSED Clock Synchronization ... Node Name Status ------------------------------------ ------------------------ rac1 passed rac2 passed rac3 passed Node Name State ------------------------------------ ------------------------ rac2 Active rac1 Active rac3 Active Node Name Time Offset Status ------------ ------------------------ ------------------------ rac2 0.0 passed rac1 0.0 passed rac3 0.0 passed Clock Synchronization ...PASSED resolv.conf Integrity ...PASSED Time zone consistency ...PASSED Single Client Access Name (SCAN) ... SCAN Name Node Running? ListenerName Port Running? ---------------- ------------ ------------ ------------ ------------ ------------ racscan rac1 true LISTENER_SCAN1 1521 true racscan rac2 true LISTENER_SCAN2 1521 true racscan rac3 true LISTENER_SCAN3 1521 true Checking TCP connectivity to SCAN listeners... Node ListenerName TCP connectivity? ------------ ------------------------ ------------------------ rac1 LISTENER_SCAN1 yes rac1 LISTENER_SCAN2 yes rac1 LISTENER_SCAN3 yes DNS/NIS name service 'racscan' ... Name Service Switch Configuration File Integrity ...PASSED DNS/NIS name service 'racscan' ...FAILED (PRVG-1101) Single Client Access Name (SCAN) ...FAILED (PRVG-11372, PRVG-1101) VIP Subnet configuration check ...PASSED Database Clusterware Version Compatibility ...PASSED ASM storage privileges for the user: oracle ... Group Membership: asmdba ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- rac2 yes yes yes passed rac1 yes yes yes passed rac3 yes yes yes passed Group Membership: asmdba ...PASSED ASM storage privileges for the user: oracle ...PASSED Daemon "proxyt" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ rac2 no passed rac1 no passed rac3 no passed Node Name Running? Status ------------ ------------------------ ------------------------ rac2 no passed rac1 no passed rac3 no passed Daemon "proxyt" not configured and running ...PASSED ACFS device special file ...PASSED /dev/shm mounted as temporary file system ...PASSED Maximum locked memory check ...PASSED Systemd login manager IPC parameter ...PASSED Current clock source ...PASSED ORAchk checks ...FAILED (PRCT-1534) Pre-check for database installation was unsuccessful on all the nodes. Failures were encountered during execution of CVU verification request "stage -pre dbinst". Single Client Access Name (SCAN) ...FAILED PRVG-11372 : Number of SCAN IP addresses that SCAN "racscan" resolved to did not match the number of SCAN VIP resources DNS/NIS name service 'racscan' ...FAILED PRVG-1101 : SCAN name "racscan" failed to resolve ORAchk checks ...FAILED rac1: PRCT-1534 : Execution of command 'orachk -profile preinstall -clusternodes rac1,rac2,rac3' from home '/opt/oracle.ahf/orachk' failed. '' output directory is not available. Run 'ahfctl access add –user oracle' to register user and then re-run orachk CVU operation performed: stage -pre dbinst Date: Jan 13, 2023 5:08:01 PM CVU version: Standalone 21.8.0.0.0 (102822x8664) Clusterware version: 21.0.0.0.0 CVU home: /u01/app/oracle Grid home: /u01/app/21.0.0/grid User: oracle Operating system: Linux4.18.0-305.el8.x86_64 You can ignore above DNS and orachk failed checks. |
Bước 6: Bắt đầu cài đặt phần mềm Oracle RDBMS 21c.
# Đăng nhập với tư cách người dùng oracle để cài đặt phần mềm và khởi chạy runInstaller [oracle@rac1 dbhome_1]$ ./runInstaller -help Usage: runInstaller [<flag>] [<option>] Following are the possible flags: -help - display help. -silent - run in silent mode. The inputs can be a response file or a list of command line variable value pairs. [-ignorePrereqFailure - ignore all prerequisite checks failures.] -responseFile - specify the complete path of the response file to use. -logLevel - enable the log of messages up to the priority level provided in this argument. Valid options are: severe, warning, info, config, fine, finer, finest. -executePrereqs | -executeConfigTools | -createGoldImage -executePrereqs - execute the prerequisite checks only. -executeConfigTools - execute the config tools for an installed home. -createGoldImage - create a gold image from the current Oracle home. -destinationLocation - specify the complete path to where the created gold image will be located. [-exclFiles - specify the complete paths to the files to be excluded from the new gold image.] -debug - run in debug mode. -waitForCompletion - wait for the completion of the installation, instead of spawning the installer and returning the console prompt. -noconfig - do not execute the config tools. -noconsole - suppress the display of messages in the console. The console is not allocated. -ignoreInternalDriverError - ignore any internal driver errors. -noCopy - perform the configuration without copying the software on to the remote nodes. Applicable only for Real Application Cluster(RAC) installs. -applyRU - apply release update to the Oracle home. -applyOneOffs - apply one-off patch to the Oracle home. Multiple one-off patches can be passed as a comma separated list of locations. [oracle@rac1 ~]$ id uid=1002(oracle) gid=2000(oinstall) groups=2000(oinstall),2100(asmadmin),2200(dba),2300(oper),2400(asmdba),2500(asmoper) [oracle@rac1 ~]$ cd /u01/app/oracle/product/21.0.0/dbhome_1/ [oracle@rac1 dbhome_1]$ ls -ltr run* -rwxr-x--- 1 oracle oinstall 1783 Mar 8 2017 runInstaller |
[oracle@rac1 dbhome_1]$ ./runInstaller -applyRU /u01/app/oracle/setup/33859395
Preparing the home to patch...
Applying the patch /u01/app/oracle/setup/33859395...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/InstallActions2023-01-13_08-19-03PM/installerPatchActions_2023-01-13_08-19-03PM.log
Launching Oracle Database Setup Wizard...
Tại đây, trong màn hình điều kiện tiên quyết, chúng ta có thể bỏ qua các lỗi phân giải quét vì chúng ta không sử dụng máy chủ DNS. Chọn tùy chọn "Bỏ qua tất cả" và nhấp vào TIẾP THEO để tiếp tục.
Bây giờ là lúc thực thi tập lệnh root.sh trên cả ba nút, lần lượt từng nút một, với quyền người dùng root. Sau khi hoàn tất, hãy nhấp vào OK để tiếp tục.
[root@rac1 ~]# id uid=0(root) gid=0(root) groups=0(root) [root@rac1 ~]# /u01/app/oracle/product/21.0.0/dbhome_1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/21.0.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. [root@rac2 ~]# id uid=0(root) gid=0(root) groups=0(root) [root@rac2 ~]# /u01/app/oracle/product/21.0.0/dbhome_1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/21.0.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. [root@rac3 ~]# id uid=0(root) gid=0(root) groups=0(root) [root@rac3 ~]# /u01/app/oracle/product/21.0.0/dbhome_1/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/21.0.0/dbhome_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. |
Quá trình cài đặt phần mềm cơ sở dữ liệu Oracle 21c 3-Node RAC đã hoàn tất thành công.
Website không chứa bất kỳ quảng cáo nào, mọi đóng góp để duy trì phát triển cho website (donation) xin vui lòng gửi về STK 90.2142.8888 - Ngân hàng Vietcombank Thăng Long - TRAN VAN BINH
=============================
Nếu bạn không muốn bị AI thay thế và tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp hay làm chủ Database thì hãy đăng ký ngay KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE, được Coaching trực tiếp từ tôi với toàn bộ bí kíp thực chiến, thủ tục, quy trình của gần 20 năm kinh nghiệm (mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google) từ đó giúp bạn dễ dàng quản trị mọi hệ thống Core tại Việt Nam và trên thế giới, đỗ OCP.
- CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
- Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
2 khóa học online qua video giúp bạn nhanh chóng có những kiến thức nền tảng về Linux, Oracle, học mọi nơi, chỉ cần có Internet/4G:
- Oracle cơ bản: https://bit.ly/admin_1200
- Linux: https://bit.ly/linux_1200
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile/Zalo: 0902912888
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: https://www.youtube.com/@binhguru
👨 Tiktok: https://www.tiktok.com/@binhguru
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhguru
👨 Podcast: https://www.podbean.com/pu/pbblog-eskre-5f82d6
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
cơ sở dữ liệu, cơ sở dữ liệu quốc gia, database, AI, trí tuệ nhân tạo, artificial intelligence, machine learning, deep learning, LLM, ChatGPT, DeepSeek, Grok, oracle tutorial, học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,sql tutorial, khóa học pl/sql tutorial, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c/21c/23c/23ai, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail,oracle RAC, ASM, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, postgresql tutorial, mysql tutorial, mariadb tutorial, ms sql server tutorial, nosql, mongodb tutorial, oci, cloud, middleware tutorial, docker, k8s, micro service, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty
