Quick and Easy Oracle Database 19c Build – A Git deployment

Here’s a quick and easy (not dirty) why to get Oracle Database 19c up and running.  Its based on a github repository.

Once you run the oracle_19c_install command, you will essentially have the following built out:

  1. All required Linux rpms installed and parameters set
  2. A 19c Oracle DB Home installed
  3. A 19c DB created with a single
  4. CDB will be opened and PDB started in left in OPEN MODE

Warning this is essentially my output listing…. hope its easy to follow along:

First ya need to have git installed, if you dont have it already

[root@git19c ~]# yum -y install git

Loaded plugins: langpacks, ulninfo

Resolving Dependencies

--> Running transaction check

---> Package git.x86_64 0:1.8.3.1-20.el7 will be installed

--> Processing Dependency: perl-Git = 1.8.3.1-20.el7 for package: git-1.8.3.1-20.el7.x86_64

--> Processing Dependency: perl(Term::ReadKey) for package: git-1.8.3.1-20.el7.x86_64

--> Processing Dependency: perl(Git) for package: git-1.8.3.1-20.el7.x86_64

--> Processing Dependency: perl(Error) for package: git-1.8.3.1-20.el7.x86_64

--> Running transaction check

---> Package perl-Error.noarch 1:0.17020-2.el7 will be installed

---> Package perl-Git.noarch 0:1.8.3.1-20.el7 will be installed

---> Package perl-TermReadKey.x86_64 0:2.30-20.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================
Package                                       Arch                                Version                                      Repository                               Size
==============================================================================================================================================================================

Installing:

git                                           x86_64                              1.8.3.1-20.el7                               ol7_latest                              4.4 M

Installing for dependencies:

perl-Error                                    noarch                              1:0.17020-2.el7                              ol7_latest                               31 k

perl-Git                                      noarch                              1.8.3.1-20.el7                               ol7_latest                               55 k

perl-TermReadKey                              x86_64                              2.30-20.el7                                  ol7_latest                               30 k

Transaction Summary

=========================================================================================================================================================

Install  1 Package (+3 Dependent packages)

Total download size: 4.5 M

Installed size: 22 M

Downloading packages:

(1/4): perl-Error-0.17020-2.el7.noarch.rpm                                                                                                             |  31 kB  00:00:00     

(2/4): perl-Git-1.8.3.1-20.el7.noarch.rpm                                                                                                              |  55 kB  00:00:00     

(3/4): perl-TermReadKey-2.30-20.el7.x86_64.rpm                                                                                                         |  30 kB  00:00:00     

(4/4): git-1.8.3.1-20.el7.x86_64.rpm                                                                                                                   | 4.4 MB  00:00:00     

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

Total                                                                                                                                         7.5 MB/s | 4.5 MB  00:00:00     

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : 1:perl-Error-0.17020-2.el7.noarch                                                                                                                          1/4

  Installing : perl-TermReadKey-2.30-20.el7.x86_64                                                                                                                        2/4

  Installing : git-1.8.3.1-20.el7.x86_64                                                                                                                                  3/4

  Installing : perl-Git-1.8.3.1-20.el7.noarch                                                                                                                             4/4

  Verifying  : perl-Git-1.8.3.1-20.el7.noarch                                                                                                                             1/4

  Verifying  : 1:perl-Error-0.17020-2.el7.noarch                                                                                                                          2/4

  Verifying  : git-1.8.3.1-20.el7.x86_64                                                                                                                                  3/4

  Verifying  : perl-TermReadKey-2.30-20.el7.x86_64                                                                                                                        4/4

Installed:

  git.x86_64 0:1.8.3.1-20.el7                                                                                                                                                 

Dependency Installed:

  perl-Error.noarch 1:0.17020-2.el7                       perl-Git.noarch 0:1.8.3.1-20.el7                       perl-TermReadKey.x86_64 0:2.30-20.el7                      

Complete!

[root@git19c ~]# git version

git version 1.8.3.1


Now lets get the database bits from git 
[root@git19c ~]# git clone https://github.com/dockerhelp/docker-oracle-ee-19c.git

Cloning into 'docker-oracle-ee-19c'...

remote: Enumerating objects: 12, done.

remote: Counting objects: 100% (12/12), done.

remote: Compressing objects: 100% (11/11), done.

remote: Total 12 (delta 0), reused 0 (delta 0), pack-reused 0

Unpacking objects: 100% (12/12), done.

[root@git19c ~]# ls -lrt .
total 0
drwxr-xr-x. 4 root root 68 Oct  6 22:57 docker-oracle-ee-19c

./docker-oracle-ee-19c:

drwxr-xr-x. 2 root root 4096 Oct  6 22:57 install

-rw-r--r--. 1 root root  412 Oct  6 22:57 Dockerfile

-rw-r--r--. 1 root root   23 Oct  6 22:57 README.md

./docker-oracle-ee-19c/install:

total 2240

-rw-r--r--. 1 root root     627 Oct  6 22:57 oracle-19c-ee.rsp

-rw-r--r--. 1 root root    3549 Oct  6 22:57 oracle_19c_install.sh

-rw-r--r--. 1 root root    1201 Oct  6 22:57 post_install.sh

-rw-r--r--. 1 root root     495 Oct  6 22:57 tns.sh

-rw-r--r--. 1 root root 2267480 Oct  6 22:57 gosu

-rw-r--r--. 1 root root     441 Oct  6 22:57 netca.rsp

-rw-r--r--. 1 root root     486 Oct  6 22:57 dbca_19c.rsp

Review the oracle_19c_install.sh file and make appropriate changes to reflect your 
environment that you want to build; eg, OHome location and DBname, etc..
[root@git19c install]# more oracle_19c_install.sh

#!/bin/bash

set -e

export INSTALL=$HOME/docker-oracle-ee-19c/install

echo `hostname -I|awk '{print $1}'` `hostname -s` `hostname` >> /etc/hosts

echo "Installing Dependencies"

yum install -y wget unzip binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64 \

glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64 \

libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64 \

libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64 oracle-database-preinstall-19c && yum clean all

rm -rf /var/cache/yum

echo "Creating Directory"

rm -rf /u01

mkdir -p /u01 && mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 && chown -R oracle:oinstall /u01 && chmod -R 775 /u01

touch /etc/oratab

chmod 777 /etc/oratab

chmod 755 $INSTALL/post_install.sh

echo "Setting ENV"

echo oracle:oracle | chpasswd

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1

export ORACLE_SID=ORCL19 >> /home/oracle/.bash_profile

export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 >> /home/oracle/.bash_profile

export PATH=$ORACLE_HOME/bin:$PATH >> /home/oracle/.bash_profile

#Download oracle database zip

echo "Downloading oracle database zip"

wget -q --load-cookies /tmp/cookies.txt "https://docs.google.com/uc?export=download&confirm=$(wget --quiet --save-cookies /tmp/cookies.txt --keep-session-cookies --no-check-c

ertificate 'https://docs.google.com/uc?export=download&id=1QinowHmGgiOCdj-OO20qaTQGHfYN2u6M' -O- | sed -rn 's/.*confirm=([0-9A-Za-z_]+).*/\1\n/p')&id=1QinowHmGgiOCdj-OO20qaTQ

[root@git19c install]#  chmod u+x $HOME/docker-oracle-ee-19c/install/oracle_19c_install.sh

[root@git19c install]# sh oracle_19c_install.sh

Installing Dependencies

Loaded plugins: langpacks, ulninfo

ol7_UEKR5                                                                                                                                              | 2.8 kB  00:00:00     

ol7_addons                                                                                                                                             | 2.8 kB  00:00:00     

ol7_developer                                                                                                                                          | 2.8 kB  00:00:00     

ol7_developer_EPEL                                                                                                                                     | 3.4 kB  00:00:00     

ol7_ksplice                                                                                                                                            | 2.8 kB  00:00:00     

ol7_latest                                                                                                                                             | 3.4 kB  00:00:00     

ol7_oci_included                                                                                                                                       | 2.9 kB  00:00:00     

ol7_optional_latest                                                                                                                                    | 2.8 kB  00:00:00     

ol7_software_collections                                                                                                                               | 2.8 kB  00:00:00     

(1/19): ol7_addons/x86_64/updateinfo                                                                                                                   |  69 kB  00:00:00     

(2/19): ol7_UEKR5/x86_64/updateinfo                                                                                                                    |  13 kB  00:00:00     

(3/19): ol7_developer_EPEL/x86_64/group_gz                                                                                                             |  87 kB  00:00:00     

(4/19): ol7_developer/x86_64/primary_db                                                                                                                | 434 kB  00:00:00     

(5/19): ol7_addons/x86_64/primary_db                                                                                                                   | 129 kB  00:00:00     

(6/19): ol7_developer_EPEL/x86_64/updateinfo                                                                                                           | 4.9 kB  00:00:00     

(7/19): ol7_ksplice/primary_db                                                                                                                         | 187 kB  00:00:00     

(8/19): ol7_UEKR5/x86_64/primary_db                                                                                                                    | 2.5 MB  00:00:00     

(9/19): ol7_latest/x86_64/group_gz                                                                                                                     | 148 kB  00:00:00     

(10/19): ol7_developer/x86_64/updateinfo                                                                                                               |   71 B  00:00:00     

(11/19): ol7_latest/x86_64/updateinfo                                                                                                                  | 2.6 MB  00:00:00     

(12/19): ol7_developer_EPEL/x86_64/primary_db                                                                                                          |  11 MB  00:00:00     

(13/19): ol7_optional_latest/x86_64/updateinfo                                                                                                         | 853 kB  00:00:00     

(14/19): ol7_ksplice/updateinfo                                                                                                                        | 4.8 kB  00:00:00     

(15/19): ol7_oci_included/x86_64/primary_db                                                                                                            |  48 kB  00:00:00     

(16/19): ol7_latest/x86_64/primary_db                                                                                                                  |  15 MB  00:00:00     

(17/19): ol7_software_collections/x86_64/updateinfo                                                                                                    | 8.7 kB  00:00:00     

(18/19): ol7_optional_latest/x86_64/primary_db                                                                                                         | 4.0 MB  00:00:00     

(19/19): ol7_software_collections/x86_64/primary_db                                                                                                    | 4.7 MB  00:00:00     

Package wget-1.14-18.el7_6.1.x86_64 already installed and latest version

Package unzip-6.0-20.el7.x86_64 already installed and latest version

Package binutils-2.27-41.base.0.1.el7.x86_64 already installed and latest version

Package glibc-2.17-292.0.1.el7.x86_64 already installed and latest version

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

Package libgcc-4.8.5-39.0.1.el7.x86_64 already installed and latest version

Package libstdc++-4.8.5-39.0.1.el7.x86_64 already installed and latest version

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

Package sysstat-10.1.5-18.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

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

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

---> Package gcc.x86_64 0:4.8.5-39.0.1.el7 will be installed

--> Processing Dependency: cpp = 4.8.5-39.0.1.el7 for package: gcc-4.8.5-39.0.1.el7.x86_64

--> Processing Dependency: libmpfr.so.4()(64bit) for package: gcc-4.8.5-39.0.1.el7.x86_64

--> Processing Dependency: libmpc.so.3()(64bit) for package: gcc-4.8.5-39.0.1.el7.x86_64

---> Package gcc-c++.x86_64 0:4.8.5-39.0.1.el7 will be installed

---> Package glibc.i686 0:2.17-292.0.1.el7 will be installed

--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.17-292.0.1.el7.i686

--> Processing Dependency: libfreebl3.so for package: glibc-2.17-292.0.1.el7.i686

---> Package glibc-devel.i686 0:2.17-292.0.1.el7 will be installed

--> Processing Dependency: glibc-headers = 2.17-292.0.1.el7 for package: glibc-devel-2.17-292.0.1.el7.i686

--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-292.0.1.el7.i686

---> Package glibc-devel.x86_64 0:2.17-292.0.1.el7 will be installed

---> Package ksh.x86_64 0:20120801-139.0.1.el7 will be installed

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

--> Processing Dependency: libX11 >= 1.5.99.902 for package: libXi-1.7.9-1.el7.i686

--> Processing Dependency: libXext.so.6 for package: libXi-1.7.9-1.el7.i686

--> Processing Dependency: libX11.so.6 for package: libXi-1.7.9-1.el7.i686

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

--> Processing Dependency: libXext.so.6()(64bit) for package: libXi-1.7.9-1.el7.x86_64

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

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

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

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

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

---> Package libgcc.i686 0:4.8.5-39.0.1.el7 will be installed

---> Package libstdc++.i686 0:4.8.5-39.0.1.el7 will be installed

---> Package libstdc++-devel.i686 0:4.8.5-39.0.1.el7 will be installed

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

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

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

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

--> Processing Dependency: psmisc for package: oracle-database-preinstall-19c-1.0-1.el7.x86_64

--> Running transaction check

---> Package cpp.x86_64 0:4.8.5-39.0.1.el7 will be installed

---> Package glibc-headers.x86_64 0:2.17-292.0.1.el7 will be installed

--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-292.0.1.el7.x86_64

--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-292.0.1.el7.x86_64

---> Package libX11.i686 0:1.6.7-2.el7 will be installed

--> Processing Dependency: libX11-common >= 1.6.7-2.el7 for package: libX11-1.6.7-2.el7.i686

--> Processing Dependency: libxcb.so.1 for package: libX11-1.6.7-2.el7.i686

---> Package libX11.x86_64 0:1.6.7-2.el7 will be installed

--> Processing Dependency: libxcb.so.1()(64bit) for package: libX11-1.6.7-2.el7.x86_64

---> Package libXext.i686 0:1.3.3-3.el7 will be installed

---> Package libXext.x86_64 0:1.3.3-3.el7 will be installed

---> Package libmpc.x86_64 0:1.0.1-3.el7 will be installed

---> Package mpfr.x86_64 0:3.1.1-4.el7 will be installed

---> Package nss-softokn-freebl.i686 0:3.44.0-5.0.1.el7 will be installed

---> Package psmisc.x86_64 0:22.20-16.el7 will be installed

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

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

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

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

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

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

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

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

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

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

--> Processing Dependency: libXmuu.so.1()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64

--> Processing Dependency: libXau.so.6()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64

--> Running transaction check

---> Package kernel-headers.x86_64 0:3.10.0-1062.1.2.el7 will be installed

---> Package libX11-common.noarch 0:1.6.7-2.el7 will be installed

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

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

---> Package libXmu.x86_64 0:1.1.2-2.el7 will be installed

--> Processing Dependency: libXt.so.6()(64bit) for package: libXmu-1.1.2-2.el7.x86_64

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

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

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

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

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

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

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

---> Package libxcb.i686 0:1.13-1.el7 will be installed

--> Processing Dependency: libXau.so.6 for package: libxcb-1.13-1.el7.i686

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

--> Running transaction check

---> Package libXau.i686 0:1.0.8-2.1.el7 will be installed

---> Package libXt.x86_64 0:1.1.5-3.el7 will be installed

--> Processing Dependency: libSM.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64

--> Processing Dependency: libICE.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64

--> Running transaction check

---> Package libICE.x86_64 0:1.0.9-9.el7 will be installed

---> Package libSM.x86_64 0:1.2.2-2.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================================================
Package                                                Arch                           Version                                       Repository                          Size
=========================================================================================================================================================
Installing:
compat-libcap1                                         x86_64                         1.10-7.el7                                    ol7_latest                          17 k
compat-libstdc++-33                                    x86_64                         3.2.3-72.el7                                  ol7_latest                         190 k
gcc                                                    x86_64                         4.8.5-39.0.1.el7                              ol7_latest                          16 M
gcc-c++                                                x86_64                         4.8.5-39.0.1.el7                              ol7_latest                         7.2 M
glibc                                                  i686                           2.17-292.0.1.el7                              ol7_latest                         4.3 M
glibc-devel                                            i686                           2.17-292.0.1.el7                              ol7_latest                         1.1 M
glibc-devel                                            x86_64                         2.17-292.0.1.el7                              ol7_latest                         1.1 M
ksh                                                    x86_64                         20120801-139.0.1.el7                          ol7_latest                         883 k
libXi                                                  i686                           1.7.9-1.el7                                   ol7_latest                          40 k
libXi                                                  x86_64                         1.7.9-1.el7                                   ol7_latest                          40 k
libXtst                                                i686                           1.2.3-1.el7                                   ol7_latest                          20 k
libXtst                                                x86_64                         1.2.3-1.el7                                   ol7_latest                          20 k
libaio                                                 i686                           0.3.109-13.el7                                ol7_latest                          24 k
libaio-devel                                           i686                           0.3.109-13.el7                                ol7_latest                          12 k
libaio-devel                                           x86_64                         0.3.109-13.el7                                ol7_latest                          12 k
libgcc                                                 i686                           4.8.5-39.0.1.el7                              ol7_latest                         110 k
libstdc++                                              i686                           4.8.5-39.0.1.el7                              ol7_latest                         318 k
libstdc++-devel                                        i686                           4.8.5-39.0.1.el7                              ol7_latest                         1.5 M
libstdc++-devel                                        x86_64                         4.8.5-39.0.1.el7                              ol7_latest                         1.5 M

oracle-database-preinstall-19c                         x86_64                         1.0-1.el7                                     ol7_latest                          18 k

Installing for dependencies:

cpp                                                    x86_64                         4.8.5-39.0.1.el7                              ol7_latest                         6.0 M

glibc-headers                                          x86_64                         2.17-292.0.1.el7                              ol7_latest                         689 k

kernel-headers                                         x86_64                         3.10.0-1062.1.2.el7                           ol7_latest                         8.7 M

libICE                                                 x86_64                         1.0.9-9.el7                                   ol7_latest                          66 k

libSM                                                  x86_64                         1.2.2-2.el7                                   ol7_latest                          39 k

libX11                                                 i686                           1.6.7-2.el7                                   ol7_latest                         610 k

libX11                                                 x86_64                         1.6.7-2.el7                                   ol7_latest                         606 k

libX11-common                                          noarch                         1.6.7-2.el7                                   ol7_latest                         164 k

libXau                                                 i686                           1.0.8-2.1.el7                                 ol7_latest                          28 k

libXau                                                 x86_64                         1.0.8-2.1.el7                                 ol7_latest                          28 k

libXext                                                i686                           1.3.3-3.el7                                   ol7_latest                          38 k

libXext                                                x86_64                         1.3.3-3.el7                                   ol7_latest                          38 k

libXinerama                                            x86_64                         1.1.3-2.1.el7                                 ol7_latest                          13 k

libXmu                                                 x86_64                         1.1.2-2.el7                                   ol7_latest                          70 k

libXrandr                                              x86_64                         1.5.1-2.el7                                   ol7_latest                          27 k

libXrender                                             x86_64                         0.9.10-1.el7                                  ol7_latest                          25 k

libXt                                                  x86_64                         1.1.5-3.el7                                   ol7_latest                         172 k

libXv                                                  x86_64                         1.0.11-1.el7                                  ol7_latest                          18 k

libXxf86dga                                            x86_64                         1.1.4-2.1.el7                                 ol7_latest                          18 k

libXxf86misc                                           x86_64                         1.0.3-7.1.el7                                 ol7_latest                          19 k

libXxf86vm                                             x86_64                         1.1.4-1.el7                                   ol7_latest                          17 k

libdmx                                                 x86_64                         1.1.3-3.el7                                   ol7_latest                          15 k

libmpc                                                 x86_64                         1.0.1-3.el7                                   ol7_latest                          49 k

libxcb                                                 i686                           1.13-1.el7                                    ol7_latest                         229 k

libxcb                                                 x86_64                         1.13-1.el7                                    ol7_latest                         213 k

mpfr                                                   x86_64                         3.1.1-4.el7                                   ol7_latest                         198 k

nss-softokn-freebl                                     i686                           3.44.0-5.0.1.el7                              ol7_latest                         214 k

psmisc                                                 x86_64                         22.20-16.el7                                  ol7_latest                         141 k

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

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

Transaction Summary

=========================================================================================================================================================
Install  20 Packages (+30 Dependent packages)
Total download size: 53 M

Installed size: 121 M

Downloading packages:

(1/50): compat-libcap1-1.10-7.el7.x86_64.rpm                                                                                                           |  17 kB  00:00:00     

(2/50): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm                                                                                                    | 190 kB  00:00:00     

(3/50): cpp-4.8.5-39.0.1.el7.x86_64.rpm                                                                                                                | 6.0 MB  00:00:00     

(4/50): gcc-c++-4.8.5-39.0.1.el7.x86_64.rpm                                                                                                            | 7.2 MB  00:00:00     

(5/50): gcc-4.8.5-39.0.1.el7.x86_64.rpm                                                                                                                |  16 MB  00:00:00     

(6/50): glibc-2.17-292.0.1.el7.i686.rpm                                                                                                                | 4.3 MB  00:00:00     

(7/50): glibc-devel-2.17-292.0.1.el7.i686.rpm                                                                                                          | 1.1 MB  00:00:00     

(8/50): glibc-devel-2.17-292.0.1.el7.x86_64.rpm                                                                                                        | 1.1 MB  00:00:00     

(9/50): glibc-headers-2.17-292.0.1.el7.x86_64.rpm                                                                                                      | 689 kB  00:00:00     

(10/50): ksh-20120801-139.0.1.el7.x86_64.rpm                                                                                                           | 883 kB  00:00:00     

(11/50): libICE-1.0.9-9.el7.x86_64.rpm                                                                                                                 |  66 kB  00:00:00     

(12/50): libSM-1.2.2-2.el7.x86_64.rpm                                                                                                                  |  39 kB  00:00:00     

(13/50): libX11-1.6.7-2.el7.i686.rpm                                                                                                                   | 610 kB  00:00:00     

(14/50): libX11-1.6.7-2.el7.x86_64.rpm                                                                                                                 | 606 kB  00:00:00     

(15/50): libX11-common-1.6.7-2.el7.noarch.rpm                                                                                                          | 164 kB  00:00:00     

(16/50): libXau-1.0.8-2.1.el7.i686.rpm                                                                                                                 |  28 kB  00:00:00     

(17/50): libXau-1.0.8-2.1.el7.x86_64.rpm                                                                                                               |  28 kB  00:00:00     

(18/50): kernel-headers-3.10.0-1062.1.2.el7.x86_64.rpm                                                                                                 | 8.7 MB  00:00:00     

(19/50): libXext-1.3.3-3.el7.i686.rpm                                                                                                                  |  38 kB  00:00:00     

(20/50): libXext-1.3.3-3.el7.x86_64.rpm                                                                                                                |  38 kB  00:00:00     

(21/50): libXi-1.7.9-1.el7.i686.rpm                                                                                                                    |  40 kB  00:00:00     

(22/50): libXi-1.7.9-1.el7.x86_64.rpm                                                                                                                  |  40 kB  00:00:00     

(23/50): libXinerama-1.1.3-2.1.el7.x86_64.rpm                                                                                                          |  13 kB  00:00:00     

(24/50): libXmu-1.1.2-2.el7.x86_64.rpm                                                                                                                 |  70 kB  00:00:00     

(25/50): libXrandr-1.5.1-2.el7.x86_64.rpm                                                                                                              |  27 kB  00:00:00     

(26/50): libXrender-0.9.10-1.el7.x86_64.rpm                                                                                                            |  25 kB  00:00:00     

(27/50): libXt-1.1.5-3.el7.x86_64.rpm                                                                                                                  | 172 kB  00:00:00     

(28/50): libXtst-1.2.3-1.el7.i686.rpm                                                                                                                  |  20 kB  00:00:00     

(29/50): libXtst-1.2.3-1.el7.x86_64.rpm                                                                                                                |  20 kB  00:00:00     

(30/50): libXv-1.0.11-1.el7.x86_64.rpm                                                                                                                 |  18 kB  00:00:00     

(31/50): libXxf86dga-1.1.4-2.1.el7.x86_64.rpm                                                                                                          |  18 kB  00:00:00     

(32/50): libXxf86misc-1.0.3-7.1.el7.x86_64.rpm                                                                                                         |  19 kB  00:00:00     

(33/50): libXxf86vm-1.1.4-1.el7.x86_64.rpm                                                                                                             |  17 kB  00:00:00     

(34/50): libaio-0.3.109-13.el7.i686.rpm                                                                                                                |  24 kB  00:00:00     

(35/50): libaio-devel-0.3.109-13.el7.i686.rpm                                                                                                          |  12 kB  00:00:00     

(36/50): libaio-devel-0.3.109-13.el7.x86_64.rpm                                                                                                        |  12 kB  00:00:00     

(37/50): libdmx-1.1.3-3.el7.x86_64.rpm                                                                                                                 |  15 kB  00:00:00     

(38/50): libgcc-4.8.5-39.0.1.el7.i686.rpm                                                                                                              | 110 kB  00:00:00     

(39/50): libmpc-1.0.1-3.el7.x86_64.rpm                                                                                                                 |  49 kB  00:00:00     

(40/50): libstdc++-4.8.5-39.0.1.el7.i686.rpm                                                                                                           | 318 kB  00:00:00     

(41/50): libstdc++-devel-4.8.5-39.0.1.el7.i686.rpm                                                                                                     | 1.5 MB  00:00:00     

(42/50): libstdc++-devel-4.8.5-39.0.1.el7.x86_64.rpm                                                                                                   | 1.5 MB  00:00:00     

(43/50): libxcb-1.13-1.el7.i686.rpm                                                                                                                    | 229 kB  00:00:00     

(44/50): libxcb-1.13-1.el7.x86_64.rpm                                                                                                                  | 213 kB  00:00:00     

(45/50): mpfr-3.1.1-4.el7.x86_64.rpm                                                                                                                   | 198 kB  00:00:00     

(46/50): nss-softokn-freebl-3.44.0-5.0.1.el7.i686.rpm                                                                                                  | 214 kB  00:00:00     

(47/50): oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm                                                                                           |  18 kB  00:00:00     

(48/50): psmisc-22.20-16.el7.x86_64.rpm                                                                                                                | 141 kB  00:00:00     

(49/50): xorg-x11-utils-7.5-23.el7.x86_64.rpm                                                                                                          | 114 kB  00:00:00     

(50/50): xorg-x11-xauth-1.0.9-1.el7.x86_64.rpm                                                                                                         |  29 kB  00:00:00     

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

Total                                                                                                                                         133 MB/s |  53 MB  00:00:00     

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : libX11-common-1.6.7-2.el7.noarch                                                                                                                          1/50

  Installing : kernel-headers-3.10.0-1062.1.2.el7.x86_64                                                                                                                 2/50

  Installing : libaio-devel-0.3.109-13.el7.x86_64                                                                                                                        3/50

  Installing : libstdc++-devel-4.8.5-39.0.1.el7.x86_64                                                                                                                   4/50

  Installing : libgcc-4.8.5-39.0.1.el7.i686                                                                                                                              5/50

  Installing : glibc-2.17-292.0.1.el7.i686                                                                                                                               6/50

  Installing : nss-softokn-freebl-3.44.0-5.0.1.el7.i686                                                                                                                  7/50

  Installing : mpfr-3.1.1-4.el7.x86_64                                                                                                                                   8/50

  Installing : libmpc-1.0.1-3.el7.x86_64                                                                                                                                 9/50

  Installing : libICE-1.0.9-9.el7.x86_64                                                                                                                                10/50

  Installing : glibc-headers-2.17-292.0.1.el7.x86_64                                                                                                                    11/50

  Installing : glibc-devel-2.17-292.0.1.el7.x86_64                                                                                                                      12/50

  Installing : libXau-1.0.8-2.1.el7.x86_64                                                                                                                              13/50

  Installing : libxcb-1.13-1.el7.x86_64                                                                                                                                 14/50

  Installing : libX11-1.6.7-2.el7.x86_64                                                                                                                                15/50

  Installing : libXext-1.3.3-3.el7.x86_64                                                                                                                               16/50

  Installing : libXi-1.7.9-1.el7.x86_64                                                                                                                                 17/50

  Installing : libXrender-0.9.10-1.el7.x86_64                                                                                                                           18/50

  Installing : libXrandr-1.5.1-2.el7.x86_64                                                                                                                             19/50

  Installing : libXtst-1.2.3-1.el7.x86_64                                                                                                                               20/50

  Installing : libdmx-1.1.3-3.el7.x86_64                                                                                                                                21/50

  Installing : libXinerama-1.1.3-2.1.el7.x86_64                                                                                                                         22/50

  Installing : libXv-1.0.11-1.el7.x86_64                                                                                                                                23/50

  Installing : libXxf86vm-1.1.4-1.el7.x86_64                                                                                                                            24/50

  Installing : libXxf86misc-1.0.3-7.1.el7.x86_64                                                                                                                        25/50

  Installing : libXxf86dga-1.1.4-2.1.el7.x86_64                                                                                                                         26/50

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

  Installing : libSM-1.2.2-2.el7.x86_64                                                                                                                                 28/50

  Installing : libXt-1.1.5-3.el7.x86_64                                                                                                                                 29/50

  Installing : libXmu-1.1.2-2.el7.x86_64                                                                                                                                30/50

  Installing : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64                                                                                                                      31/50

  Installing : cpp-4.8.5-39.0.1.el7.x86_64                                                                                                                              32/50

  Installing : gcc-4.8.5-39.0.1.el7.x86_64                                                                                                                              33/50

  Installing : psmisc-22.20-16.el7.x86_64                                                                                                                               34/50

  Installing : compat-libcap1-1.10-7.el7.x86_64                                                                                                                         35/50

  Installing : ksh-20120801-139.0.1.el7.x86_64                                                                                                                          36/50

  Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64                                                                                                                  37/50

  Installing : libstdc++-4.8.5-39.0.1.el7.i686                                                                                                                          38/50

  Installing : libstdc++-devel-4.8.5-39.0.1.el7.i686                                                                                                                    39/50

  Installing : libaio-0.3.109-13.el7.i686                                                                                                                               40/50

  Installing : libaio-devel-0.3.109-13.el7.i686                                                                                                                         41/50

  Installing : libXau-1.0.8-2.1.el7.i686                                                                                                                                42/50

  Installing : oracle-database-preinstall-19c-1.0-1.el7.x86_64                                                                                                          43/50

  Installing : gcc-c++-4.8.5-39.0.1.el7.x86_64                                                                                                                          44/50

  Installing : glibc-devel-2.17-292.0.1.el7.i686                                                                                                                        45/50

  Installing : libxcb-1.13-1.el7.i686                                                                                                                                   46/50

  Installing : libX11-1.6.7-2.el7.i686                                                                                                                                  47/50

  Installing : libXext-1.3.3-3.el7.i686                                                                                                                                 48/50

  Installing : libXi-1.7.9-1.el7.i686                                                                                                                                   49/50

  Installing : libXtst-1.2.3-1.el7.i686                                                                                                                                 50/50

  Verifying  : libXext-1.3.3-3.el7.x86_64                                                                                                                                1/50

  Verifying  : libXi-1.7.9-1.el7.x86_64                                                                                                                                  2/50

  Verifying  : libdmx-1.1.3-3.el7.x86_64                                                                                                                                 3/50

  Verifying  : libICE-1.0.9-9.el7.x86_64                                                                                                                                 4/50

  Verifying  : libaio-devel-0.3.109-13.el7.i686                                                                                                                          5/50

  Verifying  : libXinerama-1.1.3-2.1.el7.x86_64                                                                                                                          6/50

  Verifying  : libXrender-0.9.10-1.el7.x86_64                                                                                                                            7/50

  Verifying  : libXv-1.0.11-1.el7.x86_64                                                                                                                                 8/50

  Verifying  : libXext-1.3.3-3.el7.i686                                                                                                                                  9/50

  Verifying  : cpp-4.8.5-39.0.1.el7.x86_64                                                                                                                              10/50

  Verifying  : libXxf86vm-1.1.4-1.el7.x86_64                                                                                                                            11/50

  Verifying  : libXt-1.1.5-3.el7.x86_64                                                                                                                                 12/50

  Verifying  : libstdc++-devel-4.8.5-39.0.1.el7.i686                                                                                                                    13/50

  Verifying  : libxcb-1.13-1.el7.i686                                                                                                                                   14/50

  Verifying  : libstdc++-devel-4.8.5-39.0.1.el7.x86_64                                                                                                                  15/50

  Verifying  : libXi-1.7.9-1.el7.i686                                                                                                                                   16/50

  Verifying  : glibc-devel-2.17-292.0.1.el7.x86_64                                                                                                                      17/50

  Verifying  : xorg-x11-utils-7.5-23.el7.x86_64                                                                                                                         18/50

  Verifying  : libXau-1.0.8-2.1.el7.i686                                                                                                                                19/50

  Verifying  : libXtst-1.2.3-1.el7.x86_64                                                                                                                               20/50

  Verifying  : oracle-database-preinstall-19c-1.0-1.el7.x86_64                                                                                                          21/50

  Verifying  : libaio-0.3.109-13.el7.i686                                                                                                                               22/50

  Verifying  : libX11-1.6.7-2.el7.i686                                                                                                                                  23/50

  Verifying  : libX11-1.6.7-2.el7.x86_64                                                                                                                                24/50

  Verifying  : libXxf86misc-1.0.3-7.1.el7.x86_64                                                                                                                        25/50

  Verifying  : psmisc-22.20-16.el7.x86_64                                                                                                                               26/50

  Verifying  : libX11-common-1.6.7-2.el7.noarch                                                                                                                         27/50

  Verifying  : libXtst-1.2.3-1.el7.i686                                                                                                                                 28/50

  Verifying  : libxcb-1.13-1.el7.x86_64                                                                                                                                 29/50

  Verifying  : glibc-headers-2.17-292.0.1.el7.x86_64                                                                                                                    30/50

  Verifying  : nss-softokn-freebl-3.44.0-5.0.1.el7.i686                                                                                                                 31/50

  Verifying  : compat-libcap1-1.10-7.el7.x86_64                                                                                                                         32/50

  Verifying  : glibc-devel-2.17-292.0.1.el7.i686                                                                                                                        33/50

  Verifying  : libaio-devel-0.3.109-13.el7.x86_64                                                                                                                       34/50

  Verifying  : libmpc-1.0.1-3.el7.x86_64                                                                                                                                35/50

  Verifying  : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64                                                                                                                      36/50

  Verifying  : glibc-2.17-292.0.1.el7.i686                                                                                                                              37/50

  Verifying  : ksh-20120801-139.0.1.el7.x86_64                                                                                                                          38/50

  Verifying  : gcc-c++-4.8.5-39.0.1.el7.x86_64                                                                                                                          39/50

  Verifying  : libstdc++-4.8.5-39.0.1.el7.i686                                                                                                                          40/50

  Verifying  : libSM-1.2.2-2.el7.x86_64                                                                                                                                 41/50

  Verifying  : libXxf86dga-1.1.4-2.1.el7.x86_64                                                                                                                         42/50

  Verifying  : mpfr-3.1.1-4.el7.x86_64                                                                                                                                  43/50

  Verifying  : compat-libstdc++-33-3.2.3-72.el7.x86_64                                                                                                                  44/50

  Verifying  : gcc-4.8.5-39.0.1.el7.x86_64                                                                                                                              45/50

  Verifying  : libXau-1.0.8-2.1.el7.x86_64                                                                                                                              46/50

  Verifying  : libXrandr-1.5.1-2.el7.x86_64                                                                                                                             47/50

  Verifying  : libgcc-4.8.5-39.0.1.el7.i686                                                                                                                             48/50

  Verifying  : kernel-headers-3.10.0-1062.1.2.el7.x86_64                                                                                                                49/50

  Verifying  : libXmu-1.1.2-2.el7.x86_64                                                                                                                                50/50

Installed:

  compat-libcap1.x86_64 0:1.10-7.el7  compat-libstdc++-33.x86_64 0:3.2.3-72.el7  gcc.x86_64 0:4.8.5-39.0.1.el7              gcc-c++.x86_64 0:4.8.5-39.0.1.el7                 

  glibc.i686 0:2.17-292.0.1.el7       glibc-devel.i686 0:2.17-292.0.1.el7        glibc-devel.x86_64 0:2.17-292.0.1.el7      ksh.x86_64 0:20120801-139.0.1.el7                 

  libXi.i686 0:1.7.9-1.el7            libXi.x86_64 0:1.7.9-1.el7                 libXtst.i686 0:1.2.3-1.el7                 libXtst.x86_64 0:1.2.3-1.el7                      

  libaio.i686 0:0.3.109-13.el7        libaio-devel.i686 0:0.3.109-13.el7         libaio-devel.x86_64 0:0.3.109-13.el7       libgcc.i686 0:4.8.5-39.0.1.el7                    

  libstdc++.i686 0:4.8.5-39.0.1.el7   libstdc++-devel.i686 0:4.8.5-39.0.1.el7    libstdc++-devel.x86_64 0:4.8.5-39.0.1.el7  oracle-database-preinstall-19c.x86_64 0:1.0-1.el7

Dependency Installed:

  cpp.x86_64 0:4.8.5-39.0.1.el7          glibc-headers.x86_64 0:2.17-292.0.1.el7     kernel-headers.x86_64 0:3.10.0-1062.1.2.el7     libICE.x86_64 0:1.0.9-9.el7            

  libSM.x86_64 0:1.2.2-2.el7             libX11.i686 0:1.6.7-2.el7                   libX11.x86_64 0:1.6.7-2.el7                     libX11-common.noarch 0:1.6.7-2.el7     

  libXau.i686 0:1.0.8-2.1.el7            libXau.x86_64 0:1.0.8-2.1.el7               libXext.i686 0:1.3.3-3.el7                      libXext.x86_64 0:1.3.3-3.el7           

  libXinerama.x86_64 0:1.1.3-2.1.el7     libXmu.x86_64 0:1.1.2-2.el7                 libXrandr.x86_64 0:1.5.1-2.el7                  libXrender.x86_64 0:0.9.10-1.el7       

  libXt.x86_64 0:1.1.5-3.el7             libXv.x86_64 0:1.0.11-1.el7                 libXxf86dga.x86_64 0:1.1.4-2.1.el7              libXxf86misc.x86_64 0:1.0.3-7.1.el7    

  libXxf86vm.x86_64 0:1.1.4-1.el7        libdmx.x86_64 0:1.1.3-3.el7                 libmpc.x86_64 0:1.0.1-3.el7                     libxcb.i686 0:1.13-1.el7               

  libxcb.x86_64 0:1.13-1.el7             mpfr.x86_64 0:3.1.1-4.el7                   nss-softokn-freebl.i686 0:3.44.0-5.0.1.el7      psmisc.x86_64 0:22.20-16.el7           

  xorg-x11-utils.x86_64 0:7.5-23.el7     xorg-x11-xauth.x86_64 1:1.0.9-1.el7        

Complete!

Loaded plugins: langpacks, ulninfo

Cleaning repos: ol7_UEKR5 ol7_addons ol7_developer ol7_developer_EPEL ol7_ksplice ol7_latest ol7_oci_included ol7_optional_latest ol7_software_collections

Creating Directory

Setting ENV

Downloading oracle database zip

Extracting oracle database zip

setting up Response files

Installing Oracle Binaries

Launching Oracle Database Setup Wizard...

The response file for this session can be found at:

/u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2019-10-06_11-16-39PM.rsp

You can find the log of this install session at:

/tmp/InstallActions2019-10-06_11-16-39PM/installActions2019-10-06_11-16-39PM.log

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

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

2. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

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

[git19c]

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

[git19c]

Successfully Setup Software.

Moved the install session logs to:

/u01/app/oraInventory/logs/InstallActions2019-10-06_11-16-39PM

Done

Last login: Sun Oct  6 23:16:39 GMT 2019 on pts/0

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

SQL*Plus: Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

Default 19c database install with PDB

Prepare for db operation

8% complete

Copying database files

31% complete

Creating and starting Oracle instance

32% complete

36% complete

40% complete

43% complete

46% complete

Completing Database Creation

51% complete

53% complete

54% complete

Creating Pluggable Databases

58% complete

77% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

/u01/app/oracle/cfgtoollogs/dbca/ORCL19.

Database Information:

Global Database Name:ORCL19

System Identifier(SID):ORCL19

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

Starting default listener

Parsing command line arguments:

    Parameter "silent" = true

    Parameter "responsefile" = /u01/app/oracle/product/19.0.0/dbhome_1/netca.rsp

Done parsing command line arguments.

Oracle Net Services Configuration:

Configuring Listener:LISTENER_ORCL19

Listener configuration complete.

Oracle Net Listener Startup:

    Running Listener Control:

      /u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl start LISTENER_ORCL19

    Listener Control complete.

    Listener started successfully.

Profile configuration complete.

Oracle Net Services configuration successful. The exit code is 0

Configuring the TNS

Testing Database

Last login: Sun Oct  6 23:33:31 GMT 2019 on pts/0

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 6 23:33:33 2019

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL>

System altered.

SQL>

NAME   OPEN_MODE

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

ORCL19   READ WRITE

SQL>

    CON_ID CON_NAME   OPEN MODE  RESTRICTED

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

2 PDB$SEED  READ ONLY  NO

3 PDB19C  READ WRITE NO

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

Cleaning up

DataBase Installed!!!

Database Name: ORCL19 with one pluggable database PDB19C has default password Welcome_1. Just switch to oracle user and login to database.

Oracle OCI CLI setup and basics

To be honest, this blog is really more for me, cause I cant seem to remeber how to setup OCI CLI each time I need.  So effectively this is a cheat-sheet, for me and anyone else who needs it to support Oracle CLI.  I will be doing a similiar post for AWS CLI.  Its was not meant to compare/contrast….so no wagering please.

Th main parts of this process is the following:

  1. Install CLI bits (ensure your want this python version).  Install of python3x is outside of this scope.  I have purposely kept all the details from the installation.  Its so well illustrated, its worth walking thru it.
  2. Configure for OCI tenancy (get tenancy, compartment details) including setting credentials
  3. Test oci cli commands

Note, this install is being done on OEL, but its pretty much the same on any plaform.

  1. First, we need to download/acquire the CLI bits.  We do this by running curl get:

bash -c "$(curl -L https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.sh)"
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 13968  100 13968    0     0  22391      0 --:--:-- --:--:-- --:--:-- 22384

    ******************************************************************************
    You have started the OCI CLI Installer in interactive mode. If you do not wish
    to run this in interactive mode, please include the --accept-all-defaults option.
    If you have the script locally and would like to know more about
    input options for this script, then you can run:
    ./install.sh -h
    If you would like to know more about input options for this script, refer to:
https://github.com/oracle/oci-cli/blob/master/scripts/install/README.rst
    ******************************************************************************
Downloading Oracle Cloud Infrastructure CLI install script from https://raw.githubusercontent.com/oracle/oci-cli/v2.5.15/scripts/install/install.py to /tmp/oci_cli_install_tmp_L7tU.
######################################################################## 100.0%
Python3 not found on system PATH
Running install script.
python /tmp/oci_cli_install_tmp_L7tU 
-- Verifying Python version.
-- Python version 2.7.5 okay.

===> In what directory would you like to place the install? (leave blank to use '/home/nitin/lib/oracle-cli'): 
-- Creating directory '/home/nitin/lib/oracle-cli'.
-- We will install at '/home/nitin/lib/oracle-cli'.

===> In what directory would you like to place the 'oci' executable? (leave blank to use '/home/nitin/bin'): 
-- Creating directory '/home/nitin/bin'.
-- The executable will be in '/home/nitin/bin'.

===> In what directory would you like to place the OCI scripts? (leave blank to use '/home/nitin/bin/oci-cli-scripts'): 
-- Creating directory '/home/nitin/bin/oci-cli-scripts'.
-- The scripts will be in '/home/nitin/bin/oci-cli-scripts'.

===> Currently supported optional packages are: ['db (will install cx_Oracle)']
What optional CLI packages would you like to be installed (comma separated names; press enter if you don't need any optional packages)?: 
-- The optional packages installed will be ''.
-- Downloading virtualenv package from https://github.com/pypa/virtualenv/archive/15.0.0.tar.gz.
-- Downloaded virtualenv package to /tmp/tmpq_dJj9/15.0.0.tar.gz.
-- Checksum of /tmp/tmpq_dJj9/15.0.0.tar.gz OK.
-- Extracting '/tmp/tmpq_dJj9/15.0.0.tar.gz' to '/tmp/tmpq_dJj9'.
-- Executing: ['/usr/bin/python', 'virtualenv.py', '--python', '/usr/bin/python', '/home/nitin/lib/oracle-cli']
Already using interpreter /usr/bin/python
New python executable in /home/nitin/lib/oracle-cli/bin/python
Installing setuptools, pip, wheel...done.
-- Executing: ['/home/nitin/lib/oracle-cli/bin/pip', 'install', '--cache-dir', '/tmp/tmpq_dJj9', 'oci_cli', '--upgrade']
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Collecting oci_cli
  Downloading https://files.pythonhosted.org/packages/46/b3/8aa896440efaa39c4d000c2e35a8dde6efa6c140dfc1e2df116d381d6c5d/oci_cli-2.5.15-py2.py3-none-any.whl (4.0MB)
     |████████████████████████████████| 4.0MB 3.2MB/s 
Collecting idna<2.7,>=2.5 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/27/cc/6dd9a3869f15c2edfab863b992838277279ce92663d334df9ecf5106f5c6/idna-2.6-py2.py3-none-any.whl (56kB)
     |████████████████████████████████| 61kB 14.8MB/s 
Collecting arrow==0.10.0 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/54/db/76459c4dd3561bbe682619a5c576ff30c42e37c2e01900ed30a501957150/arrow-0.10.0.tar.gz (86kB)
     |████████████████████████████████| 92kB 10.7MB/s 
Collecting jmespath==0.9.3 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/b7/31/05c8d001f7f87f0f07289a5fc0fc3832e9a57f2dbd4d3b0fee70e0d51365/jmespath-0.9.3-py2.py3-none-any.whl
Collecting configparser==3.5.0 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/7c/69/c2ce7e91c89dc073eb1aa74c0621c3eefbffe8216b3f9af9d3885265c01c/configparser-3.5.0.tar.gz
Collecting oci==2.2.14 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/da/5b/c56236eb269a95a6cdc055764d983d16c4f2ae9addceb696c5b534fe1b49/oci-2.2.14-py2.py3-none-any.whl (2.1MB)
     |████████████████████████████████| 2.1MB 9.9MB/s 
Collecting httpsig-cffi==15.0.0 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/93/f5/c9a213c0f906654c933f1192148d8aded2022678ad6bce8803d3300501c6/httpsig_cffi-15.0.0-py2.py3-none-any.whl
Collecting cryptography==2.4.2 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/7f/ba/383b51cc26e3141c689ce988814385c7659f5ba01c4b5f2de38233010b5f/cryptography-2.4.2-cp27-cp27mu-manylinux1_x86_64.whl (2.1MB)
     |████████████████████████████████| 2.1MB 6.0MB/s 
Collecting terminaltables==3.1.0 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/9b/c4/4a21174f32f8a7e1104798c445dacdc1d4df86f2f26722767034e4de4bff/terminaltables-3.1.0.tar.gz
Collecting click==6.7 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/34/c1/8806f99713ddb993c5366c362b2f908f18269f8d792aff1abfd700775a77/click-6.7-py2.py3-none-any.whl (71kB)
     |████████████████████████████████| 71kB 4.1MB/s 
Collecting retrying==1.3.3 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/44/ef/beae4b4ef80902f22e3af073397f079c96969c69b2c7d52a57ea9ae61c9d/retrying-1.3.3.tar.gz
Collecting pytz==2016.10 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/f5/fa/4a9aefc206aa49a4b5e0a72f013df1f471b4714cdbe6d78f0134feeeecdb/pytz-2016.10-py2.py3-none-any.whl (483kB)
     |████████████████████████████████| 491kB 10.8MB/s 
Collecting PyYAML==3.13 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/9e/a3/1d13970c3f36777c583f136c136f804d70f500168edc1edea6daa7200769/PyYAML-3.13.tar.gz (270kB)
     |████████████████████████████████| 276kB 11.1MB/s 
Collecting certifi (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/69/1b/b853c7a9d4f6a6d00749e94eb6f3a041e342a885b87340b79c1ef73e3a78/certifi-2019.6.16-py2.py3-none-any.whl (157kB)
     |████████████████████████████████| 163kB 13.0MB/s 
Collecting python-dateutil==2.7.3 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/cf/f5/af2b09c957ace60dcfac112b669c45c8c97e32f94aa8b56da4c6d1682825/python_dateutil-2.7.3-py2.py3-none-any.whl (211kB)
     |████████████████████████████████| 215kB 12.4MB/s 
Collecting pyOpenSSL==18.0.0 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/96/af/9d29e6bd40823061aea2e0574ccb2fcf72bfd6130ce53d32773ec375458c/pyOpenSSL-18.0.0-py2.py3-none-any.whl (53kB)
     |████████████████████████████████| 61kB 15.3MB/s 
Collecting six==1.11.0 (from oci_cli)
  Downloading https://files.pythonhosted.org/packages/67/4b/141a581104b1f6397bfa78ac9d43d8ad29a7ca43ea90a2d863fe3056e86a/six-1.11.0-py2.py3-none-any.whl
Collecting enum34; python_version < "3" (from cryptography==2.4.2->oci_cli)
  Downloading https://files.pythonhosted.org/packages/c5/db/e56e6b4bbac7c4a06de1c50de6fe1ef3810018ae11732a50f15f62c7d050/enum34-1.1.6-py2-none-any.whl
Collecting cffi!=1.11.3,>=1.7 (from cryptography==2.4.2->oci_cli)
  Downloading https://files.pythonhosted.org/packages/8d/e9/0c8afd1579e5cf7bc0f06fbcd7cdb954cbc0baadd505973949a99337da1c/cffi-1.12.3-cp27-cp27mu-manylinux1_x86_64.whl(415kB)
     |████████████████████████████████| 419kB 12.5MB/s 
Collecting asn1crypto>=0.21.0 (from cryptography==2.4.2->oci_cli)
  Downloading https://files.pythonhosted.org/packages/ea/cd/35485615f45f30a510576f1a56d1e0a7ad7bd8ab5ed7cdc600ef7cd06222/asn1crypto-0.24.0-py2.py3-none-any.whl (101kB)
     |████████████████████████████████| 102kB 10.9MB/s 
Collecting ipaddress; python_version < "3" (from cryptography==2.4.2->oci_cli)
  Downloading https://files.pythonhosted.org/packages/fc/d0/7fc3a811e011d4b388be48a0e381db8d990042df54aa4ef4599a31d39853/ipaddress-1.0.22-py2.py3-none-any.whl
Collecting pycparser (from cffi!=1.11.3,>=1.7->cryptography==2.4.2->oci_cli)
  Downloading https://files.pythonhosted.org/packages/68/9e/49196946aee219aead1290e00d1e7fdeab8567783e83e1b9ab5585e6206a/pycparser-2.19.tar.gz (158kB)
     |████████████████████████████████| 163kB 12.6MB/s 
Building wheels for collected packages: arrow, configparser, terminaltables, retrying, PyYAML, pycparser
  Building wheel for arrow (setup.py) ... done
  Stored in directory: /tmp/tmpq_dJj9/wheels/ce/4f/95/64541c7466fd88ffe72fda5164f8323c91d695c9a77072c574
  Building wheel for configparser (setup.py) ... done
  Stored in directory: /tmp/tmpq_dJj9/wheels/a3/61/79/424ef897a2f3b14684a7de5d89e8600b460b89663e6ce9d17c
  Building wheel for terminaltables (setup.py) ... done
  Stored in directory: /tmp/tmpq_dJj9/wheels/30/6b/50/6c75775b681fb36cdfac7f19799888ef9d8813aff9e379663e
  Building wheel for retrying (setup.py) ... done
  Stored in directory: /tmp/tmpq_dJj9/wheels/d7/a9/33/acc7b709e2a35caa7d4cae442f6fe6fbf2c43f80823d46460c
  Building wheel for PyYAML (setup.py) ... done
  Stored in directory: /tmp/tmpq_dJj9/wheels/ad/da/0c/74eb680767247273e2cf2723482cb9c924fe70af57c334513f
  Building wheel for pycparser (setup.py) ... done
  Stored in directory: /tmp/tmpq_dJj9/wheels/f2/9a/90/de94f8556265ddc9d9c8b271b0f63e57b26fb1d67a45564511
Successfully built arrow configparser terminaltables retrying PyYAML pycparser
Installing collected packages: idna, six, python-dateutil, arrow, jmespath, configparser, enum34, pycparser, cffi, asn1crypto, ipaddress, cryptography, pyOpenSSL, pytz, certifi, oci, httpsig-cffi, terminaltables, click, retrying, PyYAML, oci-cli
Successfully installed PyYAML-3.13 arrow-0.10.0 asn1crypto-0.24.0 certifi-2019.6.16 cffi-1.12.3 click-6.7 configparser-3.5.0 cryptography-2.4.2 enum34-1.1.6 httpsig-cffi-15.0.0 idna-2.6 ipaddress-1.0.22 jmespath-0.9.3 oci-2.2.14 oci-cli-2.5.15 pyOpenSSL-18.0.0 pycparser-2.19 python-dateutil-2.7.3 pytz-2016.10 retrying-1.3.3 six-1.11.0 terminaltables-3.1.0

===> Modify profile to update your $PATH and enable shell/tab completion now? (Y/n): Y

===> Enter a path to an rc file to update (leave blank to use '/home/nitin/.bashrc'): 
-- Backed up '/home/nitin/.bashrc' to '/home/nitin/.bashrc.backup'
-- Tab completion set up complete.
-- If tab completion is not activated, verify that '/home/nitin/.bashrc' is sourced by your shell.
-- 
-- ** Run `exec -l $SHELL` to restart your shell. **
-- 
-- Installation successful.
-- Run the CLI with /home/nitin/bin/oci --help
[nitin@cloudmac ~]$ 

 

2. Now lets configure our pem keys (private and public). We use openssl to gen our keys

[nitin@cloudmac ~]$ openssl genrsa -out ./nitin-oci-key.pem 2048
Generating RSA private key, 2048 bit long modulus
..................+++
.......+++
e is 65537 (0x10001)
[nitin@cloudmac ~]$ chmod go-rwx ./nitin-oci-key.pem 
 
[nitin@cloudmac ~]$ openssl rsa -pubout -in ./nitin-oci-key.pem  -out ./nitin-oci-key-pub.pem 
writing RSA key

[nitin@cloudmac ~]$ ls -ltr nitin-oci*
-rw-------. 1 nitin nitin 1679 Jun 19 13:12 nitin-oci-key.pem
-rw-rw-r--. 1 nitin nitin  451 Jun 19 13:14 nitin-oci-key-pub.pem

 

3. Configure the OCI configuration file.

a. Upload the PEM keys in the Users tab of the OCI Menu. After uploading you’ll see a Fingerprint tag associated with User

b, Use your UI to collect the following info USER OCID, Fingerprint, Tenancy OCID and Compartment OCID

c. Create a file called $HOME/.oci/configure

[DEFAULT]
# OCID info for Nitin
user=ocid1.user.oc1..aaaaaaaacugvqgd4c7ecym6phvvrkcoeqjnenjauva7njcqq7jui6qbdfeaq
fingerprint=70:23:4c:9b:14:c9:af:d4:dd:96:cc:65:4d:xx:xx:yy
key_file=/home/nitin/nitin-oci-key.pem
tenancy=ocid1.tenancy.oc1..aaaaaaaa3k7dq4u32duuege5of24ibxsh5d2dfxqo7lxxxxxxxxxx
region=us-ashburn-1

 

4. Now lets do a simple test to verify the credentials. One test will be to list the regions, the 2nd test will be to list the VCNs (if you have correct IAM role). Note, for illustration, I have shown output as displayed in tabular an JSON format

oci iam region list --output table
+-----+----------------+
| key | name           |
+-----+----------------+
| FRA | eu-frankfurt-1 |
| IAD | us-ashburn-1   |
| ICN | ap-seoul-1     |
| LHR | uk-london-1    |
| NRT | ap-tokyo-1     |
| PHX | us-phoenix-1   |
| YYZ | ca-toronto-1   |
+-----+----------------+

oci network vcn list --compartment-id ocid1.compartment.oc1..aaaaaaaadwopyqsoqdtsv5ykghdje7f6nvk5moxdo7xxxxxxxxxx
{
  "data": [
    {
      "cidr-block": "10.224.32.0/19", 
      "compartment-id": "ocid1.compartment.oc1..aaaaaaaadwopyqsoqdtsv5ykghdje7f6nvk5moxdo7xxxxxxxxx", 
      "default-dhcp-options-id": "ocid1.dhcpoptions.oc1.iad.aaaaaaaa6xiy26rweb2ydcjp4lqsvk7zkpuhglyakjpnhdfuhvvjjpjtd4aq", 
      "default-route-table-id": "ocid1.routetable.oc1.iad.aaaaaaaa6mzxjyh3yszohnz2kn7sfsy6ykpvvlgn5a3c5mf3ki3l4ycqzgka", 
      "default-security-list-id": "ocid1.securitylist.oc1.iad.aaaaaaaaun4berdcdxlrg4mg6veoqdvwdzz3p6zbldets76y6otxmlxn3o3a", 
      "defined-tags": {}, 
      "display-name": "ASH-Exadata", 
      "dns-label": "ashexadata", 
      "freeform-tags": {}, 
      "id": "ocid1.vcn.oc1.iad.aaaaaaaahe7kvbrqla25w27id5szra7j6oda2aelfbwt5w67x3c655bvsntq", 
      "lifecycle-state": "AVAILABLE", 
      "time-created": "2018-01-29T19:55:54.760000+00:00", 
      "vcn-domain-name": "ashexadata.oraclevcn.com"
    }
  ]
}

Here's a quick example of query and retreiving information from OCI. 
In this example I'm gonna pull all database versions available to me for creating.  The second example polls with the db-system-shape

[nitin@cloudmac ~]$ oci db version list -c $COMPID --db-system-shape "VM.Standard1.1" --all --output table
+-----------------------------+--------------+-----------------+
| is-latest-for-major-version | supports-pdb | version         |
+-----------------------------+--------------+-----------------+
| True                        | False        | 11.2.0.4        |
| False                       | False        | 11.2.0.4.181016 |
| False                       | False        | 11.2.0.4.190115 |
| False                       | False        | 11.2.0.4.190416 |
| True                        | True         | 12.1.0.2        |
| False                       | True         | 12.1.0.2.181016 |
| False                       | True         | 12.1.0.2.190115 |
| False                       | True         | 12.1.0.2.190416 |
| True                        | True         | 12.2.0.1        |
| False                       | True         | 12.2.0.1.181016 |
| False                       | True         | 12.2.0.1.190115 |
| False                       | True         | 12.2.0.1.190416 |
| True                        | True         | 18.0.0.0        |
| False                       | True         | 18.4.0.0        |
| False                       | True         | 18.5.0.0        |
| False                       | True         | 18.6.0.0        |
+-----------------------------+--------------+-----------------+

[nitin@cloudmac ~]$ oci db version list -c $COMPID  --all --output table
+-----------------------------+--------------+----------+
| is-latest-for-major-version | supports-pdb | version  |
+-----------------------------+--------------+----------+
| True                        | False        | 11.2.0.4 |
| True                        | True         | 12.1.0.2 |
| True                        | True         | 12.2.0.1 |
| True                        | True         | 18.0.0.0 |
+-----------------------------+--------------+----------+

In the next Blog post, I'll work through an entire DB creation 

DbaaS/ExaCS filesystem filing up with KRB tracing

KRB tracing and background

On our Exadata Cloud Service system running 18c GI and DB, we have been running into issues with /u02 filesystem filling up.  This was primarily imposed and generated by one component – RMAN.  As it turns out we had just enabled ExaCS automated backups via the tooling (bkup_api) .

Firstly, krb.c code refers to RMAN code layer, and tracing is generally produced when user specifies krbitrc via the event tracing.  Note this is not the same as rman debugging ( debug=all).

Starting in DB 18.3 , the event tracing is generating tracing regardless of event being set or not, and worse, its gen’ing trace files for every command.  This why the the /u02 is getting filled up

Here’s a sample of the trace data:

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165134 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165134

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165135 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165135

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165136 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165136

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165137 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165137

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165138 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165138

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165139 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165139

2019-06-02 18:17:16.933*:KRB:krbr.c@15486:krbr2b1(): ; f->krfil_krbrf=0 op1=2 lbno=1165140 f->seq_krbrf=11981

2019-06-02 18:17:16.933*:KRB:krbr.c@15908:krbr9b2(): Entering; f->seq_krbrf=11981 f->thread_krbrf=2 bno=1165140

And

…………

Redo thread mounted by this instance: 1

Oracle process number: 284

Unix process pid: 8448, image: oracle@***** (TNS V1-V3)

*** 2019-06-02T19:00:03.444793+00:00 (CDB$ROOT(1))

*** SESSION ID:(1723.45910) 2019-06-19T19:00:03.444828+00:00

*** CLIENT ID:() 2019-06-02T19:00:03.444835+00:00

*** SERVICE NAME:(SYS$USERS) 2019-06-02T19:00:03.444841+00:00

*** MODULE NAME:(rman@***** (TNS V1-V3)) 2019-06-02T19:00:03.444848+00:00

*** ACTION NAME:() 2019-06-02T19:00:03.444855+00:00

*** CLIENT DRIVER:() 2019-06-02T19:00:03.444861+00:00

*** CONTAINER ID:(1) 2019-06-02T19:00:03.444868+00:00

2019-06-02 19:00:03.444*:KRB:krbi.c@8857:krbitrc(): Got krbitrc

2019-06-02 19:00:03.444*:KRB:krbi.c@8887:krbiwtrc(): (bkrsmain - Action is NULL)

*** ACTION NAME:(0000001 STARTED70) 2019-06-02T19:00:03.444998+00:00

2019-06-02 19:00:03.444*:KRB:krbi.c@8887:krbiwtrc(): (icdstart - Action set to 0000001 STARTED70)

*** ACTION NAME:(0000001 FINISHED70) 2019-06-02T19:00:03.445209+00:00

2019-06-02 19:00:03.445*:KRB:krbi.c@8887:krbiwtrc(): (icdfinish - Action set to 0000001 FINISHED70)

Doc ID 28390273.8 mentions that the fix is included in “18.4.0.0.181016 (Oct 2018) Database Release Update (DB RU)” but issue is still seen in latest RU.

You can either wait for the fix, or manually disable kbr tracing.

To fix this issue permanently set below parameter at DB level

if using spfile

Alter system set events ‘trace[krb.*] disk disable, memory disable’;  

If using pfile

event=’trace[krb.*] disk disable, memory disable’

MOS Note – Excessive MMON, KRB Traces Causing Trace File Location (/u01) Overflow in DBaaS (Doc ID 2442656.1) does a decent job describing this issue

Part Deux – Diggin’ into ODA ASM Add Disk to DiskGroup operation

This is part 2 of the storage expansion of ODA.   If you remember from Part1, we added a whole disk shelf and we walked thru the ASM alert.log to show how the storage gets added to the diskgroup.  In this blog post, I’m just going to illustrate the process flow of the disk addition as it looks thru the eyes of the oakd.log.  But rather than show the entire 20 disks being added (which would be voluminous), I’m going to describe the  addition of a specific disk, Slot 14.

When the disk is physically added into the slot (after taking out the filler), this disk insertion will invoke a series of backend automated scripts/tooling that will start with the OS creating a disk device entry via the event handler and end with the disk being added to ASM diskgroup.

The key point of this blog and discussion is to describe the entire end-2-end automation process of simply adding a new disk to an ODA engineered system (“dare I say push button approach”).

BTW, Still LOVE the references to COMET in the code 🙂

We start with the look inside oakd.log, where majority of the action is.

In this first section from the oak log, once the disk insertion is recognized,  oakd describes the disk characteristics; including capacity , hba port and state.  Note, since multipathing is enabled we will see 2paths, and thus 2 disk names for the same [root] slot device name :

2019-02-05 10:55:35.510: [   STMHW][710730400] Sha::Inserting OSDevName /dev/sdr for slot 14.  <— SDR

2019-02-05 10:55:35.510: [   STMHW][710730400] Sha::Inserting OSDevName /dev/sdao for slot 14. <— SDAO

2019-02-05 10:55:35.510: [   STMHW][710730400] Physical Disk [14] Info:  <--Next set includes physical disk info

2019-02-05 10:55:35.510: [   STMHW][710730400] Slot Num    = 14

2019-02-05 10:55:35.510: [   STMHW][710730400] Col  Num    = 2

2019-02-05 10:55:35.510: [   STMHW][710730400] OsDevNames  = |/dev/sdao||/dev/sdr|

2019-02-05 10:55:35.510: [   STMHW][710730400] Serial Num  = 1839J5XJ9X

2019-02-05 10:55:35.510: [   STMHW][710730400] Disk Type   = SSD  <--Well we know its an SSD

2019-02-05 10:55:35.510: [   STMHW][710730400] Expander    = 0 : 508002000231a17e

2019-02-05 10:55:35.510: [   STMHW][710730400] scsi-id     = 5000cca0a101ac54

2019-02-05 10:55:35.510: [   STMHW][710730400] sectors     = 781404246

2019-02-05 10:55:35.510: [   STMHW][710730400] OsDisk[14] Info:  <--This next listing details the device info

2019-02-05 10:55:35.510: [   STMHW][710730400] OsDevName: /dev/sdr, Id = 14, Slot = 14, Capacity = 3200631791616: 3200gb, Type = SSD, hba port = 14 State = State: GOOD, expWwn = 5080020002311fbe, scsiId = 5000cca0a101ac54, Ctrlr = 0

2019-02-05 10:55:35.510: [   STMHW][710730400] OsDisk[38] Info:   <--Since we have multipathing, we will get same info for /dev/sdao

2019-02-05 10:55:35.510: [   STMHW][710730400] OsDevName: /dev/sdao, Id = 38, Slot = 14, Capacity = 3200631791616: 3200gb, Type = SSD, hba port = 14 State = State: GOOD, expWwn = 508002000231a17e, scsiId = 5000cca0a101ac54, Ctrlr = 1

This section from the oak log, describes the disk details from  PDiskAdapter.scr action script and FishWrap . Note the Autodiscovery hint, as the disk is partitioned for the different diskgroups:

2019-02-05 10:55:35.946: [   STMHW][150968064]{1:11302:2} Sha::Inserting OSDevName /dev/sdr for slot 14 2019-02-05 10:55:35.946: [   STMHW][150968064]{1:11302:2} Sha::Inserting OSDevName /dev/sdao for slot 14 2019-02-05 10:55:35.946: [ ADAPTER][150968064]{1:11302:2} Running predictive failure check for: /dev/sdao 2019-02-05 10:55:35.946: [    SCSI][150968064]{1:11302:2} SCSI Inquiry Command response for /dev/sdao 2019-02-05 10:55:35.946: [   OAKFW][167753472]{1:11302:2} [ActionScript] = /opt/oracle/oak/adapters/PDiskAdapter.scr 2019-02-05 10:55:35.946: [    SCSI][150968064]{1:11302:2} Vendor = HGST     Product = HBCAC2DH2SUN3.2T Revision = A170 2019-02-05 10:55:35.946: [   OAKFW][167753472]{1:11302:2} [ActionTimeout] = 1500 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [ActivePath] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [AgentFile] = %COMET_MS_HOME%/bin/%TYPE_NAME% 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [AsmDiskList] = |0| 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [AutoDiscovery] = 1 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [AutoDiscoveryHint] = |data:80:SSD||reco:20:SSD||redo:100:SSD| 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [CheckInterval] = 600 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [ColNum] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [DiskId] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [DiskType] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [Enabled] = 1 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [ExpNum] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [MultiPathList] = |0| 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [Name] = PDType 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [NewPartAddr] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [OSUserType] = |userType:Multiuser| 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [PlatformName] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [PrevUsrDevName] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [SectorSize] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [SerialNum] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [Size] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [SlotNum] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [TotalSectors] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [UsrDevName] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [gid] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [mode] = 660 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [uid] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [DependListOpr] = add 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [Dependency] = |0| 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [IState] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [Initialized] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [IsConfigDependency] = false 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [MonitorFlag] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [Name] = ResourceDef 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [PrevState] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [State] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [StateChangeTs] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [StateDetails] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} [TypeName] = 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} Added new resource : e0_pd_11 to the agfw 2019-02-05 10:55:35.947: [   OAKFW][167753472][F-ALGO]{1:11302:2} Resource name : e0_pd_11, state : 0 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} PE invalidating the data model 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} Evaluating Add Resource for e0_pd_11 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} Executing plan size: 1 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} PE: Sending message to agent : RESOURCE_VALIDATE[e0_pd_11] ID 4361:96 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} Engine received the message : RESOURCE_VALIDATE[e0_pd_09] ID 4361:90 2019-02-05 10:55:35.947: [   OAKFW][167753472]{1:11302:2} Preparing VALIDATE command for : e0_pd_09 2019-02-05 10:55:35.948: [   STMHW][150968064]{1:11302:2} Sha::Inserting OSDevName /dev/sdr for slot 14 2019-02-05 10:55:35.948: [   STMHW][150968064]{1:11302:2} Sha::Inserting OSDevName /dev/sdao for slot 14 2019-02-05 10:55:35.948: [ ADAPTER][150968064]{1:11302:2} Creating resource for PD: SSD_E0_S14_2701241428 2019-02-05 10:55:35.948: [ ADAPTER][150968064]{1:11302:2} partName datapctStr  80 diskType =SSD This section from the oak log, describes the disk validation 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] print_args called with argument : validate 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] Arguments passed to PDiskAdapter: 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] ResName = e0_pd_14 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] DiskId = 35000cca0a101ac54 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] DevName = SSD_E0_S14_2701241428 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] MultiPaths = /dev/sdao /dev/sdr 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] ActivePath = /dev/sdao 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] DiskType = SSD 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] Expander = 0 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] Size = 3200631791616 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] Sectors = 781404246 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] ExpColNum = 2 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] NewPartAddr = 0 2019-02-05 10:55:36.015: [        ][4177499904]{1:11302:2} [validate] DiskSerial# = 1839J5XJ9X 2019-02-05 10:55:36.023: [        ][4085245696]{1:11302:2} [validate] [Tue Feb 5 10:55:35 EST 2019] Action script '/opt/oracle/oak/adapters/PDiskAdapter.scr' for resource [e0_pd_15] called for action validate

This section from the oak log, we see the Linux kernel changes once the device entry is created; eg, IO scheduler, queue  depth, property values

2019-02-05 10:55:36.166: [        ][4177499904]{1:11302:2} [validate] Running echo deadline > /sys/block/sdao/queue/scheduler;echo 4096 > /sys/block/sdao/queue/nr_requests;echo 128 > /sys/block/sdao/queue/read_ahead_kb;

2019-02-05 10:55:36.166: [        ][4177499904]{1:11302:2} [validate] Running echo deadline > /sys/block/sdr/queue/scheduler;echo 4096 > /sys/block/sdr/queue/nr_requests;echo 128 > /sys/block/sdr/queue/read_ahead_kb;

2019-02-05 10:55:36.166: [        ][4177499904]{1:11302:2} [validate] Running echo 64 > /sys/block/sdao/device/queue_depth

2019-02-05 10:55:36.166: [        ][4177499904]{1:11302:2} [validate] Running echo 64 > /sys/block/sdr/device/queue_depth

2019-02-05 10:55:36.166: [        ][4177499904]{1:11302:2} [validate] Running echo 30 > /sys/block/sdao/device/timeout

2019-02-05 10:55:36.166: [        ][4177499904]{1:11302:2} [validate] Running echo 30 > /sys/block/sdr/device/timeout

2019-02-05 10:55:36.166: [   OAKFW][4177499904]{1:11302:2} Command : validate for: e0_pd_14 completed with status: SUCCESS

2019-02-05 10:55:36.166: [   OAKFW][167753472][F-ALGO]{1:11302:2} Engine received reply for command : validate for: e0_pd_14

2019-02-05 10:55:36.166: [   OAKFW][167753472]{1:11302:2} PE: Received last reply for : RESOURCE_VALIDATE[e0_pd_14] ID 4361:107

This section from the oak log, validates the state and complete insertion

2019-02-05 10:55:51.997: [   STMHW][4177499904]{1:11302:2} getState : 1

2019-02-05 10:55:51.997: [        ][4177499904]{1:11302:2} [check] Validating disk header for : SSD_E0_S14_2701241428

2019-02-05 10:55:51.997: [ ADAPTER][4177499904]{1:11302:2} Succefully opened the device: /dev/sdao

2019-02-05 10:55:51.997: [ ADAPTER][4177499904]{1:11302:2} Diskheader.Read: devName = /dev/sdao, master_inc = 0, m_slave_inc = 0, disk_status = 0 disk_inc = 0, slot_num= 0, serial num =  chassis snum =   part_loaded_cnt=0

2019-02-05 10:55:52.608: [   STMHW][4177499904]{1:11302:2} getState : 1

2019-02-05 10:55:52.608: [   STMHW][4177499904]{1:11302:2} State has been changed for: /dev/sdr Old State: GOOD, New State: INSERTED

2019-02-05 10:55:52.608: [   STMHW][4177499904]{1:11302:2} State has been changed for: /dev/sdao Old State: GOOD, New State: INSERTED

2019-02-05 10:55:52.608: [        ][4177499904]{1:11302:2} [check] Found the disk in uninitialized state.

2019-02-05 10:55:52.608: [   STMHW][4177499904]{1:11302:2} getState : 1

2019-02-05 10:55:52.608: [        ][4177499904]{1:11302:2} [check] Running ssd wear level check for: /dev/sdao

2019-02-05 10:55:52.609: [    SCSI][4177499904]{1:11302:2} SSD Media used endurance indicator: 0%

2019-02-05 10:55:52.609: [   STMHW][4177499904]{1:11302:2} Sha::Inserting OSDevName /dev/sdr for slot 14

2019-02-05 10:55:52.609: [   STMHW][4177499904]{1:11302:2} Sha::Inserting OSDevName /dev/sdao for slot 14

2019-02-05 10:55:52.609: [        ][4177499904]{1:11302:2} [check] Disk State: 1,  Label: NewDiskInserted

2019-02-05 10:55:53.856: [   STMHW][4085245696]{1:11302:2} getState : 1

2019-02-05 10:55:53.856: [   STMHW][4085245696]{1:11302:2} State has been changed for: /dev/sdr Old State: INSERTED, New State: GOOD

2019-02-05 10:55:53.856: [   STMHW][4085245696]{1:11302:2} State has been changed for: /dev/sdao Old State: INSERTED, New State: GOOD

2019-02-05 10:55:53.856: [        ][4085245696]{1:11302:2} [check] Validating disk header for : SSD_E0_S14_2701241428

2019-02-05 10:55:53.856: [ ADAPTER][4085245696]{1:11302:2} Succefully opened the device: /dev/sdao

2019-02-05 10:55:53.856: [ ADAPTER][4085245696]{1:11302:2} Diskheader.Read: devName = /dev/sdao, master_inc = 0, m_slave_inc = 0, disk_status = 0 disk_inc = 0, slot_num= 0, serial num =  chassis snum =   part_loaded_cnt=0

Finally if you jump over to the ASM alert.log you’ll see that the disks get added to the respective ASM diskgroup:

SQL> alter diskgroup /*+ _OAK_AsmCookie */ data add disk
'AFD:SSD_E0_S08_2701228196P1' name SSD_E0_S08_2701228196p1,
'AFD:SSD_E0_S07_2701240428P1' name SSD_E0_S07_2701240428p1,
'AFD:SSD_E0_S14_2701241428P1' name SSD_E0_S14_2701241428p1,  <-- here's our dude !!
'AFD:SSD_E0_S17_2701244644P1' name SSD_E0_S17_2701244644p1,
'AFD:SSD_E0_S19_2701246564P1' name SSD_E0_S19_2701246564p1,
'AFD:SSD_E0_S09_2701252584P1' name SSD_E0_S09_2701252584p1,
'AFD:SSD_E0_S13_2701254148P1' name SSD_E0_S13_2701254148p1,
'AFD:SSD_E0_S16_2701255896P1' name SSD_E0_S16_2701255896p1,
'AFD:SSD_E0_S05_2701256380P1' name SSD_E0_S05_2701256380p1,
'AFD:SSD_E0_S11_2701257468P1' name SSD_E0_S11_2701257468p1,
'AFD:SSD_E0_S15_2701258144P1' name SSD_E0_S15_2701258144p1,
'AFD:SSD_E0_S06_2701258544P1' name SSD_E0_S06_2701258544p1,
'AFD:SSD_E0_S12_2701258588P1' name SSD_E0_S12_2701258588p1,
'AFD:SSD_E0_S10_2701259504P1' name SSD_E0_S10_2701259504p1,
'AFD:SSD_E0_S18_2701260436P1' name SSD_E0_S18_2701260436p1
kfdp_query: callcnt 338 grp 1 (DATA)
kfdp_query: callcnt 339 grp 1 (DATA)
NOTE: Assigning number (1,5) to disk (AFD:SSD_E0_S08_2701228196P1)
Disk 0x777d6080 (1:5:AFD:SSD_E0_S08_2701228196P1) is being named (SSD_E0_S08_2701228196P1)
NOTE: Assigning number (1,6) to disk (AFD:SSD_E0_S07_2701240428P1)
Disk 0x777d5708 (1:6:AFD:SSD_E0_S07_2701240428P1) is being named (SSD_E0_S07_2701240428P1)
NOTE: Assigning number (1,7) to disk (AFD:SSD_E0_S14_2701241428P1)
Disk 0x777d9950 (1:7:AFD:SSD_E0_S14_2701241428P1) is being named (SSD_E0_S14_2701241428P1)
NOTE: Assigning number (1,8) to disk (AFD:SSD_E0_S17_2701244644P1)
Disk 0x777db5b8 (1:8:AFD:SSD_E0_S17_2701244644P1) is being named (SSD_E0_S17_2701244644P1)
NOTE: Assigning number (1,9) to disk (AFD:SSD_E0_S19_2701246564P1)
Disk 0x777dc8a8 (1:9:AFD:SSD_E0_S19_2701246564P1) is being named (SSD_E0_S19_2701246564P1)
NOTE: Assigning number (1,10) to disk (AFD:SSD_E0_S09_2701252584P1)
Disk 0x777d69f8 (1:10:AFD:SSD_E0_S09_2701252584P1) is being named (SSD_E0_S09_2701252584P1)
NOTE: Assigning number (1,11) to disk (AFD:SSD_E0_S13_2701254148P1)
Disk 0x777d8fd8 (1:11:AFD:SSD_E0_S13_2701254148P1) is being named (SSD_E0_S13_2701254148P1)
NOTE: Assigning number (1,12) to disk (AFD:SSD_E0_S16_2701255896P1)
Disk 0x777dac40 (1:12:AFD:SSD_E0_S16_2701255896P1) is being named (SSD_E0_S16_2701255896P1)
NOTE: Assigning number (1,13) to disk (AFD:SSD_E0_S05_2701256380P1)
Disk 0x777d4418 (1:13:AFD:SSD_E0_S05_2701256380P1) is being named (SSD_E0_S05_2701256380P1)
NOTE: Assigning number (1,14) to disk (AFD:SSD_E0_S11_2701257468P1)
Disk 0x777d7ce8 (1:14:AFD:SSD_E0_S11_2701257468P1) is being named (SSD_E0_S11_2701257468P1)
NOTE: Assigning number (1,15) to disk (AFD:SSD_E0_S15_2701258144P1)
Disk 0x777da2c8 (1:15:AFD:SSD_E0_S15_2701258144P1) is being named (SSD_E0_S15_2701258144P1)
NOTE: Assigning number (1,16) to disk (AFD:SSD_E0_S06_2701258544P1)
Disk 0x777d4d90 (1:16:AFD:SSD_E0_S06_2701258544P1) is being named (SSD_E0_S06_2701258544P1)
NOTE: Assigning number (1,17) to disk (AFD:SSD_E0_S12_2701258588P1)
Disk 0x777d8660 (1:17:AFD:SSD_E0_S12_2701258588P1) is being named (SSD_E0_S12_2701258588P1)
NOTE: Assigning number (1,18) to disk (AFD:SSD_E0_S10_2701259504P1)
Disk 0x777d7370 (1:18:AFD:SSD_E0_S10_2701259504P1) is being named (SSD_E0_S10_2701259504P1)
NOTE: Assigning number (1,19) to disk (AFD:SSD_E0_S18_2701260436P1)
Disk 0x777dbf30 (1:19:AFD:SSD_E0_S18_2701260436P1) is being named (SSD_E0_S18_2701260436P1)
2019-02-15 16:56:32.926*:kgfm.c@547: kgfmInitialize

Exadata Cloud – Post Provisioning Exadata Configuration – Part 1

Post Provisioning Exadata Configuration – Part1

After an Exadata is provisioned, ther are several post provisioning steps that need to be executed in order to allow system automation such as patching, backups, and infrastructure updates. This document will describe these steps.

All the traffic in an Exadata DB System is, by default, routed through the client network. To route backup traffic to the backup interface (BONDETH1), a static route needs to be created on each of the compute nodes in the cluster.

First identify the gateway configured for the BONDETH1 interface.

grep GATEWAY /etc/sysconfig/network-scripts/ifcfg-bondeth1 |awk -F”=” ‘{print $2}’

10.232.35.1

Review current /etc/sysconfig/network-scripts/route-bondeth1

cat /etc/sysconfig/network-scripts/route-bondeth1

10.232.35.0/24 dev bondeth1 table 211

default via 10.232.35.1 dev bondeth1 table 211

Create a new static rule for BONDETH1 and update route-bondeth1 with the following entries (per Cloud region)

Phoenix (PHX) region:

ADDRESS0=129.146.0.0

NETMASK0=255.255.0.0

GATEWAY0=10.232.35.1

 Ashburn (IAD) region):

ADDRESS0=129.213.0.0

NETMASK0=255.255.0.0

GATEWAY0=10.232.35.1

Restart the interface.

[root@dbsys ~]# ifdown bondeth1; ifup bondeth1; 


Once this change is done, you should see a new entry in the route table:

[root@~ network-scripts]# netstat -rn

Kernel IP routing table

Destination     Gateway         Genmask         Flags   MSS Window  irtt Iface

0.0.0.0         10.232.34.1     0.0.0.0         UG        0 0          0 bondeth0

10.232.34.0     0.0.0.0         255.255.255.0   U         0 0          0 bondeth0

10.232.35.0     0.0.0.0         255.255.255.0   U         0 0          0 bondeth1

129.146.0.0     10.232.35.1     255.255.0.0     UG        0 0          0 bondeth1

169.254.200.0   0.0.0.0         255.255.255.252 U         0 0          0 eth0

192.168.132.0   0.0.0.0         255.255.252.0   U         0 0          0 clib1

192.168.132.0   0.0.0.0         255.255.252.0   U         0 0          0 clib0

192.168.136.0   0.0.0.0         255.255.248.0   U         0 0          0 stib0

192.168.136.0   0.0.0.0         255.255.248.0   U         0 0          0 stib1

 

Exadata Cloud – Post Provisioning View of the system

Review of Exadata Deployment

Once the Exadata provisioning process completes (which takes around 4-5hrs for a ½ rack).  We explore to see what gets deployed:

$ cat/etc/oratab

OCITEST:/u02/app/oracle/product/12.2.0/dbhome_2:Y

+ASM1:/u01/app/12.2.0.1/grid:N       # line added by Agent

 

[grid@phxdbm-o3eja1 ~]$ olsnodes -n

phxdbm-o3eja1 1

phxdbm-o3eja2 2

phxdbm-o3eja3 3

phxdbm-o3eja4 4

 

[grid@phxdbm-o3eja1 ~]$ cat /var/opt/oracle/creg/OCITEST.ini | grep nodelist

nodelist=phxdbm-o3eja1 phxdbm-o3eja2 phxdbm-o3eja3 phxdbm-o3eja4

 

[grid@phxdbm-o3eja1 ~]$ crsctl stat res -t

—————————————————————————–

Name           Target  State        Server                   State details

—————————————————————————–

Local Resources

—————————————————————————–

ora.ACFSC1_DG1.C1_DG11V.advm

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.ACFSC1_DG1.C1_DG12V.advm

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.ACFSC1_DG1.dg

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE    ora.ACFSC1_DG2.C1_DG2V.advm

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE    ora.ACFSC1_DG2.dg

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE    ora.ASMNET1LSNR_ASM.lsnr

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.DATAC1.dg

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE . ora.DBFS_DG.dg

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.LISTENER.lsnr

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.RECOC1.dg

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE . ora.acfsc1_dg1.c1_dg11v.acfs

ONLINE  ONLINE       phxdbm-o3eja1            mounted on /scratch/acfsc1_dg1,STABLE

ONLINE  ONLINE       phxdbm-o3eja2            mounted on /scratch/acfsc1_dg1,STABLE

ONLINE  ONLINE       phxdbm-o3eja3            mounted on /scratch/acfsc1_dg1,STABLE

ONLINE  ONLINE       phxdbm-o3eja4            mounted on /scratch/acfsc1_dg1,STABLE

ora.acfsc1_dg1.c1_dg12v.acfs

ONLINE  ONLINE       phxdbm-o3eja1            mounted on /u02/app_acfs,STABLE

ONLINE  ONLINE       phxdbm-o3eja2            mounted on /u02/app_acfs,STABLE

ONLINE  ONLINE       phxdbm-o3eja3            mounted on /u02/app_acfs,STABLE

ONLINE  ONLINE       phxdbm-o3eja4            mounted on /u02/app_acfs,STABLE

ora.acfsc1_dg2.c1_dg2v.acfs

ONLINE  ONLINE       phxdbm-o3eja1            mounted on /var/opt/oracle/dbaas_acfs,STABLE

ONLINE  ONLINE       phxdbm-o3eja2            mounted on /var/opt/oracle/dbaas_acfs,STABLE

ONLINE  ONLINE       phxdbm-o3eja3            mounted on /var/opt/oracle/dbaas_acfs,STABLE

ONLINE  ONLINE       phxdbm-o3eja4            mounted on /var/opt/oracle/dbaas_acfs,STABLE

ora.net1.network

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.ons

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

ora.proxy_advm

ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ONLINE  ONLINE       phxdbm-o3eja4            STABLE

—————————————————————————–

Cluster Resources

——————————————————————————–

ora.LISTENER_SCAN1.lsnr

1        ONLINE  ONLINE       phxdbm-o3eja2            STABLE

ora.LISTENER_SCAN2.lsnr

1        ONLINE  ONLINE       phxdbm-o3eja3            STABLE

ora.LISTENER_SCAN3.lsnr

1        ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ora.asm

1        ONLINE  ONLINE       phxdbm-o3eja1            Started,STABLE

2        ONLINE  ONLINE       phxdbm-o3eja2            Started,STABLE

3        ONLINE  ONLINE       phxdbm-o3eja3            Started,STABLE

4        ONLINE  ONLINE       phxdbm-o3eja4            Started,STABLE

ora.cvu

1        ONLINE  ONLINE       phxdbm-o3eja1            STABLE

ora.ocitest.db

1        ONLINE  ONLINE       phxdbm-o3eja1            Open,HOME=/u02/app/oracle/product/12.2.0/dbhome_2,STABLE

2        ONLINE  ONLINE       phxdbm-o3eja2            Open,HOME=/u02/app/o

racle/product/12.2.0

/dbhome_2,STABLE

3        ONLINE  ONLINE       phxdbm-o3eja3            Open,HOME=/u02/app/oracle/product/12.2.0

/dbhome_2,STABLE

4        ONLINE  ONLINE       phxdbm-o3eja4            Open,HOME=/u02/app/oracle/product/12.2.0

/dbhome_2,STABLE

ora.phxdbm-o3eja1.vip

1        ONLINE  ONLINE       phxdbm-o3eja1            STABLE ora.phxdbm-o3eja2.vip

1        ONLINE  ONLINE       phxdbm-o3eja2            STABLE ora.phxdbm-o3eja3.vip

1        ONLINE  ONLINE       phxdbm-o3eja3            STABLE ora.phxdbm-o3eja4.vip

1        ONLINE  ONLINE       phxdbm-o3eja4            STABLE ora.qosmserver

1        OFFLINE OFFLINE                               STABLE ora.scan1.vip

1        ONLINE  ONLINE       phxdbm-o3eja2            STABLE ora.scan2.vip

1        ONLINE  ONLINE       phxdbm-o3eja3            STABLE ora.scan3.vip

1        ONLINE  ONLINE       phxdbm-o3eja1            STABLE

—————————————————————————–

[grid@phxdbm-o3eja1 ~]$ asmcmd lsct

DB_Name  Status     Software_Version  Compatible_version  Instance_Name   Disk_Group

+APX     CONNECTED        12.2.0.1.0          12.2.0.1.0  +APX1   ACFSC1_DG1

+APX     CONNECTED        12.2.0.1.0          12.2.0.1.0  +APX1   ACFSC1_DG2

+ASM     CONNECTED        12.2.0.1.0          12.2.0.1.0  +ASM1   DATAC1

+ASM     CONNECTED        12.2.0.1.0          12.2.0.1.0  +ASM1    DBFS_DG

OCITEST  CONNECTED        12.2.0.1.0          12.2.0.0.0  OCITEST1 DATAC1

OCITEST  CONNECTED        12.2.0.1.0          12.2.0.0.0  OCITEST1  RECOC1

_OCR     CONNECTED         –                  phxdbm-o3eja1.client.phxexadata.oraclevcn.com  DBFS_DG

yoda     CONNECTED        12.2.0.1.0          12.2.0.0.0  yoda1    DATAC1

yoda     CONNECTED        12.2.0.1.0          12.2.0.0.0  yoda1    RECOC1

 

[root@phxdbm-o3eja1 ~]# df -k

Filesystem           1K-blocks     Used Available Use% Mounted on

/dev/mapper/VGExaDb-LVDbSys1

24639868  3878788  19486408  17% /

tmpfs                742619136  2465792 740153344   1% /dev/shm

/dev/xvda1              499656    26360    447084   6% /boot

/dev/mapper/VGExaDb-LVDbOra1

20511356   719324  18727072   4% /u01

/dev/xvdb             51475068  9757380  39079864  20% /u01/app/12.2.0.1/grid

/dev/xvdc             51475068  9302820  39534424  20% /u01/app/oracle/product/12.1.0.2/dbhome_1

/dev/xvdd             51475068  8173956  40663288  17% /u01/app/oracle/product/12.2.0.1/dbhome_1

/dev/xvde             51475068  6002756  42834488  13% /u01/app/oracle/product/11.2.0.4/dbhome_1

/dev/xvdg            206293688 19751360 176040184  11% /u02

/dev/asm/c1_dg12v-186

459276288  1067008 458209280   1% /u02/app_acfs

/dev/asm/c1_dg11v-186

229638144   611488 229026656   1% /scratch/acfsc1_dg1

/dev/asm/c1_dg2v-341 228589568 26597644 201991924  12% /var/opt/oracle/dbaas_acfs

 

Oracle Homes are created and mounted, though for IQN we will only be using 12.2, 12.1.0.2, and 11.2.0.4 [interim].

The   following are Exadata specific filesystems and use cases
/scratch/acfs1_dg1             –staging Exadata

/u02/app_acfs.                    – User filesystem for applications (currently empty)

/var/opt/oracle/dbaas_acfs.  –  Binary and image repository for all Exadata patching and enablement

Exadata Cloud Deployment and Considerations

I recently did a presentation and wipe-board session on Exadata Cloud deployment.  As part of that engagment, I did a small write-up on this topic.  This is a series of blogs that reflects the presentation:

Cloud Exadata Network and Platform Configuration

 Exadata DB Systems are offered in quarter rack, half rack or full rack configurations, and each configuration consists of compute nodes and storage servers. The compute nodes are each configured as a Virtual Machine (VM).

Key Operational characteristics of Exadata Cloud

  • Admins have root privileges for the compute node VMs. Thus 3rd party software can be installed, however, only supported Oracle DB versions and rpms should be implemented.

 

  • Admins do not have administrative access to the Exadata infrastructure components, including the physical compute node hardware, network switches, power distribution units (PDUs), integrated lights- out management (ILOM) interfaces, or the Exadata Storage Servers, which are all administered by Oracle.

 

  • Admins have full administrative privileges for your databases. However, application users should connect to databases via Oracle Net Services.

 

  • Admins are responsible for database administration tasks such as creating tablespaces and managing database users.

 

  • Admins should define how ssh keys will managed for users that will need compute node access.

 

 

 

 

 

 

 

 

 

 

 

Provisioning Exadata Pre-reqs

The following are network pre-reqs for provisioning Cloud Exadata DB Systems

Subnets

  • Require two separate VCN subnets: client subnet for user data traffic and backup subnet for backup traffic.
  • Define both the client subnet and the backup subnet as public subnets. Exadata requires a public subnet to support backup of the database to the Object Store.
  • Do not use a subnet that overlaps with 192.168.128.0/20. This restriction applies to both the client subnet and backup subnet.
  • Oracle requires that you use a VCN Resolver for DNS name resolution for the client subnet. It automatically resolves the Swift endpoints required for backing up databases, patching, and updating the cloud tooling on an Exadata DB System.

At the completion of the provisioning, you should have the following configured:

 

 

 

 

 

 

Security Lists and Routing

  • Each VCN subnet has a default security list that contains a rule to allow TCP traffic on destination port 22 (SSH) from source 0.0.0.0/0 and any source port. Properly configure the security list ingress and egress rules.
  • The OneCommand configuration enables TCP and ICMP traffic between all nodes and all ports in the respective subnet for client and backup subnets
  • Exadata DB System’s cloud network (VCN) must be configured with an internet gateway. Add a route table rule to open the access to the Object Storage Service Swift endpoint on CIDR 0.0.0.0/0.
  • Update the backup subnet’s security list to disallow any access from outside the subnet and allow egress traffic for TCP port 443 (https) on CIDR Ranges 129.146.0.0/16 (Phoenix region), 129.213.0.0/16 (Ashburn region)

Enable a route table with an entry that includes a Internet Gateway.  This will enable remote ssh access to the Exadata nodes

 

 

 

 

 

 

 

Provisioning Exadata

Service Console – Provision Exadata

Below are screenshot views that illustrate the provisioning of Exadata

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Cloud Exadata Storage Configuration

Exadata Storage Servers use the following ASM disk groups:

DATA diskgroup – for the storage of Oracle Data base datafiles.

RECO diskgroup – primarily used for storing files related to backup and recovery, such as RMAN backups and archived redo log files.  Depending how admins choose to provision for backups on Exadata storage

approximately 40% of the available storage space is allocated to the DATA disk group and approximately 60% is allocated to the RECO disk group.

Provision for backups on Exadata storage, approximately 80% of the available storage space is allocated to the DATA disk group and approximately 20% is allocated to the RECO disk group.

DBFS and ACFS diskgroups are system diskgroups that support various operational purposes. The DBFS disk group is primarily used to store the shared Clusterware files (Oracle Cluster Registry and voting disks), while the ACFS disk groups are primarily used to store Oracle Database binaries, staging directories and metadata.

 

Are You Ready to apply the 12.2.0.1 July RU ???

Here's the steps that I went thru to apply the Grid Infrastructure Jul2017 Release Update 12.2.0.1.170718, Patch 26133434 

Configuration:  2 Node RAC cluster on Kaminario K2 AFA

The Grid Infrastructure Jul2017 Release Update (RU) 12.2.0.1.170718 includes updates for both the Clusterware home and Database home that can be applied in a rolling fashion.
In this blog post we have updated both nodes GI and DB stack.
The details and execution for Node1 are repeated and presented here for Node2 as well
Big thanks to Mike Dietrich for some insight !

 Step 1) Upgrade the Opatch version to atleast (12.2.0.1.7). We need to upgrade the OPatch version at GI and DB Homes on all the nodes.

[root@vna02 grid]# cd OPatch

[root@vna02 OPatch]# ./opatch version

OPatch Version: 12.2.0.1.9   è Grid Home

OPatch succeeded.

[oracle   @vna01 dbhome_1]$ opatch version

OPatch Version: 12.2.0.1.9  è Database Home

Step 2) Patch conflict check:

Node 1 : 

[oracle@vna01 GI]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_18-43-33PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

[oracle@vna01 GI]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778

Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_19-01-04PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

From the Database Home :

