Oracle Linux 7.1 silent install 19C RAC 01/16 Update SLTechnology News&Howtos

Oracle Linux 7.1 silent install 19C RAC

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

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

One system environmental rules

1.1 Network Architecture

Node 1 Node 2 hostname 19c1 19c2 Private IP 10.10.141 10.10.142 Public IP 10.13.13.141 10.13.13.142 VIP 10.13.13.143 10.13.13.144 SCANIP 10.13.13.145/146/147 SCAN_NAME scan-19c

1.2 Storage

Shared disk ASM disk ASM disk group size redundancy / dev/sdb / dev/asmdisk1 OCR 50G external / dev/sdc / dev/asmdisk2 DATA 60G external

1.3 Software version

Operating system: Oracle Linux 7.1Cluster Software: Oracle Clusterware 19.3.0 Database Software: Oracle Database Enterprise 19.3.0

2. Preparation of installation environment

2.1 modify hostname and IP address

Modify hostname

[root@localhost ~] # hostnamectl set-hostname 19c1 [root@localhost ~] # hostnamectl set-hostname 19c2

2.2 modify Private IP address

[root@19c1 ~] # cat / etc/sysconfig/network-scripts/ifcfg-ens192 HWADDR=00:50:56:A3:10:82 TYPE=Ethernet BOOTPROTO=none IPADDR=10.10.10.141 PREFIX=24 GATEWAY=10.10.10.1 DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=no IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no NAME=ens192 UUID=7d9faf7c-d74c-41da-b02e-8703dfb8ef20 DEVICE=ens192 >

2.3 modify Public IP address [root@19c1 ~] # cat / etc/sysconfig/network-scripts/ifcfg-ens160 TYPE=Ethernet BOOTPROTO=none DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=no IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no NAME=ens160 UUID=073349c5-40bc-4a0d-b1e6-44a935689d41 DEVICE=ens160 >

2.4 turn off the time synchronization service [root@19c1 ~] # systemctl stop chronyd [root@19c1 ~] # systemctl disable chronyd rm'/ etc/systemd/system/multi-user.target.wants/chronyd.service' [root@19c1 ~] # mv / etc/chrony.conf / etc/chrony.conf.bak [root@19c2 ~] # systemctl stop chronyd [root@19c2 ~] # systemctl disable chronyd rm'/ etc/systemd/system/multi-user.target.wants/chronyd.service' [root@ 19c2 ~] # mv / etc/chrony.conf / etc/chrony.conf.bak

2.5 turn off the firewall and SELinux [root @ 19c1 ~] # systemctl stop firewalld [root@19c1 ~] # systemctl disable firewalld rm'/ etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service' rm'/ etc/systemd/system/basic.target.wants/firewalld.service' [root@19c1 ~] # setenforce 0 [root@19c1 ~] # sed-I "/ ^ SELINUX=/s#enforcing#disabled#" / etc/selinux/config [root@19c1 ~] # cat / etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing-SELinux security policy is enforced. # permissive-SELinux prints warnings instead of enforcing. # disabled-No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted-Targeted processes are protected, # minimum-Modification of targeted policy. Only selected processes are protected. # mls-Multi Level Security protection. SELINUXTYPE=targeted [root@19c2 ~] # systemctl stop chronyd [root@19c2 ~] # systemctl disable chronyd rm'/ etc/systemd/system/multi-user.target.wants/chronyd.service' [root@19c2 ~] # mv / etc/chrony.conf / etc/chrony.conf.bak [root@19c2 ~] # setenforce 0 [root@19c2 ~] # sed-I "/ ^ SELINUX=/s#enforcing#disabled#" / etc/selinux/config [root@19c2 ~] # cat / etc/selinux/config # This file controls the state of SELinux on the system # SELINUX= can take one of these three values: # enforcing-SELinux security policy is enforced. # permissive-SELinux prints warnings instead of enforcing. # disabled-No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted-Targeted processes are protected, # minimum-Modification of targeted policy. Only selected processes are protected. # mls-Multi Level Security protection. SELINUXTYPE=targeted

2.6 configure local YUM [root@19c1 ~] # ls-lrt / etc/yum.repos.d/ total 4-rw-r--r--. 1 root root 2323 Feb 16 2015 public-yum-ol7.repo [root@19c1 ~] # mv / etc/yum.repos.d/public-yum-ol7.repo / etc/yum.repos.d/public-yum-ol7.repo.bak [root@19c1 ~] # mount / dev/sr0 / mnt/ mount: / dev/sr0 is write-protected, mounting read-only [root@19c1 ~] # cat > > / etc/yum.repos.d/jy.repo

< [base] >

Name=jy > baseurl= file:///mnt > enabled=1 > gpgcheck=0 > multilib_policy=all > EOF [root@19c1 ~] # cat / etc/yum.repos.d/jy.repo [base] name=jy baseurl= file:///mnt enabled=1 gpgcheck=0 multilib_policy=all [root@19c1 ~] # yum clean all Loaded plugins: langpacks Cleaning repos: base ol7_UEKR3 ol7_latest Cleaning up everything [root@19c1 ~] # yum makecache Loaded plugins: langpacks base | 3.6kB 00:00:00 (1amp 4): base/group_gz | 134 kB 00 : 00:00 (2 MB 4): base/filelists_db | 3.4 MB 00:00:00 (3 etc/yum.repos.d/ total 4): base/primary_db | 4.0 MB 00:00:00 (4 stroke 4): base/other_db | 1.3 MB 00:00:00 Metadata Cache Created [root@19c2 ~] # ls-lrt / etc/yum.repos.d/ total 4-rw-r--r--. 1 root root 2323 Feb 16 2015 public-yum-ol7.repo [root@19c2 ~] # mv / etc/yum.repos.d/public-yum-ol7.repo / etc/yum.repos.d/public-yum-ol7.repo.bak [root@19c2 ~] # mount / dev/sr0 / mnt/ mount: / dev/sr0 is write-protected, mounting read-only [root@19c2 ~] # cat > > / etc/yum.repos.d/jy.repo

< [base] >

< kernel.shmall = 4294967296 >

Kernel.sem = 510 65280 510128 > kernel.shmmni = 4096 > kernel.shmmax = 429496729500 > net.ipv4.ip_local_port_range = 9000 65500 > net.core.rmem_default = 1048576 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048576 > fs.file-max = 6815744 > fs.aio-max-nr = 1048576 > vm.swappiness = 0 > vm.dirty_background_ratio = 3 > vm.dirty_ratio = 80 > vm. Dirty_expire_centisecs = 500 > vm.dirty_writeback_centisecs = 100 > net.ipv4.tcp_sack = 0 > net.ipv4.tcp_timestamps = 0 > net.ipv4.conf.default.rp_filter = 0 > net.ipv4.tcp_wmem = 262144 > net.ipv4.tcp_rmem = 4194304 > EOF [root@19c1] # sysctl-p kernel.shmall = 4294967296 kernel.sem = 510 65280 510 128 kernel.shmmni = 4096 kernel.shmmax = 429496729500 net.ipv4.ip_local_port_range = 900065500 Net.core.rmem_default = 1048576 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.file-max = 6815744 fs.aio-max-nr = 1048576 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 net.ipv4.tcp_sack = 0 net.ipv4.tcp_timestamps = 0 net.ipv4.conf.default.rp_filter = 0 net.ipv4.tcp_wmem = 262144 net.ipv4.tcp_rmem = 4194304 [root@19c2 ~] # sysctl-p kernel.shmall = 4294967296 kernel.sem = 510 65280 510 128 kernel.shmmni = 4096 kernel.shmmax = 429496729500 net.ipv4.ip_local_port_range = 900065500 net.core.rmem_default = 1048576 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.file-max = 6815744 fs.aio-max-nr = 1048576 vm .swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 net.ipv4.tcp_sack = 0 net.ipv4.tcp_timestamps = 0 net.ipv4.conf.default.rp_filter = 0 net.ipv4.tcp_wmem = 262144 net.ipv4.tcp_rmem = 4194304

2.13 configure LIMITS limit parameter [root@19c1 ~] # cat > > / etc/security/limits.conf

< oracle soft nproc 2047 >

Oracle hard nproc 16384 > oracle soft nofile 65536 > oracle hard nofile 65536 > oracle soft memlock 3145728 > oracle hard memlock 3145728 > oracle soft stack 10240 > oracle hard stack 32768 > > grid soft nproc 2047 > grid hard nproc 16384 > grid soft nofile 65536 > grid hard nofile 65536 > grid soft memlock 3145728 > grid hard memlock 3145728 > grid soft stack 10240 > grid hard stack 32768 > EOF [root@19c2] # cat > / etc/security/limits.conf

