Skip to content

Instantly share code, notes, and snippets.

@jcnars

jcnars/host-provision run

Created November 24, 2021 23:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jcnars/1fec3401cf3ccd0e130f627a91f0439f to your computer and use it in GitHub Desktop.
Save jcnars/1fec3401cf3ccd0e130f627a91f0439f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
host-provision run
✔ ~/mydrive/bmaas/host_provisioning/bms-toolkit [host-provision|✚ 1…1]
14:08 $ runlocalssh ./host-provision.sh --instance-ip-addr 172.16.110.1 --instance-ssh-user ansible9 --proxy-setup true --u01-lun /dev/mapper/3600a098038314473792b51456555712f
Command used:
/usr/local/google/home/jcnarasimhan/mydrive/bmaas/host_provisioning/bms-toolkit/host-provision.sh --instance-ip-addr 172.16.110.1 --instance-ssh-user ansible9 --proxy-setup true --u01-lun /dev/mapper/3600a098038314473792b51456555712f
Running with parameters from command line or environment variables:
INSTANCE_SSH_USER=ansible9
INVENTORY_FILE=172.16.110.1,
ORA_CS_HOSTS=172.16.110.1
ORA_PROXY_SETUP=true
ORA_U01_LUN=/dev/mapper/3600a098038314473792b51456555712f
Found Ansible at /usr/bin/ansible-playbook
Running Ansible playbook: /usr/bin/ansible-playbook -i 172.16.110.1, host-provision.yml
PLAY [Create private public key pair locally] **********************************************************************************************************************************
TASK [Gathering Facts] *********************************************************************************************************************************************************
ok: [localhost]
TASK [host-provision : ssh-keygen | Creates .ssh directory in control node if it does not exist] *******************************************************************************
ok: [localhost]
TASK [host-provision : ssh-keygen | Create SSH key pair locally in control node] ***********************************************************************************************
ok: [localhost]
Enter customeradmin password:
PLAY [Create user and transfer public key to set up ssh equivalence] ***********************************************************************************************************
[WARNING]: sftp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
[WARNING]: scp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
TASK [Gathering Facts] *********************************************************************************************************************************************************
ok: [172.16.110.1]
TASK [Verify that Ansible on control node meets the version requirements] ******************************************************************************************************
ok: [172.16.110.1] => {
"changed": false,
"msg": "Ansible version is 2.10.8, continuing"
}
[WARNING]: sftp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
[WARNING]: scp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
TASK [host-provision : user-setup | Create ansible user] ***********************************************************************************************************************
changed: [172.16.110.1]
TASK [host-provision : user-setup | Slurp public key contents] *****************************************************************************************************************
ok: [172.16.110.1]
TASK [host-provision : user-setup | Store public key contents to be transferred from control node to DB hosts] ****************************************************************
ok: [172.16.110.1]
[WARNING]: sftp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
[WARNING]: scp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
TASK [host-provision : user-setup | Transfer public key from control node to DB hosts] *****************************************************************************************
changed: [172.16.110.1]
[WARNING]: sftp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
[WARNING]: scp transfer mechanism failed on [172.16.110.1]. Use ANSIBLE_DEBUG=1 to see detailed information
TASK [host-provision : user-setup | Add sudoers file for ansible] **************************************************************************************************************
changed: [172.16.110.1]
PLAY [Perform config tasks (SSH equivalence validation, LVM setup, etc)] *******************************************************************************************************
TASK [Gathering Facts] *********************************************************************************************************************************************************
ok: [172.16.110.1]
TASK [host-provision : config-tasks | Validate ssh equivalence (passwordless connection) and sudo escalation for new user] *****************************************************
ok: [172.16.110.1]
TASK [host-provision : config-tasks | Create LVM layer - vgcreate] *************************************************************************************************************
changed: [172.16.110.1]
TASK [host-provision : config-tasks | Create LVM layer - lvcreate] *************************************************************************************************************
changed: [172.16.110.1]
PLAY [Proxy setup [optional]] **************************************************************************************************************************************************
TASK [Gathering Facts] *********************************************************************************************************************************************************
ok: [172.16.110.1]
TASK [host-provision : proxy | Get control node IP] ****************************************************************************************************************************
ok: [172.16.110.1]
TASK [host-provision : proxy | Validate proxy connectivity via control node] ***************************************************************************************************
ok: [172.16.110.1]
TASK [host-provision : proxy | Add control node as gateway-instance to /etc/hosts] *********************************************************************************************
changed: [172.16.110.1]
TASK [host-provision : proxy | Add client side proxy environment variables to /etc/profile.d] **********************************************************************************
changed: [172.16.110.1]
TASK [host-provision : proxy | Update proxy in sudoers] ************************************************************************************************************************
changed: [172.16.110.1]
PLAY [Perform RHEL-specific config tasks (subscription-manager, etc)] **********************************************************************************************************
TASK [Gathering Facts] *********************************************************************************************************************************************************
ok: [172.16.110.1]
PLAY RECAP *********************************************************************************************************************************************************************
172.16.110.1 : ok=18 changed=8 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0
localhost : ok=3 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0
✔ ~/mydrive/bmaas/host_provisioning/bms-toolkit [host-provision|✚ 1…1]
14:12 $ ## Cool, now the proof of the pudding ! Running the toolkit
✔ ~/mydrive/bmaas/host_provisioning/bms-toolkit [host-provision|✚ 3…7]
14:09 $ runlocalssh ./install-oracle.sh --ora-swlib-bucket gs://bmaas-testing-oracle-software --instance-ssh-user ansible9 --instance-ssh-key ~/.ssh/id_rsa_bms_toolkit --instance-ssh-extra-args ''\''-o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o IdentityAgent=no -o IdentitiesOnly=true -o ProxyCommand="ssh -W %h:%p -q jcnarasimhan@control-node.mfild.com"'\''' --backup-dest "+RECO" --ora-swlib-path /u01/oracle_install --ora-version 19 --ora-swlib-type gcs --ora-asm-disks mntrl_asm_node1.json --ora-data-mounts mntrl_data_mounts_config.json --cluster-type NONE --ora-data-diskgroup DATA --ora-reco-diskgroup RECO --ora-db-name orcl --ora-db-container false --instance-ip-addr 172.16.110.1 --instance-hostname at-3793329-svr005 > mntrl-1.out.thegabba 2>&1
✔ ~/mydrive/bmaas/host_provisioning/bms-toolkit [host-provision|✚ 2…7]
14:50 $ ### That was successful !
################ THe log file is as:
✔ ~/DriveFS/My Drive/bmaas/host_provisioning/bms-toolkit [host-provision|✚ 2…7]
15:23 $ cat mntrl-1.out.thegabba
Command used:
/usr/local/google/home/jcnarasimhan/mydrive/bmaas/host_provisioning/bms-toolkit/install-oracle.sh --ora-swlib-bucket gs://bmaas-testing-oracle-software --instance-ssh-user ansible9 --instance-ssh-key /usr/local/google/home/jcnarasimhan/.ssh/id_rsa_bms_toolkit --instance-ssh-extra-args '-o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o IdentityAgent=no -o IdentitiesOnly=true -o ProxyCommand="ssh -W %h:%p -q jcnarasimhan@control-node.mfild.com"' --backup-dest +RECO --ora-swlib-path /u01/oracle_install --ora-version 19 --ora-swlib-type gcs --ora-asm-disks mntrl_asm_node1.json --ora-data-mounts mntrl_data_mounts_config.json --cluster-type NONE --ora-data-diskgroup DATA --ora-reco-diskgroup RECO --ora-db-name orcl --ora-db-container false --instance-ip-addr 172.16.110.1 --instance-hostname at-3793329-svr005
Inventory file for this execution: ./inventory_files/inventory_at-3793329-svr005_orcl.
Running with parameters from command line or environment variables:
ANSIBLE_DISPLAY_SKIPPED_HOSTS=false
ANSIBLE_LOG_PATH=./logs/log_at-3793329-svr005_orcl_20211124_141135.log
ARCHIVE_BACKUP_MIN=30
ARCHIVE_ONLINE_DAYS=7
ARCHIVE_REDUNDANCY=2
BACKUP_DEST=+RECO
BACKUP_LEVEL0_DAYS=0
BACKUP_LEVEL1_DAYS=1-6
BACKUP_LOG_LOCATION=/home/oracle/logs
BACKUP_REDUNDANCY=2
BACKUP_SCRIPT_LOCATION=/home/oracle/scripts
BACKUP_START_HOUR=01
BACKUP_START_MIN=00
CLUSTER_CONFIG=cluster_config.json
CLUSTER_TYPE=NONE
INSTANCE_HOSTGROUP_NAME=dbasm
INSTANCE_HOSTNAME=at-3793329-svr005
INSTANCE_IP_ADDR=172.16.110.1
INSTANCE_SSH_EXTRA_ARGS=''\''-o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o IdentityAgent=no -o IdentitiesOnly=true -o ProxyCommand="ssh -W %h:%p -q jcnarasimhan@control-node.mfild.com"'\'''
INSTANCE_SSH_KEY=/usr/local/google/home/jcnarasimhan/.ssh/id_rsa_bms_toolkit
INSTANCE_SSH_USER=ansible9
ORA_ASM_DISKS=mntrl_asm_node1.json
ORA_DATA_DISKGROUP=DATA
ORA_DATA_MOUNTS=mntrl_data_mounts_config.json
ORA_DB_CHARSET=AL32UTF8
ORA_DB_CONTAINER=false
ORA_DB_DOMAIN=
ORA_DB_NAME=orcl
ORA_DB_NCHARSET=AL16UTF16
ORA_DB_TYPE=MULTIPURPOSE
ORA_DISK_MGMT=UDEV
ORA_EDITION=EE
ORA_LISTENER_NAME=LISTENER
ORA_LISTENER_PORT=1521
ORA_PDB_COUNT=1
ORA_PDB_NAME_PREFIX=PDB
ORA_RECO_DISKGROUP=RECO
ORA_REDO_LOG_SIZE=100MB
ORA_RELEASE=latest
ORA_ROLE_SEPARATION=TRUE
ORA_STAGING=/u01/oracle_install
ORA_SWLIB_BUCKET=gs://bmaas-testing-oracle-software
ORA_SWLIB_CREDENTIALS=
ORA_SWLIB_PATH=/u01/oracle_install
ORA_SWLIB_TYPE=gcs
ORA_VERSION=19.3.0.0.0
PB_CHECK_INSTANCE=check-instance.yml
PB_CONFIG_DB=config-db.yml
PB_CONFIG_RAC_DB=config-rac-db.yml
PB_INSTALL_SW=install-sw.yml
PB_LIST='check-instance.yml prep-host.yml install-sw.yml config-db.yml'
PB_PREP_HOST=prep-host.yml
PRIMARY_IP_ADDR=
Ansible params:
Found Ansible at /usr/bin/ansible-playbook
Running Ansible playbook: /usr/bin/ansible-playbook -i ./inventory_files/inventory_at-3793329-svr005_orcl check-instance.yml
PLAY [dbasm] *******************************************************************
TASK [Verify that Ansible on control node meets the version requirements] ******
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "Ansible version is 2.10.8, continuing"
}
TASK [Confirm JSON parsing works] **********************************************
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "All assertions passed"
}
TASK [Test connectivity to target instance via ping] ***************************
ok: [at-3793329-svr005]
TASK [Abort if ping module fails] **********************************************
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "The instance has an usable python installation, continuing"
}
TASK [Collect facts from target] ***********************************************
ok: [at-3793329-svr005]
TASK [Test privilege escalation on target] *************************************
ok: [at-3793329-svr005]
TASK [Fail if unable to sudo to root on target] ********************************
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "The account ansible9 used to connect has sudo root privileges, continuing"
}
TASK [Check for Python installation] *******************************************
ok: [at-3793329-svr005]
PLAY RECAP *********************************************************************
at-3793329-svr005 : ok=8 changed=0 unreachable=0 failed=0 skipped=3 rescued=0 ignored=0
Running Ansible playbook: /usr/bin/ansible-playbook -i ./inventory_files/inventory_at-3793329-svr005_orcl prep-host.yml
PLAY [Populate variables] ******************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [common : populate-vars | Resolve software release] ***********************
ok: [at-3793329-svr005] => (item=19.3.1.0.0)
ok: [at-3793329-svr005] => (item=19.4.0.0.190716)
ok: [at-3793329-svr005] => (item=19.5.0.0.191015)
ok: [at-3793329-svr005] => (item=19.6.0.0.200114)
ok: [at-3793329-svr005] => (item=19.7.0.0.200414)
ok: [at-3793329-svr005] => (item=19.8.0.0.200714)
ok: [at-3793329-svr005] => (item=19.9.0.0.201020)
TASK [common : populate-vars | Set base if no release found] *******************
ok: [at-3793329-svr005]
TASK [common : populate-vars | Show resolved release] **************************
ok: [at-3793329-svr005] => {
"oracle_rel": "19.9.0.0.201020"
}
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [Verify that Ansible on control node meets the version requirements] ******
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "Ansible version is 2.10.8, continuing"
}
TASK [base-provision : Validate OS family and version] *************************
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "All assertions passed"
}
TASK [base-provision : Validate architecture] **********************************
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "All assertions passed"
}
TASK [base-provision : Ensure yum is not running, send Ctrl-C if it is] ********
changed: [at-3793329-svr005]
TASK [base-provision : Remove chrony package] **********************************
ok: [at-3793329-svr005]
TASK [base-provision : Remove chrony rpmsave] **********************************
ok: [at-3793329-svr005]
TASK [base-provision : Install required base OS packages] **********************
ok: [at-3793329-svr005]
TASK [base-provision : Update OPTIONS in /etc/sysconfig/ntpd] ******************
ok: [at-3793329-svr005]
TASK [base-provision : Add ntp preferred server] *******************************
ok: [at-3793329-svr005]
TASK [base-provision : Make sure ntp is running] *******************************
ok: [at-3793329-svr005]
TASK [base-provision : Remove all 127.0.0.1 lines from /etc/hosts] *************
changed: [at-3793329-svr005]
TASK [base-provision : Add fqdn to /etc/hosts if needed] ***********************
ok: [at-3793329-svr005]
TASK [base-provision : Add localhost to /etc/hosts if needed] ******************
changed: [at-3793329-svr005]
TASK [host-storage : Add filesystem on Oracle user mount LV devices] ***********
changed: [at-3793329-svr005] => (item={'purpose': 'software', 'blk_device': '/dev/mapper/db-sw', 'name': 'u01', 'fstype': 'xfs', 'mount_point': '/u01', 'mount_opts': 'defaults'})
TASK [host-storage : Mount Oracle user mount LV devices] ***********************
changed: [at-3793329-svr005] => (item={'purpose': 'software', 'blk_device': '/dev/mapper/db-sw', 'name': 'u01', 'fstype': 'xfs', 'mount_point': '/u01', 'mount_opts': 'defaults'})
TASK [hugepages : get shmmax from sysctl if any] *******************************
ok: [at-3793329-svr005]
TASK [hugepages : get shmall from sysctl if any] *******************************
ok: [at-3793329-svr005]
TASK [hugepages : get shmmni from sysctl if any] *******************************
ok: [at-3793329-svr005]
TASK [hugepages : get shmmni from memory if not configured in sysctl] **********
ok: [at-3793329-svr005]
TASK [hugepages : get Hugepagesize from memory] ********************************
ok: [at-3793329-svr005]
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"ansible_memory_mb.real.total": "770467"
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmax_sysctl.stdout_lines": [
"525130583244"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmax.stdout_lines": "VARIABLE IS NOT DEFINED!"
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmall_sysctl.stdout_lines": [
"128205709"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmall.stdout_lines": "VARIABLE IS NOT DEFINED!"
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmni_sysctl.stdout_lines": [
"4096"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmni.stdout_lines": [
"4096"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_Hugepagesize.stdout_lines": [
"2048"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"ram_pct_used": 65
}
TASK [hugepages : configure memlock limits] ************************************
ok: [at-3793329-svr005] => (item=soft)
ok: [at-3793329-svr005] => (item=hard)
TASK [hugepages : adjust shmmni,shmall and hugepages if shmmax is already set according recommendations] ***
ok: [at-3793329-svr005] => (item={'name': 'kernel.shmall', 'value': '128205709'})
ok: [at-3793329-svr005] => (item={'name': 'kernel.shmmni', 'value': '4096'})
ok: [at-3793329-svr005] => (item={'name': 'vm.nr_hugepages', 'value': '250401'})
TASK [hugepages : Check transparent hugepage] **********************************
ok: [at-3793329-svr005]
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"checkTPH": {
"changed": false,
"cmd": "( cat /sys/kernel/mm/transparent_hugepage/enabled ) || true",
"delta": "0:00:00.002243",
"end": "2021-11-24 14:13:15.444818",
"failed": false,
"rc": 0,
"start": "2021-11-24 14:13:15.442575",
"stderr": "",
"stderr_lines": [],
"stdout": "always madvise [never]",
"stdout_lines": [
"always madvise [never]"
]
}
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"grubbyTPH": {
"changed": false,
"skip_reason": "Conditional result was False",
"skipped": true
}
}
TASK [hugepages : Check if THP shows as used and recommend reboot if AnonHugePages in /proc/meminfo is nonzero] ***
ok: [at-3793329-svr005]
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"msg": "WARNING: A reboot is required to disable transparent huge pages"
}
TASK [ora-host : Disable selinux (permanently)] ********************************
[WARNING]: SELinux state change will take effect next reboot
ok: [at-3793329-svr005]
TASK [ora-host : Disable selinux (runtime)] ************************************
changed: [at-3793329-svr005]
TASK [ora-host : Ensure NOZEROCONF=yes is in /etc/sysconfig/network] ***********
ok: [at-3793329-svr005]
TASK [ora-host : Ensure /dev/shm is present in /etc/fstab] *********************
ok: [at-3793329-svr005]
TASK [ora-host : Stat RHEL7 base repo] *****************************************
ok: [at-3793329-svr005]
TASK [ora-host : Stat RHEL7 rhui repo] *****************************************
ok: [at-3793329-svr005]
TASK [ora-host : Stat OL7 repo] ************************************************
ok: [at-3793329-svr005]
TASK [ora-host : Install Oracle required packages (base/non-rhui config) for OEL7] ***
ok: [at-3793329-svr005]
TASK [ora-host : Add OS groups] ************************************************
changed: [at-3793329-svr005] => (item={'group': 'oinstall', 'gid': 801})
changed: [at-3793329-svr005] => (item={'group': 'dba', 'gid': 802})
changed: [at-3793329-svr005] => (item={'group': 'oper', 'gid': 803})
changed: [at-3793329-svr005] => (item={'group': 'backupdba', 'gid': 804})
changed: [at-3793329-svr005] => (item={'group': 'dgdba', 'gid': 805})
changed: [at-3793329-svr005] => (item={'group': 'kmdba', 'gid': 806})
changed: [at-3793329-svr005] => (item={'group': 'racdba', 'gid': 810})
changed: [at-3793329-svr005] => (item={'group': 'asmdba', 'gid': 807})
changed: [at-3793329-svr005] => (item={'group': 'asmoper', 'gid': 808})
changed: [at-3793329-svr005] => (item={'group': 'asmadmin', 'gid': 809})
TASK [ora-host : Add OS users] *************************************************
changed: [at-3793329-svr005] => (item={'name': 'oracle', 'comment': '', 'uid': 801, 'group': 'oinstall'})
changed: [at-3793329-svr005] => (item={'name': 'grid', 'comment': '', 'uid': 802, 'group': 'oinstall'})
TASK [ora-host : Add necessary groups to grid user] ****************************
changed: [at-3793329-svr005] => (item={'group': 'asmdba', 'gid': 807})
changed: [at-3793329-svr005] => (item={'group': 'asmoper', 'gid': 808})
changed: [at-3793329-svr005] => (item={'group': 'asmadmin', 'gid': 809})
changed: [at-3793329-svr005] => (item={'group': 'dba', 'gid': 802})
TASK [ora-host : Add necessary groups to the oracle user] **********************
changed: [at-3793329-svr005] => (item={'group': 'oinstall', 'gid': 801})
changed: [at-3793329-svr005] => (item={'group': 'dba', 'gid': 802})
changed: [at-3793329-svr005] => (item={'group': 'oper', 'gid': 803})
changed: [at-3793329-svr005] => (item={'group': 'backupdba', 'gid': 804})
changed: [at-3793329-svr005] => (item={'group': 'dgdba', 'gid': 805})
changed: [at-3793329-svr005] => (item={'group': 'kmdba', 'gid': 806})
changed: [at-3793329-svr005] => (item={'group': 'racdba', 'gid': 810})
changed: [at-3793329-svr005] => (item={'group': 'asmdba', 'gid': 807})
changed: [at-3793329-svr005] => (item={'group': 'asmadmin', 'gid': 809})
TASK [ora-host : Add sysctl entries] *******************************************
ok: [at-3793329-svr005] => (item={'name': 'fs.aio-max-nr', 'value': '1048576'})
ok: [at-3793329-svr005] => (item={'name': 'fs.file-max', 'value': '6815744'})
ok: [at-3793329-svr005] => (item={'name': 'kernel.panic_on_oops', 'value': '1'})
ok: [at-3793329-svr005] => (item={'name': 'kernel.sem', 'value': '250 32000 100 128'})
ok: [at-3793329-svr005] => (item={'name': 'net.ipv4.ip_local_port_range', 'value': '9000 65500'})
ok: [at-3793329-svr005] => (item={'name': 'net.core.rmem_default', 'value': '262144'})
ok: [at-3793329-svr005] => (item={'name': 'net.core.rmem_max', 'value': '4194304'})
ok: [at-3793329-svr005] => (item={'name': 'net.core.wmem_default', 'value': '262144'})
ok: [at-3793329-svr005] => (item={'name': 'net.core.wmem_max', 'value': '1048586'})
TASK [ora-host : Adjust kernel limits for users] *******************************
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'nofile', 'type': 'soft', 'value': '1024'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'nofile', 'type': 'hard', 'value': '65536'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'nproc', 'type': 'soft', 'value': '2047'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'nproc', 'type': 'hard', 'value': '16384'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'stack', 'type': 'soft', 'value': '10240'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'stack', 'type': 'hard', 'value': '32768'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'memlock', 'type': 'soft', 'value': 'unlimited'}])
ok: [at-3793329-svr005] => (item=['oracle', {'name': 'memlock', 'type': 'hard', 'value': 'unlimited'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'nofile', 'type': 'soft', 'value': '1024'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'nofile', 'type': 'hard', 'value': '65536'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'nproc', 'type': 'soft', 'value': '2047'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'nproc', 'type': 'hard', 'value': '16384'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'stack', 'type': 'soft', 'value': '10240'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'stack', 'type': 'hard', 'value': '32768'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'memlock', 'type': 'soft', 'value': 'unlimited'}])
ok: [at-3793329-svr005] => (item=['grid', {'name': 'memlock', 'type': 'hard', 'value': 'unlimited'}])
TASK [ora-host : Create required directories] **********************************
changed: [at-3793329-svr005] => (item={'name': '/u01/oracle_install', 'owner': 'oracle', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
changed: [at-3793329-svr005] => (item={'name': '/u01/app/oracle', 'owner': 'oracle', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
changed: [at-3793329-svr005] => (item={'name': '/u01/app/oraInventory', 'owner': 'grid', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
changed: [at-3793329-svr005] => (item={'name': '/u01/app/oracle/product/19.3.0/dbhome_1', 'owner': 'oracle', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
changed: [at-3793329-svr005] => (item={'name': '/home/oracle/.ansible/tmp', 'owner': 'oracle', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
changed: [at-3793329-svr005] => (item={'name': '/u01/app/19.3.0/grid', 'owner': 'grid', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
changed: [at-3793329-svr005] => (item={'name': '/home/grid/.ansible/tmp', 'owner': 'grid', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
TASK [ora-host : Check ASM backup destination] *********************************
ok: [at-3793329-svr005]
TASK [ora-host : tmp file configuration] ***************************************
ok: [at-3793329-svr005] => (item=x /var/tmp/.oracle)
ok: [at-3793329-svr005] => (item=x /tmp/.oracle)
ok: [at-3793329-svr005] => (item=x /usr/tmp/.oracle)
TASK [ora-host : Set RemoveIPC=no in /etc/systemd/logind.conf (MOS Doc ID 2081410.1)] ***
ok: [at-3793329-svr005]
TASK [ora-host : Append database variables to bash_profile] ********************
changed: [at-3793329-svr005]
TASK [ora-host : Append GI variables to bash_profile] **************************
changed: [at-3793329-svr005]
TASK [ora-host : (asmlib) | ASM device managment via asmlib or udev?] **********
ok: [at-3793329-svr005] => {
"msg": "asm_disk_management is set to udev"
}
TASK [ora-host : Collect new disk facts] ***************************************
ok: [at-3793329-svr005]
TASK [ora-host : (debug) asm disk configuration] *******************************
ok: [at-3793329-svr005] => {
"msg": [
"asm_disks [{'diskgroup': 'DATA', 'disks': [{'name': 'DATA_3161313547', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313547'}, {'name': 'DATA_3161313548', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313548'}, {'name': 'DATA_3161313549', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313549'}, {'name': 'DATA_316131354A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354a'}, {'name': 'DATA_316131354B', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354b'}, {'name': 'DATA_316131354C', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354c'}, {'name': 'DATA_316131354D', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354d'}, {'name': 'DATA_316131354E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354e'}, {'name': 'DATA_3161313439', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313439'}, {'name': 'DATA_3161313441', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313441'}, {'name': 'DATA_3161313443', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313443'}, {'name': 'DATA_3161313445', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313445'}, {'name': 'DATA_3161313447', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313447'}, {'name': 'DATA_316131344A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344a'}, {'name': 'DATA_316131344E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344e'}]}, {'diskgroup': 'RECO', 'disks': [{'name': 'RECO_316131354F', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354f'}, {'name': 'RECO_3161313550', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313550'}, {'name': 'RECO_3161313551', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313551'}, {'name': 'RECO_3161313552', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313552'}, {'name': 'RECO_3161313456', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313456'}, {'name': 'RECO_316131345A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131345a'}, {'name': 'RECO_3161313464', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313464'}, {'name': 'RECO_3161313469', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313469'}]}]",
"asm_def_file mntrl_asm_node1.json",
"asm_disk_input [{'diskgroup': 'DATA', 'disks': [{'name': 'DATA_3161313547', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313547'}, {'name': 'DATA_3161313548', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313548'}, {'name': 'DATA_3161313549', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313549'}, {'name': 'DATA_316131354A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354a'}, {'name': 'DATA_316131354B', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354b'}, {'name': 'DATA_316131354C', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354c'}, {'name': 'DATA_316131354D', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354d'}, {'name': 'DATA_316131354E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354e'}, {'name': 'DATA_3161313439', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313439'}, {'name': 'DATA_3161313441', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313441'}, {'name': 'DATA_3161313443', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313443'}, {'name': 'DATA_3161313445', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313445'}, {'name': 'DATA_3161313447', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313447'}, {'name': 'DATA_316131344A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344a'}, {'name': 'DATA_316131344E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344e'}]}, {'diskgroup': 'RECO', 'disks': [{'name': 'RECO_316131354F', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354f'}, {'name': 'RECO_3161313550', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313550'}, {'name': 'RECO_3161313551', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313551'}, {'name': 'RECO_3161313552', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313552'}, {'name': 'RECO_3161313456', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313456'}, {'name': 'RECO_316131345A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131345a'}, {'name': 'RECO_3161313464', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313464'}, {'name': 'RECO_3161313469', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313469'}]}]"
]
}
TASK [ora-host : (udev) Add ASM mpath disk rules on BM (udevadm info)] *********
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313547', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313547'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313548', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313548'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313549', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313549'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354a'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354B', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354b'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354C', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354c'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354D', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354d'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354e'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313439', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313439'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313441', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313441'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313443', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313443'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313445', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313445'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313447', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313447'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131344A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344a'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131344E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344e'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_316131354F', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354f'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313550', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313550'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313551', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313551'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313552', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313552'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313456', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313456'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_316131345A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131345a'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313464', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313464'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313469', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313469'}])
TASK [ora-host : (udev) Add ASM mpath disk rules on BM (init dict)] ************
ok: [at-3793329-svr005]
TASK [ora-host : (udev) Add ASM mpath disk rules on BM (filling dict)] *********
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:07.598063', 'stdout': 'mpath-3600a09803831444a685d513161313547', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313547 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:07.592910', 'stderr': '', 'delta': '0:00:00.005153', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313547 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313547'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313547', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313547'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:10.677458', 'stdout': 'mpath-3600a09803831444a685d513161313548', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313548 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:10.672389', 'stderr': '', 'delta': '0:00:00.005069', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313548 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313548'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313548', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313548'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:13.694951', 'stdout': 'mpath-3600a09803831444a685d513161313549', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313549 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:13.689842', 'stderr': '', 'delta': '0:00:00.005109', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313549 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313549'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313549', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313549'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:16.711410', 'stdout': 'mpath-3600a09803831444a685d51316131354a', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354a | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:16.706266', 'stderr': '', 'delta': '0:00:00.005144', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354a | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131354a'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131354A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354a'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:19.753016', 'stdout': 'mpath-3600a09803831444a685d51316131354b', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354b | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:19.747831', 'stderr': '', 'delta': '0:00:00.005185', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354b | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131354b'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131354B', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354b'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:22.759168', 'stdout': 'mpath-3600a09803831444a685d51316131354c', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354c | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:22.753989', 'stderr': '', 'delta': '0:00:00.005179', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354c | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131354c'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131354C', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354c'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:25.793356', 'stdout': 'mpath-3600a09803831444a685d51316131354d', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354d | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:25.788261', 'stderr': '', 'delta': '0:00:00.005095', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354d | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131354d'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131354D', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354d'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:28.846920', 'stdout': 'mpath-3600a09803831444a685d51316131354e', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354e | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:28.841851', 'stderr': '', 'delta': '0:00:00.005069', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354e | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131354e'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131354E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354e'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:31.924512', 'stdout': 'mpath-3600a09803831444a685d513161313439', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313439 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:31.919373', 'stderr': '', 'delta': '0:00:00.005139', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313439 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313439'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313439', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313439'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:35.008345', 'stdout': 'mpath-3600a09803831444a685d513161313441', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313441 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:35.003204', 'stderr': '', 'delta': '0:00:00.005141', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313441 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313441'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313441', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313441'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:38.045294', 'stdout': 'mpath-3600a09803831444a685d513161313443', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313443 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:38.040037', 'stderr': '', 'delta': '0:00:00.005257', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313443 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313443'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313443', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313443'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:41.068014', 'stdout': 'mpath-3600a09803831444a685d513161313445', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313445 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:41.062912', 'stderr': '', 'delta': '0:00:00.005102', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313445 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313445'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313445', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313445'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:44.098966', 'stdout': 'mpath-3600a09803831444a685d513161313447', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313447 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:44.093831', 'stderr': '', 'delta': '0:00:00.005135', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313447 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313447'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_3161313447', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313447'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:47.084721', 'stdout': 'mpath-3600a09803831444a685d51316131344a', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131344a | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:47.079539', 'stderr': '', 'delta': '0:00:00.005182', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131344a | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131344a'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131344A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344a'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:50.115640', 'stdout': 'mpath-3600a09803831444a685d51316131344e', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131344e | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:50.110439', 'stderr': '', 'delta': '0:00:00.005201', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131344e | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131344e'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'DATA'}, {'name': 'DATA_316131344E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344e'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:53.166836', 'stdout': 'mpath-3600a09803831444a685d51316131354f', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354f | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:53.161638', 'stderr': '', 'delta': '0:00:00.005198', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131354f | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131354f'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_316131354F', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354f'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:56.281188', 'stdout': 'mpath-3600a09803831444a685d513161313550', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313550 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:56.276040', 'stderr': '', 'delta': '0:00:00.005148', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313550 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313550'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_3161313550', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313550'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:17:59.414709', 'stdout': 'mpath-3600a09803831444a685d513161313551', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313551 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:17:59.409524', 'stderr': '', 'delta': '0:00:00.005185', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313551 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313551'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_3161313551', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313551'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:18:02.435810', 'stdout': 'mpath-3600a09803831444a685d513161313552', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313552 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:18:02.430638', 'stderr': '', 'delta': '0:00:00.005172', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313552 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313552'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_3161313552', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313552'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:18:05.446287', 'stdout': 'mpath-3600a09803831444a685d513161313456', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313456 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:18:05.441121', 'stderr': '', 'delta': '0:00:00.005166', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313456 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313456'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_3161313456', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313456'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:18:08.508434', 'stdout': 'mpath-3600a09803831444a685d51316131345a', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131345a | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:18:08.503304', 'stderr': '', 'delta': '0:00:00.005130', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d51316131345a | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d51316131345a'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_316131345A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131345a'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:18:11.528884', 'stdout': 'mpath-3600a09803831444a685d513161313464', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313464 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:18:11.523653', 'stderr': '', 'delta': '0:00:00.005231', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313464 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313464'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_3161313464', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313464'}], 'ansible_loop_var': 'item'})
ok: [at-3793329-svr005] => (item={'changed': True, 'end': '2021-11-24 14:18:14.541719', 'stdout': 'mpath-3600a09803831444a685d513161313469', 'cmd': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313469 | grep DM_UUID | awk -F'=' '{print $2}'", 'rc': 0, 'start': '2021-11-24 14:18:14.536490', 'stderr': '', 'delta': '0:00:00.005229', 'invocation': {'module_args': {'creates': None, 'executable': None, '_uses_shell': True, 'strip_empty_ends': True, '_raw_params': "udevadm info --query=all --name=/dev/mapper/3600a09803831444a685d513161313469 | grep DM_UUID | awk -F'=' '{print $2}'", 'removes': None, 'argv': None, 'warn': True, 'chdir': None, 'stdin_add_newline': True, 'stdin': None}}, 'stdout_lines': ['mpath-3600a09803831444a685d513161313469'], 'stderr_lines': [], 'failed': False, 'item': [{'diskgroup': 'RECO'}, {'name': 'RECO_3161313469', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313469'}], 'ansible_loop_var': 'item'})
TASK [ora-host : (udev) Add ASM mpath disk rules on BM (udev rules file)] ******
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313547)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313548)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313549)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131354a)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131354b)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131354c)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131354d)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131354e)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313439)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313441)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313443)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313445)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313447)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131344a)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131344e)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131354f)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313550)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313551)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313552)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313456)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d51316131345a)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313464)
changed: [at-3793329-svr005] => (item=mpath-3600a09803831444a685d513161313469)
TASK [ora-host : (udev) reload rules] ******************************************
changed: [at-3793329-svr005]
TASK [hugepages : get shmmax from sysctl if any] *******************************
ok: [at-3793329-svr005]
TASK [hugepages : get shmall from sysctl if any] *******************************
ok: [at-3793329-svr005]
TASK [hugepages : get shmmni from sysctl if any] *******************************
ok: [at-3793329-svr005]
TASK [hugepages : get shmmni from memory if not configured in sysctl] **********
ok: [at-3793329-svr005]
TASK [hugepages : get Hugepagesize from memory] ********************************
ok: [at-3793329-svr005]
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"ansible_memory_mb.real.total": "770467"
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmax_sysctl.stdout_lines": [
"525130583244"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmax.stdout_lines": "VARIABLE IS NOT DEFINED!"
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmall_sysctl.stdout_lines": [
"128205709"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmall.stdout_lines": "VARIABLE IS NOT DEFINED!"
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmni_sysctl.stdout_lines": [
"4096"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_shmmni.stdout_lines": [
"4096"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"v_Hugepagesize.stdout_lines": [
"2048"
]
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"ram_pct_used": 65
}
TASK [hugepages : configure memlock limits] ************************************
ok: [at-3793329-svr005] => (item=soft)
ok: [at-3793329-svr005] => (item=hard)
TASK [hugepages : adjust shmmni,shmall and hugepages if shmmax is already set according recommendations] ***
ok: [at-3793329-svr005] => (item={'name': 'kernel.shmall', 'value': '128205709'})
ok: [at-3793329-svr005] => (item={'name': 'kernel.shmmni', 'value': '4096'})
ok: [at-3793329-svr005] => (item={'name': 'vm.nr_hugepages', 'value': '250401'})
TASK [hugepages : Check transparent hugepage] **********************************
ok: [at-3793329-svr005]
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"checkTPH": {
"changed": false,
"cmd": "( cat /sys/kernel/mm/transparent_hugepage/enabled ) || true",
"delta": "0:00:00.002211",
"end": "2021-11-24 14:20:08.456831",
"failed": false,
"rc": 0,
"start": "2021-11-24 14:20:08.454620",
"stderr": "",
"stderr_lines": [],
"stdout": "always madvise [never]",
"stdout_lines": [
"always madvise [never]"
]
}
}
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"grubbyTPH": {
"changed": false,
"skip_reason": "Conditional result was False",
"skipped": true
}
}
TASK [hugepages : Check if THP shows as used and recommend reboot if AnonHugePages in /proc/meminfo is nonzero] ***
ok: [at-3793329-svr005]
TASK [hugepages : debug] *******************************************************
ok: [at-3793329-svr005] => {
"msg": "WARNING: A reboot is required to disable transparent huge pages"
}
PLAY [dbasm[0]] ****************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [swlib : swlib | Create swlib folder] *************************************
changed: [at-3793329-svr005]
included: /usr/local/google/home/jcnarasimhan/DriveFS/My Drive/bmaas/host_provisioning/bms-toolkit/roles/swlib/tasks/gcscopy.yml for at-3793329-svr005
TASK [swlib : gcscopy | Copy GI software from GCS to target instance] **********
changed: [at-3793329-svr005] => (item={'name': '19c_gi', 'version': '19.3.0.0.0', 'files': ['V982068-01.zip'], 'sha256sum': ['D668002664D9399CF61EB03C0D1E3687121FC890B1DDD50B35DCBE13C5307D2E'], 'md5sum': ['t8TGb4AfktFPqg15HM2nIQ==']})
TASK [swlib : gcscopy | Copy GI patches from GCS to target instance] ***********
changed: [at-3793329-svr005] => (item={'category': 'RU', 'base': '19.3.0.0.0', 'release': '19.9.0.0.201020', 'patchnum': '31720429', 'patchfile': 'p31720429_190000_Linux-x86-64.zip', 'patch_subdir': '/31750108', 'prereq_check': False, 'method': 'opatchauto apply', 'ocm': False, 'upgrade': False, 'md5sum': 'tTZDYSasdnt7lrNJ/MYm1g=='})
TASK [swlib : gcscopy | Copy GI OPatch update files from GCS to target instance] ***
changed: [at-3793329-svr005] => (item={'category': 'OPatch', 'release': '19.3.0.0.0', 'patchnum': '6880880', 'patchfile': 'p6880880_190000_Linux-x86-64.zip', 'md5sum': ''})
TASK [swlib : gcscopy | Copy RDBMS software from GCS to target instance] *******
changed: [at-3793329-svr005] => (item={'name': '19c_base', 'version': '19.3.0.0.0', 'edition': ['EE', 'SE2'], 'files': ['V982063-01.zip'], 'sha256sum': ['BA8329C757133DA313ED3B6D7F86C5AC42CD9970A28BF2E6233F3235233AA8D8'], 'md5sum': ['GFi9DSgcYPTdq9h7HCFKTw==']})
TASK [swlib : gcscopy | Copy RDBMS patches from GCS to target instance] ********
ok: [at-3793329-svr005] => (item={'category': 'RU_Combo', 'base': '19.3.0.0.0', 'release': '19.9.0.0.201020', 'patchnum': '31720429', 'patchfile': 'p31720429_190000_Linux-x86-64.zip', 'patch_subdir': '/31668882', 'prereq_check': True, 'method': 'opatch apply', 'ocm': False, 'upgrade': True, 'md5sum': 'tTZDYSasdnt7lrNJ/MYm1g=='})
PLAY RECAP *********************************************************************
at-3793329-svr005 : ok=98 changed=21 unreachable=0 failed=0 skipped=37 rescued=0 ignored=0
Running Ansible playbook: /usr/bin/ansible-playbook -i ./inventory_files/inventory_at-3793329-svr005_orcl install-sw.yml
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [Verify that Ansible on control node meets the version requirements] ******
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "Ansible version is 2.10.8, continuing"
}
TASK [gi-setup : Check if software is already installed] ***********************
ok: [at-3793329-svr005]
TASK [gi-setup : OH Confirmation] **********************************************
ok: [at-3793329-svr005] => {
"msg": "Installing GRID_HOME - /u01/app/19.3.0/grid"
}
included: /usr/local/google/home/jcnarasimhan/DriveFS/My Drive/bmaas/host_provisioning/bms-toolkit/roles/gi-setup/tasks/gi-install.yml for at-3793329-svr005 => (item={'name': '19c_gi', 'version': '19.3.0.0.0', 'files': ['V982068-01.zip'], 'sha256sum': ['D668002664D9399CF61EB03C0D1E3687121FC890B1DDD50B35DCBE13C5307D2E'], 'md5sum': ['t8TGb4AfktFPqg15HM2nIQ==']})
TASK [gi-setup : gi-install | Set facts] ***************************************
ok: [at-3793329-svr005]
TASK [gi-setup : gi-install | Installer confirmations] *************************
ok: [at-3793329-svr005] => {
"msg": [
"Installing from file : ['V982068-01.zip']",
"Unzipping into dir : /u01/app/19.3.0/grid",
"Using cluvfy cmd : /u01/app/19.3.0/grid/runcluvfy.sh stage -pre hacfg -verbose"
]
}
TASK [gi-setup : gi-install | Unzipping GI software] ***************************
changed: [at-3793329-svr005] => (item=V982068-01.zip)
TASK [gi-setup : gi-install | Find the cvuqdisk RPM] ***************************
ok: [at-3793329-svr005]
TASK [gi-setup : gi-install | Install the cvuqdisk RPM] ************************
ok: [at-3793329-svr005]
TASK [gi-setup : gi-install | Create GI response file script] ******************
changed: [at-3793329-svr005]
TASK [gi-setup : gi-install | Run GI response file script] *********************
changed: [at-3793329-svr005]
TASK [gi-setup : gi-install | Script cleanup] **********************************
changed: [at-3793329-svr005]
TASK [gi-setup : gi-install | Set mgmtdb option] *******************************
ok: [at-3793329-svr005]
TASK [gi-setup : gi-install | Set installer command] ***************************
ok: [at-3793329-svr005]
TASK [gi-setup : gi-install | Update GI OPatch] ********************************
changed: [at-3793329-svr005] => (item={'category': 'OPatch', 'release': '19.3.0.0.0', 'patchnum': '6880880', 'patchfile': 'p6880880_190000_Linux-x86-64.zip', 'md5sum': ''})
TASK [gi-setup : gi-install | Information] *************************************
ok: [at-3793329-svr005] => {
"msg": "Using installer cmd: /u01/app/19.3.0/grid/gridSetup.sh -ignorePrereqFailure -silent -responseFile /u01/oracle_install/grid_install.rsp -J-Doracle.install.mgmtDB=false -J-Doracle.install.mgmtDB.CDB=false -J-Doracle.install.crs.enableRemoteGIMR=false"
}
TASK [gi-setup : gi-install | Run installer] ***********************************
changed: [at-3793329-svr005]
TASK [gi-setup : gi-install | Installer output] ********************************
ok: [at-3793329-svr005] => {
"msg": [
[
"/u01/app/19.3.0/grid/gridSetup.sh",
"-ignorePrereqFailure",
"-silent",
"-responseFile",
"/u01/oracle_install/grid_install.rsp",
"-J-Doracle.install.mgmtDB=false",
"-J-Doracle.install.mgmtDB.CDB=false",
"-J-Doracle.install.crs.enableRemoteGIMR=false"
],
[
"Launching Oracle Grid Infrastructure Setup Wizard...",
"",
"The response file for this session can be found at:",
" /u01/app/19.3.0/grid/install/response/grid_2021-11-24_02-32-08PM.rsp",
"",
"You can find the log of this install session at:",
" /tmp/GridSetupActions2021-11-24_02-32-08PM/gridSetupActions2021-11-24_02-32-08PM.log",
"",
"As a root user, execute the following script(s):",
"\t1. /u01/app/oraInventory/orainstRoot.sh",
"\t2. /u01/app/19.3.0/grid/root.sh",
"",
"Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: ",
"[at-3793329-svr005]",
"Execute /u01/app/19.3.0/grid/root.sh on the following nodes: ",
"[at-3793329-svr005]",
"",
"",
"Successfully Setup Software.",
"Moved the install session logs to:",
" /u01/app/oraInventory/logs/GridSetupActions2021-11-24_02-32-08PM"
]
]
}
TASK [gi-setup : gi-install | Run script orainstRoot.sh] ***********************
changed: [at-3793329-svr005]
TASK [gi-setup : gi-install | Run script root.sh] ******************************
changed: [at-3793329-svr005]
TASK [gi-setup : gi-install | Complete plugin configuration] *******************
changed: [at-3793329-svr005]
TASK [gi-setup : Configure HAS] ************************************************
changed: [at-3793329-svr005]
TASK [gi-setup : Check ASM status] *********************************************
ok: [at-3793329-svr005]
included: /usr/local/google/home/jcnarasimhan/DriveFS/My Drive/bmaas/host_provisioning/bms-toolkit/roles/gi-setup/tasks/asm-create.yml for at-3793329-svr005
TASK [gi-setup : asm-create | Create ASM initialization file] ******************
changed: [at-3793329-svr005]
TASK [gi-setup : asm-create | Change ASM LV permissions] ***********************
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313547', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313547'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313548', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313548'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313549', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313549'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354a'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354B', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354b'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354C', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354c'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354D', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354d'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131354E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354e'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313439', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313439'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313441', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313441'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313443', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313443'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313445', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313445'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_3161313447', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313447'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131344A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344a'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'DATA'}, {'name': 'DATA_316131344E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344e'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_316131354F', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354f'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313550', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313550'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313551', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313551'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313552', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313552'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313456', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313456'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_316131345A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131345a'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313464', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313464'}])
changed: [at-3793329-svr005] => (item=[{'diskgroup': 'RECO'}, {'name': 'RECO_3161313469', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313469'}])
TASK [gi-setup : asm-create | Start ASM instance] ******************************
changed: [at-3793329-svr005]
TASK [gi-setup : asm-create | (udev) Create disk groups] ***********************
changed: [at-3793329-svr005] => (item={'diskgroup': 'DATA', 'disks': [{'name': 'DATA_3161313547', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313547'}, {'name': 'DATA_3161313548', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313548'}, {'name': 'DATA_3161313549', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313549'}, {'name': 'DATA_316131354A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354a'}, {'name': 'DATA_316131354B', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354b'}, {'name': 'DATA_316131354C', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354c'}, {'name': 'DATA_316131354D', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354d'}, {'name': 'DATA_316131354E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354e'}, {'name': 'DATA_3161313439', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313439'}, {'name': 'DATA_3161313441', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313441'}, {'name': 'DATA_3161313443', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313443'}, {'name': 'DATA_3161313445', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313445'}, {'name': 'DATA_3161313447', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313447'}, {'name': 'DATA_316131344A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344a'}, {'name': 'DATA_316131344E', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131344e'}]})
changed: [at-3793329-svr005] => (item={'diskgroup': 'RECO', 'disks': [{'name': 'RECO_316131354F', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131354f'}, {'name': 'RECO_3161313550', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313550'}, {'name': 'RECO_3161313551', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313551'}, {'name': 'RECO_3161313552', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313552'}, {'name': 'RECO_3161313456', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313456'}, {'name': 'RECO_316131345A', 'blk_device': '/dev/mapper/3600a09803831444a685d51316131345a'}, {'name': 'RECO_3161313464', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313464'}, {'name': 'RECO_3161313469', 'blk_device': '/dev/mapper/3600a09803831444a685d513161313469'}]})
TASK [gi-setup : Check cluster resources] **************************************
ok: [at-3793329-svr005]
TASK [gi-setup : crsctl stat res -t output] ************************************
ok: [at-3793329-svr005] => {
"msg": [
"( /u01/app/19.3.0/grid/bin/crsctl stat res -t ) || true",
[
"--------------------------------------------------------------------------------",
"Name Target State Server State details ",
"--------------------------------------------------------------------------------",
"Local Resources",
"--------------------------------------------------------------------------------",
"ora.DATA.dg",
" ONLINE ONLINE at-3793329-svr005 STABLE",
"ora.RECO.dg",
" ONLINE ONLINE at-3793329-svr005 STABLE",
"ora.asm",
" ONLINE ONLINE at-3793329-svr005 Started,STABLE",
"ora.ons",
" OFFLINE OFFLINE at-3793329-svr005 STABLE",
"--------------------------------------------------------------------------------",
"Cluster Resources",
"--------------------------------------------------------------------------------",
"ora.cssd",
" 1 ONLINE ONLINE at-3793329-svr005 STABLE",
"ora.diskmon",
" 1 OFFLINE OFFLINE STABLE",
"ora.evmd",
" 1 ONLINE ONLINE at-3793329-svr005 STABLE",
"--------------------------------------------------------------------------------"
]
]
}
TASK [gi-setup : Final GI permission adjustments] ******************************
changed: [at-3793329-svr005] => (item={'name': '/u01/app/oracle/diag', 'owner': 'oracle', 'mode': 'ug=rwx,o=rx', 'recurse': 'no'})
changed: [at-3793329-svr005] => (item={'name': '/u01/app/oracle/diag/crs', 'owner': 'grid', 'mode': 'g+w', 'recurse': 'yes'})
ok: [at-3793329-svr005] => (item={'name': '/u01/app/oracle/diag/kfod', 'owner': 'grid', 'mode': 'g+w', 'recurse': 'yes'})
changed: [at-3793329-svr005] => (item={'name': '/u01/app/oracle/admin', 'owner': 'oracle', 'mode': 'g+w', 'recurse': 'yes'})
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [Verify that Ansible on control node meets the version requirements] ******
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "Ansible version is 2.10.8, continuing"
}
TASK [rdbms-setup : Check if software is already installed] ********************
ok: [at-3793329-svr005]
TASK [rdbms-setup : OH Confirmation] *******************************************
ok: [at-3793329-svr005] => {
"msg": "Installing ORACLE_HOME - /u01/app/oracle/product/19.3.0/dbhome_1"
}
TASK [rdbms-setup : Validate directories (required for secondary home)] ********
ok: [at-3793329-svr005] => (item={'name': '/u01/app/oracle/product/19.3.0/dbhome_1', 'owner': 'oracle', 'group': 'oinstall', 'mode': 'ug=rwx,o=rx'})
included: /usr/local/google/home/jcnarasimhan/DriveFS/My Drive/bmaas/host_provisioning/bms-toolkit/roles/rdbms-setup/tasks/rdbms-install.yml for at-3793329-svr005 => (item={'name': '19c_base', 'version': '19.3.0.0.0', 'edition': ['EE', 'SE2'], 'files': ['V982063-01.zip'], 'sha256sum': ['BA8329C757133DA313ED3B6D7F86C5AC42CD9970A28BF2E6233F3235233AA8D8']})
TASK [rdbms-setup : rdbms-install | Set facts] *********************************
ok: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Installer confirmations] *******************
ok: [at-3793329-svr005] => {
"msg": [
"Installing from file : ['V982063-01.zip']",
"Unzipping into dir : /u01/app/oracle/product/19.3.0/dbhome_1",
"Using installer dir : /u01/app/oracle/product/19.3.0/dbhome_1"
]
}
TASK [rdbms-setup : rdbms-install | Set variable for OneOff patch] *************
ok: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Unzipping software] ************************
changed: [at-3793329-svr005] => (item=V982063-01.zip)
TASK [rdbms-setup : rdbms-install | Create RDBMS response file script] *********
changed: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Run RDBMS response file script] ************
changed: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Script cleanup] ****************************
changed: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Update DB OPatch] **************************
changed: [at-3793329-svr005] => (item={'category': 'OPatch', 'release': '19.3.0.0.0', 'patchnum': '6880880', 'patchfile': 'p6880880_190000_Linux-x86-64.zip', 'md5sum': ''})
TASK [rdbms-setup : rdbms-install | Set installer command] *********************
ok: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Information] *******************************
ok: [at-3793329-svr005] => {
"msg": "Using installer cmd: /u01/app/oracle/product/19.3.0/dbhome_1/runInstaller -silent -waitforcompletion -responseFile /u01/oracle_install/db_install.rsp -ignorePrereqFailure"
}
TASK [rdbms-setup : rdbms-install | Run runInstaller] **************************
changed: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | runInstaller output] ***********************
ok: [at-3793329-svr005] => {
"msg": [
[
"/u01/app/oracle/product/19.3.0/dbhome_1/runInstaller",
"-silent",
"-waitforcompletion",
"-responseFile",
"/u01/oracle_install/db_install.rsp",
"-ignorePrereqFailure"
],
[
"Launching Oracle Database Setup Wizard...",
"",
"The response file for this session can be found at:",
" /u01/app/oracle/product/19.3.0/dbhome_1/install/response/db_2021-11-24_02-39-21PM.rsp",
"",
"You can find the log of this install session at:",
" /u01/app/oraInventory/logs/InstallActions2021-11-24_02-39-21PM/installActions2021-11-24_02-39-21PM.log",
"",
"As a root user, execute the following script(s):",
"\t1. /u01/app/oracle/product/19.3.0/dbhome_1/root.sh",
"",
"Execute /u01/app/oracle/product/19.3.0/dbhome_1/root.sh on the following nodes: ",
"[at-3793329-svr005]",
"",
"",
"Successfully Setup Software."
]
]
}
TASK [rdbms-setup : rdbms-install | Run script orainstRoot.sh] *****************
changed: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Run script root.sh] ************************
changed: [at-3793329-svr005]
TASK [rdbms-setup : rdbms-install | Complete plugin configuration] *************
changed: [at-3793329-svr005]
TASK [rdbms-setup : Create sqlnet.ora file] ************************************
changed: [at-3793329-svr005]
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [rac-gi-install | defaults from common] ***********************************
ok: [at-3793329-svr005]
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [rac-gi-install | defaults from common] ***********************************
ok: [at-3793329-svr005]
PLAY [dbasm[0]] ****************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [rac-gi-install | defaults from common] ***********************************
ok: [at-3793329-svr005]
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [rac-db-install | defaults from common] ***********************************
ok: [at-3793329-svr005]
PLAY [dbasm[0]] ****************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [rac-db-install | defaults from common] ***********************************
ok: [at-3793329-svr005]
PLAY RECAP *********************************************************************
at-3793329-svr005 : ok=64 changed=25 unreachable=0 failed=0 skipped=23 rescued=0 ignored=0
Running Ansible playbook: /usr/bin/ansible-playbook -i ./inventory_files/inventory_at-3793329-svr005_orcl config-db.yml
PLAY [dbasm] *******************************************************************
TASK [Gathering Facts] *********************************************************
ok: [at-3793329-svr005]
TASK [Verify that Ansible on control node meets the version requirements] ******
ok: [at-3793329-svr005] => {
"changed": false,
"msg": "Ansible version is 2.10.8, continuing"
}
TASK [lsnr-create : Open listener port in firewall] ****************************
ok: [at-3793329-svr005]
TASK [lsnr-create : Test whether port is free] *********************************
ok: [at-3793329-svr005]
TASK [lsnr-create : Check if listener has already been created] ****************
ok: [at-3793329-svr005]
TASK [lsnr-create : Create listener] *******************************************
changed: [at-3793329-svr005]
TASK [lsnr-create : Listener creation output] **********************************
ok: [at-3793329-svr005] => {
"msg": [
"export PATH=/u01/app/19.3.0/grid/bin:${PATH}\nsrvctl add listener -l LISTENER -p 1521 -o /u01/app/19.3.0/grid\nsrvctl start listener -l LISTENER\nsrvctl config listener -l LISTENER\nsrvctl status listener -l LISTENER\n",
[
"Name: LISTENER",
"Type: Database Listener",
"Home: /u01/app/19.3.0/grid",
"End points: TCP:1521",
"Listener is enabled.",
"Listener LISTENER is enabled",
"Listener LISTENER is running on node(s): at-3793329-svr005"
]
]
}
TASK [db-create : Test whether pmon process by same name already exists] *******
ok: [at-3793329-svr005]
TASK [db-create : Check if database is already in oratab] **********************
ok: [at-3793329-svr005]
TASK [db-create : Adjust instance memory values (not 11.2 or 12.1)] ************
ok: [at-3793329-svr005]
TASK [db-create : Create DBCA response file script] ****************************
changed: [at-3793329-svr005]
TASK [db-create : Run DBCA response file script] *******************************
changed: [at-3793329-svr005]
TASK [db-create : Script cleanup] **********************************************
changed: [at-3793329-svr005]
TASK [db-create : Copy to instance the pwgen.sh script] ************************
ok: [at-3793329-svr005]
TASK [db-create : Generate command for password randomization (not 11.2)] ******
ok: [at-3793329-svr005]
TASK [db-create : Run DBCA] ****************************************************
changed: [at-3793329-svr005]
TASK [db-create : DBCA output] *************************************************
ok: [at-3793329-svr005] => {
"msg": [
"set -o pipefail\nexport PATH=/u01/app/oracle/product/19.3.0/dbhome_1/bin:${PATH}\necho -e \"$(/usr/local/bin/pwgen.sh 16)\\n$(/usr/local/bin/pwgen.sh 16)\\n$(/usr/local/bin/pwgen.sh 16)\" | dbca -silent -createDatabase -redoLogFileSize 100 -responseFile /u01/oracle_install/dbca_orcl.rsp\n",
[
"Enter SYS user password: ",
"\b \b*****************",
"Enter SYSTEM user password: ",
"******\b \b*************",
"Prepare for db operation",
"10% complete",
"Registering database with Oracle Restart",
"14% complete",
"Copying database files",
"43% complete",
"Creating and starting Oracle instance",
"45% complete",
"49% complete",
"53% complete",
"56% complete",
"62% complete",
"Completing Database Creation",
"68% complete",
"70% complete",
"71% complete",
"Executing Post Configuration Actions",
"100% complete",
"Database creation complete. For details check the logfiles at:",
" /u01/app/oracle/cfgtoollogs/dbca/orcl.",
"Database Information:",
"Global Database Name:orcl",
"System Identifier(SID):orcl",
"Look at the log file \"/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log\" for further details."
]
]
}
TASK [db-create : Save PDBs state] *********************************************
changed: [at-3793329-svr005]
TASK [db-adjustements : Copy database adjustment scripts to target server] *****
changed: [at-3793329-svr005] => (item=archivelog_mode.sh)
changed: [at-3793329-svr005] => (item=db_modifications.sh)
TASK [db-adjustements : Run database adjustment scripts on target server] ******
changed: [at-3793329-svr005] => (item=archivelog_mode.sh)
changed: [at-3793329-svr005] => (item=db_modifications.sh)
TASK [db-adjustements : Script cleanup on target server] ***********************
changed: [at-3793329-svr005] => (item=archivelog_mode.sh)
changed: [at-3793329-svr005] => (item=db_modifications.sh)
TASK [db-backups : Create required directories] ********************************
changed: [at-3793329-svr005] => (item=/home/oracle/scripts)
changed: [at-3793329-svr005] => (item=/home/oracle/logs)
TASK [db-backups : Copy backup scripts to target server] ***********************
changed: [at-3793329-svr005] => (item=rman_full_backup.sh)
changed: [at-3793329-svr005] => (item=rman_arch_backup.sh)
changed: [at-3793329-svr005] => (item=rman_restore_example.sh)
TASK [db-backups : Schedule full backups] **************************************
changed: [at-3793329-svr005] => (item={'level': 0, 'days': '0'})
changed: [at-3793329-svr005] => (item={'level': 1, 'days': '1-6'})
TASK [db-backups : Schedule archived redo log backups] *************************
changed: [at-3793329-svr005]
TASK [db-backups : Run initial full backup] ************************************
changed: [at-3793329-svr005]
TASK [db-backups : Run initial archivelog backup] ******************************
changed: [at-3793329-svr005]
TASK [validation-scripts : Copy validation scripts to server] ******************
changed: [at-3793329-svr005] => (item=asm_disks.sh)
changed: [at-3793329-svr005] => (item=crs_check.sh)
changed: [at-3793329-svr005] => (item=cluvfy_checks.sh)
PLAY RECAP *********************************************************************
at-3793329-svr005 : ok=28 changed=16 unreachable=0 failed=0 skipped=10 rescued=0 ignored=0
Files used by this session:
- ./inventory_files/inventory_at-3793329-svr005_orcl
- ./logs/log_at-3793329-svr005_orcl_20211124_141135.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment