Java & Linux : Fishing in the Desert

Replication from Oracle to MySQL Using GoldenGate

2023-01-24T21:26:00.004+02:00

Replication from Oracle to MySQL Using GoldenGate
https://houseofbrick.com/blog/replication-from-oracle-to-mysql-using-goldengate/

Oracle to MYSQL Replication Using Golden Gate
https://www.support.dbagenesis.com/post/oracle-to-mysql-replication-using-golden-gate

GoldenGate: MySQL to Oracle Heterogeneous Unidirectional Replication
https://www.ktexperts.com/goldengate-mysql-to-oracle-heterogeneous-unidirectional-replication/

Replication from Oracle to PostgreSQL Using GoldenGate

https://houseofbrick.com/blog/replication-from-oracle-to-postgresql/

Multi-Master Oracle Replication Using GoldenGate

https://houseofbrick.com/blog/multi-master-oracle-replication-using-goldengate/

Checking in at the Golden Gate 19c

2023-01-21T15:28:00.018+02:00

Checking in at the Golden Gate

https://paulguerin.medium.com/checking-in-at-the-golden-gate-e8af42eba786

git clone https://github.com/oracle/vagrant-projects
cd ~/vagrant-projects/OracleGoldenGate/19.3.0

Now just need to download the database and Golden Gate prerequisite files that are the following:

LINUX.X64_193000_db_home.zip
191004_fbo_ggs_Linux_x64_shiphome.zip (or later)
OGG_BigData_Linux_x64_19.1.0.0.1 (or later)

vagrant up
vagrant ssh
sudo su - oracle
cd /u01/oggbd
./ggsci
info all

vagrant script has an error related to KAFKA download :
https://downloads.apache.org/kafka/2.8.2/
curl https://downloads.apache.org/kafka/2.8.2/kafka_2.12-2.8.2.tgz -# -o /tmp/kafka_2.12-2.8.2.tgz

Other GoldenGate Links :
----------------------------------

The Ultimate Guide to Setup Golden Gate On Vagrant Box :

https://itnext.io/the-ultimate-guide-to-setup-golden-gate-on-vagrant-box-5f73fc67ebd6

HOW TO PREPARE A GOLDENGATE TEST LAB?

https://ora-base.com/?p=1419

Oracle GoldenGate - Basic Configuration :

http://www.juliandyke.com/Research/GoldenGate/GoldenGateBasicConfiguration.php

Administering Oracle GoldenGate 19c :
https://docs.oracle.com/en/middleware/goldengate/core/19.1/admin/administering-oracle-goldengate.pdf

GoldenGate for Big Data and Kafka Handlers hands-on – part 1
https://blog.yannickjaquier.com/oracle/goldengate-for-big-data-and-kafka-handlers-hands-on-part-1.html

GoldenGate for Big Data and Kafka Handlers hands-on – part 2
https://blog.yannickjaquier.com/oracle/goldengate-for-big-data-and-kafka-handlers-hands-on-part-2.html

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

HOW TO CREATE THE SAMPLE HR SCHEMA IN YOUR PDB?
https://ora-base.com/?p=1415

Step 1 ) Navigate to the DEMO folder
[oracle@ggs1 ~]$ cd /u01/app/oracle/product/19c/dbhome_1/demo/schema/human_resources

Step 2 ) Connect to the PDB and execute the “hr_main.sql”
[oracle@ggs1 human_resources]$ sqlplus / as sysdba

SQL> alter session set container=ORCLPDB;
SQL> @hr_main.sql

specify password for HR as parameter 1:
Enter value for 1: hr

specify default tablespeace for HR as parameter 2:
Enter value for 2: users

specify temporary tablespace for HR as parameter 3:
Enter value for 3: temp

specify log path as parameter 4:
Enter value for 4: /tmp

Step 3 ) Let’s connect as HR and check the tables
[oracle@ggs1 human_resources]$ sqlplus hr/hr@orclpdb

SQL> show user
SQL> set lin 200
SQL> col tname format a30
SQL> select * from tab;

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

Oracle GoldenGate 12c
http://samiora.blogspot.com/2020/05/oracle-goldengate-12c.html
Oracle GoldenGate Processes

How GoldenGate Works :

ORACLE GOLDENGATE - critical components :
https://medium.com/@Xavient/oracle-goldengate-57b09329222

Oracle GoldenGate Windows and UNIX Administrator’s Guide 11g Release 2 Patch Set 1 https://docs.oracle.com/cd/E35209_01/doc.1121/e29397.pdf

Oracle Database 19c RAC on Linux - Vagrant UP

2022-12-29T19:42:00.009+02:00

I've used below article :

Oracle Database 19c RAC On Oracle Linux 7 Using VirtualBox and Vagrant
https://oracle-base.com/articles/19c/oracle-db-19c-rac-installation-on-oracle-linux-7-using-virtualbox

for last node , after "vagrant up" command , below was on my screen :

alex@Lenovo-Legion:/home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/node1$

alex@Lenovo-Legion:/home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/node1$ vagrant up

Bringing machine 'default' up with 'virtualbox' provider...

==> default: Checking if box 'oraclebase/oracle-7' version '2022.10.21' is up to date...

==> default: Clearing any previously set network interfaces...

==> default: Preparing network interfaces based on configuration...

default: Adapter 1: nat

default: Adapter 2: hostonly

default: Adapter 3: intnet

==> default: Forwarding ports...

default: 1521 (guest) => 1521 (host) (adapter 1)

default: 5500 (guest) => 5500 (host) (adapter 1)

default: 22 (guest) => 2222 (host) (adapter 1)

==> default: Running 'pre-boot' VM customizations...

==> default: Booting VM...

==> default: Waiting for machine to boot. This may take a few minutes...

default: SSH address: 127.0.0.1:2222

default: SSH username: vagrant

default: SSH auth method: private key

default:

default: Vagrant insecure key detected. Vagrant will automatically replace

default: this with a newly generated keypair for better security.

default:

default: Inserting generated public key within guest...

default: Removing insecure key from the guest if it's present...

default: Key inserted! Disconnecting and reconnecting using new SSH key...

==> default: Machine booted and ready!

==> default: Checking for guest additions in VM...

==> default: Configuring and enabling network interfaces...

==> default: Mounting shared folders...

default: /vagrant => /home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/node1

default: /vagrant_config => /home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/config

default: /vagrant_scripts => /home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/shared_scripts

default: /vagrant_software => /home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/software

==> default: Running provisioner: shell...

default: Running: inline script

default: ******************************************************************************

default: Setup Start. Fri Dec 23 13:15:32 UTC 2022

default: ******************************************************************************

default: Amend hosts file with SCAN IPs. Fri Dec 23 13:15:32 UTC 2022

default: ******************************************************************************

default: Install dnsmasq. Fri Dec 23 13:15:32 UTC 2022

default: ******************************************************************************

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package dnsmasq.x86_64 0:2.76-17.el7_9.3 will be installed

default: --> Processing Dependency: libnettle.so.4()(64bit) for package: dnsmasq-2.76-17.el7_9.3.x86_64

default: ---> Package mc.x86_64 1:4.8.7-11.el7 will be installed

default: --> Processing Dependency: libgpm.so.2()(64bit) for package: 1:mc-4.8.7-11.el7.x86_64

default: --> Running transaction check

default: ---> Package gpm-libs.x86_64 0:1.20.7-6.el7 will be installed

default: ---> Package nettle.x86_64 0:2.7.1-9.el7_9 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: dnsmasq x86_64 2.76-17.el7_9.3 ol7_latest 280 k

default: mc x86_64 1:4.8.7-11.el7 ol7_latest 1.7 M

default: Installing for dependencies:

default: gpm-libs x86_64 1.20.7-6.el7 ol7_latest 32 k

default: nettle x86_64 2.7.1-9.el7_9 ol7_latest 327 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 2 Packages (+2 Dependent packages)

default: Total download size: 2.4 M

default: Installed size: 7.0 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 1.7 MB/s | 2.4 MB 00:01

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : gpm-libs-1.20.7-6.el7.x86_64 1/4

default:

default: Installing : nettle-2.7.1-9.el7_9.x86_64 2/4

default:

default: Installing : dnsmasq-2.76-17.el7_9.3.x86_64 3/4

default:

default: Installing : 1:mc-4.8.7-11.el7.x86_64 4/4

default:

default: Verifying : 1:mc-4.8.7-11.el7.x86_64 1/4

default:

default: Verifying : dnsmasq-2.76-17.el7_9.3.x86_64 2/4

default:

default: Verifying : nettle-2.7.1-9.el7_9.x86_64 3/4

default:

default: Verifying : gpm-libs-1.20.7-6.el7.x86_64 4/4

default:

default: Installed:

default: dnsmasq.x86_64 0:2.76-17.el7_9.3 mc.x86_64 1:4.8.7-11.el7

default:

default: Dependency Installed:

default: gpm-libs.x86_64 0:1.20.7-6.el7 nettle.x86_64 0:2.7.1-9.el7_9

default:

default: Complete!

default: Created symlink from /etc/systemd/system/multi-user.target.wants/dnsmasq.service to /usr/lib/systemd/system/dnsmasq.service.

default: ******************************************************************************

default: Setup End. Fri Dec 23 13:16:23 UTC 2022

default: ******************************************************************************

default: Prepare /u01 disk. Fri Dec 23 13:16:23 UTC 2022

default: ******************************************************************************

default: Welcome to fdisk (util-linux 2.23.2).

default:

default: Changes will remain in memory only, until you decide to write them.

default: Be careful before using the write command.

default:

default: Command (m for help): Partition type:

default: p primary (0 primary, 0 extended, 4 free)

default: e extended

default: Select (default p): Partition number (1-4, default 1):

default: Device does not contain a recognized partition table

default: Building a new DOS disklabel with disk identifier 0xf5b6bc91.

default: First sector (2048-209715199, default 2048): Using default value 2048

default: Last sector, +sectors or +size{K,M,G} (2048-209715199, default 209715199): Using default value 209715199

default: Partition 1 of type Linux and of size 100 GiB is set

default:

default: Command (m for help):

default: The partition table has been altered!

default:

default: Calling ioctl() to re-read partition table.

default: Syncing disks.

default: meta-data=/dev/sdb1 isize=256 agcount=4, agsize=6553536 blks

default: = sectsz=512 attr=2, projid32bit=1

default: = crc=0 finobt=0, sparse=0, rmapbt=0

default: = reflink=0

default: data = bsize=4096 blocks=26214144, imaxpct=25

default: = sunit=0 swidth=0 blks

default: naming =version 2 bsize=4096 ascii-ci=0, ftype=1

default: log =internal log bsize=4096 blocks=12799, version=2

default: = sectsz=512 sunit=0 blks, lazy-count=1

default: realtime =none extsz=4096 blocks=0, rtextents=0

default: ******************************************************************************

default: Prepare yum repos and install base packages. Fri Dec 23 13:16:24 UTC 2022

default: ******************************************************************************

default: Loaded plugins: ulninfo

default: Package yum-utils-1.1.31-54.0.1.el7_8.noarch already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package oracle-epel-release-el7.x86_64 0:1.0-4.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: oracle-epel-release-el7 x86_64 1.0-4.el7 ol7_latest 14 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default: Total download size: 14 k

default: Installed size: 18 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : oracle-epel-release-el7-1.0-4.el7.x86_64 1/1

default:

default: Verifying : oracle-epel-release-el7-1.0-4.el7.x86_64 1/1

default:

default: Installed:

default: oracle-epel-release-el7.x86_64 0:1.0-4.el7

default: Complete!

default: =========================== repo: ol7_developer_EPEL ===========================

default: [ol7_developer_EPEL]

default: async = True

default: bandwidth = 0

default: base_persistdir = /var/lib/yum/repos/x86_64/7Server

default: baseurl = https://yum.oracle.com/repo/OracleLinux/OL7/developer_EPEL/x86_64/

default: cache = 0

default: cachedir = /var/cache/yum/x86_64/7Server/ol7_developer_EPEL

default: check_config_file_age = True

default: compare_providers_priority = 80

default: cost = 1000

default: deltarpm_metadata_percentage = 100

default: deltarpm_percentage =

default: enabled = True

default: enablegroups = True

default: exclude =

default: failovermethod = priority

default: ftp_disable_epsv = False

default: gpgcadir = /var/lib/yum/repos/x86_64/7Server/ol7_developer_EPEL/gpgcadir

default: gpgcakey =

default: gpgcheck = True

default: gpgdir = /var/lib/yum/repos/x86_64/7Server/ol7_developer_EPEL/gpgdir

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

default: hdrdir = /var/cache/yum/x86_64/7Server/ol7_developer_EPEL/headers

default: http_caching = all

default: includepkgs =

default: ip_resolve =

default: keepalive = True

default: keepcache = False

default: mddownloadpolicy = sqlite

default: mdpolicy = group:small

default: mediaid =

default: metadata_expire = 21600

default: metadata_expire_filter = read-only:present

default: metalink =

default: minrate = 0

default: mirrorlist =

default: mirrorlist_expire = 86400

default: name = Oracle Linux 7Server EPEL Packages for Development (x86_64)

default: old_base_cache_dir =

default: password =

default: persistdir = /var/lib/yum/repos/x86_64/7Server/ol7_developer_EPEL

default: pkgdir = /var/cache/yum/x86_64/7Server/ol7_developer_EPEL/packages

default: proxy = False

default: proxy_dict =

default: proxy_password =

default: proxy_username =

default: repo_gpgcheck = False

default: retries = 10

default: skip_if_unavailable = False

default: ssl_check_cert_permissions = True

default: sslcacert =

default: sslclientcert =

default: sslclientkey =

default: sslverify = True

default: throttle = 0

default: timeout = 30.0

default: ui_id = ol7_developer_EPEL/x86_64

default: ui_repoid_vars = releasever,

default: basearch

default: username =

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package sshpass.x86_64 0:1.06-1.el7 will be installed

default: ---> Package unzip.x86_64 0:6.0-24.0.1.el7_9 will be installed

default: ---> Package zip.x86_64 0:3.0-11.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: sshpass x86_64 1.06-1.el7 ol7_developer_EPEL 21 k

default: unzip x86_64 6.0-24.0.1.el7_9 ol7_latest 172 k

default: zip x86_64 3.0-11.el7 ol7_latest 259 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 3 Packages

default: Total download size: 452 k

default: Installed size: 1.2 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 977 kB/s | 452 kB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : zip-3.0-11.el7.x86_64 1/3

default:

default: Installing : sshpass-1.06-1.el7.x86_64 2/3

default:

default: Installing : unzip-6.0-24.0.1.el7_9.x86_64 3/3

default:

default: Verifying : unzip-6.0-24.0.1.el7_9.x86_64 1/3

default:

default: Verifying : sshpass-1.06-1.el7.x86_64 2/3

default:

default: Verifying : zip-3.0-11.el7.x86_64 3/3

default:

default: Installed:

default: sshpass.x86_64 0:1.06-1.el7 unzip.x86_64 0:6.0-24.0.1.el7_9

default: zip.x86_64 0:3.0-11.el7

default: Complete!

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package oracle-database-preinstall-19c.x86_64 0:1.0-3.el7 will be installed

default: --> Processing Dependency: bind-utils for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: libaio for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: smartmontools for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: sysstat for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: xorg-x11-utils for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Processing Dependency: xorg-x11-xauth for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64

default: --> Running transaction check

default: ---> Package bind-utils.x86_64 32:9.11.4-26.P2.el7_9.10 will be installed

default: --> Processing Dependency: bind-libs(x86-64) = 32:9.11.4-26.P2.el7_9.10 for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: bind-libs-lite(x86-64) = 32:9.11.4-26.P2.el7_9.10 for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: libGeoIP.so.1()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: libbind9.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: libdns.so.1102()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: libirs.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: libisc.so.169()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: libisccfg.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: --> Processing Dependency: liblwres.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64

default: ---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed

default: ---> Package ksh.x86_64 0:20120801-144.0.1.el7_9 will be installed

default: ---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed

default: ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed

default: ---> Package libstdc++-devel.x86_64 0:4.8.5-44.0.3.el7 will be installed

default: ---> Package smartmontools.x86_64 1:7.0-2.el7 will be installed

default: ---> Package sysstat.x86_64 0:10.1.5-20.0.1.el7_9 will be installed

default: --> Processing Dependency: libsensors.so.4()(64bit) for package: sysstat-10.1.5-20.0.1.el7_9.x86_64

default: ---> Package xorg-x11-utils.x86_64 0:7.5-23.el7 will be installed

default: --> Processing Dependency: libXi.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXinerama.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXrandr.so.2()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXrender.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXtst.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXv.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXxf86dga.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXxf86misc.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libXxf86vm.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: --> Processing Dependency: libdmx.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64

default: ---> Package xorg-x11-xauth.x86_64 1:1.0.9-1.el7 will be installed

default: --> Running transaction check

default: ---> Package GeoIP.x86_64 0:1.5.0-14.el7 will be installed

default: --> Processing Dependency: geoipupdate for package: GeoIP-1.5.0-14.el7.x86_64

default: ---> Package bind-libs.x86_64 32:9.11.4-26.P2.el7_9.10 will be installed

default: --> Processing Dependency: bind-license = 32:9.11.4-26.P2.el7_9.10 for package: 32:bind-libs-9.11.4-26.P2.el7_9.10.x86_64

default: ---> Package bind-libs-lite.x86_64 32:9.11.4-26.P2.el7_9.10 will be installed

default: ---> Package libXi.x86_64 0:1.7.9-1.el7 will be installed

default: ---> Package libXinerama.x86_64 0:1.1.3-2.1.el7 will be installed

default: ---> Package libXrandr.x86_64 0:1.5.1-2.el7 will be installed

default: ---> Package libXrender.x86_64 0:0.9.10-1.el7 will be installed

default: ---> Package libXtst.x86_64 0:1.2.3-1.el7 will be installed

default: ---> Package libXv.x86_64 0:1.0.11-1.el7 will be installed

default: ---> Package libXxf86dga.x86_64 0:1.1.4-2.1.el7 will be installed

default: ---> Package libXxf86misc.x86_64 0:1.0.3-7.1.el7 will be installed

default: ---> Package libXxf86vm.x86_64 0:1.1.4-1.el7 will be installed

default: ---> Package libdmx.x86_64 0:1.1.3-3.el7 will be installed

default: ---> Package lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.0.1.el7 will be installed

default: --> Running transaction check

default: ---> Package bind-license.noarch 32:9.11.4-26.P2.el7_9.10 will be installed

default: ---> Package geoipupdate.x86_64 0:2.5.0-1.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: oracle-database-preinstall-19c

default: x86_64 1.0-3.el7 ol7_latest 27 k

default: Installing for dependencies:

default: GeoIP x86_64 1.5.0-14.el7 ol7_latest 1.5 M

default: bind-libs x86_64 32:9.11.4-26.P2.el7_9.10 ol7_latest 157 k

default: bind-libs-lite x86_64 32:9.11.4-26.P2.el7_9.10 ol7_latest 1.1 M

default: bind-license noarch 32:9.11.4-26.P2.el7_9.10 ol7_latest 91 k

default: bind-utils x86_64 32:9.11.4-26.P2.el7_9.10 ol7_latest 261 k

default: compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k

default: geoipupdate x86_64 2.5.0-1.el7 ol7_latest 34 k

default: ksh x86_64 20120801-144.0.1.el7_9 ol7_latest 882 k

default: libXi x86_64 1.7.9-1.el7 ol7_latest 40 k

default: libXinerama x86_64 1.1.3-2.1.el7 ol7_latest 13 k

default: libXrandr x86_64 1.5.1-2.el7 ol7_latest 27 k

default: libXrender x86_64 0.9.10-1.el7 ol7_latest 25 k

default: libXtst x86_64 1.2.3-1.el7 ol7_latest 20 k

default: libXv x86_64 1.0.11-1.el7 ol7_latest 18 k

default: libXxf86dga x86_64 1.1.4-2.1.el7 ol7_latest 18 k

default: libXxf86misc x86_64 1.0.3-7.1.el7 ol7_latest 19 k

default: libXxf86vm x86_64 1.1.4-1.el7 ol7_latest 17 k

default: libaio x86_64 0.3.109-13.el7 ol7_latest 24 k

default: libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k

default: libdmx x86_64 1.1.3-3.el7 ol7_latest 15 k

default: libstdc++-devel x86_64 4.8.5-44.0.3.el7 ol7_latest 1.5 M

default: lm_sensors-libs x86_64 3.4.0-8.20160601gitf9185e5.0.1.el7 ol7_latest 41 k

default: smartmontools x86_64 1:7.0-2.el7 ol7_latest 546 k

default: sysstat x86_64 10.1.5-20.0.1.el7_9 ol7_latest 315 k

default: xorg-x11-utils x86_64 7.5-23.el7 ol7_latest 114 k

default: xorg-x11-xauth x86_64 1:1.0.9-1.el7 ol7_latest 29 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+26 Dependent packages)

default: Total download size: 6.8 M

default: Installed size: 23 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 7.1 MB/s | 6.8 MB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : libaio-0.3.109-13.el7.x86_64 1/27

default:

default: Installing : 32:bind-license-9.11.4-26.P2.el7_9.10.noarch 2/27

default:

default: Installing : libXi-1.7.9-1.el7.x86_64 3/27

default:

default: Installing : libXrender-0.9.10-1.el7.x86_64 4/27

default:

default: Installing : libXrandr-1.5.1-2.el7.x86_64 5/27

default:

default: Installing : libXtst-1.2.3-1.el7.x86_64 6/27

default:

default: Installing : libaio-devel-0.3.109-13.el7.x86_64 7/27

default:

default: Installing : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.0.1.el7.x86_6 8/27

default:

default: Installing : sysstat-10.1.5-20.0.1.el7_9.x86_64 9/27

default:

default: Installing : libXxf86dga-1.1.4-2.1.el7.x86_64 10/27

default:

default: Installing : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 11/27

default:

default: Installing : compat-libcap1-1.10-7.el7.x86_64 12/27

default:

default: Installing : ksh-20120801-144.0.1.el7_9.x86_64 13/27

default:

default: Installing : 1:smartmontools-7.0-2.el7.x86_64 14/27

default:

default: Installing : libstdc++-devel-4.8.5-44.0.3.el7.x86_64 15/27

default:

default: Installing : libXxf86misc-1.0.3-7.1.el7.x86_64 16/27

default:

default: Installing : libXxf86vm-1.1.4-1.el7.x86_64 17/27

default:

default: Installing : libXv-1.0.11-1.el7.x86_64 18/27

default:

default: Installing : libXinerama-1.1.3-2.1.el7.x86_64 19/27

default:

default: Installing : geoipupdate-2.5.0-1.el7.x86_64 20/27

default:

default: Installing : GeoIP-1.5.0-14.el7.x86_64 21/27

default:

default: Installing : 32:bind-libs-lite-9.11.4-26.P2.el7_9.10.x86_64 22/27

default:

default: Installing : 32:bind-libs-9.11.4-26.P2.el7_9.10.x86_64 23/27

default:

default: Installing : 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64 24/27

default:

default: Installing : libdmx-1.1.3-3.el7.x86_64 25/27

default:

default: Installing : xorg-x11-utils-7.5-23.el7.x86_64 26/27

default:

default: Installing : oracle-database-preinstall-19c-1.0-3.el7.x86_64 27/27

default:

default: Verifying : 32:bind-libs-9.11.4-26.P2.el7_9.10.x86_64 1/27

default:

default: Verifying : libdmx-1.1.3-3.el7.x86_64 2/27

default:

default: Verifying : geoipupdate-2.5.0-1.el7.x86_64 3/27

default:

default: Verifying : libXinerama-1.1.3-2.1.el7.x86_64 4/27

default:

default: Verifying : libXrender-0.9.10-1.el7.x86_64 5/27

default:

default: Verifying : libXv-1.0.11-1.el7.x86_64 6/27

default:

default: Verifying : libXi-1.7.9-1.el7.x86_64 7/27

default:

default: Verifying : libXxf86vm-1.1.4-1.el7.x86_64 8/27

default:

default: Verifying : libXxf86misc-1.0.3-7.1.el7.x86_64 9/27

default:

default: Verifying : 32:bind-libs-lite-9.11.4-26.P2.el7_9.10.x86_64 10/27

default:

default: Verifying : 32:bind-utils-9.11.4-26.P2.el7_9.10.x86_64 11/27

default:

default: Verifying : GeoIP-1.5.0-14.el7.x86_64 12/27

default:

default: Verifying : xorg-x11-utils-7.5-23.el7.x86_64 13/27

default:

default: Verifying : 32:bind-license-9.11.4-26.P2.el7_9.10.noarch 14/27

default:

default: Verifying : libXtst-1.2.3-1.el7.x86_64 15/27

default:

default: Verifying : libstdc++-devel-4.8.5-44.0.3.el7.x86_64 16/27

default:

default: Verifying : libaio-0.3.109-13.el7.x86_64 17/27

default:

default: Verifying : 1:smartmontools-7.0-2.el7.x86_64 18/27

default:

default: Verifying : sysstat-10.1.5-20.0.1.el7_9.x86_64 19/27

default:

default: Verifying : ksh-20120801-144.0.1.el7_9.x86_64 20/27

default:

default: Verifying : oracle-database-preinstall-19c-1.0-3.el7.x86_64 21/27

default:

default: Verifying : compat-libcap1-1.10-7.el7.x86_64 22/27

default:

default: Verifying : libXrandr-1.5.1-2.el7.x86_64 23/27

default:

default: Verifying : libaio-devel-0.3.109-13.el7.x86_64 24/27

default:

default: Verifying : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64 25/27

default:

default: Verifying : libXxf86dga-1.1.4-2.1.el7.x86_64 26/27

default:

default: Verifying : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.0.1.el7.x86_6 27/27

default:

default: Installed:

default: oracle-database-preinstall-19c.x86_64 0:1.0-3.el7

default:

default: Dependency Installed:

default: GeoIP.x86_64 0:1.5.0-14.el7

default: bind-libs.x86_64 32:9.11.4-26.P2.el7_9.10

default: bind-libs-lite.x86_64 32:9.11.4-26.P2.el7_9.10

default: bind-license.noarch 32:9.11.4-26.P2.el7_9.10

default: bind-utils.x86_64 32:9.11.4-26.P2.el7_9.10

default: compat-libcap1.x86_64 0:1.10-7.el7

default: geoipupdate.x86_64 0:2.5.0-1.el7

default: ksh.x86_64 0:20120801-144.0.1.el7_9

default: libXi.x86_64 0:1.7.9-1.el7

default: libXinerama.x86_64 0:1.1.3-2.1.el7

default: libXrandr.x86_64 0:1.5.1-2.el7

default: libXrender.x86_64 0:0.9.10-1.el7

default: libXtst.x86_64 0:1.2.3-1.el7

default: libXv.x86_64 0:1.0.11-1.el7

default: libXxf86dga.x86_64 0:1.1.4-2.1.el7

default: libXxf86misc.x86_64 0:1.0.3-7.1.el7

default: libXxf86vm.x86_64 0:1.1.4-1.el7

default: libaio.x86_64 0:0.3.109-13.el7

default: libaio-devel.x86_64 0:0.3.109-13.el7

default: libdmx.x86_64 0:1.1.3-3.el7

default: libstdc++-devel.x86_64 0:4.8.5-44.0.3.el7

default: lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.0.1.el7

default: smartmontools.x86_64 1:7.0-2.el7

default: sysstat.x86_64 0:10.1.5-20.0.1.el7_9

default: xorg-x11-utils.x86_64 0:7.5-23.el7

default: xorg-x11-xauth.x86_64 1:1.0.9-1.el7

default: Complete!

default: ******************************************************************************

default: Add extra OS packages. Most should be present. Fri Dec 23 13:16:52 UTC 2022

default: ******************************************************************************

default: Loaded plugins: ulninfo

default: Package bc-1.06.95-13.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package binutils-2.27-44.base.0.3.el7_9.1.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: compat-libstdc++-33 x86_64 3.2.3-72.el7 ol7_latest 190 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default: Total download size: 190 k

default: Installed size: 811 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 1/1

default:

default: Verifying : compat-libstdc++-33-3.2.3-72.el7.x86_64 1/1

default:

default: Installed:

default: compat-libstdc++-33.x86_64 0:3.2.3-72.el7

default: Complete!

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package dtrace-utils.x86_64 0:0.6.2-3.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: dtrace-utils x86_64 0.6.2-3.el7 ol7_latest 312 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default: Total download size: 312 k

default: Installed size: 931 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : dtrace-utils-0.6.2-3.el7.x86_64 1/1

default:

default: Verifying : dtrace-utils-0.6.2-3.el7.x86_64 1/1

default:

default: Installed:

default: dtrace-utils.x86_64 0:0.6.2-3.el7

default: Complete!

default: Loaded plugins: ulninfo

default: Package elfutils-libelf-0.176-5.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package elfutils-libelf-devel-0.176-5.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package fontconfig-devel.x86_64 0:2.13.0-4.3.el7 will be installed

default: --> Processing Dependency: fontconfig(x86-64) = 2.13.0-4.3.el7 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64

default: --> Processing Dependency: freetype-devel >= 2.8-7 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64

default: --> Processing Dependency: pkgconfig(freetype2) >= 20.0.14 for package: fontconfig-devel-2.13.0-4.3.el7.x86_64

default: --> Processing Dependency: pkgconfig(expat) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64

default: --> Processing Dependency: pkgconfig(uuid) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64

default: --> Processing Dependency: libfontconfig.so.1()(64bit) for package: fontconfig-devel-2.13.0-4.3.el7.x86_64

default: --> Running transaction check

default: ---> Package expat-devel.x86_64 0:2.1.0-15.0.1.el7_9 will be installed

default: ---> Package fontconfig.x86_64 0:2.13.0-4.3.el7 will be installed

default: --> Processing Dependency: dejavu-sans-fonts for package: fontconfig-2.13.0-4.3.el7.x86_64

default: --> Processing Dependency: fontpackages-filesystem for package: fontconfig-2.13.0-4.3.el7.x86_64

default: ---> Package freetype-devel.x86_64 0:2.8-14.el7_9.1 will be installed

default: --> Processing Dependency: pkgconfig(libpng) for package: freetype-devel-2.8-14.el7_9.1.x86_64

default: ---> Package libuuid-devel.x86_64 0:2.23.2-65.0.3.el7_9.1 will be installed

default: --> Running transaction check

default: ---> Package dejavu-sans-fonts.noarch 0:2.33-6.el7 will be installed

default: --> Processing Dependency: dejavu-fonts-common = 2.33-6.el7 for package: dejavu-sans-fonts-2.33-6.el7.noarch

default: ---> Package fontpackages-filesystem.noarch 0:1.44-8.el7 will be installed

default: ---> Package libpng-devel.x86_64 2:1.5.13-8.el7 will be installed

default: --> Running transaction check

default: ---> Package dejavu-fonts-common.noarch 0:2.33-6.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: fontconfig-devel x86_64 2.13.0-4.3.el7 ol7_latest 137 k

default: Installing for dependencies:

default: dejavu-fonts-common noarch 2.33-6.el7 ol7_latest 64 k

default: dejavu-sans-fonts noarch 2.33-6.el7 ol7_latest 1.4 M

default: expat-devel x86_64 2.1.0-15.0.1.el7_9 ol7_latest 58 k

default: fontconfig x86_64 2.13.0-4.3.el7 ol7_latest 254 k

default: fontpackages-filesystem noarch 1.44-8.el7 ol7_latest 9.4 k

default: freetype-devel x86_64 2.8-14.el7_9.1 ol7_latest 446 k

default: libpng-devel x86_64 2:1.5.13-8.el7 ol7_latest 121 k

default: libuuid-devel x86_64 2.23.2-65.0.3.el7_9.1 ol7_latest 93 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+8 Dependent packages)

default: Total download size: 2.6 M

default: Installed size: 9.3 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 3.8 MB/s | 2.6 MB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : fontpackages-filesystem-1.44-8.el7.noarch 1/9

default:

default: Installing : dejavu-fonts-common-2.33-6.el7.noarch 2/9

default:

default: Installing : dejavu-sans-fonts-2.33-6.el7.noarch 3/9

default:

default: Installing : fontconfig-2.13.0-4.3.el7.x86_64 4/9

default:

default: Installing : 2:libpng-devel-1.5.13-8.el7.x86_64 5/9

default:

default: Installing : freetype-devel-2.8-14.el7_9.1.x86_64 6/9

default:

default: Installing : expat-devel-2.1.0-15.0.1.el7_9.x86_64 7/9

default:

default: Installing : libuuid-devel-2.23.2-65.0.3.el7_9.1.x86_64 8/9

default:

default: Installing : fontconfig-devel-2.13.0-4.3.el7.x86_64 9/9

default:

default: Verifying : fontconfig-devel-2.13.0-4.3.el7.x86_64 1/9

default:

default: Verifying : fontconfig-2.13.0-4.3.el7.x86_64 2/9

default:

default: Verifying : libuuid-devel-2.23.2-65.0.3.el7_9.1.x86_64 3/9

default:

default: Verifying : expat-devel-2.1.0-15.0.1.el7_9.x86_64 4/9

default:

default: Verifying : dejavu-fonts-common-2.33-6.el7.noarch 5/9

default:

default: Verifying : dejavu-sans-fonts-2.33-6.el7.noarch 6/9

default:

default: Verifying : 2:libpng-devel-1.5.13-8.el7.x86_64 7/9

default:

default: Verifying : freetype-devel-2.8-14.el7_9.1.x86_64 8/9

default:

default: Verifying : fontpackages-filesystem-1.44-8.el7.noarch 9/9

default:

default: Installed:

default: fontconfig-devel.x86_64 0:2.13.0-4.3.el7

default:

default: Dependency Installed:

default: dejavu-fonts-common.noarch 0:2.33-6.el7

default: dejavu-sans-fonts.noarch 0:2.33-6.el7

default: expat-devel.x86_64 0:2.1.0-15.0.1.el7_9

default: fontconfig.x86_64 0:2.13.0-4.3.el7

default: fontpackages-filesystem.noarch 0:1.44-8.el7

default: freetype-devel.x86_64 0:2.8-14.el7_9.1

default: libpng-devel.x86_64 2:1.5.13-8.el7

default: libuuid-devel.x86_64 0:2.23.2-65.0.3.el7_9.1

default: Complete!

default: Loaded plugins: ulninfo

default: Package glibc-2.17-326.0.1.el7_9.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package glibc-devel-2.17-326.0.1.el7_9.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package ksh-20120801-144.0.1.el7_9.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libaio-0.3.109-13.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libaio-devel-0.3.109-13.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package libdtrace-ctf-devel.x86_64 0:1.1.0-2.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: libdtrace-ctf-devel x86_64 1.1.0-2.el7 ol7_UEKR6 22 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default:

default: Total download size: 22 k

default: Installed size: 53 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : libdtrace-ctf-devel-1.1.0-2.el7.x86_64 1/1

default:

default: Verifying : libdtrace-ctf-devel-1.1.0-2.el7.x86_64 1/1

default:

default: Installed:

default: libdtrace-ctf-devel.x86_64 0:1.1.0-2.el7

default:

default: Complete!

default: Loaded plugins: ulninfo

default: Package libXrender-0.9.10-1.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package libXrender-devel.x86_64 0:0.9.10-1.el7 will be installed

default: --> Processing Dependency: pkgconfig(renderproto) >= 0.9 for package: libXrender-devel-0.9.10-1.el7.x86_64

default: --> Processing Dependency: pkgconfig(x11) for package: libXrender-devel-0.9.10-1.el7.x86_64

default: --> Processing Dependency: pkgconfig(xproto) for package: libXrender-devel-0.9.10-1.el7.x86_64

default: --> Running transaction check

default: ---> Package libX11-devel.x86_64 0:1.6.7-4.el7_9 will be installed

default: --> Processing Dependency: pkgconfig(xcb) >= 1.11.1 for package: libX11-devel-1.6.7-4.el7_9.x86_64

default: --> Processing Dependency: pkgconfig(xcb) for package: libX11-devel-1.6.7-4.el7_9.x86_64

default: ---> Package xorg-x11-proto-devel.noarch 0:2018.4-1.el7 will be installed

default: --> Running transaction check

default: ---> Package libxcb-devel.x86_64 0:1.13-1.el7 will be installed

default: --> Processing Dependency: pkgconfig(xau) >= 0.99.2 for package: libxcb-devel-1.13-1.el7.x86_64

default: --> Running transaction check

default: ---> Package libXau-devel.x86_64 0:1.0.8-2.1.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: libXrender-devel x86_64 0.9.10-1.el7 ol7_latest 16 k

default: Installing for dependencies:

default: libX11-devel x86_64 1.6.7-4.el7_9 ol7_latest 981 k

default: libXau-devel x86_64 1.0.8-2.1.el7 ol7_latest 14 k

default: libxcb-devel x86_64 1.13-1.el7 ol7_latest 1.1 M

default: xorg-x11-proto-devel noarch 2018.4-1.el7 ol7_latest 279 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+4 Dependent packages)

default: Total download size: 2.3 M

default: Installed size: 5.4 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 4.1 MB/s | 2.3 MB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : xorg-x11-proto-devel-2018.4-1.el7.noarch 1/5

default:

default: Installing : libXau-devel-1.0.8-2.1.el7.x86_64 2/5

default:

default: Installing : libxcb-devel-1.13-1.el7.x86_64 3/5

default:

default: Installing : libX11-devel-1.6.7-4.el7_9.x86_64 4/5

default:

default: Installing : libXrender-devel-0.9.10-1.el7.x86_64 5/5

default:

default: Verifying : libXrender-devel-0.9.10-1.el7.x86_64 1/5

default:

default: Verifying : libX11-devel-1.6.7-4.el7_9.x86_64 2/5

default:

default: Verifying : xorg-x11-proto-devel-2018.4-1.el7.noarch 3/5

default:

default: Verifying : libXau-devel-1.0.8-2.1.el7.x86_64 4/5

default:

default: Verifying : libxcb-devel-1.13-1.el7.x86_64 5/5

default:

default: Installed:

default: libXrender-devel.x86_64 0:0.9.10-1.el7

default:

default: Dependency Installed:

default: libX11-devel.x86_64 0:1.6.7-4.el7_9

default: libXau-devel.x86_64 0:1.0.8-2.1.el7

default: libxcb-devel.x86_64 0:1.13-1.el7

default: xorg-x11-proto-devel.noarch 0:2018.4-1.el7

default: Complete!

default: Loaded plugins: ulninfo

default: Package libX11-1.6.7-4.el7_9.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libXau-1.0.8-2.1.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libXi-1.7.9-1.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libXtst-1.2.3-1.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libgcc-4.8.5-44.0.3.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package rdma-core-devel.x86_64 0:22.4-6.el7_9 will be installed

default: --> Processing Dependency: ibacm = 22.4-6.el7_9 for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: libibumad = 22.4-6.el7_9 for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: libibverbs = 22.4-6.el7_9 for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: librdmacm = 22.4-6.el7_9 for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: rdma-core(x86-64) = 22.4-6.el7_9 for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: libibumad.so.3()(64bit) for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: libibverbs.so.1()(64bit) for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: libmlx4.so.1()(64bit) for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: libmlx5.so.1()(64bit) for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Processing Dependency: librdmacm.so.1()(64bit) for package: rdma-core-devel-22.4-6.el7_9.x86_64

default: --> Running transaction check

default: ---> Package ibacm.x86_64 0:22.4-6.el7_9 will be installed

default: ---> Package libibumad.x86_64 0:22.4-6.el7_9 will be installed

default: ---> Package libibverbs.x86_64 0:22.4-6.el7_9 will be installed

default: ---> Package librdmacm.x86_64 0:22.4-6.el7_9 will be installed

default: ---> Package rdma-core.x86_64 0:22.4-6.el7_9 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: rdma-core-devel x86_64 22.4-6.el7_9 ol7_latest 254 k

default: Installing for dependencies:

default: ibacm x86_64 22.4-6.el7_9 ol7_latest 82 k

default: libibumad x86_64 22.4-6.el7_9 ol7_latest 24 k

default: libibverbs x86_64 22.4-6.el7_9 ol7_latest 268 k

default: librdmacm x86_64 22.4-6.el7_9 ol7_latest 63 k

default: rdma-core x86_64 22.4-6.el7_9 ol7_latest 51 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+5 Dependent packages)

default: Total download size: 743 k

default: Installed size: 1.5 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 932 kB/s | 743 kB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : rdma-core-22.4-6.el7_9.x86_64 1/6

default:

default: Installing : libibverbs-22.4-6.el7_9.x86_64 2/6

default:

default: Installing : libibumad-22.4-6.el7_9.x86_64 3/6

default:

default: Installing : ibacm-22.4-6.el7_9.x86_64 4/6

default:

default: Installing : librdmacm-22.4-6.el7_9.x86_64 5/6

default:

default: Installing : rdma-core-devel-22.4-6.el7_9.x86_64 6/6

default:

default: Verifying : ibacm-22.4-6.el7_9.x86_64 1/6

default:

default: Verifying : rdma-core-devel-22.4-6.el7_9.x86_64 2/6

default:

default: Verifying : libibverbs-22.4-6.el7_9.x86_64 3/6

default:

default: Verifying : rdma-core-22.4-6.el7_9.x86_64 4/6

default:

default: Verifying : libibumad-22.4-6.el7_9.x86_64 5/6

default:

default: Verifying : librdmacm-22.4-6.el7_9.x86_64 6/6

default:

default: Installed:

default: rdma-core-devel.x86_64 0:22.4-6.el7_9

default:

default: Dependency Installed:

default: ibacm.x86_64 0:22.4-6.el7_9 libibumad.x86_64 0:22.4-6.el7_9

default: libibverbs.x86_64 0:22.4-6.el7_9 librdmacm.x86_64 0:22.4-6.el7_9

default: rdma-core.x86_64 0:22.4-6.el7_9

default: Complete!

default: Loaded plugins: ulninfo

default: Package libstdc++-4.8.5-44.0.3.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libstdc++-devel-4.8.5-44.0.3.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package libxcb-1.13-1.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package 1:make-3.82-24.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package net-tools-2.0-0.25.20131004git.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package 1:nfs-utils-1.3.0-0.68.0.1.el7.2.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package python-2.7.5-92.0.1.el7_9.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package python-configshell.noarch 1:1.1.26-1.0.1.el7 will be installed

default: --> Processing Dependency: pyparsing for package: 1:python-configshell-1.1.26-1.0.1.el7.noarch

default: --> Processing Dependency: python-six for package: 1:python-configshell-1.1.26-1.0.1.el7.noarch

default: --> Processing Dependency: python-urwid for package: 1:python-configshell-1.1.26-1.0.1.el7.noarch