< oracle soft nproc 2047 >

2.14 configure PAM [root@19c1 ~] # cat > > / etc/pam.d/login

< session required /lib64/security/pam_limits.so >

EOF [root@19c2 ~] # cat > > / etc/pam.d/login

< session required /lib64/security/pam_limits.so >

EOF

2.15 configure the system environment variable [root@19c1 ~] # cat > > / etc/pam.d/login

< if [ \$USER = "oracle" ]; then >

If [\ $SHELL = "/ bin/ksh"]; then > ulimit-p 16384 > ulimit-n 65536 > else > ulimit-u 16384-n 65536 > fi > fi > > if [\ $USER = "grid"]; then > if [\ $SHELL = "/ bin/ksh"]; then > ulimit-p 16384 > ulimit-n 65536 > else > ulimit-u 16384-n 65536 > fi > fi > > EOF [root@19c2 ~] # cat > > / etc/profile

< if [ \$USER = "oracle" ]; then >

2.16 configure the grid user environment variable [grid@19c1 ~] $vi .bash _ profile # .bash _ profile # Get the aliases and functions if [- f ~ / .bashrc]; then. ~ / .bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/19.3/grid export ORACLE_SID=+ASM1 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib LD_LIBRARY_ PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib [grid@19c2 ~] $vi .bash _ profile # .bash _ profile # Get the aliases and functions if [- f ~ / .bashrc] Then. ~ / .bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/19.3/grid export ORACLE_SID=+ASM2 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib LD_LIBRARY_ PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib

2.17 configure the oracle user environment variable [oracle@19c1 ~] $vi .bash _ profile # .bash _ profile # Get the aliases and functions if [- f ~ / .bashrc]; then. ~ / .bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/19.3/db export ORACLE_SID=ora19c1 export ORACLE_UNQNAME=ora19c export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib: / usr/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib [oracle@19c2 ~] $vi .bash _ profile # .bash _ profile # Get the aliases and functions if [- f ~ / .bashrc] Then. ~ / .bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/19.3/db export ORACLE_SID=ora19c2 export ORACLE_UNQNAME=ora19c export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib: / usr/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib

2.18 configure the disks required for ASM, edit the / etc/udev/rules.d/99-my-asmdevices.rules configuration file

[root@19c1 ~] # fdisk-l

Disk / dev/sdc: 64.4 GB, 64424509440 bytes, 125829120 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk / dev/sda: 85.9 GB, 85899345920 bytes, 167772160 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk label type: dos

Disk identifier: 0x0001fbac

Device Boot Start End Blocks Id System

/ dev/sda1 * 2048 1026047 512000 83 Linux

/ dev/sda2 1026048 167649279 83311616 8e Linux LVM

Disk / dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk / dev/mapper/ol-root: 76.8 GB, 76843843584 bytes, 150085632 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk / dev/mapper/ol-swap: 8455 MB, 8455716864 bytes, 16515072 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

[root@19c1] # / usr/lib/udev/scsi_id-g-u-d / dev/sdb

36000c299fe61de641fb3c6a854adf1f7

[root@19c1] # / usr/lib/udev/scsi_id-g-u-d / dev/sdc

36000c29ad3aa426c31327dac0a2b2a01

[root@19c1 ~] # vi / etc/udev/rules.d/99-my-asmdevices.rules

KERNEL== "sd* [! 0-9]", ENV {DEVTYPE} = = "disk", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-g-u-d $devnode", RESULT== "36000c299fe61de641fb3c6a854adf1f7", RUN+= "/ bin/sh-c 'mknod / dev/asmdisk01 b $major $minor; chown grid:asmadmin / dev/asmdisk01; chmod 0660 / dev/asmdisk01'"

KERNEL== "sd* [! 0-9]", ENV {DEVTYPE} = = "disk", SUBSYSTEM== "block", PROGRAM== "/ usr/lib/udev/scsi_id-g-u-d $devnode", RESULT== "36000c29ad3aa426c31327dac0a2b2a01", RUN+= "/ bin/sh-c 'mknod / dev/asmdisk02 b $major $minor; chown grid:asmadmin / dev/asmdisk02; chmod 0660 / dev/asmdisk02'"