[oracle@vna01 GI]$ . oraenv
ORACLE_SID = [VNADB1] ? VNADB1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@vna01 GI]$ cd $ORACLE_HOME/OPatch
[oracle@vna01 OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_19-03-12PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

[oracle@vna01 OPatch]$
[oracle@vna01 OPatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_19-03-25PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

One-off Patch Conflict Detection and Resolution

[root@vna01 OPatch]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/software/patches/DB-GI-RU/GI/26133434 -analyze

OPatchauto session is initiated at Wed Sep 20 19:53:25 2017
System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-20_07-53-27PM.log.
Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-20_07-53-48PM.log
The id for this session is QWPL
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1
Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid
Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1
Patch applicability verified successfully on home /u01/app/12.2.0/grid
Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

Following step failed during analysis:
/bin/sh -c 'ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_SID=VNADB1 /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/datapatch -prereq'
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1
OPatchAuto successful.

--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:vna01
RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1

==Following patches were SKIPPED:
Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399
Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778
Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log
Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830
Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log

Host:vna01
CRS Home:/u01/app/12.2.0/grid
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log
Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log
Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_19-53-51PM_1.log
OPatchauto session completed at Wed Sep 20 19:57:09 2017
Time taken to complete the session 3 minutes, 44 seconds


Now OPatchauto Apply process:

[root@vna01 OPatch]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/software/patches/DB-GI-RU/GI/26133434

OPatchauto session is initiated at Wed Sep 20 20:18:27 2017

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-20_08-18-28PM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-20_08-18-50PM.log

The id for this session is CNCU

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

"/bin/sh -c 'ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_SID=VNADB1 /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/datapatch -prereq'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be analyzed by manually retrying the same command.

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/dbhome_1

Successfully prepared home /u01/app/oracle/product/12.2.0/dbhome_1 to bring down database service

Bringing down CRS service on home /u01/app/12.2.0/grid

Prepatch operation log file location: /u01/app/oracle/crsdata/vna01/crsconfig/crspatch_vna01_2017-09-20_08-22-15PM.log

CRS service brought down successfully on home /u01/app/12.2.0/grid

Performing prepatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1

Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Start applying binary patch on home /u01/app/oracle/product/12.2.0/dbhome_1

Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Performing postpatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1

Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Start applying binary patch on home /u01/app/12.2.0/grid

Binary patch applied successfully on home /u01/app/12.2.0/grid

Starting CRS service on home /u01/app/12.2.0/grid

Postpatch operation log file location: /u01/app/oracle/crsdata/vna01/crsconfig/crspatch_vna01_2017-09-20_08-27-01PM.log

CRS service started successfully on home /u01/app/12.2.0/grid

Preparing home /u01/app/oracle/product/12.2.0/dbhome_1 after database service restarted

No step execution required.........

Prepared home /u01/app/oracle/product/12.2.0/dbhome_1 successfully after database service restarted

Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/dbhome_1

"/bin/sh -c 'ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1 ORACLE_SID=VNADB1 /u01/app/oracle/product/12.2.0/dbhome_1/OPatch/datapatch'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be applied by manually retrying the same command.

SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:vna01

RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1

Summary:

==Following patches were SKIPPED:

Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399

Reason: This patch is not applicable to this specified target type - "rac_database"



==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-23-57PM_1.log

Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-23-57PM_1.log


Host:vna01

CRS Home:/u01/app/12.2.0/grid

Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26002778

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-24-44PM_1.log

Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/25586399

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-24-44PM_1.log

Patch: /home/oracle/software/patches/DB-GI-RU/GI/26133434/26123830

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-20_20-24-44PM_1.log

OPatchauto session completed at Wed Sep 20 20:34:23 2017

Time taken to complete the session 15 minutes, 56 seconds


lsInventory Output:

[oracle@vna01 OPatch]$ opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/12.2.0/grid

Central Inventory : /u01/app/oraInventory

from           : /u01/app/12.2.0/grid/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-20_20-38-46PM_1.log



lsinventory Output file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-09-20_20-38-46PM.txt

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

Local Machine Information::

Hostname: vna01

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c                                       12.2.0.1.0

There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch  26123830     : applied on Wed Sep 20 20:26:39 BST 2017

Unique Patch ID:  21405588

Patch description:  "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)"

Created on 7 Jul 2017, 00:33:59 hrs PST8PDT

Bugs fixed:

23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877

25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421

25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959

25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846

24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398

24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007

25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332

25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017

22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726

25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817

24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628

24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167

25967985

Patch  25586399     : applied on Wed Sep 20 20:26:17 BST 2017

Unique Patch ID:  21306685

Patch description:  "ACFS Patch Set Update : 12.2.0.1.170718 (25586399)"

Created on 16 Jun 2017, 00:35:19 hrs PST8PDT

Bugs fixed:

24679041, 24964969, 25098392, 25078431, 25491831


Patch  26002778     : applied on Wed Sep 20 20:25:26 BST 2017

Unique Patch ID:  21306682

Patch description:  "OCW Patch Set Update : 12.2.0.1.170718 (26002778)"

Created on 3 Jul 2017, 03:26:30 hrs PST8PDT

Bugs fixed:

26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375

25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495

25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658

25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035

25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158

25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126

25197395, 24808260

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

OPatch succeeded.

[oracle@vna01 OPatch]

From the Database Home :

[oracle@vna01 OPatch]$ . oraenv

ORACLE_SID = [+ASM1] ? VNADB1

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@vna01 OPatch]$  export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@vna01 OPatch]$ which opatch

/u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch

[oracle@vna01 OPatch]$ opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_20-40-03PM_1.log

lsinventory Output file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-20_20-40-03PM.txt

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

Local Machine Information::

Hostname: vna01

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.2.0.1.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  26123830     : applied on Wed Sep 20 20:24:26 BST 2017

Unique Patch ID:  21405588

Patch description:  "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)"

Created on 7 Jul 2017, 00:33:59 hrs PST8PDT

Bugs fixed:

23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877

25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421

25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959

25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846

24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398

24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007

25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332

25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017

22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726

25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817

24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628

24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167

25967985



Patch  26002778     : applied on Wed Sep 20 20:24:11 BST 2017

Unique Patch ID:  21306682

Patch description:  "OCW Patch Set Update : 12.2.0.1.170718 (26002778)"

Created on 3 Jul 2017, 03:26:30 hrs PST8PDT

Bugs fixed:

26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375

25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495

25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658

25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035

25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158

25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126

25197395, 24808260

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

OPatch succeeded.

[oracle@vna01 OPatch]$



Node 2 : 

Run OPatch Conflict Check

From GI Home:

[oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26123830

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/12.2.0/grid

Central Inventory : /u01/app/oraInventory

from           : /u01/app/12.2.0/grid/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-20_20-48-20PM_1.log



Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@vna02 patches]$

[oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26002778

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.



PREREQ session

Oracle Home       : /u01/app/12.2.0/grid

Central Inventory : /u01/app/oraInventory

from           : /u01/app/12.2.0/grid/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-20_20-48-32PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

For the DB Home:

[oracle@vna02 patches]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@vna02 patches]$ which opatch

/u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch

[oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26123830

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_20-52-24PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@vna02 patches]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/patches/26133434/26002778

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-20_20-52-38PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@vna02 patches]$



OPATCH Conflict Checks:

[root@vna02 12.2.0]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/patches/26133434 -analyze

OPatchauto session is initiated at Thu Sep 21 02:18:32 2017

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-21_02-18-33AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-21_02-18-53AM.log

The id for this session is NWN8

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.2.0/grid

Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:vna02

RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1

==Following patches were SKIPPED:

Patch: /home/oracle/patches/26133434/25586399

Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /home/oracle/patches/26133434/26002778

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log

Patch: /home/oracle/patches/26133434/26123830

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log

Host:vna02

CRS Home:/u01/app/12.2.0/grid

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /home/oracle/patches/26133434/26002778

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log

Patch: /home/oracle/patches/26133434/25586399

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log



Patch: /home/oracle/patches/26133434/26123830

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-18-56AM_1.log

OPatchauto session completed at Thu Sep 21 02:22:48 2017

Time taken to complete the session 4 minutes, 16 seconds


OPatchauto apply:



[root@vna02 12.2.0]# $ORACLE_HOME/OPatch/opatchauto apply /home/oracle/patches/26133434



OPatchauto session is initiated at Thu Sep 21 02:25:35 2017



System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2017-09-21_02-25-36AM.log.



Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2017-09-21_02-25-57AM.log

The id for this session is PM1S



Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1



Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.2.0/grid

Patch applicability verified successfully on home /u01/app/12.2.0/grid



Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1





Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/dbhome_1

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/dbhome_1





Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/dbhome_1

Successfully prepared home /u01/app/oracle/product/12.2.0/dbhome_1 to bring down database service





Bringing down CRS service on home /u01/app/12.2.0/grid

Prepatch operation log file location: /u01/app/oracle/crsdata/vna02/crsconfig/crspatch_vna02_2017-09-21_02-30-11AM.log

CRS service brought down successfully on home /u01/app/12.2.0/grid





Performing prepatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1

Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1





Start applying binary patch on home /u01/app/oracle/product/12.2.0/dbhome_1

Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1





Performing postpatch operation on home /u01/app/oracle/product/12.2.0/dbhome_1

Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/dbhome_1





Start applying binary patch on home /u01/app/12.2.0/grid

Binary patch applied successfully on home /u01/app/12.2.0/grid





Starting CRS service on home /u01/app/12.2.0/grid

Postpatch operation log file location: /u01/app/oracle/crsdata/vna02/crsconfig/crspatch_vna02_2017-09-21_02-34-30AM.log

CRS service started successfully on home /u01/app/12.2.0/grid





Preparing home /u01/app/oracle/product/12.2.0/dbhome_1 after database service restarted

No step execution required.........

Prepared home /u01/app/oracle/product/12.2.0/dbhome_1 successfully after database service restarted





Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/dbhome_1

SQL patch applied successfully on home /u01/app/oracle/product/12.2.0/dbhome_1



OPatchAuto successful.



--------------------------------Summary--------------------------------



Patching is completed successfully. Please find the summary as follows:



Host:vna02

RAC Home:/u01/app/oracle/product/12.2.0/dbhome_1

Summary:



==Following patches were SKIPPED:



Patch: /home/oracle/patches/26133434/25586399

Reason: This patch is not applicable to this specified target type - "rac_database"





==Following patches were SUCCESSFULLY applied:



Patch: /home/oracle/patches/26133434/26002778

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-31-39AM_1.log



Patch: /home/oracle/patches/26133434/26123830

Log: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-31-39AM_1.log





Host:vna02

CRS Home:/u01/app/12.2.0/grid

Summary:



==Following patches were SUCCESSFULLY applied:



Patch: /home/oracle/patches/26133434/26002778

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-32-21AM_1.log



Patch: /home/oracle/patches/26133434/25586399

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-32-21AM_1.log



Patch: /home/oracle/patches/26133434/26123830

Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-09-21_02-32-21AM_1.log







OPatchauto session completed at Thu Sep 21 02:41:44 2017

Time taken to complete the session 16 minutes, 9 seconds

[root@vna02 12.2.0]#

LsInventory Checks:

GRIDHome Inventory

[oracle@vna02 ~]$ . oraenv

ORACLE_SID = [oracle] ? +ASM2
The Oracle base has been set to /u01/app/oracle

[oracle@vna02 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@vna02 ~]$ which opatch
/u01/app/12.2.0/grid/OPatch/opatch

[oracle@vna02 ~]$ opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/12.2.0/grid
Central Inventory : /u01/app/oraInventory
from           : /u01/app/12.2.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.9
OUI version       : 12.2.0.1.4
Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2017-09-21_02-44-21AM_1.log
Lsinventory Output file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-09-21_02-44-21AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: vna02
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c                                       12.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :
Patch  26123830     : applied on Thu Sep 21 02:34:08 BST 2017
Unique Patch ID:  21405588
Patch description:  "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)"
Created on 7 Jul 2017, 00:33:59 hrs PST8PDT

Bugs fixed:
23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877

25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421

25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959

25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846

24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398

24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007

25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332

25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017

22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726

25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817

24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628

24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167

25967985



Patch  25586399     : applied on Thu Sep 21 02:33:51 BST 2017

Unique Patch ID:  21306685

Patch description:  "ACFS Patch Set Update : 12.2.0.1.170718 (25586399)"

Created on 16 Jun 2017, 00:35:19 hrs PST8PDT

Bugs fixed:

24679041, 24964969, 25098392, 25078431, 25491831



Patch  26002778     : applied on Thu Sep 21 02:33:01 BST 2017

Unique Patch ID:  21306682

Patch description:  "OCW Patch Set Update : 12.2.0.1.170718 (26002778)"

Created on 3 Jul 2017, 03:26:30 hrs PST8PDT

Bugs fixed:

26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375

25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495

25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658

25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035

25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158

25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126

25197395, 24808260







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



OPatch succeeded.

[oracle@vna02 ~]$









DBHome Inventory:







[oracle@vna02 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@vna02 ~]$ which opatch

/u01/app/oracle/product/12.2.0/dbhome_1/OPatch/opatch

[oracle@vna02 ~]$

[oracle@vna02 ~]$

[oracle@vna02 ~]$ opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.9

Copyright (c) 2017, Oracle Corporation.  All rights reserved.





Oracle Home       : /u01/app/oracle/product/12.2.0/dbhome_1

Central Inventory : /u01/app/oraInventory

from           : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.9

OUI version       : 12.2.0.1.4

Log file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-09-21_02-45-58AM_1.log



Lsinventory Output file location : /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-21_02-45-58AM.txt



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

Local Machine Information::

Hostname: vna02

ARU platform id: 226

ARU platform description:: Linux x86-64



Installed Top-level Products (1):



Oracle Database 12c                                                  12.2.0.1.0

There are 1 products installed in this Oracle Home.





Interim patches (2) :



Patch  26123830     : applied on Thu Sep 21 02:32:03 BST 2017

Unique Patch ID:  21405588

Patch description:  "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)"

Created on 7 Jul 2017, 00:33:59 hrs PST8PDT

Bugs fixed:

23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877

25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421

25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959

25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846

24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398

24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007

25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332

25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017

22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726

25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817

24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628

24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167

25967985



Patch  26002778     : applied on Thu Sep 21 02:31:51 BST 2017

Unique Patch ID:  21306682

Patch description:  "OCW Patch Set Update : 12.2.0.1.170718 (26002778)"

Created on 3 Jul 2017, 03:26:30 hrs PST8PDT

Bugs fixed:

26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375

25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495

25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658

25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035

25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158

25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126

25197395, 24808260







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



OPatch succeeded.

[oracle@vna02 ~]$

 

BMCS-PeopleSoft Deployment Guide

This article illustrates a joint cookbook-approach for provisioning a PeopleSoft application on Bare Metal Cloud Services configuration; including network, compute, database, load balancing service, and storage. The second section of this paper describes the migration of an on- premise PeopleSoft Database to the Bare Metal Cloud.

The following link describes this in detail.  Enjoy !!

BMCS-PeopleSoft Deployment Guide