default: --> Running transaction check

default: ---> Package pyparsing.noarch 0:2.0.3-1.el7 will be installed

default: ---> Package python-six.noarch 0:1.9.0-2.el7 will be installed

default: ---> Package python-urwid.x86_64 0:1.1.1-3.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: python-configshell noarch 1:1.1.26-1.0.1.el7 ol7_latest 68 k

default: Installing for dependencies:

default: pyparsing noarch 2.0.3-1.el7 ol7_developer_EPEL 98 k

default: python-six noarch 1.9.0-2.el7 ol7_latest 28 k

default: python-urwid x86_64 1.1.1-3.el7 ol7_latest 653 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+3 Dependent packages)

default: Total download size: 847 k

default: Installed size: 3.6 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 1.7 MB/s | 847 kB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : python-urwid-1.1.1-3.el7.x86_64 1/4

default:

default: Installing : python-six-1.9.0-2.el7.noarch 2/4

default:

default: Installing : pyparsing-2.0.3-1.el7.noarch 3/4

default:

default: Installing : 1:python-configshell-1.1.26-1.0.1.el7.noarch 4/4

default:

default: Verifying : pyparsing-2.0.3-1.el7.noarch 1/4

default:

default: Verifying : python-six-1.9.0-2.el7.noarch 2/4

default:

default: Verifying : python-urwid-1.1.1-3.el7.x86_64 3/4

default:

default: Verifying : 1:python-configshell-1.1.26-1.0.1.el7.noarch 4/4

default:

default: Installed:

default: python-configshell.noarch 1:1.1.26-1.0.1.el7

default:

default: Dependency Installed:

default: pyparsing.noarch 0:2.0.3-1.el7 python-six.noarch 0:1.9.0-2.el7

default: python-urwid.x86_64 0:1.1.1-3.el7

default:

default: Complete!

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package python-rtslib.noarch 0:2.1.74-1.0.3.el7_9 will be installed

default: --> Processing Dependency: python-kmod for package: python-rtslib-2.1.74-1.0.3.el7_9.noarch

default: --> Running transaction check

default: ---> Package python-kmod.x86_64 0:0.9-4.el7 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: python-rtslib noarch 2.1.74-1.0.3.el7_9 ol7_latest 104 k

default: Installing for dependencies:

default: python-kmod x86_64 0.9-4.el7 ol7_latest 56 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+1 Dependent package)

default: Total download size: 160 k

default: Installed size: 905 k

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 418 kB/s | 160 kB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : python-kmod-0.9-4.el7.x86_64 1/2

default:

default: Installing : python-rtslib-2.1.74-1.0.3.el7_9.noarch 2/2

default:

default: Verifying : python-rtslib-2.1.74-1.0.3.el7_9.noarch 1/2

default:

default: Verifying : python-kmod-0.9-4.el7.x86_64 2/2

default:

default: Installed:

default: python-rtslib.noarch 0:2.1.74-1.0.3.el7_9

default:

default: Dependency Installed:

default: python-kmod.x86_64 0:0.9-4.el7

default: Complete!

default: Loaded plugins: ulninfo

default: Package python-six-1.9.0-2.el7.noarch already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package targetcli.noarch 0:2.1.53-1.0.1.el7_9 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: targetcli noarch 2.1.53-1.0.1.el7_9 ol7_latest 74 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default: Total download size: 74 k

default: Installed size: 254 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : targetcli-2.1.53-1.0.1.el7_9.noarch 1/1

default:

default: Verifying : targetcli-2.1.53-1.0.1.el7_9.noarch 1/1

default:

default: Installed:

default: targetcli.noarch 0:2.1.53-1.0.1.el7_9

default: Complete!

default: Loaded plugins: ulninfo

default: Package 1:smartmontools-7.0-2.el7.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Package sysstat-10.1.5-20.0.1.el7_9.x86_64 already installed and latest version

default: Nothing to do

default: Loaded plugins: ulninfo

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package unixODBC.x86_64 0:2.3.1-14.0.1.el7 will be installed

default: --> Processing Dependency: libltdl.so.7()(64bit) for package: unixODBC-2.3.1-14.0.1.el7.x86_64

default: --> Running transaction check

default: ---> Package libtool-ltdl.x86_64 0:2.4.2-22.el7_3 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: unixODBC x86_64 2.3.1-14.0.1.el7 ol7_latest 413 k

default: Installing for dependencies:

default: libtool-ltdl x86_64 2.4.2-22.el7_3 ol7_latest 48 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package (+1 Dependent package)

default: Total download size: 461 k

default: Installed size: 1.3 M

default: Downloading packages:

default: --------------------------------------------------------------------------------

default: Total 553 kB/s | 461 kB 00:00

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Installing : libtool-ltdl-2.4.2-22.el7_3.x86_64 1/2

default:

default: Installing : unixODBC-2.3.1-14.0.1.el7.x86_64 2/2

default:

default: Verifying : unixODBC-2.3.1-14.0.1.el7.x86_64 1/2

default:

default: Verifying : libtool-ltdl-2.4.2-22.el7_3.x86_64 2/2

default:

default: Installed:

default: unixODBC.x86_64 0:2.3.1-14.0.1.el7

default:

default: Dependency Installed:

default: libtool-ltdl.x86_64 0:2.4.2-22.el7_3

default: Complete!

default: Loaded plugins: ulninfo

default: Package chrony-3.4-1.0.1.el7.x86_64 already installed and latest version

default: Nothing to do

default: ******************************************************************************

default: Firewall. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: SELinux. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: Set root and oracle password and change ownership of /u01. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: New password:

default: BAD PASSWORD: The password contains the user name in some form

default: Retype new password:

default: Changing password for user root.

default: passwd: all authentication tokens updated successfully.

default: New password: BAD PASSWORD: The password is shorter than 8 characters

default: Retype new password:

default: Changing password for user oracle.

default: passwd: all authentication tokens updated successfully.

default: ******************************************************************************

default: Amend hosts file with public, private and virtual IPs. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: Enable chronyd service. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: 503 No such source

default: 200 OK

default: ******************************************************************************

default: Configure shared disks. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: Partition disks. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: /dev/sda

default: /dev/sda1

default: /dev/sda2

default: /dev/sda3

default: /dev/sdb

default: /dev/sdb1

default: /dev/sdc

default: /dev/sdc1

default: /dev/sdd

default: /dev/sdd1

default: /dev/sde

default: /dev/sde1

default: /dev/sdf

default: /dev/sdf1

default: /dev/sdg

default: /dev/sdg1

default: ******************************************************************************

default: Configure udev. Fri Dec 23 13:18:17 UTC 2022

default: ******************************************************************************

default: lrwxrwxrwx. 1 root root 7 Dec 23 13:18 /dev/oracleasm/asm-crs-disk1 -> ../sdc1

default: lrwxrwxrwx. 1 root root 7 Dec 23 13:18 /dev/oracleasm/asm-crs-disk2 -> ../sdd1

default: lrwxrwxrwx. 1 root root 7 Dec 23 13:18 /dev/oracleasm/asm-crs-disk3 -> ../sde1

default: lrwxrwxrwx. 1 root root 7 Dec 23 13:18 /dev/oracleasm/asm-data-disk1 -> ../sdf1

default: lrwxrwxrwx. 1 root root 7 Dec 23 13:18 /dev/oracleasm/asm-reco-disk1 -> ../sdg1

default: ******************************************************************************

default: Create environment scripts. Fri Dec 23 13:18:58 UTC 2022

default: ******************************************************************************

default: Create directories. Fri Dec 23 13:18:58 UTC 2022

default: ******************************************************************************

default: Passwordless SSH Setup for oracle. Fri Dec 23 13:18:58 UTC 2022

default: ******************************************************************************

default: Host key verification failed.

default: # ol7-19-rac1:22 SSH-2.0-OpenSSH_7.4

default: # ol7-19-rac2:22 SSH-2.0-OpenSSH_7.4

default: /bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/home/oracle/.ssh/id_dsa.pub"

default: /bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed

default: /bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys

default:

default: Number of key(s) added: 1

default:

default: Now try logging into the machine, with: "ssh 'ol7-19-rac2'"

default: and check to make sure that only the key(s) you wanted were added.

default: # ol7-19-rac1:22 SSH-2.0-OpenSSH_7.4

default: # ol7-19-rac2:22 SSH-2.0-OpenSSH_7.4

default: /usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/home/oracle/.ssh/id_dsa.pub"

default: /usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed

default: /usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys

default:

default: Number of key(s) added: 1

default:

default: Now try logging into the machine, with: "ssh 'ol7-19-rac1'"

default: and check to make sure that only the key(s) you wanted were added.

default: ******************************************************************************

default: Unzip grid software. Fri Dec 23 13:19:00 UTC 2022

default: ******************************************************************************

default: Set Hostname. Fri Dec 23 13:20:25 UTC 2022

default: ******************************************************************************

default: Passwordless SSH Setup for root. Fri Dec 23 13:20:25 UTC 2022

default: ******************************************************************************

default: Host key verification failed.

default: # ol7-19-rac1:22 SSH-2.0-OpenSSH_7.4

default: # ol7-19-rac2:22 SSH-2.0-OpenSSH_7.4

default: /bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_dsa.pub"

default: /bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed

default: /bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys

default:

default: Number of key(s) added: 1

default:

default: Now try logging into the machine, with: "ssh 'ol7-19-rac2'"

default: and check to make sure that only the key(s) you wanted were added.

default: # ol7-19-rac1:22 SSH-2.0-OpenSSH_7.4

default: # ol7-19-rac2:22 SSH-2.0-OpenSSH_7.4

default: /usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_dsa.pub"

default: /usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed

default: /usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys

default:

default: Number of key(s) added: 1

default:

default: Now try logging into the machine, with: "ssh 'ol7-19-rac1'"

default: and check to make sure that only the key(s) you wanted were added.

default: ******************************************************************************

default: Install cvuqdisk package. Fri Dec 23 13:20:28 UTC 2022

default: ******************************************************************************

default: Loaded plugins: ulninfo

default: Examining /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm: cvuqdisk-1.0.10-1.x86_64

default: Marking /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm to be installed

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package cvuqdisk.x86_64 0:1.0.10-1 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: cvuqdisk x86_64 1.0.10-1 /cvuqdisk-1.0.10-1 22 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default: Total size: 22 k

default: Installed size: 22 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Using default group oinstall to install package

default: Installing : cvuqdisk-1.0.10-1.x86_64 1/1

default:

default: Verifying : cvuqdisk-1.0.10-1.x86_64 1/1

default:

default: Installed:

default: cvuqdisk.x86_64 0:1.0.10-1

default: Complete!

default: Loaded plugins: ulninfo

default: Examining /tmp/cvuqdisk-1.0.10-1.rpm: cvuqdisk-1.0.10-1.x86_64

default: Marking /tmp/cvuqdisk-1.0.10-1.rpm to be installed

default: Resolving Dependencies

default: --> Running transaction check

default: ---> Package cvuqdisk.x86_64 0:1.0.10-1 will be installed

default: --> Finished Dependency Resolution

default:

default: Dependencies Resolved

default:

default: ================================================================================

default: Package Arch Version Repository Size

default: ================================================================================

default: Installing:

default: cvuqdisk x86_64 1.0.10-1 /cvuqdisk-1.0.10-1 22 k

default:

default: Transaction Summary

default: ================================================================================

default: Install 1 Package

default: Total size: 22 k

default: Installed size: 22 k

default: Downloading packages:

default: Running transaction check

default: Running transaction test

default: Transaction test succeeded

default: Running transaction

default: Using default group oinstall to install package

default: Installing : cvuqdisk-1.0.10-1.x86_64 1/1

default:

default: Verifying : cvuqdisk-1.0.10-1.x86_64 1/1

default:

default: Installed:

default: cvuqdisk.x86_64 0:1.0.10-1

default:

default: Complete!

default: ******************************************************************************

default: Do grid software-only installation. Fri Dec 23 13:20:39 UTC 2022

default: ******************************************************************************

default: Launching Oracle Grid Infrastructure Setup Wizard...

default: [WARNING] [INS-41808] Possible invalid choice for OSASM Group.

default: CAUSE: The name of the group you selected for the OSASM group is commonly used to grant other system privileges (For example: asmdba, asmoper, dba, oper).

default: ACTION: Oracle recommends that you designate asmadmin as the OSASM group.

default: [WARNING] [INS-41809] Possible invalid choice for OSDBA Group.

default: CAUSE: The group name you selected as the OSDBA for ASM group is commonly used for Oracle Database administrator privileges.

default: ACTION: Oracle recommends that you designate asmdba as the OSDBA for ASM group, and that the group should not be the same group as an Oracle Database OSDBA group.

default: [WARNING] [INS-41812] OSDBA and OSASM are the same OS group.

default: CAUSE: The chosen values for OSDBA group and the chosen value for OSASM group are the same.

default: ACTION: Select an OS group that is unique for ASM administrators. The OSASM group should not be the same as the OS groups that grant privileges for Oracle ASM access, or for database administration.

default: [WARNING] [INS-40109] The specified Oracle Base location is not empty on this server.

default: ACTION: Specify an empty location for Oracle Base.

default: [WARNING] [INS-13013] Target environment does not meet some mandatory requirements.

default: CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /tmp/GridSetupActions2022-12-23_01-20-39PM/gridSetupActions2022-12-23_01-20-39PM.log

default: ACTION: Identify the list of failed prerequisite checks from the log: /tmp/GridSetupActions2022-12-23_01-20-39PM/gridSetupActions2022-12-23_01-20-39PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

default: The response file for this session can be found at:

default: /u01/app/19.0.0/grid/install/response/grid_2022-12-23_01-20-39PM.rsp

default: You can find the log of this install session at:

default: /tmp/GridSetupActions2022-12-23_01-20-39PM/gridSetupActions2022-12-23_01-20-39PM.log

default:

default: As a root user, execute the following script(s):

default: 1. /u01/app/oraInventory/orainstRoot.sh

default: 2. /u01/app/19.0.0/grid/root.sh

default:

default: Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:

default: [ol7-19-rac1, ol7-19-rac2]

default: Execute /u01/app/19.0.0/grid/root.sh on the following nodes:

default: [ol7-19-rac1, ol7-19-rac2]

default:

default: Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.

default:

default: Successfully Setup Software with warning(s).

default: As install user, execute the following command to complete the configuration.

default: /u01/app/19.0.0/grid/gridSetup.sh -executeConfigTools -responseFile /u01/app/19.0.0/grid/install/response/gridsetup.rsp [-silent]

default: Moved the install session logs to:

default: /u01/app/oraInventory/logs/GridSetupActions2022-12-23_01-20-39PM

default: ******************************************************************************

default: Run grid root scripts. Fri Dec 23 13:27:45 UTC 2022

default: ******************************************************************************

default: Changing permissions of /u01/app/oraInventory.

default: Adding read,write permissions for group.

default: Removing read,write,execute permissions for world.

default: Changing groupname of /u01/app/oraInventory to oinstall.

default: The execution of the script is complete.

default: Changing permissions of /u01/app/oraInventory.

default: Adding read,write permissions for group.

default: Removing read,write,execute permissions for world.

default: Changing groupname of /u01/app/oraInventory to oinstall.

default: The execution of the script is complete.

default: Check /u01/app/19.0.0/grid/install/root_ol7-19-rac1.localdomain_2022-12-23_13-27-45-390005350.log for the output of root script

default: Check /u01/app/19.0.0/grid/install/root_ol7-19-rac2.localdomain_2022-12-23_13-37-39-962758714.log for the output of root script

default: ******************************************************************************

default: Do grid configuration. Fri Dec 23 13:40:37 UTC 2022

default: ******************************************************************************

default: Launching Oracle Grid Infrastructure Setup Wizard...

default: You can find the logs of this session at:

default: /u01/app/oraInventory/logs/GridSetupActions2022-12-23_01-40-38PM

default: You can find the log of this install session at:

default: /u01/app/oraInventory/logs/UpdateNodeList2022-12-23_01-40-38PM.log

default: Configuration failed.

default: [WARNING] [INS-43080] Some of the configuration assistants failed, were cancelled or skipped.

default: ACTION: Refer to the logs or contact Oracle Support Services.

default: ******************************************************************************

default: Create additional diskgroups. Fri Dec 23 13:42:52 UTC 2022

default: ******************************************************************************

default:

default: SQL*Plus: Release 19.0.0.0.0 - Production on Fri Dec 23 13:42:52 2022

default: Version 19.3.0.0.0

default:

default: Connected to:

default: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

default: Version 19.3.0.0.0

default:

default: SQL> 2

default: Diskgroup created.

default: SQL> 2

default:

default: Diskgroup created.

default: SQL>

default: SQL> SQL> SQL>

default:

default: NAME COMPATIBILITY

default: ------------------------------ ------------------------------------------------------------

default: CRS 19.0.0.0.0

default: DATA 19.0.0.0.0

default: RECO 19.0.0.0.0

default: SQL>

default: Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

default: Version 19.3.0.0.0

default: ******************************************************************************

default: Check cluster configuration. Fri Dec 23 13:43:27 UTC 2022

default: ******************************************************************************

default: --------------------------------------------------------------------------------

default: Name Target State Server State details

default: --------------------------------------------------------------------------------

default: Local Resources

default: --------------------------------------------------------------------------------

default: ora.LISTENER.lsnr

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.chad

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.net1.network

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.ons

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: --------------------------------------------------------------------------------

default: Cluster Resources

default: --------------------------------------------------------------------------------

default: ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.CRS.dg(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.DATA.dg(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 OFFLINE OFFLINE STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.LISTENER_SCAN1.lsnr

default: 1 ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.LISTENER_SCAN2.lsnr

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.LISTENER_SCAN3.lsnr

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.RECO.dg(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 OFFLINE OFFLINE STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.asm(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 Started,STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 Started,STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.asmnet1.asmnetwork(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.cvu

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.ol7-19-rac1.vip

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.ol7-19-rac2.vip

default: 1 ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.qosmserver

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.scan1.vip

default: 1 ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.scan2.vip

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.scan3.vip

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: --------------------------------------------------------------------------------

default: ******************************************************************************

default: Unzip database software. Fri Dec 23 13:43:28 UTC 2022

default: ******************************************************************************

default: Do database software-only installation. Fri Dec 23 13:46:22 UTC 2022

default: ******************************************************************************

default: Launching Oracle Database Setup Wizard...

default: [WARNING] [INS-13013] Target environment does not meet some mandatory requirements.

default: CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2022-12-23_01-46-24PM/installActions2022-12-23_01-46-24PM.log

default: ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2022-12-23_01-46-24PM/installActions2022-12-23_01-46-24PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.

default: The response file for this session can be found at:

default: /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2022-12-23_01-46-24PM.rsp

default: You can find the log of this install session at:

default: /u01/app/oraInventory/logs/InstallActions2022-12-23_01-46-24PM/installActions2022-12-23_01-46-24PM.log

default:

default: As a root user, execute the following script(s):

default: 1. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

default:

default: Execute /u01/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes:

default: [ol7-19-rac1, ol7-19-rac2]

default:

default: Successfully Setup Software with warning(s).

default: ******************************************************************************

default: Run DB root scripts. Fri Dec 23 13:58:17 UTC 2022

default: ******************************************************************************

default: Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_ol7-19-rac1.localdomain_2022-12-23_13-58-18-006523587.log for the output of root script

default: Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_ol7-19-rac2.localdomain_2022-12-23_13-58-18-558580900.log for the output of root script

default: ******************************************************************************

default: Create database. Fri Dec 23 13:58:19 UTC 2022

default: ******************************************************************************

default: Prepare for db operation

default: 7% complete

default: Copying database files

default: 27% complete

default: Creating and starting Oracle instance

default: 28% complete

default: 31% complete

default: 35% complete

default: 37% complete

default: 40% complete

default: Creating cluster database views

default: 41% complete

default: 53% complete

default: Completing Database Creation

default: 57% complete

default: 59% complete

default: 60% complete

default: Creating Pluggable Databases

default: 64% complete

default: 80% complete

default: Executing Post Configuration Actions

default: 100% complete

default: Database creation complete. For details check the logfiles at:

default: /u01/app/oracle/cfgtoollogs/dbca/cdbrac.

default: Database Information:

default: Global Database Name:cdbrac

default: System Identifier(SID) Prefix:cdbrac

default: Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdbrac/cdbrac.log" for further details.

default: ******************************************************************************

default: Save state of PDB to enable auto-start. Fri Dec 23 14:29:32 UTC 2022

default: ******************************************************************************

default:

default: SQL*Plus: Release 19.0.0.0.0 - Production on Fri Dec 23 14:29:32 2022

default: Version 19.3.0.0.0

default:

default: Connected to:

default: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

default: Version 19.3.0.0.0

default: SQL>

default:

default: Pluggable database altered.

default:

default: SQL>

default: Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

default: Version 19.3.0.0.0

default: ******************************************************************************

default: Check cluster configuration. Fri Dec 23 14:29:33 UTC 2022

default: ******************************************************************************

default: Output from crsctl stat res -t Fri Dec 23 14:29:33 UTC 2022

default: ******************************************************************************

default: --------------------------------------------------------------------------------

default: Name Target State Server State details

default: --------------------------------------------------------------------------------

default: Local Resources

default: --------------------------------------------------------------------------------

default: ora.LISTENER.lsnr

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.chad

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.net1.network

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.ons

default: ONLINE ONLINE ol7-19-rac1 STABLE

default: ONLINE ONLINE ol7-19-rac2 STABLE

default: --------------------------------------------------------------------------------

default: Cluster Resources

default: --------------------------------------------------------------------------------

default: ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.CRS.dg(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.DATA.dg(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.LISTENER_SCAN1.lsnr

default: 1 ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.LISTENER_SCAN2.lsnr

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.LISTENER_SCAN3.lsnr

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.RECO.dg(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.asm(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 Started,STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 Started,STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.asmnet1.asmnetwork(ora.asmgroup)

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 STABLE

default: 3 OFFLINE OFFLINE STABLE

default: ora.cdbrac.db

default: 1 ONLINE ONLINE ol7-19-rac1 Open,HOME=/u01/app/o

default: racle/product/19.0.0

default: /dbhome_1,STABLE

default: 2 ONLINE ONLINE ol7-19-rac2 Open,HOME=/u01/app/o

default: racle/product/19.0.0

default: /dbhome_1,STABLE

default: ora.cvu

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.ol7-19-rac1.vip

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.ol7-19-rac2.vip

default: 1 ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.qosmserver

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.scan1.vip

default: 1 ONLINE ONLINE ol7-19-rac2 STABLE

default: ora.scan2.vip

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: ora.scan3.vip

default: 1 ONLINE ONLINE ol7-19-rac1 STABLE

default: --------------------------------------------------------------------------------

default: ******************************************************************************

default: Output from srvctl config database -d cdbrac Fri Dec 23 14:29:33 UTC 2022

default: ******************************************************************************

default: Database unique name: cdbrac

default: Database name: cdbrac

default: Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1

default: Oracle user: oracle

default: Spfile: +DATA/CDBRAC/PARAMETERFILE/spfile.272.1124202197

default: Password file: +DATA/CDBRAC/PASSWORD/pwdcdbrac.256.1124200773

default: Domain:

default: Start options: open

default: Stop options: immediate

default: Database role: PRIMARY

default: Management policy: AUTOMATIC

default: Server pools:

default: Disk Groups: RECO,DATA

default: Mount point paths:

default: Services:

default: Type: RAC

default: Start concurrency:

default: Stop concurrency:

default: OSDBA group: dba

default: OSOPER group: oper

default: Database instances: cdbrac1,cdbrac2

default: Configured nodes: ol7-19-rac1,ol7-19-rac2

default: CSS critical: no

default: CPU count: 0

default: Memory target: 0

default:

default: Maximum memory: 0

default: Default network number for database services:

default: Database is administrator managed

default: ******************************************************************************

default: Output from srvctl status database -d cdbrac Fri Dec 23 14:29:37 UTC 2022

default: ******************************************************************************

default: Instance cdbrac1 is running on node ol7-19-rac1

default: Instance cdbrac2 is running on node ol7-19-rac2

default: ******************************************************************************

default: Output from v$active_instances Fri Dec 23 14:29:39 UTC 2022

default: ******************************************************************************

default:

default: SQL*Plus: Release 19.0.0.0.0 - Production on Fri Dec 23 14:29:39 2022

default: Version 19.3.0.0.0

default:

default: Connected to:

default: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

default: Version 19.3.0.0.0

default: SQL>

default:

default: INST_NAME

default: --------------------------------------------------------------------------------

default: ol7-19-rac1.localdomain:cdbrac1

default: ol7-19-rac2.localdomain:cdbrac2

default:

default: SQL>

default: Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

default: Version 19.3.0.0.0

alex@Lenovo-Legion:/home/vagrant/Oracle-Linux/OL7/ora19c/rac/ol7_19_v2/node1$

Oracle Database 19c RAC on Oracle Linux 7 : common commands

2022-12-29T19:22:00.007+02:00

High Availability Services - Tests and Checks

Oracle Database 19c RAC on Oracle Linux 7 https://www.youtube.com/watch?v=_FNKBrOBbHI

[root@ol7-19-rac1 scripts]# /u01/app/19.0.0/grid/bin/crsctl stat res -t # How to identify which version of Clusterware is running : [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# /u01/app/19.0.0/grid/bin/crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [root@ol7-19-rac1 ~]# # check SCAN - Single Client Access Name : /u01/app/19.0.0/grid/bin/cluvfy comp scan [oracle@ol7-19-rac1 ~]$ /u01/app/19.0.0/grid/bin/cluvfy comp scan # Verification of node reachability /u01/app/19.0.0/grid/bin/cluvfy comp nodereach -n ol7-19-rac1 /u01/app/19.0.0/grid/bin/cluvfy comp nodereach -n ol7-19-rac2 [oracle@ol7-19-rac1 ~]$ /u01/app/19.0.0/grid/bin/cluvfy comp nodereach -n ol7-19-rac2 [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/cluvfy comp nodereach -n ol7-19-rac1 # Verification of node connectivity /u01/app/19.0.0/grid/bin/cluvfy comp nodecon -n ol7-19-rac1 -verbose /u01/app/19.0.0/grid/bin/cluvfy comp nodecon -n ol7-19-rac2 -verbose [oracle@ol7-19-rac1 ~]$ /u01/app/19.0.0/grid/bin/cluvfy comp nodecon -n ol7-19-rac2 -verbose [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/cluvfy comp nodecon -n ol7-19-rac1 -verbose # check OCR Integrity /u01/app/19.0.0/grid/bin/cluvfy comp ocr -n all -verbose [oracle@ol7-19-rac1 ~]$ /u01/app/19.0.0/grid/bin/cluvfy comp ocr -n all -verbose # check backups for Oracle Cluster Registry : /u01/app/19.0.0/grid/bin/ocrconfig -showbackup [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/ocrconfig -showbackup /u01/app/19.0.0/grid/bin/ocrconfig -showbackuploc /u01/app/19.0.0/grid/bin/asmcmd lsdg asmcmd lsdsk -k # create backup for Oracle Cluster Registry : /u01/app/19.0.0/grid/bin/ocrconfig -manualbackup [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/ocrconfig -manualbackup # Config & Status of Oracle Cluster Registry /u01/app/19.0.0/grid/bin/ocrcheck [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/ocrcheck [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/ocrcheck -config # # How do I identify the voting disk location /u01/app/19.0.0/grid/bin/ocrcheck -config # # Oracle Local Registry configuration : /u01/app/19.0.0/grid/bin/ocrcheck -local -config [oracle@ol7-19-rac1 ~]$ /u01/app/19.0.0/grid/bin/ocrcheck -local -config # nodeapps : /u01/app/19.0.0/grid/bin/srvctl status nodeapps /u01/app/19.0.0/grid/bin/srvctl status nodeapps -n ol7-19-rac1 ( /u01/app/19.0.0/grid/bin/srvctl config nodeapps -a -s ) [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/srvctl status nodeapps [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/srvctl config nodeapps -a -s [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/srvctl status nodeapps -n ol7-19-rac1 [oracle@ol8-21-rac1 ~]$ srvctl config nodeapps -s # check Oracle Cluster Health Analysis Service : /u01/app/19.0.0/grid/bin/srvctl status cha [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/srvctl status cha [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl stop cluster -all [root@ol7-19-rac1 ~]# /u01/app/19.0.0/grid/bin/crsctl stop has [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl stop has ps -elf | egrep "PID|d.bin|ohas|oraagent|orarootagent|cssdagent|cssdmonitor" | grep -v grep ---------------------------------------------------------------------------------------------- Mallik034 - Nov 5, 2020 Basic Cluster Health Checks - Oracle 12c : Clusterware Administration https://www.youtube.com/watch?v=nlnxiBLmLI4 Oracle Clusterware Administration Basics - crsctl & srvctl - Basic Cluster Health Checks ---------------------------------------------------------------------------------------------- /u01/app/19.0.0/grid/bin/srvctl status cha [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl check crs [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl check css [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl check evm [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl check cluster -all [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status ons [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status asm [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status scan [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl config scan [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status scan_listener [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status database -d cdbrac [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl config database [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl config database -d cdbrac [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status nodeapps [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl config nodeapps -a crsctl query css votedisk Lists the voting files ( location ) used by Cluster Synchronization Services [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl query css votedisk [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl query crs activeversion [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status diskgroup -diskgroup CRS [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status diskgroup -diskgroup DATA [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status diskgroup -diskgroup RECO [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/srvctl status diskgroup -diskgroup CRS -node ol7-19-rac1 /u01/app/19.0.0/grid/bin/olsnodes -------------------------------------------------------------------------------------- https://heliosguneserol.com/2020/11/04/how-to-manage-crs-and-rac-services/ https://heliosguneserol.com/2020/11/04/how-to-manage-crs-and-rac-services/ -------------------------------------------------------------------------------------- << Use the “crsctl enable/disable has” command to disable automatic startup of the Oracle High Availability Services stack when the server boots up. >> # To see current settings for Oracle High Availability Services stack when the server boots up: /u01/app/19.0.0/grid/bin/crsctl config has [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# /u01/app/19.0.0/grid/bin/crsctl config has CRS-4621: Oracle High Availability Services autostart is disabled. [root@ol7-19-rac1 ~]# -------------------------------------------------------------------------------------- https://heliosguneserol.com/2020/11/04/how-to-manage-crs-and-rac-services/ -------------------------------------------------------------------------------------- https://niteshdba.wordpress.com/rac/ Usage: srvctl start diskgroup -g <dg_name> [-n “<node_list>”] Usage: srvctl stop diskgroup -g <dg_name> [-n “<node_list>”] [-f] Usage: srvctl status diskgroup -g <dg_name> [-n “<node_list>”] [-a] Usage: srvctl enable diskgroup -g <dg_name> [-n “<node_list>”] Usage: srvctl disable diskgroup -g <dg_name> [-n “<node_list>”] Usage: srvctl remove diskgroup -g <dg_name> [-f] https://niteshdba.wordpress.com/rac/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Oracle RAC Service Concept and Live Demo ------------------------------------------- https://www.youtube.com/watch?v=WvX0G3O5dFU /u01/app/21.0.0/grid/bin/srvctl add service -d ocdbrac -s ocdbracsvc -preferred ocdbrac1 -available ocdbrac2 /u01/app/21.0.0/grid/bin/srvctl relocate service -d ocdbrac -s ocdbracsvc -oldinst ocdbrac1 -newinst ocdbrac2 /u01/app/21.0.0/grid/bin/srvctl status service -d ocdbrac /u01/app/21.0.0/grid/bin/srvctl start service -d ocdbrac [oracle@ol8-21-rac2 ~]$ /u01/app/21.0.0/grid/bin/srvctl add service -d ocdbrac -s ocdbracsvc2 -preferred ocdbrac1,ocdbrac2 [oracle@ol8-21-rac2 ~]$ /u01/app/21.0.0/grid/bin/srvctl remove service -d ocdbrac -s ocdbracsvc2 ============================================================================ High Availability TeST : ------------------------------------ ------------------------------------ /u01/app/19.0.0/grid/bin/srvctl add service -d cdbrac -s cdbracsvc -preferred cdbrac1 -available cdbrac2 srvctl add service -d cdbrac -s cdbracsvc -preferred cdbrac1 -available cdbrac2 srvctl relocate service -d cdbrac -s cdbracsvc -oldinst cdbrac1 -newinst cdbrac2 srvctl relocate service -d cdbrac -s cdbracsvc -oldinst cdbrac2 -newinst cdbrac1 srvctl status service -d cdbrac srvctl start service -d cdbrac srvctl stop service -d cdbrac srvctl remove service -d cdbrac -s cdbracsvc #1 creating cdbracsvc database Service with both instances as preferred : [oracle@ol7-19-rac2 admin]$ srvctl add service -d cdbrac -s cdbracsvc -preferred cdbrac1,cdbrac2 # srvctl add service -d cdbrac -s cdbracsvc -preferred cdbrac1,cdbrac2 # srvctl config service -d cdbrac #2 : connecting into cdbracsvc database Service : [oracle@ol7-19-rac2 admin]$ sqlplus sys/SysPassword1@cdbracsvc as sysdba #3 " checking in which instance the service is connected : SQL> select host_name,instance_name from v$instance; HOST_NAME ---------------------------------------------------------------- INSTANCE_NAME ---------------- ol7-19-rac1.localdomain cdbrac1 #4 : stopping the instance in which last connection was made ( cdbrac1 / ol7-19-rac1 ) : srvctl stop instance -d cdbrac -i cdbrac1 -f #5 : disconnect , reconnect and check again : [oracle@ol7-19-rac2 admin]$ sqlplus sys/SysPassword1@cdbracsvc as sysdba SQL> select host_name,instance_name from v$instance; HOST_NAME ---------------------------------------------------------------- INSTANCE_NAME ---------------- ol7-19-rac2.localdomain cdbrac2 SQL> ============================================================================ srvctl stop instance -d cdbrac -i cdbrac1 srvctl status instance -d cdbrac -i cdbrac1 srvctl status database -d cdbrac [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac2 ~]$ lsnrctl status | grep r.ora Listener Parameter File /u01/app/19.0.0/grid/network/admin/listener.ora [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac2 ~]$ lsnrctl services [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac2 ~]$ cd $ORACLE_HOME/network/admin/ [oracle@ol7-19-rac2 admin]$ [oracle@ol7-19-rac2 admin]$ ll *tns* -rw-r-----. 1 oracle oinstall 334 Dec 26 16:45 ini.tnsnames.ora.bak -rw-r-----. 1 oracle oinstall 527 Dec 26 16:47 tnsnames.ora [oracle@ol7-19-rac2 admin]$ [oracle@ol7-19-rac2 admin]$ diff tnsnames.ora ini.tnsnames.ora.bak 13,21d12 < CDBRACSVC = < (DESCRIPTION = < (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19-scan)(PORT = 1521)) < (CONNECT_DATA = < (SERVER = DEDICATED) < (SERVICE_NAME = cdbracsvc) < ) < ) < [oracle@ol7-19-rac2 admin]$ [oracle@ol7-19-rac2 admin]$ cat $ORACLE_HOME/network/admin/ini.tnsnames.ora.bak # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. CDBRAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cdbrac) ) ) [oracle@ol7-19-rac2 admin]$ [oracle@ol7-19-rac2 admin]$ [oracle@ol7-19-rac2 admin]$ tnsping cdbracsvc TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-DEC-2022 16:49:21 Copyright (c) 1997, 2019, Oracle. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cdbracsvc))) OK (0 msec) [oracle@ol7-19-rac2 admin]$ SQL > select host_name,instance_name from v$instance; ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2022-12.24 :=> /u01/app/21.0.0/grid/bin/olsnodes -n /u01/app/21.0.0/grid/bin/olsnodes /u01/app/21.0.0/grid/bin/crsctl check has Shutdown and Start sequence of Oracle RAC https://valehagayev.wordpress.com/tag/srvctl/ To print private interconnect address for the local node : [oracle@ol8-21-rac1 ~]$ [oracle@ol8-21-rac1 ~]$ /u01/app/21.0.0/grid/bin/olsnodes -l -p ol8-21-rac1 192.168.1.101 [oracle@ol8-21-rac1 ~]$ [oracle@ol8-21-rac1 ~]$ srvctl status listener # To display the status services running in the database : [oracle@ol8-21-rac1 ~]$ srvctl status service -d ocdbrac Service ocdbracsvc is not running. [oracle@ol8-21-rac1 ~]$ # https://valehagayev.wordpress.com/tag/srvctl/ # To stop or start SCAN listener and the SCAN VIP resources : # https://valehagayev.wordpress.com/tag/srvctl/ [oracle@test4 ~]$ srvctl stop scan_listener [oracle@test4 ~]$ srvctl start scan_listener [oracle@test4 ~]$ srvctl stop scan [oracle@test4 ~]$ srvctl start scan ++++++++++++++++++++++++ Oracle SQLPlus The Definitive Guide 2nd Edition https://resources.oreilly.com/examples/9780596007461/-/blob/master/SQLPlusData.tar.gz https://resources.oreilly.com/examples/9780596007461/ Creating and Loading the Sample Tables https://flylib.com/books/en/2.525.1/creating_and_loading_the_sample_tables.html#fastmenu_1 https://resources.oreilly.com/examples/9780596007461/-/blob/master/SQLPlusData.tar.gz ++++++++++++++++++++++++ [oracle@ol7-19-rac2 ~]$ sqlplus / as sysdba SQL> show con_name SQL> show pdbs SQL> ALTER SESSION SET CONTAINER=PDB1; SQL> ALTER PLUGGABLE DATABASE OPEN READ WRITE; CREATE TABLE PROFILE( ID INTEGER, NAME VARCHAR2(100), GENDER CHAR(10), COUNTRY VARCHAR2(100) DEFAULT 'USA' ); insert into profile values ( 101,'John' , 'M', 'USA') ; insert into profile values ( 102,'Mary' , 'F', 'USA'); describe PROFILE insert into profile values ( 103,'Marc' , 'M', 'USA'); insert into profile values ( 104,'Anna' , 'M', 'USA') ; SQL> select * from profile; commit; <<== || 2022-12.24 https://ocptechnology.com/drop-database-manually/ $export ORACLE_SID=orcl $sqlplus / as sysdba SQL> shu immediate SQL> startup mount exclusive restrict; SQL> drop database; - - - SQL> select name from v$database; <<--- check database name SQL> select name from v$datafile; SQL> select name from v$controlfile; SQL> select member from v$logfile; - - - env | grep ORA [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac2 ~]$ env | grep ORA ORACLE_UNQNAME=cdbrac ORACLE_SID=cdbrac2 ORACLE_BASE=/u01/app/oracle ORACLE_HOSTNAME=ol7-19-rac2.localdomain ORA_INVENTORY=/u01/app/oraInventory ORACLE_TERM=xterm ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@ol7-19-rac2 ~]$ - - - https://www.thegeekdiary.com/oracleasm-command-examples/ https://dbaclass.com/article/oracleasm-utility-asmlib/ [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# yum install oracleasm-support Loaded plugins: ulninfo Package oracleasm-support-2.1.11-2.el7.x86_64 already installed and latest version Nothing to do [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# oracleasm status Checking if ASM is loaded: no Checking if /dev/oracleasm is mounted: no [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# /sbin/blkid /dev/sda1: UUID="8da902df-d8f3-4a1c-be3b-1d4eee1516c3" TYPE="xfs" /dev/sda2: UUID="6a55898a-b4f5-4f2a-ab83-1cf6b9fff18b" TYPE="swap" /dev/sda3: UUID="311e2f43-9882-4b6f-bbd4-b7ca186771c8" TYPE="xfs" /dev/sdc1: TYPE="oracleasm" /dev/sdb1: UUID="fcfed228-4244-42bd-8812-7612b571eba4" TYPE="xfs" /dev/sdf1: TYPE="oracleasm" /dev/sdd1: TYPE="oracleasm" /dev/sdg1: TYPE="oracleasm" /dev/sde1: TYPE="oracleasm" [root@ol7-19-rac1 ~]# [oracle@ol7-19-rac1 ~]$ [oracle@ol7-19-rac1 ~]$ asmcmd lsdsk -k Total_MB Free_MB OS_MB Name Failgroup Site_Name Site_GUID Site_Status Failgroup_Type Library Label Failgroup_Label Site_Label UDID Product Redund Path 2047 1788 2047 CRS_0000 CRSFG1 00000000000000000000000000000000 REGULAR System UNKNOWN /dev/oracleasm/asm-crs-disk1 2047 1789 2047 CRS_0001 CRSFG2 00000000000000000000000000000000 REGULAR System UNKNOWN /dev/oracleasm/asm-crs-disk2 2047 1791 2047 CRS_0002 CRSFG3 00000000000000000000000000000000 REGULAR System UNKNOWN /dev/oracleasm/asm-crs-disk3 40959 37093 40959 DATA_0000 DATA_0000 00000000000000000000000000000000 REGULAR System UNKNOWN /dev/oracleasm/asm-data-disk1 20479 20146 20479 RECO_0000 RECO_0000 00000000000000000000000000000000 REGULAR System UNKNOWN /dev/oracleasm/asm-reco-disk1 [oracle@ol7-19-rac1 ~]$ [oracle@ol7-19-rac1 ~]$ [oracle@ol7-19-rac1 ~]$ 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 NORMAL N 512 512 4096 1048576 6141 5368 2047 1660 0 Y CRS/ MOUNTED EXTERN N 512 512 4096 1048576 40959 37093 0 37093 0 N DATA/ MOUNTED EXTERN N 512 512 4096 1048576 20479 20146 0 20146 0 N RECO/ [oracle@ol7-19-rac1 ~]$ - - - https://db.geeksinsight.com/dbahelper/oracle-rac-interview-questions-10g/ How do you backup the OCR There is an automatic backup mechanism for OCR. The default location is : $ORA_CRS_HOMEcdata"clustername" To display backups : #ocrconfig -showbackup To restore a backup : #ocrconfig –restore With Oracle RAC 10g Release 2 or later, you can also use the export command: #ocrconfig -export -s online, and use -import option to restore the contents back. With Oracle RAC 11g Release 1, you can do a manaual backup of the OCR with the command: # ocrconfig –manualbackup https://db.geeksinsight.com/dbahelper/oracle-rac-interview-questions-10g/ What is the purpose of Private Interconnect ? Clusterware uses the private interconnect for cluster synchronization (network heartbeat) and daemon communication between the the clustered nodes. This communication is based on the TCP protocol. RAC uses the interconnect for cache fusion (UDP) and inter-process communication (TCP). Cache Fusion is the remote memory mapping of Oracle buffers, shared between the caches of participating nodes in the cluster. What are Oracle Clusterware Components Voting Disk - Oracle RAC uses the voting disk to manage cluster membership by way of a health check and arbitrates cluster ownership among the instances in case of network failures. The voting disk must reside on shared disk. Oracle Cluster Registry (OCR) — Maintains cluster configuration information as well as configuration information about any cluster database within the cluster. The OCR must reside on shared disk that is accessible by all of the nodes in your cluster Oracle Cluster Interconnect — In other words also called as private interconnect, with high speed gigabit channel , low latency network connection attached to private switches rather the public interfaces. This will be used by cluster to provide node membership and also inter cluster communication (aka global cache services , transfer of blocks from one node to another) ========================================================================== # Get Private interconnect IP address ------------------------------------------------------ [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/oifcfg getif eth1 192.168.56.0 global public eth2 192.168.1.0 global cluster_interconnect,asm [oracle@ol7-19-rac2 ~]$ ------------------------------------------------------ https://dbaclass.com/article/oracle-rac-interview-questions/ 31. What is the purpose of Voting disk? Voting disk stores information about the nodes in the cluster and their heartbeat information. Also stores information about cluster membership. 32. Why we need voting disk? Oracle Clusterware uses the VD to determine which nodes are members of a cluster. Oracle Cluster Synchronization Service daemon (OCSSD) on each cluster node updates the VD with the current status of the node every second. The VD is used to determine which RAC nodes are still in the cluster should the interconnect heartbeat between the RAC nodes fail. https://orahow.com/oracle-rac-clusterware-startup-sequence/ Voting Disk The voting disk manage node membership information. It is a shared disks that will be accessed by all the member of the nodes in the cluster. It is used as central reference for all the nodes and keeps the heartbeat information between the nodes. If any of the node is unable to ping the voting disk, cluster immediately recognize the communication failure and evicts the node from the cluster. [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# /u01/app/19.0.0/grid/bin/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 NORMAL N 512 512 4096 1048576 6141 5368 2047 1660 0 Y CRS/ MOUNTED EXTERN N 512 512 4096 1048576 40959 37103 0 37103 0 N DATA/ MOUNTED EXTERN N 512 512 4096 1048576 20479 20146 0 20146 0 N RECO/ [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# /u01/app/19.0.0/grid/bin/asmcmd ASMCMD> pwd + ASMCMD> ls CRS/ DATA/ RECO/ ASMCMD> cd DATA ASMCMD> ASMCMD> pwd +DATA ASMCMD> ASMCMD> ls CDBRAC/ ASMCMD> ASMCMD> cd CDBRAC/ ASMCMD> ASMCMD> ls 86B637B62FE07A65E053F706E80A27CA/ CONTROLFILE/ DATAFILE/ F0805BD1B3E77F03E0536538A8C07CB3/ F08097DB1052325AE0536538A8C0F39A/ ONLINELOG/ PARAMETERFILE/ PASSWORD/ TEMPFILE/ ASMCMD> ASMCMD> cd DATAFILE/ ASMCMD> ASMCMD> pwd +DATA/CDBRAC/DATAFILE ASMCMD> ASMCMD> ls SYSAUX.258.1124200845 SYSTEM.257.1124200809 UNDOTBS1.259.1124200859 UNDOTBS2.269.1124201819 USERS.260.1124200861 ASMCMD> ASMCMD> exit [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# ps -ef | grep d.bin root 13010 6103 0 14:18 pts/0 00:00:00 grep --color=auto d.bin root 19896 1 1 12:05 ? 00:01:43 /u01/app/19.0.0/grid/bin/ohasd.bin reboot root 20000 1 0 12:05 ? 00:00:41 /u01/app/19.0.0/grid/bin/orarootagent.bin oracle 20079 1 0 12:05 ? 00:01:16 /u01/app/19.0.0/grid/bin/oraagent.bin oracle 20102 1 0 12:05 ? 00:00:16 /u01/app/19.0.0/grid/bin/mdnsd.bin oracle 20104 1 0 12:05 ? 00:00:47 /u01/app/19.0.0/grid/bin/evmd.bin oracle 20134 1 0 12:06 ? 00:00:19 /u01/app/19.0.0/grid/bin/gpnpd.bin oracle 20187 20104 0 12:06 ? 00:00:17 /u01/app/19.0.0/grid/bin/evmlogger.bin -o /u01/app/19.0.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/19.0.0/grid/log/[HOSTNAME]/evmd/evmlogger.log oracle 20204 1 0 12:06 ? 00:00:52 /u01/app/19.0.0/grid/bin/gipcd.bin root 20238 1 0 12:06 ? 00:00:24 /u01/app/19.0.0/grid/bin/cssdmonitor root 20243 1 1 12:06 ? 00:02:38 /u01/app/19.0.0/grid/bin/osysmond.bin root 20271 1 0 12:06 ? 00:00:25 /u01/app/19.0.0/grid/bin/cssdagent oracle 20289 1 1 12:06 ? 00:02:02 /u01/app/19.0.0/grid/bin/ocssd.bin root 20716 1 0 12:06 ? 00:00:49 /u01/app/19.0.0/grid/bin/octssd.bin reboot root 20816 1 1 12:06 ? 00:02:08 /u01/app/19.0.0/grid/bin/ologgerd -M root 21101 1 1 12:07 ? 00:01:58 /u01/app/19.0.0/grid/bin/crsd.bin reboot oracle 21322 1 2 12:07 ? 00:02:39 /u01/app/19.0.0/grid/bin/oraagent.bin root 21335 1 3 12:07 ? 00:04:05 /u01/app/19.0.0/grid/bin/orarootagent.bin oracle 21504 1 0 12:07 ? 00:00:03 /u01/app/19.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit oracle 21506 1 0 12:07 ? 00:00:20 /u01/app/19.0.0/grid/bin/scriptagent.bin oracle 21720 1 0 12:07 ? 00:00:00 /u01/app/19.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit oracle 21779 1 0 12:07 ? 00:00:00 /u01/app/19.0.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit oracle 21798 1 0 12:07 ? 00:00:00 /u01/app/19.0.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit root 25403 20243 0 12:08 ? 00:00:13 /u01/app/19.0.0/grid/perl/bin/perl /u01/app/19.0.0/grid/bin/diagsnap.pl start [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# /u01/app/19.0.0/grid/bin/olsnodes ol7-19-rac1 ol7-19-rac2 [root@ol7-19-rac1 ~]# sqlplus / as sysdba <<EOF set echo on select INST_ID, CON_ID, name, OPEN_MODE from gv\$pdbs where con_id!=2 order by name, inst_id; exit EOF https://niteshdba.wordpress.com/rac/ [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac2 ~]$ /u01/app/19.0.0/grid/bin/srvctl config asm ASM home: <CRS home> Password file: +CRS/orapwASM Backup of Password file: +CRS/orapwASM_backup ASM listener: LISTENER ASM instance count: 3 Cluster ASM listener: ASMNET1LSNR_ASM [oracle@ol7-19-rac2 ~]$ [oracle@ol7-19-rac1 ~]$ [oracle@ol7-19-rac1 ~]$ /u01/app/19.0.0/grid/bin/srvctl config asm -a ASM home: <CRS home> Password file: +CRS/orapwASM Backup of Password file: +CRS/orapwASM_backup ASM listener: LISTENER ASM is enabled. ASM is individually enabled on nodes: ASM is individually disabled on nodes: ASM instance count: 3 Cluster ASM listener: ASMNET1LSNR_ASM [oracle@ol7-19-rac1 ~]$ <<== || 2022-12.26 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ??? /u01/app/21.0.0/grid/bin/crsctl disable crs /u01/app/21.0.0/grid/bin/crsctl disable has ??? [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl start has CRS-4123: Oracle High Availability Services has been started. [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl start crs CRS-4640: Oracle High Availability Services is already active CRS-4000: Command Start failed, or completed with errors. [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# /u01/app/19.0.0/grid/bin/crsctl start cluster CRS-4691: Oracle Clusterware is already running CRS-4000: Command Start failed, or completed with errors. [root@ol7-19-rac2 ~]# +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ STOP , START & CHECK - clusterware : ( as root ) -------------------------------------- /u01/app/19.0.0/grid/bin/crsctl stop cluster -all ( in one node ) /u01/app/19.0.0/grid/bin/crsctl stop has ( in all nodes ) ------------------------------------------------------------------------------- /u01/app/19.0.0/grid/bin/crsctl start has ( in all nodes ) /u01/app/19.0.0/grid/bin/crsctl start cluster -all ( in one node ) ------------------------------------------------------------------------------- /u01/app/19.0.0/grid/bin/crsctl check cluster -all ------------------------------------------------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ [root@ol7-19-rac1 scripts]# [root@ol7-19-rac1 scripts]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 # Public 192.168.56.101 ol7-19-rac1.localdomain ol7-19-rac1 192.168.56.102 ol7-19-rac2.localdomain ol7-19-rac2 # Private 192.168.1.101 ol7-19-rac1-priv.localdomain ol7-19-rac1-priv 192.168.1.102 ol7-19-rac2-priv.localdomain ol7-19-rac2-priv # Virtual 192.168.56.103 ol7-19-rac1-vip.localdomain ol7-19-rac1-vip 192.168.56.104 ol7-19-rac2-vip.localdomain ol7-19-rac2-vip # SCAN 192.168.56.105 ol7-19-scan.localdomain ol7-19-scan 192.168.56.106 ol7-19-scan.localdomain ol7-19-scan 192.168.56.107 ol7-19-scan.localdomain ol7-19-scan [root@ol7-19-rac1 scripts]# [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 # Public 192.168.56.101 ol7-19-rac1.localdomain ol7-19-rac1 192.168.56.102 ol7-19-rac2.localdomain ol7-19-rac2 # Private 192.168.1.101 ol7-19-rac1-priv.localdomain ol7-19-rac1-priv 192.168.1.102 ol7-19-rac2-priv.localdomain ol7-19-rac2-priv # Virtual 192.168.56.103 ol7-19-rac1-vip.localdomain ol7-19-rac1-vip 192.168.56.104 ol7-19-rac2-vip.localdomain ol7-19-rac2-vip # SCAN 192.168.56.105 ol7-19-scan.localdomain ol7-19-scan 192.168.56.106 ol7-19-scan.localdomain ol7-19-scan 192.168.56.107 ol7-19-scan.localdomain ol7-19-scan [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# cat /etc/resolv.conf search localdomain nameserver 192.168.56.100 nameserver 192.168.56.101 nameserver 8.8.8.8 [root@ol7-19-rac2 ~]# [root@ol7-19-rac2 ~]# ip a | grep glo inet 10.0.2.15/24 brd 10.0.2.255 scope global dynamic noprefixroute eth0 inet 192.168.56.102/24 brd 192.168.56.255 scope global noprefixroute eth1 inet 192.168.1.102/24 brd 192.168.1.255 scope global noprefixroute eth2 [root@ol7-19-rac2 ~]# [root@ol7-19-rac1 scripts]# cat /etc/resolv.conf search localdomain nameserver 192.168.56.100 nameserver 192.168.56.102 nameserver 8.8.8.8 [root@ol7-19-rac1 scripts]# [root@ol7-19-rac1 scripts]# ip a | grep glo inet 10.0.2.15/24 brd 10.0.2.255 scope global dynamic noprefixroute eth0 inet 192.168.56.101/24 brd 192.168.56.255 scope global noprefixroute eth1 inet 192.168.1.101/24 brd 192.168.1.255 scope global noprefixroute eth2 [root@ol7-19-rac1 scripts]# [root@ol7-19-rac2 ~]# ssh ol7-19-rac1 [root@ol7-19-rac1 ~]# [root@ol7-19-rac1 ~]# ssh ol7-19-rac2 Last login: Mon Dec 19 17:08:07 2022 [root@ol7-19-rac2 ~]# [root@ol7-19-rac1 ~]# su - oracle Last login: Mon Dec 19 17:20:51 UTC 2022 [oracle@ol7-19-rac1 ~]$ [oracle@ol7-19-rac1 ~]$ ssh ol7-19-rac2 Last login: Mon Dec 19 17:07:37 2022 [oracle@ol7-19-rac2 ~]$ ssh ol7-19-rac1 Last login: Mon Dec 19 17:33:39 2022 [oracle@ol7-19-rac1 ~]$

Steps to "fix" the dynamic ip of KVM

2022-01-30T17:39:00.022+02:00

https://www.cyberciti.biz/faq/linux-kvm-libvirt-dnsmasq-dhcp-static-ip-address-configuration-for-guest-os/
"KVM libvirt assign static guest IP addresses using DHCP on the virtual machine"

- in this blog-post :

I'm connecting to a running KVM via dynamic iP ;

I’m changing DHCP for default Virtual Network to grant “fixed” iPs based on KVM’s mac Hwaddress .

Eventually I'm connecting to same KVM via a “fixed” iP that won’t change after KVM restarts ;

====================================================================

- List all KVMs :

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

root@ubuntu2004:~# virsh list --all

Id Name State

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

1 centos82a running

====================================================================

- Check mac of running KVM - "centos82a" :

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

root@ubuntu2004:~# virsh dumpxml centos82a | grep -i '<mac'

root@ubuntu2004:~#

====================================================================

- Check the list of virtual networks :

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

root@ubuntu2004:~# virsh net-list

Name State Autostart Persistent

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

default active yes yes

====================================================================

We need dynamic iPs that can be assigned to virtual machines on default network ;

- Check dhcp range of default network bridge :

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

root@ubuntu2004:~# virsh net-dumpxml default

<name>default</name>

<nat>

</nat>

</forward>

<dhcp>

</dhcp>

</ip>

</network>

====================================================================

Check iP of host OS :

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

root@ubuntu2004:~#

root@ubuntu2004:~# ip a | grep glo

inet 172.20.124.107/20 brd 172.20.127.255 scope global dynamic eth0

inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0

====================================================================

- Check iP of guest KVM :

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

root@ubuntu2004:~#

root@ubuntu2004:~# arp -n

Address HWtype HWaddress Flags Mask Iface

172.20.112.1 ether 00:15:5d:bf:f7:ba C eth0

192.168.122.223 ether 52:54:00:a1:16:27 C virbr0

root@ubuntu2004:~#

====================================================================

- We can enter into KVM via dynamic iP that can change after shutdown / start :

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

root@ubuntu2004:~# sshpass -p"toor" ssh root@192.168.122.223

Last login: Thu Jan 27 13:53:45 2022 from 192.168.122.1

[root@localhost ~]#

[root@localhost ~]# ip a | grep glo

inet 192.168.122.223/24 brd 192.168.122.255 scope global dynamic noprefixroute ens2

[root@localhost ~]#

[root@localhost ~]# logout

Connection to 192.168.122.223 closed.

root@ubuntu2004:~#

root@ubuntu2004:~# virsh net-edit default

Select an editor. To change later, run 'select-editor'.

1. /usr/bin/vim.nox

2. /bin/nano <---- easiest

3. /usr/bin/vim.basic

4. /usr/bin/mcedit

5. /usr/bin/vim.tiny

6. /bin/ed

Choose 1-6 [2]: 3

Network default XML configuration not changed.

root@ubuntu2004:~#

root@ubuntu2004:~# select-editor

Select an editor. To change later, run 'select-editor'.

1. /usr/bin/vim.nox

2. /bin/nano <---- easiest

3. /usr/bin/vim.basic

4. /usr/bin/mcedit

5. /usr/bin/vim.tiny

6. /bin/ed

Choose 1-6 [2]: 4

root@ubuntu2004:~#

root@ubuntu2004:~# virsh dumpxml centos82a | grep -i '<mac'

root@ubuntu2004:~#

root@ubuntu2004:~# virsh net-dumpxml default

<name>default</name>

<nat>

</nat>

</forward>

<dhcp>

</dhcp>

</ip>

</network>

root@ubuntu2004:~#

====================================================================

On "default" VirtuaL Network , we add this line at <dhcp> :

After change : net-destroy + net-start on "default"

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

root@ubuntu2004:~#

root@ubuntu2004:~# virsh net-edit default

Network default XML configuration edited.

root@ubuntu2004:~#

root@ubuntu2004:~# virsh net-destroy default

Network default destroyed

root@ubuntu2004:~# virsh net-start default

Network default started

root@ubuntu2004:~#

root@ubuntu2004:~# virsh net-dumpxml default

<name>default</name>

<nat>

</nat>

</forward>

<dhcp>

</dhcp>

</ip>

</network>

root@ubuntu2004:~#

root@ubuntu2004:~# virsh dumpxml centos82a | grep -i '<mac'

root@ubuntu2004:~#

root@ubuntu2004:~# sshpass -p"toor" ssh root@192.168.122.223

ssh: connect to host 192.168.122.223 port 22: No route to host

root@ubuntu2004:~#

root@ubuntu2004:~# arp -n

Address HWtype HWaddress Flags Mask Iface

192.168.122.111 (incomplete) virbr0

192.168.122.223 (incomplete) virbr0

172.20.112.1 ether 00:15:5d:bf:f7:ba C eth0

root@ubuntu2004:~#

====================================================================

Shutdown / start KVM "centos82a" :

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

root@ubuntu2004:~# virsh shutdown centos82a

Domain centos82a is being shutdown

root@ubuntu2004:~#

root@ubuntu2004:~# virsh list --all

Id Name State

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

- centos82a shut off

root@ubuntu2004:~#

root@ubuntu2004:~# virsh start centos82a

Domain centos82a started

root@ubuntu2004:~#

root@ubuntu2004:~# virsh list --all

Id Name State

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

2 centos82a running

root@ubuntu2004:~#

root@ubuntu2004:~# arp -n

Address HWtype HWaddress Flags Mask Iface

192.168.122.111 (incomplete) virbr0

192.168.122.223 (incomplete) virbr0

172.20.112.1 ether 00:15:5d:bf:f7:ba C eth0

root@ubuntu2004:~#

root@ubuntu2004:~# arp -n

Address HWtype HWaddress Flags Mask Iface

192.168.122.111 ether 52:54:00:a1:16:27 C virbr0

192.168.122.223 (incomplete) virbr0

172.20.112.1 ether 00:15:5d:bf:f7:ba C eth0

root@ubuntu2004:~#

====================================================================

- Now We can enter into KVM via dynamic iP that won't change after shutdown / start :

it's fixed by mac address

the new iP "192.168.122.111" it's fixed by mac (HWadress) "52:54:00:a1:16:27"

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

root@ubuntu2004:~#

root@ubuntu2004:~# sshpass -p"toor" ssh root@192.168.122.111

Last login: Sun Jan 30 05:45:54 2022 from 192.168.122.1

[root@centos82a ~]#

[root@centos82a ~]# cat /etc/*rele* | grep -i linux | sort -u

CentOS Linux release 8.2.2004 (Core)

Derived from Red Hat Enterprise Linux 8.2 (Source)

NAME="CentOS Linux"

PRETTY_NAME="CentOS Linux 8 (Core)"

[root@centos82a ~]#

[root@centos82a ~]# ip a | grep glo

inet 192.168.122.111/24 brd 192.168.122.255 scope global dynamic noprefixroute ens2

[root@centos82a ~]#

[root@centos82a ~]# ip a

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 scope host lo

valid_lft forever preferred_lft forever

inet6 ::1/128 scope host

valid_lft forever preferred_lft forever

2: ens2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc fq_codel state UP group default qlen 1000

link/ether 52:54:00:a1:16:27 brd ff:ff:ff:ff:ff:ff

inet 192.168.122.111/24 brd 192.168.122.255 scope global dynamic noprefixroute ens2

valid_lft 2955sec preferred_lft 2955sec

inet6 fe80::f55f:7b40:d40c:3062/64 scope link noprefixroute

valid_lft forever preferred_lft forever

[root@centos82a ~]#

[root@centos82a ~]# logout

Connection to 192.168.122.111 closed.

root@ubuntu2004:~#

root@ubuntu2004:~# virsh net-dhcp-leases default

Expiry Time MAC address Protocol IP address Hostname Client ID or DUID

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

2022-01-30 17:09:45 52:54:00:a1:16:27 ipv4 192.168.122.111/24 centos82a 01:52:54:00:a1:16:27

root@ubuntu2004:~#

root@ubuntu2004:~# cat /etc/*rele* | grep -i version

VERSION="20.04.3 LTS (Focal Fossa)"

VERSION_ID="20.04"

VERSION_CODENAME=focal

root@ubuntu2004:~#

Windows-11 + Vagrant + Hyper-V + Ubuntu-20.04 + KVM + CentOS-8.2

2022-01-24T23:52:00.060+02:00

- in this blog-post :

I'm installing Vagrant in Windows 11 ;

With Vagrant I'm creating and starting a VM in Hyper-V ;

In Hyper-V : I'm installing Ubuntu-20.04

In Ubuntu with KVM , QEMU and Libvirt :

- I'm playing with 3 CentOS-8.2 boxes .

Enable Hyper-V and Install Vagrant on Windows 10|11:

https://computingforgeeks.com/enable-hyper-v-and-install-vagrant-in-windows/

Ensure you are running Powershell as Administrator:

Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V -All

Enable-WindowsOptionalFeature -Online -FeatureName "SMB1Protocol" -All

Downlolad and install Vagrant :

https://www.vagrantup.com/downloads

https://releases.hashicorp.com/vagrant/2.2.19/vagrant_2.2.19_x86_64.msi

https://releases.hashicorp.com/vagrant/2.2.19/vagrant_2.2.19_i686.msi

After reboot - adding our ( Ubuntu ) Vagrant Box into Hyper-V :

( Ensure you are still running Powershell as Administrator )

PS C:\Windows\system32>

PS C:\Windows\system32> vagrant init generic/ubuntu2004

A `Vagrantfile` has been placed in this directory. You are now

ready to `vagrant up` your first virtual environment! Please read

the comments in the Vagrantfile as well as documentation on

`vagrantup.com` for more information on using Vagrant.

PS C:\Windows\system32>

PS C:\Windows\system32> vagrant up --provider hyperv

Bringing machine 'default' up with 'hyperv' provider...

==> default: Verifying Hyper-V is enabled...

==> default: Verifying Hyper-V is accessible...

==> default: Box 'generic/ubuntu2004' could not be found. Attempting to find and install...

default: Box Provider: hyperv

default: Box Version: >= 0

==> default: Loading metadata for box 'generic/ubuntu2004'

default: URL: https://vagrantcloud.com/generic/ubuntu2004

==> default: Adding box 'generic/ubuntu2004' (v3.6.4) for provider: hyperv

Downloading:

https://vagrantcloud.com/generic/boxes/ubuntu2004/versions/3.6.4/providers/hyperv.box

default: Calculating and comparing box checksum...

==> default: Successfully added box 'generic/ubuntu2004' (v3.6.4) for 'hyperv'!

==> default: Importing a Hyper-V instance

default: Creating and registering the VM...

default: Successfully imported VM

default: Configuring the VM...

default: Setting VM Enhanced session transport type to disabled/default (VMBus)

==> default: Starting the machine...

==> default: Waiting for the machine to report its IP address...

default: Timeout: 120 seconds

default: IP: 172.23.90.135

==> default: Waiting for machine to boot. This may take a few minutes...

default: SSH address: 172.23.90.135:22

default: SSH username: vagrant

default: SSH auth method: private key

default:

default: Vagrant insecure key detected. Vagrant will automatically replace

default: this with a newly generated keypair for better security.

default:

default: Inserting generated public key within guest...

default: Removing insecure key from the guest if it's present...

default: Key inserted! Disconnecting and reconnecting using new SSH key...

==> default: Machine booted and ready!

PS C:\Windows\system32>

PS C:\Windows\system32> vagrant status

Current machine states:

default running (hyperv)

PS C:\Windows\system32>

PS C:\Windows\system32> vagrant ssh default

vagrant@ubuntu2004:~$

vagrant@ubuntu2004:~$ sudo su -

root@ubuntu2004:~#

root@ubuntu2004:~# cat /etc/*rele*

DISTRIB_ID=Ubuntu

DISTRIB_RELEASE=20.04

DISTRIB_CODENAME=focal

DISTRIB_DESCRIPTION="Ubuntu 20.04.3 LTS"

NAME="Ubuntu"

VERSION="20.04.3 LTS (Focal Fossa)"

ID=ubuntu

ID_LIKE=debian

PRETTY_NAME="Ubuntu 20.04.3 LTS"

VERSION_ID="20.04"

HOME_URL="https://www.ubuntu.com/"

SUPPORT_URL="https://help.ubuntu.com/"

BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"

PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"

VERSION_CODENAME=focal

UBUNTU_CODENAME=focal

root@ubuntu2004:~#

root@ubuntu2004:~# sudo apt update && sudo apt -y upgrade

root@ubuntu2004:~# apt install -y qemu-kvm libvirt-daemon-system bridge-utils genisoimage

root@ubuntu2004:~# systemctl status libvirtd

root@ubuntu2004:~# apt install libguestfs-tools libguestfs-xfs virt-top

root@ubuntu2004:~# apt install sshpass

root@ubuntu2004:~# apt install net-tools

root@ubuntu2004:~# apt install virtinst

# uncomment user & group "root" & restart libvirtd service :

root@ubuntu2004:~# cat /etc/libvirt/qemu.conf | grep root

# By default libvirt runs VMs as non-root and uses AppArmor profiles

# root, /dev/vhost-net, /dev/vhost-vsock and /dev/vhost-scsi access is

# running as root would have direct access to this file. If changing this

# to run as root, you may want to remove this access from

user = "root"

group = "root"

# Minimum must be greater than 0, however when QEMU is not running as root,

# and uses; alternative is 'root'

root@ubuntu2004:~#

root@ubuntu2004:~# systemctl restart libvirtd

root@ubuntu2004:~/kvm# pwd

/root/kvm

root@ubuntu2004:~/kvm#

# virt-builder -l

# export LIBGUESTFS_BACKEND=direct

# virt-builder centos-8.2 --format qcow2 --size 12G \

-o centos82a.qcow2 --root-password password

# virt-builder centos-8.2 --format qcow2 \

-o centos82b.qcow2 --root-password password

# qemu-img resize /root/kvm/centos82b.qcow2 12G

root@ubuntu2004:~/kvm# virt-builder centos-8.2 \

--format qcow2 --size 12G -o centos82c.qcow2 \

--root-password password

[ 3.3] Downloading: http://builder.libguestfs.org/centos-8.2.xz

[ 7.4] Planning how to build this image

[ 7.4] Uncompressing

[ 35.6] Resizing (using virt-resize) to expand the disk to 12.0G

[ 165.0] Opening the new disk

[ 185.1] Setting a random seed

[ 185.3] Setting passwords

[ 195.2] Finishing off

Output file: centos82c.qcow2

Output size: 12.0G

Output format: qcow2

Total usable space: 11.3G

Free space: 9.9G (87%)

root@ubuntu2004:~/kvm#

virt-install --name centos82a --ram 1024 \

--disk path=/root/kvm/centos82a.qcow2 \

--vcpus 1 --os-type linux --os-variant centos8 \

--network bridge=virbr0 --graphics none \

--serial pty --console pty --boot hd --import

# virt-install --name centos82b --ram 2048 \

--disk path=/root/kvm/centos82b.qcow2 \

--vcpus 2 --os-type linux --os-variant centos8 \

--network bridge=virbr0 --graphics none \

--serial pty --console pty --boot hd –import

# virsh setmaxmem centos82b 8G

# virsh setmem centos82b 6G --config

root@ubuntu2004:~/kvm# virt-install --name centos82c --ram 2048 \

--disk path=/root/kvm/centos82c.qcow2 --vcpus 2 \

--os-type linux --os-variant centos8 --network bridge=virbr0 \

--graphics none --serial pty --console pty --boot hd --import

CentOS Linux 8 (Core)

Kernel 4.18.0-193.6.3.el8_2.x86_64 on an x86_64

localhost login: root

[root@localhost ~]#

[root@localhost ~]# passwd root

root@ubuntu2004:~#

root@ubuntu2004:~# arp -n

Address HWtype HWaddress Flags Mask Iface

172.23.80.1 ether 00:15:5d:36:52:16 C eth0

192.168.122.197 ether 52:54:00:5d:75:91 C virbr0

root@ubuntu2004:~#

root@ubuntu2004:~# virsh start centos82b

Domain centos82b started

root@ubuntu2004:~# virsh shutdown centos82b

Domain centos82b is being shutdown

root@ubuntu2004:~#

root@ubuntu2004:~# virsh list --all

Id Name State

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

1 centos82c running

- centos82a shut off

- centos82b shut off

root@ubuntu2004:~#

root@ubuntu2004:~# ssh root@192.168.122.197

The authenticity of host '192.168.122.197 (192.168.122.197)' can't be established.

ECDSA key fingerprint is SHA256:LAo3p2USa4Dmy5F3nTpkX7Uugs7ElZVhgb6Oh5ZJO+8.

Are you sure you want to continue connecting (yes/no/[fingerprint])? yes

Warning: Permanently added '192.168.122.197' (ECDSA) to the list of known hosts.

root@192.168.122.197's password:

Last login: Mon Jan 24 16:10:00 2022

[root@localhost ~]#

[root@localhost ~]# logout

Connection to 192.168.122.197 closed.

root@ubuntu2004:~#

root@ubuntu2004:~# sshpass -p"toor" ssh root@192.168.122.197

Last login: Mon Jan 24 16:13:15 2022 from 192.168.122.1

[root@localhost ~]#

[root@localhost ~]# cat /etc/*rele*

CentOS Linux release 8.2.2004 (Core)

Derived from Red Hat Enterprise Linux 8.2 (Source)

NAME="CentOS Linux"

VERSION="8 (Core)"

ID="centos"

ID_LIKE="rhel fedora"

VERSION_ID="8"

PLATFORM_ID="platform:el8"

PRETTY_NAME="CentOS Linux 8 (Core)"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:centos:centos:8"

HOME_URL="https://www.centos.org/"

BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-8"

CENTOS_MANTISBT_PROJECT_VERSION="8"

REDHAT_SUPPORT_PRODUCT="centos"

REDHAT_SUPPORT_PRODUCT_VERSION="8"

CentOS Linux release 8.2.2004 (Core)

cpe:/o:centos:centos:8

[root@localhost ~]#

KVM on CentOS-7.5

https://www.server-world.info/en/note?os=CentOS_7&p=kvm&f=1

https://www.server-world.info/en/note?os=CentOS_7&p=kvm&f=2

https://www.server-world.info/en/note?os=CentOS_7&p=kvm&f=4

https://www.server-world.info/en/note?os=CentOS_7&p=kvm&f=9

Other nice KVM articles :

https://ostechnix.com/manage-kvm-virtual-machines-with-virsh-program/

https://ostechnix.com/how-to-find-the-ip-address-of-a-kvm-virtual-machine/

https://libguestfs.org/virt-builder.1.html

https://yping88.medium.com/building-and-installing-terraform-provider-for-libvirt-a08a29f93135

https://yping88.medium.com/provisioning-multiple-linux-distributions-using-terraform-provider-for-libvirt-632186f1c007

https://blog.programster.org/kvm-cheatsheet

https://linux.goffinet.org/administration/virtualisation-linux/virtualisation-kvm/

https://www.unixarena.com/2015/12/linux-kvm-how-to-add-remove-memory-to-guest-on-fly.html/

PostgreSQL Patroni HAProxy ViP

2022-01-10T17:45:00.008+02:00

High Availability and Automatic Failover in PostgreSQL on Kubernetes, On-premise and Cloud

https://www.youtube.com/watch?v=97rwCskemXo&list=PLWhC0zeznqknTPmcSrKmnV75Zr3QLfq7e&index=28

HAProxy can be configured to check via Patroni api who is the new master after a switchover :
below picture is from above video at minute 26:23

Same ideea of a Load Balancer who uses health checks in order to find the master ==>>

Design A Highly Available PostgreSQL Cluster With Patroni In GCP — Part 1 :

https://blog.searce.com/design-a-highly-available-postgresql-cluster-with-patroni-in-gcp-part-1-dfb6ed277806

Do we need HA Proxy:

To use Patroni, we need at least 3 nodes. In case of failover, we need some Virtual(or floating) IP address to make the application continue to access the database. To reduce this dependency, the HA proxy will always talk to the master node. Here is how HA proxy knows who is the master. In HA proxy, we need to give health check port. 8008 is the default Patroni rest API port. HA proxy will send a GET Request to all the nodes in the cluster in 8008 port. Only the Master node will give 200 OK status. Other nodes will return 503 Server Unavailable.

Alternative to HAProxy is ViP-Manager :
https://github.com/cybertec-postgresql/vip-manager

Using Vagrant for Windows VMs provisioning

2022-01-08T22:40:00.008+02:00

Using Vagrant for Windows VMs provisioning - Dots and Brackets: Code Blog

https://codeblog.dotsandbrackets.com/vagrant-windows/

https://app.vagrantup.com/mwrock

"mwrock/windows2016"

Vagrant.configure("2") do |config|

config.vm.box = "mwrock/windows2016"

config.vm.hostname = "host-win"

winClientIP = "192.168.99.103"

config.vm.network "private_network", ip: winClientIP

end

https://app.vagrantup.com/mwrock/boxes/Windows2016

Vagrantfile

Vagrant.configure("2") do |config|

config.vm.box = "mwrock/Windows2016"

end

vagrant init mwrock/Windows2016

vagrant up

https://app.vagrantup.com/StefanScherer/boxes/windows_2019

"StefanScherer/windows_2019"

Vagrantfile

Vagrant.configure("2") do |config|

config.vm.box = "StefanScherer/windows_2019"

end

vagrant init StefanScherer/windows_2019

vagrant up

Windows Server 2019 Eval with Desktop

Packer templates at :

https://github.com/StefanScherer/packer-windows/releases/tag/2021.05.15

HowTo build Windows 10/11/2016/2019/2022 base Vagrant boxes

using Packer and VirtualBox/libvirt/qemu.

https://github.com/rgl/windows-vagrant

https://github.com/joefitzgerald/packer-windows

PostgreSQL High Availability with Patroni and ETCD

2021-03-21T10:51:00.012+02:00

Building an Enterprise-Grade PostgreSQL Setup Using Open Source Tools
https://www.percona.com/blog/2018/10/19/postgresql-building-enterprise-grade-setup-with-open-source/
https://www.veritas.com/content/support/en_US/doc/129277259-129955710-0/v129957708-129955710

Set Up Highly Available PostgreSQL12 Cluster on CentOS, RHEL 8
https://www.techsupportpk.com/2020/02/how-to-create-highly-available-postgresql-cluster-centos-rhel-8.html

Set Up a Highly Available PostgreSQL12 Cluster on CentOS, RHEL 7
https://www.techsupportpk.com/2020/02/how-to-create-highly-available-postgresql-cluster-using-patroni-haproxy-centos-rhel-7.html

The simplest Patroni PostgreSQL HA is with One ETCD instance and Two PostgreSQL ( instances ) https://www.cybertec-postgresql.com/en/patroni-setting-up-a-highly-available-postgresql-cluster/

My favourite Patroni introduction :
https://www.cybertec-postgresql.com/en/postgresql-high-availability-and-patroni-an-introduction/

Nice article about ETCD Cluster :
https://www.cybertec-postgresql.com/en/introduction-and-how-to-etcd-clusters-for-patroni/

Other useful Links with more information regarding the subject :
https://www.youtube.com/watch?v=FiWZuEVlSLc
https://digitalis.io/blog/postgresql/part1-postgresql-ha-patroni-etcd-haproxy/

https://www.programmersought.com/article/4066235751/

https://www.techsupportpk.com/2020/02/how-to-create-highly-available-postgresql-cluster-centos-rhel-8.html

https://www.alibabacloud.com/blog/how-to-set-up-a-highly-available-postgresql-cluster-using-patroni-on-ubuntu-16-04_594477

https://blog.dbi-services.com/postgresql-high-availabilty-patroni-ectd-haproxy-keepalived/

PostgreSQL Cluster Patroni ETCD
https://www.youtube.com/watch?v=SBRo0l7fc_Q
https://github.com/jamalshahverdiev/vagrant-codes-in-practice/tree/master/vagrant-jenkins-gitlab
by Jamal Shahverdiev

How to Set Up a High Available PostgreSQL Cluster Using Patroni
https://miro.medium.com/max/1400/1*MKVdFmARn20kBlKcnSx_9w.png
https://medium.com/@neslisah.demirci/how-to-set-up-a-high-available-postgresql-cluster-using-patroni-d7044a754d2f

- Load Balancing with Primary + Replica - HAProxy
https://github.com/zalando/patroni/blob/master/postgres1.yml
https://github.com/zalando/patroni/blob/master/postgres0.yml

https://dzone.com/articles/managing-high-availability-in-postgresql-part-iii

---

Articles from books :

---

- Preventing Split Brain
https://subscription.packtpub.com/book/data/9781838984854/1/ch01lvl1sec09/preventing-split-brain
- Installing and configuring pgBackRest
https://subscription.packtpub.com/book/data/9781838984854/8/ch08lvl1sec98/installing-and-configuring-pgbackrest

( PostgreSQL 12 High Availability Cookbook - Third Edition : By Shaun Thomas - February 2020 )

---

PITR on a patroni-pgbackrest stack
https://medium.com/@Gowtham_Raj_Elangovan/pitr-on-a-patroni-pgbackrest-stack-9472846d8559

How to configure a Patroni Cluster to use pgbackrest

https://community.pivotal.io/s/article/How-to-Configure-a-Patroni-Cluster-to-use-pgbackrest?language=en_US

Point-in-time-recovery (PITR) with Patroni

https://community.pivotal.io/s/article/Point-in-time-recovery-PITR-with-Patroni

Q: Is it possible to perform PITR recovery with Patroni using pgBackrest?

A: As of pgBackrest 2.23 and Patroni 1.6.4, it is only possible to perform a PITR if you bootstrap the cluster.

How to use pgbackrest to bootstrap or add replica to HA Patroni

https://community.pivotal.io/s/article/How-to-Use-pgbackrest-to-bootstrap-or-add-replica-to-HA-Patroni

How to configure a Patroni Cluster to use pgbackrest

https://community.pivotal.io/s/article/How-to-Configure-a-Patroni-Cluster-to-use-pgbackrest

An ultimate guide to upgrading your PostgreSQL installation

https://www.youtube.com/watch?v=CzhVkdnbQBU

https://youtu.be/CzhVkdnbQBU?t=2528

by Ilya Kosmodemiansky

Cluster PostgreSQL mutualisé : les choix techniques Sigma

https://www.sigma.fr/2020/05/26/2-cluster-postgresql-mutualise-les-choix-techniques-sigma/

PostgreSQL Data ModeL

2021-02-28T10:13:00.005+02:00

A postgreSQL Data ModeL related to customer's order :

CREATE TABLE customer (
    c_since timestamp with time zone NOT NULL,
    c_id integer NOT NULL,
    c_w_id integer NOT NULL,
    c_d_id smallint NOT NULL,
    c_payment_cnt smallint NOT NULL,
    c_delivery_cnt smallint NOT NULL,
    c_first character varying(16) NOT NULL,
    c_middle character(2) NOT NULL,
    c_last character varying(16) NOT NULL,
    c_street_1 character varying(20) NOT NULL,
    c_street_2 character varying(20) NOT NULL,
    c_city character varying(20) NOT NULL,
    c_state character(2) NOT NULL,
    c_zip character(9) NOT NULL,
    c_phone character(16) NOT NULL,
    c_credit character(2) NOT NULL,
    c_credit_lim numeric(12,2) NOT NULL,
    c_discount numeric(4,4) NOT NULL,
    c_balance numeric(12,2) NOT NULL,
    c_ytd_payment numeric(12,2) NOT NULL,
    c_data character varying(500) NOT NULL,

    CONSTRAINT customer_i1 PRIMARY KEY (c_w_id, c_d_id, c_id)
);
CREATE UNIQUE INDEX customer_i2 ON customer USING btree (c_w_id, c_d_id, c_last, c_first, c_id);

CREATE TABLE district (
    d_w_id integer NOT NULL,
    d_next_o_id integer NOT NULL,
    d_id smallint NOT NULL,
    d_ytd numeric(12,2) NOT NULL,
    d_tax numeric(4,4) NOT NULL,
    d_name character varying(10) NOT NULL,
    d_street_1 character varying(20) NOT NULL,
    d_street_2 character varying(20) NOT NULL,
    d_city character varying(20) NOT NULL,
    d_state character(2) NOT NULL,
    d_zip character(9) NOT NULL,

    CONSTRAINT district_i1 PRIMARY KEY (d_w_id, d_id)
);

CREATE TABLE history (
    h_date timestamp with time zone NOT NULL,
    h_c_id integer,
    h_c_w_id integer NOT NULL,
    h_w_id integer NOT NULL,
    h_c_d_id smallint NOT NULL,
    h_d_id smallint NOT NULL,
    h_amount numeric(6,2) NOT NULL,
    h_data character varying(24) NOT NULL
);

CREATE TABLE item (
    i_id integer NOT NULL,
    i_im_id integer NOT NULL,
    i_name character varying(24) NOT NULL,
    i_price numeric(5,2) NOT NULL,
    i_data character varying(50) NOT NULL,

    CONSTRAINT item_i1 PRIMARY KEY (i_id)
);

CREATE TABLE new_order (
    no_w_id integer NOT NULL,
    no_o_id integer NOT NULL,
    no_d_id smallint NOT NULL,

    CONSTRAINT new_order_i1 PRIMARY KEY (no_w_id, no_d_id, no_o_id)
);

CREATE TABLE order_line (
    ol_delivery_d timestamp with time zone,
    ol_o_id integer NOT NULL,
    ol_w_id integer NOT NULL,
    ol_i_id integer NOT NULL,
    ol_supply_w_id integer NOT NULL,
    ol_d_id smallint NOT NULL,
    ol_number smallint NOT NULL,
    ol_quantity smallint NOT NULL,
    ol_amount numeric(6,2),
    ol_dist_info character(24),

    CONSTRAINT order_line_i1 PRIMARY KEY (ol_w_id, ol_d_id, ol_o_id, ol_number)
);

CREATE TABLE orders (
    o_entry_d timestamp with time zone NOT NULL,
    o_id integer NOT NULL,
    o_w_id integer NOT NULL,
    o_c_id integer NOT NULL,
    o_d_id smallint NOT NULL,
    o_carrier_id smallint,
    o_ol_cnt smallint NOT NULL,
    o_all_local smallint NOT NULL,

    CONSTRAINT orders_i1 PRIMARY KEY (o_w_id, o_d_id, o_id)
);
CREATE UNIQUE INDEX orders_i2 ON orders USING btree (o_w_id, o_d_id, o_c_id, o_id);

CREATE TABLE stock (
    s_i_id integer NOT NULL,
    s_w_id integer NOT NULL,
    s_ytd integer NOT NULL,
    s_quantity smallint NOT NULL,
    s_order_cnt smallint NOT NULL,
    s_remote_cnt smallint NOT NULL,
    s_dist_01 character(24) NOT NULL,
    s_dist_02 character(24) NOT NULL,
    s_dist_03 character(24) NOT NULL,
    s_dist_04 character(24) NOT NULL,
    s_dist_05 character(24) NOT NULL,
    s_dist_06 character(24) NOT NULL,
    s_dist_07 character(24) NOT NULL,
    s_dist_08 character(24) NOT NULL,
    s_dist_09 character(24) NOT NULL,
    s_dist_10 character(24) NOT NULL,
    s_data character varying(50) NOT NULL,

    CONSTRAINT stock_i1 PRIMARY KEY (s_w_id, s_i_id)
);

CREATE TABLE warehouse (
    w_id integer NOT NULL,
    w_name character varying(10) NOT NULL,
    w_street_1 character varying(20) NOT NULL,
    w_street_2 character varying(20) NOT NULL,
    w_city character varying(20) NOT NULL,
    w_state character(2) NOT NULL,
    w_zip character(9) NOT NULL,
    w_tax numeric(4,4) NOT NULL,
    w_ytd numeric(12,2) NOT NULL,

    CONSTRAINT warehouse_i1 PRIMARY KEY (w_id)
);

https://www.enterprisedb.com/blog/postgresql-tproc-c-benchmarks-postgresql-12-vs-postgresql-13-performance

MS SQLS port 1433

2021-02-28T01:22:00.006+02:00

PowersheLL commands for Microsoft SQL Server :

Get-Service | Where-Object {$_.Name -like "*SQL*"}
gsv | where {$_.Name -like "*SQL*"}

Get-NetTCPConnection | Where-Object {$_.LocalPort -like "143*"}
Test-NetConnection -ComputerName localhost -Port 1433

Install Microsoft SQL Server with PowersheLL DSC

2021-02-15T06:58:00.019+02:00

Get-Host
Install-Module -Name SqlServerDsc
Get-DscResource -Module SqlServerDsc
New-Item -Path C:\SQL2017 -ItemType Directory
$mountResult = Mount-DiskImage -ImagePath 'C:\vagrant\SQLServer2017-x64-ENU.iso' -PassThru
$volumeInfo = $mountResult | Get-Volume
echo $volumeInfo
$driveInfo = Get-PSDrive -Name $volumeInfo.DriveLetter
echo $driveInfo
Copy-Item -Path ( Join-Path -Path $driveInfo.Root -ChildPath '*' ) -Destination C:\SQL2017\ -Recurse
Dismount-DiskImage -ImagePath 'C:\vagrant\SQLServer2017-x64-ENU.iso'

cd C:\vagrant\scripts\
PS C:\vagrant\scripts\> dir
Directory: C:\Scripts\MSSQLS
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a---- 2/14/2021 5:20 AM 627 SQLInstallConfiguration.ps1

. .\SQLInstallConfiguration.ps1
SQLInstall

Start-DscConfiguration -Path C:\Scripts\MSSQLS\SQLInstall -Wait -Force -Verbose
Test-DscConfiguration
Get-Service -Name *SQL*

Get-Command -ModuleName sqlserver

sqlcmd
SELECT @@SERVERNAME
go

SELECT @@VERSION
go

Vagrantfile
Vagrant.configure("2") do |config|
config.vm.box = "StefanScherer/windows_2019"
config.vm.network "private_network", ip: "192.168.20.19"
end

SQLServer2017-x64-ENU.iso
- downloaded from :
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019

https://www.google.com/search?q=download+Microsoft+Command+Line+Utilities+for+SQL+Server
Microsoft Command Line Utilities 14.0 for SQL Server
https://www.microsoft.com/en-us/download/details.aspx?id=53591

About sqlcmd Utility
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017

Download the latest version of sqlcmd Utility
https://go.microsoft.com/fwlink/?linkid=2142258

Download ODBC Driver for SQL Server
https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-2017

Install SQL Server with PowerShell Desired State Configuration
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-with-powershell-desired-state-configuration?view=sql-server-ver15

The rise of the time-series database

2021-01-17T10:16:00.004+02:00

The rise of the time-series database

Which new startups are emerging?

New companies see an opportunity through focusing on adding the right amount of indexing and post-processing to make queries fast and effective.

InfluxDB began as an open source project and is now available as either a standalone installation or an elastic serverless option from the InfluxDB Cloud. The company’s Flux query language simplifies tasks like computing the moving averages of the data stream. The language is functional and designed to be easily composable so queries can be built up from other queries.

Timescale DB is a separate engine that is fully integrated with PostgreSQL for tasks that might need traditional relational tables and time-series data. The company’s benchmarks boast of speeding up ingesting data by a factor of 20. The queries for searching the data or identifying significant values like maxima can be thousands of times faster.

Prometheus stores all data with a timestamp automatically and provides a set of standard queries for analyzing changes in the data. Its PromQL bears some resemblance to the emerging data format for queries, GraphQL. This makes it simple for developers to set up alerts that could be triggered by data anomalies.

Redis created a special module for ingesting the rapid data flows into the database. The indexing routines build a set of average statistics about the data’s evolution. To save memory, it can also downsample or aggregate the elements.

The cloud companies are also adding data storage services for this market. AWS, for example, launched its Timestream service, a tool optimized for IoT data.

https://venturebeat.com/2021/01/15/database-trends-the-rise-of-the-time-series-database/

UPGRADING POSTGRESQL TO A MAJOR VERSION

2020-12-12T00:42:00.002+02:00

To do the upgrade , we have various options:

pg_dump & pg_restore

https://www.enterprisedb.com/postgres-tutorials/how-use-pgdump-and-pgrestore-multi-host-enviorment

pg_upgrade : Copy data on a binary level

pg_upgrade is not destructive.

If things go wrong, you can always delete the new data directory and start from scratch.

To upgrade a database, two steps are needed:

initdb -D /data/db_new

pg_upgrade -d /data/db_old/ -D /data/db_new -b /path/to/pg_old/bin/ -B /path/to/pg_new/bin/

pg_upgrade –link : In-place upgrades

To reduce downtime, we can use the << -link >> option:

pg_upgrade -d /data/db_old/ -D /data/db_new -b /path/to/pg_old/bin/ -B /path/to/pg_new/bin/ --link

https://www.cybertec-postgresql.com/en/upgrading-and-updating-postgresql/

MySQL 8 Router - High Availability - with Pacemaker on CentOS 8

2020-09-22T01:37:00.011+03:00

https://github.com/auntaru/vagrantfiles
https://www.youtube.com/watch?v=EVb_YhO3c7U
https://raw.githubusercontent.com/auntaru/vagrantfiles/master/MySQL-iNNoDB-CLuSTeR-pacemaker-RouTeR/provision.sh
https://github.com/auntaru/vagrantfiles/blob/master/MySQL-iNNoDB-CLuSTeR-pacemaker-RouTeR/innodb-cluster-status.js
https://github.com/auntaru/vagrantfiles/blob/master/MySQL-iNNoDB-CLuSTeR-pacemaker-RouTeR/Vagrantfile

GoaL of this article :
MySQL Router shouldn't be the single point of failure between application and a MySQL CLuSTeR

On all Nodes, Install Pacemaker and configure some settings.
If [HighAvailability] repository is not in your CentOS 8, run [# dnf upgrade centos-repos] first.

The first step is to install pacemaker on all the machines we will use for our “MySQL Router Cluster”:

# # enable [HighAvailability] repo and install (it's disabled by default)
[root@hyperv-primary-cos8 ~]# dnf --enablerepo=HighAvailability -y install pacemaker pcs

# Now we need to start the pcsd service and enable it at boot (on all machines):
[root@hyperv-primary-cos8 ~]# systemctl enable --now pcsd

Setup authentication : operation is again executed on all machines part of the MySQL Router Cluster:
# # set cluster admin password
[root@hyperv-primary-cos8 ~]# echo MyStrongPassw0rd | passwd --stdin hacluster

And on one of the nodes, we can now execute the following command:

On CentOS7 :

[root@mysql1 ~]# pcs cluster auth mysql1 mysql2 mysql3 -u hacluster -p MyStrongPassw0rd --force
mysql1: Authorized
mysql2: Authorized
mysql3: Authorized

On CentOS8 :
On a Node, Configure basic Cluster settings.
# authorize among nodes
[root@hyperv-primary-cos8 ~]# pcs host auth mysql01 mysql02 mysql03 -u hacluster -p MyStrongPassw0rd
mysql02: Authorized
mysql01: Authorized
mysql03: Authorized
[root@hyperv-primary-cos8 ~]#

# configure / create pacemaker-corosync cluster :
[root@hyperv-primary-cos8 ~]# pcs cluster setup routercluster mysql01 mysql02 mysql03
No addresses specified for host 'mysql01', using 'mysql01'
No addresses specified for host 'mysql02', using 'mysql02'
No addresses specified for host 'mysql03', using 'mysql03'
Destroying cluster on hosts: 'mysql01', 'mysql02', 'mysql03'...
mysql02: Successfully destroyed cluster
mysql03: Successfully destroyed cluster
mysql01: Successfully destroyed cluster
Requesting remove 'pcsd settings' from 'mysql01', 'mysql02', 'mysql03'
mysql01: successful removal of the file 'pcsd settings'
mysql02: successful removal of the file 'pcsd settings'
mysql03: successful removal of the file 'pcsd settings'
Sending 'corosync authkey', 'pacemaker authkey' to 'mysql01', 'mysql02', 'mysql03'
mysql01: successful distribution of the file 'corosync authkey'
mysql01: successful distribution of the file 'pacemaker authkey'
mysql02: successful distribution of the file 'corosync authkey'
mysql02: successful distribution of the file 'pacemaker authkey'
mysql03: successful distribution of the file 'corosync authkey'
mysql03: successful distribution of the file 'pacemaker authkey'
Sending 'corosync.conf' to 'mysql01', 'mysql02', 'mysql03'
mysql01: successful distribution of the file 'corosync.conf'
mysql02: successful distribution of the file 'corosync.conf'
mysql03: successful distribution of the file 'corosync.conf'
Cluster has been successfully set up.
[root@hyperv-primary-cos8 ~]#

We can now start the cluster (running the following command on one node):
[root@hyperv-primary-cos8 ~]# pcs cluster start --all
mysql02: Starting Cluster...
mysql01: Starting Cluster...
mysql03: Starting Cluster...
[root@hyperv-primary-cos8 ~]#

[root@hyperv-primary-cos8 ~]# pcs cluster status
Cluster Status:
Cluster Summary:
* Stack: corosync
* Current DC: mysql01 (version 2.0.3-5.el8_2.1-4b1f869f0f) - partition with quorum
* Last updated: Wed Sep 16 18:34:28 2020
* Last change: Wed Sep 16 18:19:10 2020 by hacluster via crmd on mysql01
* 3 nodes configured
* 0 resource instances configured
Node List:
* Online: [ mysql01 mysql02 mysql03 ]

PCSD Status:
mysql01: Online
mysql02: Online
mysql03: Online
[root@hyperv-primary-cos8 ~]#

Now we can set some properties to our cluster:
[root@hyperv-primary-cos8 ~]# pcs property set stonith-enabled=false
[root@hyperv-primary-cos8 ~]# pcs property set no-quorum-policy=ignore
[root@hyperv-primary-cos8 ~]# pcs resource defaults migration-threshold=1

Adding resources

VIP

The first resource we will use is the VIP (Virtual IP) that the application will use to connect to MySQL Router:

[root@hyperv-primary-cos8 ~]# ip a

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 scope host lo

valid_lft forever preferred_lft forever

2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000

link/ether 00:15:5d:38:01:07 brd ff:ff:ff:ff:ff:ff

inet 192.168.0.22/24 brd 192.168.0.255 scope global noprefixroute eth0

valid_lft forever preferred_lft forever

inet6 fc00::1:122/64 scope global noprefixroute

valid_lft forever preferred_lft forever

inet6 fe80::77b3:112:420b:3363/64 scope link noprefixroute

valid_lft forever preferred_lft forever

[root@hyperv-primary-cos8 ~]#

[root@hyperv-primary-cos8 ~]# pcs resource create Router_VIP ocf:heartbeat:IPaddr2 \

> ip=192.168.0.11 cidr_netmask=24 op monitor interval=5s

[root@hyperv-primary-cos8 ~]# ip a

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 scope host lo

valid_lft forever preferred_lft forever

2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP group default qlen 1000

link/ether 00:15:5d:38:01:07 brd ff:ff:ff:ff:ff:ff

inet 192.168.0.22/24 brd 192.168.0.255 scope global noprefixroute eth0

valid_lft forever preferred_lft forever

inet 192.168.0.11/24 brd 192.168.0.255 scope global secondary eth0

valid_lft forever preferred_lft forever

inet6 fc00::1:122/64 scope global noprefixroute

valid_lft forever preferred_lft forever

inet6 fe80::77b3:112:420b:3363/64 scope link noprefixroute

valid_lft forever preferred_lft forever

[root@hyperv-primary-cos8 ~]#

yum install -y mysql-router

[root@hyperv-primary-cos8 ~]# pcs resource create mysqlrouter systemd:mysqlrouter clone

pcs resource list | grep -i router
pcs resource list | grep -i mysql

[root@hyperv-primary-cos8 ~]# pcs resource list | grep -i postgres
ocf:heartbeat:pgsql - Manages a PostgreSQL database instance
[root@hyperv-primary-cos8 ~]#

Before adding the MySQL Router as resource, we need to be sure that the router is installed and bootstrapped on each nodes. As reminder, this is how to proceed:

MySQL-RouteR : BooTsTraP

password="Cluster^123"
mysql -e "create user 'mysqlrouter' identified by '$password'"

[root@hyperv-proxy-cos8 ~]# echo $password | mysqlrouter --bootstrap mycluster@mysql01 --user=mysqlrouter

mysql --host=192.168.0.22 --port=3306 --user=mycluster -p"Cluster^123"

Now we can add the resource that will manage MySQL Router in our pacemaker cluster. We will use systemd.

You can verify if systemd service for mysqlrouter is available using the following command:

[root@mysql1 ~]# pcs resource list | grep router
service:mysqlrouter - systemd unit file for mysqlrouter
systemd:mysqlrouter - systemd unit file for mysqlrouter

OK, so let’s add the resource and let’s it run on all nodes (clone), no need to start mysqlrouter only if the running one has issue:

[root@hyperv-primary-cos8 ~]# pcs resource create mysqlrouter systemd:mysqlrouter clone

Let’s verify if the resource is now added:

[root@hyperv-primary-cos8 ~]# crm_mon -1

Cluster Summary:

* Stack: corosync

* Current DC: mysql01 (version 2.0.3-5.el8_2.1-4b1f869f0f) - partition with quorum

* Last updated: Wed Sep 16 19:00:31 2020

* Last change: Wed Sep 16 19:00:27 2020 by root via cibadmin on mysql01

* 3 nodes configured

* 4 resource instances configured

Node List:

* Online: [ mysql01 mysql02 mysql03 ]

Active Resources:

* Router_VIP (ocf::heartbeat:IPaddr2): Started mysql01

* Clone Set: mysqlrouter-clone [mysqlrouter]:

* Started: [ mysql01 mysql02 mysql03 ]

[root@hyperv-primary-cos8 ~]#

Now we need to tell the cluster that the VIP needs to stand where a router instance also runs:

[root@hyperv-primary-cos8 ~]# pcs constraint colocation add Router_VIP \

> with mysqlrouter-clone score=INFINITY

[root@hyperv-primary-cos8 ~]#

Now we will kill mysqlrouter process on mysql01 and see what the cluster does:

https://lefred.be/content/mysql-router-ha-with-pacemaker/
https://www.server-world.info/en/note?os=CentOS_8&p=pacemaker&f=1
https://raw.githubusercontent.com/behemius/gcp01/master/node1_install.sh
https://raw.githubusercontent.com/behemius/gcp01/master/router_install.sh

[root@hyperv-primary-cos8 ~]#

[root@hyperv-primary-cos8 ~]# mysqlsh --sql -e "select * from performance_schema.replication_group_members\G" --user=mycluster -p"Cluster^123"

WARNING: Using a password on the command line interface can be insecure.

*************************** 1. row ***************************

CHANNEL_NAME: group_replication_applier

MEMBER_ID: 3d17fb2b-f143-11ea-9c6b-00155d380107

MEMBER_HOST: hyperv-primary-cos8

MEMBER_PORT: 3306

MEMBER_STATE: ONLINE

MEMBER_ROLE: PRIMARY

MEMBER_VERSION: 8.0.17

*************************** 2. row ***************************

CHANNEL_NAME: group_replication_applier

MEMBER_ID: 6a766bf2-f184-11ea-a7ad-00155d380109

MEMBER_HOST: hyperv-proxy-cos8

MEMBER_PORT: 3306

MEMBER_STATE: ONLINE

MEMBER_ROLE: SECONDARY

MEMBER_VERSION: 8.0.17

*************************** 3. row ***************************

CHANNEL_NAME: group_replication_applier

MEMBER_ID: ef479c0a-f183-11ea-b35a-00155d380108

MEMBER_HOST: hyperv-standby-cos8

MEMBER_PORT: 3306

MEMBER_STATE: ONLINE

MEMBER_ROLE: SECONDARY

MEMBER_VERSION: 8.0.17

[root@hyperv-primary-cos8 ~]#

[root@hyperv-primary-cos8 ~]# mysqlsh --sql -e "SELECT @@global.read_only, @@global.super_read_only, @@global.group_replication_group_seeds\G" --user=mycluster -p"Cluster^123"

WARNING: Using a password on the command line interface can be insecure.

*************************** 1. row ***************************

@@global.read_only: 0

@@global.super_read_only: 0

@@global.group_replication_group_seeds: 192.168.0.22:33061,192.168.0.24:33061,192.168.0.28:33061,hyperv-proxy-cos8:33061

[root@hyperv-primary-cos8 ~]#

[root@hyperv-primary-cos8 ~]# cat ./innodb-cluster-status.js

try {

shell.connect('mycluster@hyperv-primary-cos8', "Cluster^123");

print(dba.getCluster().status());

print(session.runSql("SHOW DATABASES;"));

} catch(e) {

print('\nThe InnoDB cluster could not be created.\n\nError: ' +

+ e.message + '\n');

}

[root@hyperv-primary-cos8 ~]#

[root@hyperv-primary-cos8 ~]# mysqlsh -f innodb-cluster-status.js

{

"clusterName": "mycluster",

"defaultReplicaSet": {

"name": "default",

"primary": "hyperv-primary-cos8:3306",

"ssl": "REQUIRED",

"status": "OK",

"statusText": "Cluster is ONLINE and can tolerate up to ONE failure.",

"topology": {

"hyperv-primary-cos8:3306": {

"address": "hyperv-primary-cos8:3306",

"mode": "R/W",

"readReplicas": {},

"replicationLag": null,

"role": "HA",

"status": "ONLINE",

"version": "8.0.17"

"hyperv-proxy-cos8:3306": {

"address": "hyperv-proxy-cos8:3306",

"mode": "R/O",

"readReplicas": {},

"replicationLag": null,

"role": "HA",

"status": "ONLINE",

"version": "8.0.17"

"hyperv-standby-cos8:3306": {

"address": "hyperv-standby-cos8:3306",

"mode": "R/O",

"readReplicas": {},

"replicationLag": null,

"role": "HA",

"status": "ONLINE",

"version": "8.0.17"

}

"topologyMode": "Single-Primary"

"groupInformationSourceMember": "hyperv-primary-cos8:3306"

}<SqlResult>[root@hyperv-primary-cos8 ~]#

https://lefred.be/content/mysql-router-ha-with-pacemaker

https://lefred.be/content/mysql-innodb-cluster-is-the-router-a-single-point-of-failure/

https://www.server-world.info/en/note?os=CentOS_8&p=pacemaker&f=1

Clusters_from_Scratch.pdf

How to generate self-signed SSL certificates

2020-08-20T09:24:00.000+03:00

Generate a root private key (rootCA.key):

openssl genrsa -out rootCA.key 2048

Generate a self-singed root certificate (rootCA.pem):

openssl req -x509 -new -nodes -key rootCA.key -days 1024 -out rootCA.pem

Create a private key for the final certificate (dovecot.key):

openssl genrsa -out dovecot.key 2048

Create a certificate sign request (dovecot.csr):

openssl req -new -key dovecot.key -out dovecot.csr

Create a certificate based on the root CA certificate and the root private key (dovecot.crt):

openssl x509 -req -in dovecot.csr -CA rootCA.pem -CAkey rootCA.key -CAcreateserial -out dovecot.crt -days 500

Copy the private key and the certificate to the /etc/dovecot/private/ directory

cp dovecot.crt /etc/dovecot/private/dovecot.crt

# cp dovecot.key /etc/dovecot/private/dovecot.key

Set the required permissions on the file:

chmod 400 /etc/dovecot/private/dovecot.crt

# chmod 400 /etc/dovecot/private/dovecot.key

Update paths to the key and the certificate in the Dovecot configuration file /etc/dovecot/dovecot.conf:

ssl_cert = < /etc/dovecot/private/dovecot.crt

ssl_key = </etc/dovecot/private/dovecot.key

Restart the Dovecot service to apply the changes:

service dovecot restart

Systemd - systemctl - Services Management

2020-08-09T13:13:00.009+03:00

systemctl list-units
This will show you a list of all of the units that systemd currently has active on the system.

systemctl list-units --all
This will show any unit that systemd loaded or attempted to load, regardless of its current state on the system. Some units become inactive after running, and some units that systemd attempted to load may have not been found on disk.

systemctl list-units --all --state=inactive
systemctl list-units --type=service

systemctl list-unit-files
Units are representations of resources that systemd knows about. Since systemd has not necessarily read all of the unit definitions in this view, it only presents information about the files themselves. The output has two columns: the unit file and the state.

systemctl cat atd.service
systemctl list-dependencies sshd.service
systemctl show sshd.service

sudo systemctl edit nginx.service
This will be a blank file that can be used to override or add directives to the unit definition. A directory will be created within the /etc/systemd/system directory which contains the name of the unit with .d appended. For instance, for the nginx.service, a directory called nginx.service.d will be created.

https://www.digitalocean.com/community/tutorials/how-to-use-systemctl-to-manage-systemd-services-and-units

AWS EC2 : Dockerize Java App & Deploy Container

2020-07-25T17:52:00.000+03:00

https://youtu.be/ToqoJ8YAkRg

Dockerize app and deploy in EC2 instance
Push the docker image to Docker Hub public repository

Steps:
1. Setting up docker engine

sudo yum update -y

sudo amazon-linux-extras install docker

sudo service docker start

sudo usermod -a -G docker ec2-user

2. Dockerize your application

-- Dockerfile
FROM java:8
WORKDIR /
ADD myapp.jar myapp.jar
COPY application.properties application.properties
EXPOSE 5000
CMD java -jar myapp.jar -Dspring.config.location=application.properties

3. Building docker image of application:

docker build -t myapp .

4. Tagging image

docker tag myapp nirajtechi/myapp

5. Overriding port while launching docker container

docker run -p 8080:5000 nirajtechi/myapp

6. Push image to repository (Docker Hub)
docker push nirajtechi/myapp

7. Pull image from repository (Docker Hub)
docker pull nirajtechi/myapp

Java Microservices : Quarkus vs. Spring Boot

2020-07-25T14:21:00.010+03:00

Nowadays, with the Microservice Architecture, perhaps it does not make sense anymore, nor any advantage, build something multi-platform (interpreted) for something that will always run on the same place and platform (the Docker Container — Linux environment). Portability is now less relevant (maybe more than ever), those extra level of abstraction is not important.

Having said that, let's check a simple and raw comparison between two alternatives to generate Microservices in Java: the very well-known Spring Boot and the not so very well-know (yet) Quarkus.

https://dzone.com/articles/microservices-quarkus-vs-spring-boot

https://thorntail.io/posts/thorntail-community-announcement-on-quarkus/

Thorntail Community Announcement on Quarkus

The team will continue contributing to SmallRye and Eclipse MicroProfile, while also shifting work towards Quarkus in the future . . .

https://thorntail.io/

Thorntail has announced end of life. Everything else on this site is now outdated. We recommend using Quarkus or WildFly.

Thorntail offers an innovative approach to packaging and running Java EE applications by packaging them with just enough of the server runtime to "java -jar" your application. It's MicroProfile compatible, too. And, it's all much, much cooler than that ...

https://wildfly.org/news/2020/06/18/Bootable-jar-Wildfly-20/

Getting started

In order to help you start using the org.wildfly.plugins:wildfly-jar-maven-plugin Maven plugin, we have defined a set of examples that cover common use-cases.

To retrieve the examples:

git clone -b 2.0.0.Alpha4 http://github.com/wildfly-extras/wildfly-jar-maven-plugin

cd wildfly-jar-maven-plugin/examples

A good example to start with is the jaxrs example. To build and run the jaxrs example:

cd jaxrs

mvn package

java -jar target/jaxrs-wildfly.jar

The plugin documentation (currently an index.html file to download) can be found here. It contains a comprehensive list of the options you can use to fine tune the Maven build and create a bootable JAR.

Be sure to read the examples/README that contains required information to run the examples in an OpenShift context.

Using Kubernetes to Deploy PostgreSQL

2020-07-18T18:03:00.002+03:00

PostgreSQL kubectl YAML

Config Maps :

===============================

File: postgres-configmap.yaml

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

apiVersion: v1

kind: ConfigMap

metadata:

labels:

app: postgres

data:

POSTGRES_DB: postgresdb

POSTGRES_USER: postgresadmin

POSTGRES_PASSWORD: admin123

Create Postgres config maps resource

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

$ kubectl create -f postgres-configmap.yaml

configmap "postgres-config" created

Persistent Storage Volume

===============================

File: postgres-storage.yaml

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

kind: PersistentVolume

apiVersion: v1

metadata:

labels:

type: local

app: postgres

spec:

storageClassName: manual

capacity:

storage: 5Gi

accessModes:

- ReadWriteMany

hostPath:

path: "/mnt/data"

---

kind: PersistentVolumeClaim

apiVersion: v1

metadata:

labels:

app: postgres

spec:

storageClassName: manual

accessModes:

- ReadWriteMany

resources:

requests:

storage: 5Gi

Create storage related deployments

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

$ kubectl create -f postgres-storage.yaml

persistentvolume "postgres-pv-volume" created

persistentvolumeclaim "postgres-pv-claim" created

PostgreSQL Deployment

===============================

File: postgres-deployment.yaml

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

apiVersion: extensions/v1beta1

kind: Deployment

metadata:

spec:

replicas: 1

template:

metadata:

labels:

app: postgres

spec:

containers:

- name: postgres

image: postgres:10.4

imagePullPolicy: "IfNotPresent"

ports:

- containerPort: 5432

envFrom:

- configMapRef:

volumeMounts:

- mountPath: /var/lib/postgresql/data

volumes:

- name: postgredb

persistentVolumeClaim:

claimName: postgres-pv-claim

Create Postgres deployment

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

$ kubectl create -f postgres-deployment.yaml

deployment "postgres" created

PostgreSQL Service

===============================

File: postgres-service.yaml

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

apiVersion: v1

kind: Service

metadata:

labels:

app: postgres

spec:

type: NodePort

ports:

- port: 5432

selector:

app: postgres

Create Postgres Service

$ kubectl create -f postgres-service.yaml

service "postgres" created

Connect to PostgreSQL

$ kubectl get svc postgres

NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE

postgres NodePort 10.107.71.253 <none> 5432:31070/TCP 5m

psql -h localhost -U postgresadmin1 --password -p 31070 postgresdb

Delete PostgreSQL Deployments

# kubectl delete service postgres

# kubectl delete deployment postgres

# kubectl delete configmap postgres-config

# kubectl delete persistentvolumeclaim postgres-pv-claim

# kubectl delete persistentvolume postgres-pv-volume

MariaDB in the penguin container of ChromeOS

2020-07-12T14:01:00.000+03:00

I've got a Chromebook ; Installed MariaDB in penguin container :

apt install mysql-server
apt install mysql-workbench
systemctl status mariadb

https://discuss.linuxcontainers.org/t/using-lxd-on-your-chromebook/3823

https://www.maketecheasier.com/run-ubuntu-container-chrome-os/

How can Docker help a MariaDB cluster for Disaster/Recovery

2020-07-06T18:04:00.003+03:00

https://blog.dbi-services.com/how-can-docker-help-a-mariadb-cluster-for-disaster-recovery/

This post is a work in progress ; On the above link is the original ideea ;

Mistakes or accidental data deletions can sometimes happen on a productive MariaDB Galera Cluster and this can be disastrous.
There are so many cases I have heard by customers and hereafter are some of the most common:
– dropping one column of a table
– dropping one table
– updating a big table without a where clause
What if it was possible to restore online a subset of data without downtime?

MariaDB preparation

We need some help from Docker ;
Using a delayed node (the helper), we can deploy a container with a delayed replication of 15minutes, but of course you can choose your own lags.

MariaDB > create user rpl_user@’192.168.56.%' IDENTIFIED BY 'manager';

MariaDB > GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%’;

MariaDB > show grants for 'rpl_user'@'’192.168.56.%';

+-------------------------------------------------------------------------------------+

| Grants for rpl_user@%                                                               |

+-------------------------------------------------------------------------------------+

| GRANT REPLICATION SLAVE ON *.* TO 'rpl_user'@'’192.168.56.%'                        |

+-------------------------------------------------------------------------------------+

$ vi /storage/mariadb-slave-15m/mariadb.conf.d/my.cnf

[mysqld]

server_id=10015

binlog_format=ROW

log_bin=binlog

log_slave_updates=1

relay_log=relay-bin

expire_logs_days=7

read_only=ON

The most important parameter is “MASTER_DELAY” as it determines the amount of time in seconds the slave should lag behind the master.

CHANGE MASTER TO MASTER_HOST = '192.168.56.203’, \
MASTER_USER = 'rpl_user', MASTER_PASSWORD = 'manager’, \
MASTER_DELAY=900;
START SLAVE

How to use table partitioning to scale PostgreSQL

2020-07-06T17:37:00.000+03:00

https://www.enterprisedb.com/postgres-tutorials/how-use-table-partitioning-scale-postgresql

Benefits of partitioning

PostgreSQL declarative partitioning is highly flexible and provides good control to users. Users can create any level of partitioning based on need and can modify, use constraints, triggers, and indexes on each partition separately as well as on all partitions together.
Query performance can be increased significantly compared to selecting from a single large table.
Partition-wise-join and partition-wise-aggregate features increase complex query computation performance as well.
Bulk loads and data deletion can be much faster, as based on user requirements these operations can be performed on individual partitions.
Each partition can contain data based on its frequency of use and so can be stored on media that may be cheaper or slower for low-use data.

When to use partitioning

Most benefits of partitioning can be enjoyed when a single table is not able to provide them. So we can say that if a lot of data is going to be written on a single table at some point, users need partitioning. Apart from data, there may be other factors users should consider, like update frequency of the data, use of data over a time period, how small a range data can be divided, etc. With good planning and taking all factors into consideration, table partitioning can give a great performance boost and scale your PostgreSQL to larger datasets.

How to use partitioning

As of PostgreSQL12 release List, Range, Hash and combinations of these partition methods at different levels are supported.

MySQL other commands

2020-07-05T19:06:00.000+03:00

MySQL default port = 3306

MySQL USER

show grants for 'SUPER'@'%'
CREATE USER 'SUPER'@'%' IDENTIFIED BY 'toor'
GRANT SELECT ON *.* TO 'SUPER'@'127.0.0.1'
ALTER USER 'SUPER'@'%' PASSWORD EXPIRE
flush privileges;

`GRANT ALL PRIVILEGES ON . TO 'SUPER'@'%' WITH GRANT OPTION;`

mysql -u SUPER -P 3306 -h 127.0.0.1 -p toor
show grants for 'SUPER'@'%';

select @@port , @@hostname;

show global variables\G
select @@version , @@port , @@hostname , @@datadir , @@socket , @@log_error , @@pid_file , @@max_connections , @@log_bin , @@expire_logs_days;

show global variables like "datadir";
show global variables like "%port%";
SHOW GLOBAL VARIABLES LIKE '%bin%';
SHOW GLOBAL VARIABLES LIKE '%log%';
show slave status\G
show master status\G

select host,user,authentication_string from mysql.user where user like 'R%';

sfx=$(ps -efa | grep mysql | grep 'suffix')
if [ "x${sfx}" != "x" ]
then
instlist=$(ps -ef | grep 'mysqld '| grep -o '@.*' | cut -c2- | awk '{print $1}' | sort );
else
instlist=$(ps -efa | grep 'mysqld ' | grep -o 'port=.*' | cut -c6- | sort)
fi
echo $instlist
for i in $instlist; do echo $i ; done

select * from information_schema.processlist where state like '%lock%';

su ansible -c "mysqladmin --login-path=labelPORT status processlist shutdown"
instlist="3366 3367 3368 3369";for INSTANCE in $instlist; do echo ${INSTANCE};mysql --login-path=label${INSTANCE} -e "\s" | grep Up ; done

NO COLOR
echo $PS1
export PS1="[\u@\h \d \@ \w]$ "

mysql --login-path=label${INSTANCE} -e 'SELECT table_schema "database", sum(data_length + index_length)/1024/1024/1024 "size in GB" FROM information_schema.TABLES table_schema; ';

instlist=$( ps -efa | grep 'mysqld ' | grep -o 'pid-file=.*' | awk '{print $1}' | cut -d'.' -f1 | rev | cut -c1-4 | rev | sort );
for INSTANCE in $instlist; do echo ${INSTANCE};mysql --login-path=label${INSTANCE} -e "\s" | grep "Server version" ; done

5.6=>

instlist56=$(ps -efa | grep 'mysqld ' | grep -o 'port=.*' | cut -c6- | sort )
for INSTANCE in $instlist56; do echo ${INSTANCE};/home/usr/bin/mysql --login-path=label${INSTANCE} -e "\s" | grep "Server version"; done

instlist57=$(ps -ef | grep 'mysqld '| grep -o '@.*' | cut -c2- | awk '{print $1}' | sort );
for INSTANCE in $instlist57; do echo ${INSTANCE};mysql --login-path=label${INSTANCE} -e "\s" | grep "Server version"; done

<=5.7

echo $instlist

sfx=$(ps -efa | grep mysql | grep 'suffix')
if [ "x${sfx}" != "x" ]
then
instlist=$(ps -ef | grep 'mysqld '| grep -o '@.*' | cut -c2- | awk '{print $1}' | sort );
else
instlist=$(ps -efa | grep 'mysqld ' | grep -o 'port=.*' | cut -c6- | sort)
fi

echo $instlist
for INSTANCE in $instlist;
do
echo ${INSTANCE};
mysql --login-path=label${INSTANCE} -e 'SELECT table_schema "database", sum(data_length + index_length)/1024/1024/1024 "size in GB" FROM information_schema.TABLES table_schema ORDER by 2 DESC; ';
done

mysql_config_editor set --login-path=label3306 --host=127.0.0.1 --user=USER --port=3306 --password
mysql_config_editor print --all

mysql -u db_user -S/home/mysql/socket/my.sock -p
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "%expire_logs_days%"'
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "%log%"'
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "general_log_file"'
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "log_error"'
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "%log_bin%"'
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "%relay_log%"'
/home/usr/bin/mysql --login-path=label3306 -e 'show global variables like "%slow_query_log%"'
CLUSTER RHEL7 : sudo pcs status
sudo su - ansible + root on labelJUmper
mysql -h 127.0.0.1 -u USER -p -P port
mysql -u USER -P 3306 -h 127.0.0.1 -p
systemctl status mysqld@port
mysql --login-path=labelPORT

/opt/rh/mysql55/root/usr/bin/mysql -uroot -p pact -e 'SELECT * from table where field in ('3520','3535','3540') into OUTFILE 'autorisatie.csv' FIELDS TERMINATED BY ',';'

How To Copy a Folder
https://www.cyberciti.biz/faq/copy-folder-linux-command-line/
cp -var /home/source/folder /backup/copy/destination

Where,

-a : Preserve attributes such as file ownership, timestamps
-v : Verbose output.
-r : Copy directories recursively.

Use Linux rsync Command to copy a folder
rsync -av /path/to/source/ /path/to/destination/

To backup my home directory, which consists of large files and mail folders to /media/backup, enter:
$ rsync -avz /home/vivek /media/backup

copy a folder to remote machine called server1.cyberciti.biz as follows:
$ rsync -avz /home/vivek/ server1.cyberciti.biz:/home/backups/vivek/

Where,

-a : Archive mode i.e. copy a folder with all its permission and other information including recursive copy.
-v : Verbose mode.
-z : With this option, rsync compresses the file data as it is sent to the destination machine, which reduces the amount of data being transmitted something that is useful over a slow connection.
You can show progress during transfer using –progress or -P option:
$ rsync -av --progress /path/to/source/ /path/to/dest

Important MySQL Commands

2020-02-25T10:50:00.002+02:00

To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u username -ppassword
To login (from windows)
mysql dir/bin/mysql.exe -h hostname -u username -ppassword

Create a database.
mysql> create database [databasename];

List all databases on the server.
mysql> show databases;

Switch to a database.
mysql> use [db name];

To see all the tables in the db.
mysql> show tables;

To see table's field formats.
mysql> describe [table name];

To delete a db.
mysql> drop database [database name];

To delete a table.
mysql> drop table [table name];

Show all data from a table.
mysql> SELECT * FROM [table name];

To return columns and column information.
mysql> show columns from [table name];

Show particular rows with the given value.
mysql> SELECT * FROM [table name] WHERE [field name] = "value";

Show all records containing the name "Something" AND the phone number '0123456789'.
mysql> SELECT * FROM [table name] WHERE name = "Something" AND phone_number = '0123456789';

Show all records not containing the name "Something" AND the phone number '0123456789' order by the phone_number field.
mysql> SELECT * FROM [table name] WHERE name != "Something" AND phone_number = '0123456789' order by phone_number;

Show all records starting with the letters 'Something' AND the phone number '0123456789'.
mysql> SELECT * FROM [table name] WHERE name like "Something%" AND phone_number = '0123456789';

Show all records starting with letters 'Something' AND the phone number '0123456789' limit to records 1 through 5.
mysql> SELECT * FROM [table name] WHERE name like "Something%" AND phone_number = '0123456789' limit 1,5;

Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a.
mysql> SELECT * FROM [table name] WHERE rec RLIKE "^a";

Show unique records.
mysql> SELECT DISTINCT [column name] FROM [table name];

Show selected records sorted in an ascending (asc) or descending (desc).
mysql> SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;

Return number of rows.
mysql> SELECT COUNT(*) FROM [table name];

Sum column.
mysql> SELECT SUM(*) FROM [table name];

Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
mysql> flush privileges;

Change a users password from unix shell.
# [mysql dir]/bin/mysqladmin -u username -h hostname -ppassword 'new-password'

Change a users password from MySQL prompt. Login as root. Set the password. Update privileges.
# mysql -u root -p
mysql> SET PASSWORD FOR 'user'@'hostname' = PASSWORD('password');
mysql> flush privileges;

Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables
# mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newpassword") where User='root';
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql stop
# /etc/init.d/mysql start

Set a root password if there is no root password.
# mysqladmin -u root password newpassword

Update a root password.
# mysqladmin -u root -p oldpassword newpassword

Allow the user "Someone" to connect to the server from localhost using the password "passwd". Login as root. Switch to the MySQL db. Give privs. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql> grant usage on *.* to Someone@localhost identified by 'passwd';
mysql> flush privileges;

Give user privilages for a db. Login as root. Switch to the MySQL db. Grant privs. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql>INSERT INTO user(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv)
VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');
mysql> flush privileges;

or

mysql> grant all privileges on databasename.* to username@localhost;
mysql> flush privileges;

To update info already in a table.
mysql> UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';

Delete a row(s) from a table.
mysql> DELETE from [table name] where [field name] = 'fieldvalue';

Update database permissions/privilages.
mysql> flush privileges;

Delete a column.
mysql> alter table [table name] drop column [column name];

Add a new column to db.
mysql> alter table [table name] add column [new column name] varchar (20);

Change column name.
mysql> alter table [table name] change [old column name] [new column name] varchar (50);

Make a unique column so you get no dupes.
mysql> alter table [table name] add unique ([column name]);

Make a column bigger.
mysql> alter table [table name] modify [column name] VARCHAR(3);

Delete unique from table.
mysql> alter table [table name] drop index [colmn name];

Load a CSV file into a table.
mysql> LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);

Dump all databases for backup. Backup file is sql commands to recreate all db's.
# mysqldump -u username -ppassword --opt > /tmp/alldatabases.sql

Dump one database for backup.
# mysqldump -u username -ppassword --databases databasename > /tmp/databasename.sql

Dump a table from a database.
# mysqldump -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

Restore database (or database table) from backup.
# mysql -u username -ppassword databasename < /tmp/databasename.sql

Create Table Example 1.
mysql> CREATE TABLE [table name] (name VARCHAR(20));

Create Table Example 2.
mysql> create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default 'somethiing');

Java & Linux : Fishing in the Desert

Replication from Oracle to MySQL Using GoldenGate

Checking in at the Golden Gate 19c

Oracle Database 19c RAC on Linux - Vagrant UP

Oracle Database 19c RAC on Oracle Linux 7 : common commands

Steps to "fix" the dynamic ip of KVM

Windows-11 + Vagrant + Hyper-V + Ubuntu-20.04 + KVM + CentOS-8.2

PostgreSQL Patroni HAProxy ViP

Using Vagrant for Windows VMs provisioning

PostgreSQL High Availability with Patroni and ETCD

PostgreSQL Data ModeL

MS SQLS port 1433

Install Microsoft SQL Server with PowersheLL DSC

The rise of the time-series database

UPGRADING POSTGRESQL TO A MAJOR VERSION

MySQL 8 Router - High Availability - with Pacemaker on CentOS 8

How to generate self-signed SSL certificates

Systemd - systemctl - Services Management

AWS EC2 : Dockerize Java App & Deploy Container

Java Microservices : Quarkus vs. Spring Boot

Using Kubernetes to Deploy PostgreSQL

MariaDB in the penguin container of ChromeOS

How can Docker help a MariaDB cluster for Disaster/Recovery

MariaDB preparation

How to use table partitioning to scale PostgreSQL

Benefits of partitioning

When to use partitioning

How to use partitioning

MySQL other commands

GRANT ALL PRIVILEGES ON *.* TO 'SUPER'@'%' WITH GRANT OPTION;

Important MySQL Commands

`GRANT ALL PRIVILEGES ON . TO 'SUPER'@'%' WITH GRANT OPTION;`