[root@19c1] # / sbin/udevadm trigger-- type=devices-- action=change

[root@19c1 ~] # ls-lrt / dev/asm*

Brw-rw----. 1 grid asmadmin 8, 16 May 18 18:30 / dev/asmdisk01

Brw-rw----. 1 grid asmadmin 8, 32 May 18 18:30 / dev/asmdisk02

[root@19c2 ~] # fdisk-l

Disk / dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk / dev/sda: 85.9 GB, 85899345920 bytes, 167772160 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk label type: dos

Disk identifier: 0x0001fbac

Device Boot Start End Blocks Id System

/ dev/sda1 * 2048 1026047 512000 83 Linux

/ dev/sda2 1026048 167649279 83311616 8e Linux LVM

Disk / dev/sdc: 64.4 GB, 64424509440 bytes, 125829120 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk / dev/mapper/ol-root: 76.8 GB, 76843843584 bytes, 150085632 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk / dev/mapper/ol-swap: 8455 MB, 8455716864 bytes, 16515072 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

[root@19c2] # / usr/lib/udev/scsi_id-g-u-d / dev/sdb

36000c299fe61de641fb3c6a854adf1f7

[root@19c2] # / usr/lib/udev/scsi_id-g-u-d / dev/sdc

36000c29ad3aa426c31327dac0a2b2a01

[root@19c2 ~] # vi / etc/udev/rules.d/99-my-asmdevices.rules

[root@19c2] # / sbin/udevadm trigger-- type=devices-- action=change

[root@19c2 ~] # ls-lrt / dev/asm*

Brw-rw----. 1 grid asmadmin 8, 16 May 18 18:30 / dev/asmdisk01

Brw-rw----. 1 grid asmadmin 8, 32 May 18 18:30 / dev/asmdisk02

2.19 disable avahi

[root@19c1 /] # systemctl stop avahi-dnsconfd

Failed to issue method call: Unit avahi-dnsconfd.service not loaded.

[root@19c1 /] # systemctl stop avahi-daemon

Warning: Stopping avahi-daemon, but it can still be activated by:

Avahi-daemon.socket

[root@19c1 /] # systemctl disable avahi-dnsconfd

[root@19c1 /] # systemctl disable avahi-daemon

[root@19c2 /] # systemctl stop avahi-dnsconfd

Failed to issue method call: Unit avahi-dnsconfd.service not loaded.

[root@19c2 /] # systemctl stop avahi-daemon

Warning: Stopping avahi-daemon, but it can still be activated by:

Avahi-daemon.socket

[root@19c2 /] # systemctl disable avahi-dnsconfd

[root@19c2 /] # systemctl disable avahi-daemon

3. Install cluster software

3.1 decompress grid software [root@19c1 /] # su-grid Last login: Mon May 18 18:15:15 CST 2020 on pts/0 [grid@19c1 ~] $cd / soft [grid@19c1 soft] $ls-lrt total 5809468-rw-r--r--. 1 grid oinstall 2889184573 May 16 22:08 LINUX.X64_193000_grid_home.zip-rwxr-xr-x. 1 oracle oinstall 3059705302 May 18 18:44 LINUX.X64_193000_db_home.zip [grid@19c1 soft] $unzip-Q LINUX.X64_193000_grid_home.zip-d $ORACLE_HOME

3.2 install CVU [root @ 19c1 /] # export CVUQDISK_GRP=oinstall; [root@19c1 /] # rpm-ivh / u01/app/19.3/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm Preparing... # # [100%] Updating / installing... 1:cvuqdisk-1.0.10-1 # #

Copy the installation package to node 2 [root@19c1 /] # scp / u01/app/19.3/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm 19c2u01/app/19.3/grid/cv/rpm/cvuqdisk-1.0.10 ~ The authenticity of host '19c2 (10.13.13.142)' can't be established. ECDSA key fingerprint is 7f:1f:9a:0f:8b:d1:e0:17:32:08:12:73:d8:1d:9c:da. Are you sure you want to continue connecting (yes/no)? Yes Warning: Permanently added '19c2Magi 10.13.13.142' (ECDSA) to the list of known hosts. Root@19c2's password: cvuqdisk-1.0.10-1.rpm [root@19c2 ~] # export CVUQDISK_GRP=oinstall; [root@19c2 ~] # rpm-ivh cvuqdisk-1.0.10-1.rpm Preparing... # # [100%] Updating / installing... 1:cvuqdisk-1.0.10-1 # #

