ansible-playbook 2.4.0.0
config file = /etc/ansible/ansible.cfg
configured module search path = [u'/home/projectsudo/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']
ansible python module location = /usr/lib/python2.7/site-packages/ansible
executable location = /usr/bin/ansible-playbook
python version = 2.7.5 (default, May 29 2017, 20:42:36) [GCC 4.8.5 20150623 (Red Hat 4.8.5-11)]
Using /etc/ansible/ansible.cfg as config file
Reading vault password file: /var/vault/vaultpass
setting up inventory plugins
Parsed /etc/ansible/inventory/project/project.sandbox inventory source with ini plugin
[WARNING]: Ignoring invalid attribute: include_task
Loading callback plugin default of type stdout, v2.0 from /usr/lib/python2.7/site-packages/ansible/plugins/callback/__init__.pyc
Loading callback plugin profile_tasks of type aggregate, v2.0 from /usr/lib/python2.7/site-packages/ansible/plugins/callback/__init__.pyc
PLAYBOOK: oracle_sql.yml ***********************************************************************************************************************************
1 plays in oracle_sql.yml
PLAY [Host Configuration and prerequisites configs for OEL before installing Database] *************************************************************************
META: ran handlers
Found a vault_id (default) in the vaulttext
We have a secret associated with vault id (default), will try to use to decrypt /etc/ansible/inventory/project/group_vars/sandbox.db.yml
Trying to use vault secret=(FileVaultSecret(filename='/var/vault/vaultpass')) id=default to decrypt /etc/ansible/inventory/project/group_vars/sandbox.db.yml
Trying secret FileVaultSecret(filename='/var/vault/vaultpass') for vault_id=default
decrypt succesful with secret=FileVaultSecret(filename='/var/vault/vaultpass') and vault_id=default
TASK [project-oracle-sql : Run sqlplus command on Target DB server] ************************************************************************************************
task path: /etc/ansible/playbooks/project/database/roles/project-oracle-sql/tasks/main.yml:3
Wednesday 07 March 2018 00:14:40 -0600 (0:00:00.202) 0:00:00.202 *******
Using module_utils file /usr/lib/python2.7/site-packages/ansible/module_utils/basic.py
Using module_utils file /usr/lib/python2.7/site-packages/ansible/module_utils/_text.py
Using module_utils file /usr/lib/python2.7/site-packages/ansible/module_utils/parsing/convert_bool.py
Using module_utils file /usr/lib/python2.7/site-packages/ansible/module_utils/parsing/__init__.py
Using module_utils file /usr/lib/python2.7/site-packages/ansible/module_utils/pycompat24.py
Using module_utils file /usr/lib/python2.7/site-packages/ansible/module_utils/six/__init__.py
Using module file /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
<localhost> ESTABLISH LOCAL CONNECTION FOR USER: user
<localhost> EXEC /bin/sh -c 'echo ~ && sleep 0'
<localhost> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387 `" && echo ansible-tmp-1520403280.71-164279973024387="` echo /home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387 `" ) && sleep 0'
<localhost> PUT /tmp/tmpVvsHsp TO /home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387/command.py
<localhost> EXEC /bin/sh -c 'chmod u+x /home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387/ /home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387/command.py && sleep 0'
<localhost> EXEC /bin/sh -c '/usr/bin/python2 /home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387/command.py; rm -rf "/home/projectsudo/.ansible/tmp/ansible-tmp-1520403280.71-164279973024387/" > /dev/null 2>&1 && sleep 0'
changed: [10.202.98.146 -> localhost] => {
"changed": true,
"cmd": "source ~/.bash_profile && sqlplus -S 'admin/password@sandbox16:1521/project' @\"sharedschema_version.sql\"",
"delta": "0:00:00.066447",
"end": "2018-03-07 00:14:40.952333",
"failed": false,
"invocation": {
"module_args": {
"_raw_params": "source ~/.bash_profile && sqlplus -S 'admin/password@sandbox16:1521/orcl' @\"sharedschema_version.sql\"",
"_uses_shell": true,
"chdir": "roles/oracle-sql/files/",
"creates": null,
"executable": null,
"removes": null,
"stdin": null,
"warn": true
}
},
"rc": 0,
"start": "2018-03-07 00:14:40.885886",
"stderr": "",
"stderr_lines": [],
"stdout": "\t 0",
"stdout_lines": [
"\t 0"
]
}
TASK [project-oracle-sql : set_fact] *******************************************************************************************************************************
task path: /etc/ansible/playbooks/project/database/roles/oracle-sql/tasks/main.yml:11
Wednesday 07 March 2018 00:14:41 -0600 (0:00:00.491) 0:00:00.694 *******
ok: [10.202.98.146 -> localhost] => {
"ansible_facts": {
"sharedschema_version_build_number": [
"\t 0"
]
},
"changed": false,
"failed": false
}
TASK [oracle-sql : Get CSV File Content with out header] ***************************************************************************************************
task path: /etc/ansible/playbooks/project/database/roles/oracle-sql/tasks/main.yml:39
Wednesday 07 March 2018 00:14:44 -0600 (0:00:01.530) 0:00:04.204 *******
Using module file /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
<localhost> ESTABLISH LOCAL CONNECTION FOR USER: projectsudo
<localhost> EXEC /bin/sh -c 'echo ~ && sleep 0'
<localhost> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560 `" && echo ansible-tmp-1520403284.55-215267815054560="` echo /home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560 `" ) && sleep 0'
<localhost> PUT /tmp/tmptUjnTF TO /home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560/command.py
<localhost> EXEC /bin/sh -c 'chmod u+x /home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560/ /home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560/command.py && sleep 0'
<localhost> EXEC /bin/sh -c '/usr/bin/python2 /home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560/command.py; rm -rf "/home/user/.ansible/tmp/ansible-tmp-1520403284.55-215267815054560/" > /dev/null 2>&1 && sleep 0'
changed: [IP_ADDRESS -> localhost] => {
"changed": true,
"cmd": "source ~/.bash_profile && awk -F',' '!/^#/ && !/^$/ && (NR!=1) { print }' \"/home/user/client_schema_output.csv\" | sed 's/\\\"//g'",
"delta": "0:00:00.021714",
"end": "2018-03-07 00:14:44.738602",
"failed": false,
"invocation": {
"module_args": {
"_raw_params": "source ~/.bash_profile && awk -F',' '!/^#/ && !/^$/ && (NR!=1) { print }' \"/home/user/client_schema_output.csv\" | sed 's/\\\"//g'",
"_uses_shell": true,
"chdir": null,
"creates": null,
"executable": null,
"removes": null,
"stdin": null,
"warn": true
}
},
"rc": 0,
"start": "2018-03-07 00:14:44.716888",
"stderr": "",
"stderr_lines": [],
"stdout": Client_Schema1,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\nClient_Schema2,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\nClient_Schema3",password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))\n
"stdout_lines": [
"Client_Schema1","admin","password","TNSNAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))"
"Client_Schema2","admin","password","TNSNAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))"
"Client_Schema3","admin","password","TNSNAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))"
]
}
TASK [oracle-sql : debug] **********************************************************************************************************************************
task path: /etc/ansible/playbooks/project/database/roles/oracle-sql/tasks/main.yml:45
Wednesday 07 March 2018 00:14:44 -0600 (0:00:00.268) 0:00:04.473 *******
ok: [IP_ADDRESS -> localhost] => {
"groups_out.stdout_lines": [
"Client_Schema1","admin","password","TNSNAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))"
"Client_Schema2","admin","password","TNSNAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))"
"Client_Schema3","admin","password","TNSNAME","(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))"
]
}
TASK [oracle-sql : Run sqlplus command on Client DB] *******************************************************************************************************
task path: /etc/ansible/playbooks/project/database/roles/oracle-sql/tasks/main.yml:48
Wednesday 07 March 2018 00:14:44 -0600 (0:00:00.059) 0:00:04.532 *******
Using module file /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
<localhost> ESTABLISH LOCAL CONNECTION FOR USER: user
<localhost> EXEC /bin/sh -c 'echo ~ && sleep 0'
<localhost> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652 `" && echo ansible-tmp-1520403284.9-239190304128652="` echo /home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652 `" ) && sleep 0'
<localhost> PUT /tmp/tmp7r4pD8 TO /home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652/command.py
<localhost> EXEC /bin/sh -c 'chmod u+x /home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652/ /home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652/command.py && sleep 0'
<localhost> EXEC /bin/sh -c '/usr/bin/python2 /home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652/command.py; rm -rf "/home/user/.ansible/tmp/ansible-tmp-1520403284.9-239190304128652/" > /dev/null 2>&1 && sleep 0'
Using module file /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
changed: [IP_ADDRESS -> localhost] => (item=Client_Schema1,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=project)))) => {
"changed": true,
"cmd": "source ~/.bash_profile && sqlplus -S 'admin/password@projectsandbox16:1521/project' @\"clientschema_version.sql\" Client_Schema1",
"delta": "0:00:00.064133",
"end": "2018-03-07 00:14:45.133627",
"failed": false,
"invocation": {
"module_args": {
"_raw_params": "source ~/.bash_profile && sqlplus -S 'admin/password@projectsandbox16:1521/project' @\"clientschema_version.sql\" Client_Schema1",
"_uses_shell": true,
"chdir": "roles/oracle-sql/files/",
"creates": null,
"executable": null,
"removes": null,
"stdin": null,
"warn": true
}
},
"item": "Client_Schema1,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=project)))",
"rc": 0,
"start": "2018-03-07 00:14:45.069494",
"stderr": "",
"stderr_lines": [],
"stdout": "\t 0",
"stdout_lines": [
"\t 0"
]
}
<localhost> EXEC /bin/sh -c 'echo ~ && sleep 0'
<localhost> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873 `" && echo ansible-tmp-1520403285.16-117714937344873="` echo /home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873 `" ) && sleep 0'
<localhost> PUT /tmp/tmpY47pQq TO /home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873/command.py
<localhost> EXEC /bin/sh -c 'chmod u+x /home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873/ /home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873/command.py && sleep 0'
<localhost> EXEC /bin/sh -c '/usr/bin/python2 /home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873/command.py; rm -rf "/home/user/.ansible/tmp/ansible-tmp-1520403285.16-117714937344873/" > /dev/null 2>&1 && sleep 0'
changed: [IP_ADDRESS -> localhost] => (item=Client_Schema2,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=project)))) => {
"changed": true,
"cmd": "source ~/.bash_profile && sqlplus -S 'admin/password@sandbox16:1521/project' @\"clientschema_version.sql\" Client_Schema2",
"delta": "0:00:00.068016",
"end": "2018-03-07 00:14:45.391251",
"failed": false,
"invocation": {
"module_args": {
"_raw_params": "source ~/.bash_profile && sqlplus -S 'admin/password@sandbox16:1521/project' @\"clientschema_version.sql\" Client_Schema2",
"_uses_shell": true,
"chdir": "roles/oracle-sql/files/",
"creates": null,
"executable": null,
"removes": null,
"stdin": null,
"warn": true
}
},
"item": "Client_Schema2,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=project)))",
"rc": 0,
"start": "2018-03-07 00:14:45.323235",
"stderr": "",
"stderr_lines": [],
"stdout": "\t 0",
"stdout_lines": [
"\t 0"
]
}
Using module file /usr/lib/python2.7/site-packages/ansible/modules/commands/command.py
<localhost> EXEC /bin/sh -c 'echo ~ && sleep 0'
<localhost> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268 `" && echo ansible-tmp-1520403285.42-73929200440268="` echo /home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268 `" ) && sleep 0'
<localhost> PUT /tmp/tmp9_nI9W TO /home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268/command.py
<localhost> EXEC /bin/sh -c 'chmod u+x /home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268/ /home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268/command.py && sleep 0'
<localhost> EXEC /bin/sh -c '/usr/bin/python2 /home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268/command.py; rm -rf "/home/user/.ansible/tmp/ansible-tmp-1520403285.42-73929200440268/" > /dev/null 2>&1 && sleep 0'
changed: [IP_ADDRESS -> localhost] => (item=Client_Schema3,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=project)))) => {
"changed": true,
"cmd": "source ~/.bash_profile && sqlplus -S 'admin/password@sandbox16:1521/project' @\"clientschema_version.sql\" Client_Schema3",
"delta": "0:00:00.073883",
"end": "2018-03-07 00:14:45.663021",
"failed": false,
"invocation": {
"module_args": {
"_raw_params": "source ~/.bash_profile && sqlplus -S 'admin/password@sandbox16:1521/project' @\"clientschema_version.sql\" Client_Schema3",
"_uses_shell": true,
"chdir": "roles/oracle-sql/files/",
"creates": null,
"executable": null,
"removes": null,
"stdin": null,
"warn": true
}
},
"item": "Client_Schema3,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))",
"rc": 0,
"start": "2018-03-07 00:14:45.589138",
"stderr": "",
"stderr_lines": [],
"stdout": "\t 0",
"stdout_lines": [
"\t 0"
]
}
TASK [oracle-sql : command] ********************************************************************************************************************************
task path: /etc/ansible/playbooks/project/database/roles/oracle-sql/tasks/main.yml:64
Wednesday 07 March 2018 00:14:47 -0600 (0:00:02.965) 0:00:07.497 *******
skipping: [IP_ADDRESS] => (item=Client_Schema1,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))) => {
"changed": false,
"item": "Client_Schema1,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))",
"skip_reason": "Conditional result was False",
"skipped": true
}
skipping: [IP_ADDRESS] => (item=Client_Schema2,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))) => {
"changed": false,
"item": "Client_Schema2,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))",
"skip_reason": "Conditional result was False",
"skipped": true
}
skipping: [IP_ADDRESS] => (item=Client_Schema3,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))) => {
"changed": false,
"item": "Client_Schema3,password,SANDBOX16,(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SANDBOX16)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))",
"skip_reason": "Conditional result was False",
"skipped": true
}