Configure SSH Trust

Configure grid users [root@19c1 /] # / u01/app/19.3/grid/oui/prov/resources/scripts/sshUserSetup.sh-user grid-hosts "19c1 19c2"-advanced exverify-confirm [root@19c1 /] # / u01/app/19.3/grid/oui/prov/resources/scripts/sshUserSetup.sh-user oracle-hosts "19c1 19c2"-advanced exverify-confirm [root@19c1 /] # su-grid Last login: Mon May 18 19:03:39 CST 2020 on pts/0 [grid@19c1 ~] $ssh 19c2 date Mon May 18 19:07:27 CST 2020 [grid@19c1 ~] $ssh 19c1 date Mon May 18 19:07:36 CST 2020 [grid@19c1 ~] $exit logout [root@19c1 /] # su-oracle Last login: Mon May 18 18:17:25 CST 2020 on pts/0 [oracle@19c1 ~] $ssh 19c2 date Mon May 18 19:07:45 CST 2020 [oracle@19c1 ~] $ssh 19c1 date Mon May 18 19:07:51 CST 2020 [root@19c2 ~] # su-grid Last login: Mon May 18 18:16:12 CST 2020 on pts/0 [grid@19c2 ~] $ssh 19c1 date Mon May 18 19:04:05 CST 2020 [grid@19c2 ~] $ssh 19c2 date Mon May 18 19:08:17 CST 2020 [grid@19c2 ~] $exit logout [root@19c2] # su-oracle Last login: Mon May 18 18:19:20 CST 2020 on pts/0 [oracle@19c2 ~] $ssh 19c1 date Mon May 18 19:08 27 CST 2020 [oracle@19c2 ~] $ssh 19c2 date Mon May 18 19:08:31 CST 2020

3.4 pre-installation environment check GI [grid@19c1 ~] $ORACLE_HOME/runcluvfy.sh stage-pre crsinst-n "19C1 Magazine 19c2"-fixup-verbose repair the checked problem as prompted [root@19c1 /] # / u01/tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully. [root@19c2 /] # / u01/tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully.

3.5 start installing Grid software [grid@19c1 ~] $vi grid.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 INVENTORY_LOCATION=/u01/app/oraInventory oracle.install.option=CRS_CONFIG ORACLE_BASE=/u01/app/grid oracle.install.asm.OSDBA=asmdba oracle.install.asm.OSOPER=asmoper oracle.install.asm.OSASM=asmadmin oracle.install.crs.config.scanType=LOCAL_SCAN oracle.install.crs.config.gpnp.scanName=scan-19c oracle.install.crs. Config.gpnp.scanPort=1521 oracle.install.crs.config.ClusterConfiguration=STANDALONE oracle.install.crs.config.configureAsExtendedCluster=false oracle.install.crs.config.clusterName=ora19c-cluster oracle.install.crs.config.gpnp.configureGNS=false oracle.install.crs.config.autoConfigureClusterNodeVIP=false oracle.install.crs.config.clusterNodes=19c1:19c1-vip 19c2:19c2-vip oracle.install.crs.config.networkInterfaceList=ens192:10.10.10.0:5 Ens160:10.13.13.0:1 oracle.install.crs.configureGIMR=false oracle.install.asm.configureGIMRDataDG=false oracle.install.crs.config.useIPMI=false oracle.install.asm.storageOption=ASM oracle.install.asmOnNAS.configureGIMRDataDG=false oracle.install.asm.SYSASMPassword=xxzx7817600 oracle.install.asm.diskGroup.name=OCR oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.diskGroup.AUSize=4 oracle.install.asm.diskGroup.disks=/dev/asmdisk01 oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm* oracle.install.asm.configureAFD=false oracle.install. Asm.monitorPassword=xxzx7817600 oracle.install.crs.configureRHPS=false oracle.install.crs.config.ignoreDownNodes=false oracle.install.config.managementOption=NONE oracle.install.config.omsPort=0 oracle.install.crs.rootconfig.executeRootScript=false [grid@19c1 ~] $$ORACLE_HOME/gridSetup.sh-silent-force-noconfig-waitforcompletion-ignorePrereq-responseFile / home/grid/grid.rsp Launching Oracle Grid Infrastructure Setup Wizard... [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-32047] The location (/ u01/app/oraInventory) specified for the central inventory is not empty. ACTION: It is recommended to provide an empty location for the inventory. [WARNING] [INS-13013] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. / u01/tmp/GridSetupActions2020-05-1811 09-17-17PM/gridSetupActions2020-05-18 09-17-17PM.log ACTION: Identify the list of failed prerequisite checks from the log: / u01/tmp/GridSetupActions2020-05-18 09-17-17PM/gridSetupActions2020-05-18 09-17-17PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: / u01/app/19.3/grid/install/response/grid_2020-05-1809-17-17PM.rsp You can find the log of this install session at: / u01/tmp/GridSetupActions2020-05-1809-17-17PM/gridSetupActions2020-05-1809-17-17PM.log As a root user Execute the following script (s): 1. / u01/app/oraInventory/orainstRoot.sh 2. / u01/app/19.3/grid/root.sh Execute / u01/app/oraInventory/orainstRoot.sh on the following nodes: [19c1, 19c2] Execute / u01/app/19.3/grid/root.sh on the following nodes: [19c1, 19c2] Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes. Successfully Setup Software with warning (s). As install user, execute the following command to complete the configuration. / u01/app/19.3/grid/gridSetup.sh-executeConfigTools-responseFile / home/grid/grid.rsp [- silent] Moved the install session logs to: / u01/app/oraInventory/logs/GridSetupActions2020-05-18 09-17-17PM

Node 1 executes the root script [root@19c1 ~] # / u01/app/oraInventory/orainstRoot.sh Changing permissions of / u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of / u01/app/oraInventory to oinstall. The execution of the script is complete. [root@19c1] # / u01/app/19.3/grid/root.sh Check / u01/app/19.3/grid/install/root_19c1_2020-05-18 21-35-58-622023345.log for the output of root script

Node 2 executes the root script [root@19c2 /] # / u01/app/oraInventory/orainstRoot.sh Changing permissions of / u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of / u01/app/oraInventory to oinstall. The execution of the script is complete. [root@19c2 /] # / u01/app/19.3/grid/root.sh Check / u01/app/19.3/grid/install/root_19c2_2020-05-18 21-58-15-384301417.log for the output of root script [grid@19c1 ~] $crsctl stat res-t -Name Target State Server State details- Local Resources-ora.LISTENER.lsnr ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.chad ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.net1.network ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora .ons ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE-Cluster Resources- -ora.19c1.vip 1 ONLINE ONLINE 19c1 STABLE ora.19c2.vip 1 ONLINE ONLINE 19c2 STABLE ora.ASMNET1LSNR_ASM.lsnr (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.OCR.dg (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm (ora.asmgroup) 1 ONLINE ONLINE 19c1 Started STABLE 2 ONLINE ONLINE 19c2 Started STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c1 STABLE ora.qosmserver 1 ONLINE ONLINE 19c1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c2 STABLE ora.scan2.vip 1 ONLINE ONLINE 19c1 STABLE ora.scan3.vip 1 ONLINE ONLINE 19c1 STABLE- -

Create ASM disk group [grid@19c1 ~] $sqlplus / as sysasm SQL*Plus: Release 19.0.0.0.0-Production on Mon May 18 22:10:54 2020 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 > create diskgroup DATA external REDUNDANCY disk'/ dev/asmdisk02' ATTRIBUTE 'au_size'='4M',' compatible.rdbms' = '19.0,' compatible.asm' = '19.0; Diskgroup created.

Node 2 performs mounting [grid@19c2 ~] $sqlplus / as sysasm SQL*Plus: Release 19.0.0.0.0-Production on Mon May 18 22:13:07 2020 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 > alter diskgroup data mount; Diskgroup altered. [grid@19c1] $crsctl stat res-t-Name Target State Server State details- -Local Resources -ora.LISTENER.lsnr ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.chad ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.net1.network ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.ons ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE-- -Cluster Resources-ora.19c1.vip 1 ONLINE ONLINE 19c1 STABLE ora.19c2.vip 1 ONLINE ONLINE 19c2 STABLE ora.ASMNET1LSNR_ASM.lsnr (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA.dg (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.OCR.dg (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm (ora.asmgroup) 1 ONLINE ONLINE 19c1 Started STABLE 2 ONLINE ONLINE 19c2 Started STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c1 STABLE ora.qosmserver 1 ONLINE ONLINE 19c1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c2 STABLE ora.scan2.vip 1 ONLINE ONLINE 19c1 STABLE ora.scan3.vip 1 ONLINE ONLINE 19c1 STABLE- -

4. Install database software

4.1 extract the installation package [oracle@19c1 ~] $cd / soft [oracle@19c1 soft] $ls-lrt total 5809468-rw-r--r--. 1 grid oinstall 2889184573 May 16 22:08 LINUX.X64_193000_grid_home.zip-rwxr-xr-x. 1 oracle oinstall 3059705302 May 18 18:44 LINUX.X64_193000_db_home.zip [oracle@19c1 soft] $unzip-Q LINUX.X64_193000_db_home.zip-d $ORACLE_HOME 4.2 check before installation [grid@19c1] $ORACLE_HOME/runcluvfy.sh stage-pre dbinst-n "19c1Mague 19c2"-fixup-verbose

4.3 write the response file [oracle@19c1 ~] $vi dbinstall.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/19.3/db oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install .db.OSBACKUPDBA _ GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.CLUSTER_NODES=19c1,19c2 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

4.4 perform installation [oracle@19c1 ~] $ORACLE_HOME/runInstaller-silent-force-noconfig-ignorePrereq-responseFile / home/oracle/dbinstall.rsp Launching Oracle Database Setup Wizard... [WARNING] [INS-13013] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. / u01/app/oraInventory/logs/InstallActions2020-05-18-10-55-24PM/installActions2020-05-18-10-55-24PM.log ACTION: Identify the list of failed prerequisite checks from the log: / u01/app/oraInventory/logs/InstallActions2020-05-18-10-55-24PM/installActions2020-05-18-10-55-24PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: / u01/app/oracle/product/19.3/db/install/response/db_2020-05-18 # 10-55-24PM.rsp You can find the log of this install session at: / u01/app/oraInventory/logs/InstallActions2020-05-18 # 10-55-24PM/installActions2020-05-18 # 10-55-24PM.log As a root user Execute the following script (s): 1. / u01/app/oracle/product/19.3/db/root.sh Execute / u01/app/oracle/product/19.3/db/root.sh on the following nodes: [19c1, 19c2] Successfully Setup Software with warning (s)

4.5 execute the root.sh script [root@19c1 ~] # / u01/app/oracle/product/19.3/db/root.sh Check / u01/app/oracle/product/19.3/db/install/root_19c1_2020-05-18-18-15-064687854.log for the output of root script [root@19c1 ~] # cat / u01/app/oracle/product/19.3/db/install/root_19c1_2020-05-18-15-064687854.log Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / u01/app/oracle/product/19.3/db Copying dbhome to / usr/local/bin... Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Entries will be added to the / etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. [root@19c2 /] # / u01/app/19.3/grid/root.sh Check / u01/app/19.3/grid/install/root_19c2_2020-05-18 21-58-15-384301417.log for the output of root script [root@19c2 /] # / u01/app/oracle/product/19.3/db/root.sh Check / u01/app/oracle/product/19.3/db/install/root_19c2_2020-05-18-18-22 -213501815.log for the output of root script [root@19c2 /] # cat / u01/app/oracle/product/19.3/db/install/root_19c2_2020-05-18-23-18-22-213501815.log Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / u01/app/oracle/product/19.3/db Copying dbhome to / usr/local/bin... Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Entries will be added to the / etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.

Fifth, create a database [oracle@19c1 ~] $vi dbca.rsp responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0 templateName=General_Purpose.dbc gdbName=ora19c sid=ora19c databaseConfigType=RAC responseFile=NO_VALUE characterSet=ZHS16GBK nationalCharacterSet=AL16UTF16 sysPassword=xxzx7817600 systemPassword=xxzx7817600 createAsContainerDatabase=true numberOfPDBs=1 pdbName=ora19cpdb useLocalUndoForPDBs=TRUE pdbAdminPassword=xxzx7817600 databaseType=MULTIPURPOSE automaticMemoryManagement=false totalMemory=3072 redoLogFileSize=50 emConfiguration=NONE nodelist=19c1,19c2 storageType=ASM diskGroupName=+DATA datafileDestination=+DATA asmsnmpPassword=xxzx7817600 sampleSchema=TRUE oracle@19c1 ~] $dbca-silent-createDatabase-responseFile / home/oracle/dbca.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: A. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. B.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: A. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. B.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: A. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. B.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [FATAL] [DBT-09101] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. / u01/app/oracle/cfgtoollogs/dbca/trace.log_2020-05-1911 12-01-31AM ACTION: Find the appropriate configuration from the log file or from the installation guide to meet the prerequisites and fix this manually.

Check the error log to see that the check failed INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OS Kernel Version: This is a prerequisite condition to test whether the system kernel version is at least "4.1.12" because the operating system kernel version is too low. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:CRITICAL INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: * INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Package: kmod-20-21 (x86-64): This is a prerequisite condition to test whether the package "kmod-20-21 (x86-64)" is available on the system. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:IGNORABLE INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: * INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Package: kmod-libs-20-21 (x86-64): This is a prerequisite condition to test whether the package "kmod-libs-20-21 (x86-64)" is available on the system. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:IGNORABLE INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: * INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Single Client Access Name (SCAN): This test verifies the Single Client Access Name configuration. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:CRITICAL INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: * INFO: May 19 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: DNS/NIS name service 'scan-19c': This test verifies that the Name Service lookups for the Distributed Name Server (DNS) and the Network Information Service (NIS) match for the SCAN name entries. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:CRITICAL INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED

Use-ignorePreReqs to ignore warnings and errors and execute [oracle@19c1 ~] $dbca-ignorePreReqs-silent-createDatabase-responseFile / home/oracle/dbca.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards again. CAUSE: A. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. B.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: A. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. B.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: A. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. B.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Prepare for db operation 7 complete Copying database files 27% complete Creating and starting Oracle instance 28% complete 31% complete 35% complete 37% complete 40 complete Creating cluster database views 41% complete 53% complete Completing Database Creation 57% complete 59% complete 60 complete Creating Pluggable Databases 64% complete 80% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: / u01/app/oracle/cfgtoollogs/dbca/ora19c. Database Information: Global Database Name:ora19c System Identifier (SID) Prefix:ora19c Look at the log file "/ u01/app/oracle/cfgtoollogs/dbca/ora19c/ora19c0.log" for further details. [grid@19c2] $crsctl stat res-t-Name Target State Server State details- -Local Resources -ora.LISTENER.lsnr ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.chad ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.net1.network ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.ons ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE-- -Cluster Resources-ora.19c1.vip 1 ONLINE ONLINE 19c1 STABLE ora.19c2.vip 1 ONLINE ONLINE 19c2 STABLE ora.ASMNET1LSNR_ASM.lsnr (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA.dg (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.OCR.dg (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm (ora.asmgroup) 1 ONLINE ONLINE 19c1 Started STABLE 2 ONLINE ONLINE 19c2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork (ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c1 STABLE ora.ora19c.db 1 ONLINE ONLINE 19c1 Open,HOME=/u01/app/o racle/product/19.3/d bStable 2 ONLINE ONLINE 19c2 Open,HOME=/u01/app/o racle/product/19.3/d b STABLE ora.qosmserver 1 ONLINE ONLINE 19c1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c2 STABLE ora.scan2.vip 1 ONLINE ONLINE 19c1 STABLE ora.scan3.vip 1 ONLINE ONLINE 19c1 STABLE-

Test the connection [oracle@19c2 ~] $sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0-Production on Tue May 19 02:12:46 2020 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 > select * from v$version BANNER BANNER_FULL BANNER_LEGACY CON_ID- -Oracle Database 19c Enterprise Edition Release 19.0.0.0.0-Oracle Database 19c Enterprise Edition Release 19.0.0.0.0-Oracle Database 19c Enterprise Edition Release 19.0 Production Production 0.0.0.0-Production SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED-2 PDB$SEED READ ONLY NO 3 ORA19CPDB READ WRITE NO

This is the end of the installation.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.