cruglobal / ansible-oracle-db-upgrade Goto Github PK

Hi
Getting following error for RAC DB, this environment didn't have ORACLE_SID etc set , all are part of 12c_1_pre_upgrade.yml file.. what am I doing different here.

• hosts: oracle
  become: true
  become_user: oracle
  vars:
  db_name: TEMPDB
  accelerate: true
  oracle_user: oracle
  oracle_group: dba
  master_node: 1
  oracle_install_type: EE
  oracle_base: /u02/app/oracle
  tns_admin: /u02/app/oracle/product/11.2.0.4/TEMP/dbhome_1/network/admin
  database_parameters:
  TEMPDB:
  db_version: 12.1.0.2
  sga_target: 4G
  pga_aggregate_target: 4G
  redolog_size_mb: 4096M
  db_recovery_file_dest_size: 100G
  log_mode: archivelog
  tasks:

  • action: ping
  • name: test connection
    action: ping

  roles:

  • role: db-upgrade

changed: [10.10.112.167] => {"changed": true, "cmd": "cat db_unique_name.log", "delta": "0:00:00.025194", "end": "2017-12-14 14:24:30.563766", "invocation": {"module_args": {"_raw_params": "cat db_unique_name.log", "_uses_shell": true, "chdir": "/u03/omcs/ansible_stage/12c_upgrade/TEMPDB", "creates": null, "executable": null, "removes": null, "warn": true}, "module_name": "command"}, "rc": 0, "start": "2017-12-14 14:24:30.538572", "stderr": "", "stdout": "TEMPDB", "stdout_lines": ["TEMPDB"], "warnings": []}
changed: [10.10.112.162] => {"changed": true, "cmd": "cat db_unique_name.log", "delta": "0:00:00.015577", "end": "2017-12-14 14:24:30.811786", "invocation": {"module_args": {"_raw_params": "cat db_unique_name.log", "_uses_shell": true, "chdir": "/u03/omcs/ansible_stage/12c_upgrade/TEMPDB", "creates": null, "executable": null, "removes": null, "warn": true}, "module_name": "command"}, "rc": 0, "start": "2017-12-14 14:24:30.796209", "stderr": "", "stdout": "select trim(value) from v$parameter where name='db_unique_name'\n*\nERROR at line 1:\nORA-01034: ORACLE not available\nProcess ID: 0\nSession ID: 0 Serial number: 0", "stdout_lines": ["select trim(value) from v$parameter where name='db_unique_name'", "*", "ERROR at line 1:", "ORA-01034: ORACLE not available", "Process ID: 0", "Session ID: 0 Serial number: 0"], "warnings": []}

Dear CruGlobal,

I am getting below warnings and errors, could you please help me to troubleshoot this.

[oracle@pluto1226 ar_scripts]$ ansible-playbook 12c_1_pre_upgrade.yml [WARNING]: * Failed to parse /home/oracle/ar_scripts/12c_1_pre_upgrade.yml with yaml plugin:
YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/12c_1_pre_upgrade.yml with ini plugin:
/home/oracle/ar_scripts/12c_1_pre_upgrade.yml:2: Expected key=value host variable assignment, got:
hosts:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/12c_1_pre_upgrade.yml with auto plugin:
'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/12c_1_pre_upgrade.yml as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/my_name.yml with yaml plugin: YAML
inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/my_name.yml with ini plugin:
/home/oracle/ar_scripts/my_name.yml:2: Expected key=value host variable assignment, got: hosts:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/my_name.yml with auto plugin:
'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/my_name.yml as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/myphy/airandom.py with script plugin:
problem running /home/oracle/ar_scripts/myphy/airandom.py --list ([Errno 8] Exec format error)

[WARNING]: * Failed to parse /home/oracle/ar_scripts/myphy/airandom.py with ini plugin:
/home/oracle/ar_scripts/myphy/airandom.py:1: Expected key=value host variable assignment, got:
random

[WARNING]: Unable to parse /home/oracle/ar_scripts/myphy/airandom.py as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/myphy/cards.py with ini plugin:
/home/oracle/ar_scripts/myphy/cards.py:1: Expected key=value host variable assignment, got:
unicards

[WARNING]: Unable to parse /home/oracle/ar_scripts/myphy/cards.py as an inventory source

[WARNING]: Unable to parse /home/oracle/ar_scripts/myphy as an inventory source

[WARNING]: Skipping 'upgrade_tzv' as this is not a valid group definition

[WARNING]: Skipping 'upgrade' as this is not a valid group definition

[WARNING]: Skipping 'upgrade_final' as this is not a valid group definition

[WARNING]: Skipping 'pre_upgrade' as this is not a valid group definition

[WARNING]: Skipping 'oracle_stage_base' as this is not a valid group definition

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_apply.sql
with script plugin: problem running /home/oracle/ar_scripts/roles/db-
upgrade/files/upg_tzv_apply.sql --list ([Errno 8] Exec format error)

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_apply.sql
with ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_apply.sql:2: Expected
key=value host variable assignment, got: Copyright

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_apply.sql as an
inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_check.sql
with script plugin: problem running /home/oracle/ar_scripts/roles/db-
upgrade/files/upg_tzv_check.sql --list ([Errno 8] Exec format error)

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_check.sql
with ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_check.sql:2: Expected
key=value host variable assignment, got: Copyright

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/files/upg_tzv_check.sql as an
inventory source

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/files as an inventory source

[WARNING]: Skipping 'dependencies' as this is not a valid group definition

[WARNING]: Skipping unexpected key (company) in group (galaxy_info), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (min_ansible_version) in group (galaxy_info), only "vars",
"children" and "hosts" are valid

[WARNING]: Skipping unexpected key (description) in group (galaxy_info), only "vars", "children"
and "hosts" are valid

[WARNING]: Skipping unexpected key (license) in group (galaxy_info), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (author) in group (galaxy_info), only "vars", "children" and
"hosts" are valid

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/2 with yaml plugin:
YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/2 with ini plugin:
/home/oracle/ar_scripts/roles/db-upgrade/tasks/2:2: Expected key=value host variable assignment,
got: name:

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/2 as an inventory
source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/get_unique_name.yml
with yaml plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/get_unique_name.yml
with ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/get_unique_name.yml:3: Expected
key=value host variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/get_unique_name.yml
with auto plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/get_unique_name.yml as
an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/main.yml with yaml
plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/main.yml with ini
plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/main.yml:2: Expected key=value host
variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/main.yml with auto
plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/main.yml as an
inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_checks.yml with
yaml plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_checks.yml with
ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_checks.yml:3: Expected key=value
host variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_checks.yml with
auto plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_checks.yml as an
inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_upgrade.yml with
yaml plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_upgrade.yml with
ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_upgrade.yml:2: Expected key=value
host variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_upgrade.yml with
auto plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_upgrade.yml as an
inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade.yml with
yaml plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade.yml with ini
plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade.yml:4: Expected key=value host
variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade.yml with
auto plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade.yml as an
inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_final.yml
with yaml plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_final.yml
with ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_final.yml:3: Expected
key=value host variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_final.yml
with auto plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_final.yml as an
inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_tzv.yml with
yaml plugin: YAML inventory has invalid structure, it should be a dictionary, got: <class
'ansible.parsing.yaml.objects.AnsibleSequence'>

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_tzv.yml with
ini plugin: /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_tzv.yml:5: Expected key=value
host variable assignment, got: name:

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_tzv.yml with
auto plugin: 'AnsibleSequence' object has no attribute 'get'

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks/upgrade_tzv.yml as an
inventory source

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/tasks as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/db_unique_name.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/db_unique_name.j2:1: Expected key=value host variable assignment, got: -s

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/templates/db_unique_name.j2
as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/enable_archivelog.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/enable_archivelog.j2:1: Expected key=value host variable assignment, got: mount;

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/enable_archivelog.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/enable_flashback_database.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/enable_flashback_database.j2:1: Expected key=value host variable assignment,
got: linesize

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/enable_flashback_database.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/final_upgrade_backup_0.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/final_upgrade_backup_0.j2:1: Expected key=value host variable assignment, got:
target

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/final_upgrade_backup_0.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/post_upgrade_tasks.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/post_upgrade_tasks.j2:1: Expected key=value host variable assignment, got:
linesize

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/post_upgrade_tasks.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_0.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_0.j2:1: Expected key=value host variable assignment, got:
target

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_0.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_0_dw.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_0_dw.j2:1: Expected key=value host variable assignment, got:
target

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_0_dw.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_1.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_1.j2:1: Expected key=value host variable assignment, got:
target

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_1.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_1_dw.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_1_dw.j2:1: Expected key=value host variable assignment, got:
target

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_backup_1_dw.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_tasks.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_tasks.j2:1: Expected key=value host variable assignment, got:
linesize

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/pre_upgrade_tasks.j2 as an inventory source

[WARNING]: * Failed to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/upgrade_final_tasks.j2 with ini plugin: /home/oracle/ar_scripts/roles/db-
upgrade/templates/upgrade_final_tasks.j2:1: Expected key=value host variable assignment, got:
RESTORE

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-
upgrade/templates/upgrade_final_tasks.j2 as an inventory source

[WARNING]: Unable to parse /home/oracle/ar_scripts/roles/db-upgrade/templates as an inventory
source

[WARNING]: Skipping unexpected key (PATH) in group (env_old), only "vars", "children" and "hosts"
are valid

[WARNING]: Skipping unexpected key (ORACLE_SID) in group (env_old), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (TNS_ADMIN) in group (env_old), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (ORACLE_BASE) in group (env_old), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (ORACLE_HOME) in group (env_old), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping 'oracle_stage' as this is not a valid group definition

[WARNING]: Skipping 'oracle_home' as this is not a valid group definition

[WARNING]: Skipping 'oracle_home_old' as this is not a valid group definition

[WARNING]: Skipping 'master_node' as this is not a valid group definition

[WARNING]: Skipping 'oracle_version' as this is not a valid group definition

[WARNING]: Skipping unexpected key (PATH) in group (env), only "vars", "children" and "hosts" are
valid

[WARNING]: Skipping unexpected key (ORACLE_SID) in group (env), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (TNS_ADMIN) in group (env), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (ORACLE_BASE) in group (env), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping unexpected key (ORACLE_HOME) in group (env), only "vars", "children" and
"hosts" are valid

[WARNING]: Skipping 'oracle_sid' as this is not a valid group definition

[WARNING]: Skipping 'oracle_version_old' as this is not a valid group definition

PLAY [apps1159] ***********************************************************************************

TASK [Gathering Facts] ****************************************************************************
ok: [apps1159]

TASK [db-upgrade : Create a directory if it does not exist] ***************************************
changed: [apps1159]

TASK [db-upgrade : fail if required variables are not defined] ************************************
fatal: [apps1159]: FAILED! => {"msg": "The conditional check 'master_node' failed. The error was: error while evaluating conditional (master_node): is undefined\n\nThe error appears to have been in '/home/oracle/ar_scripts/roles/db-upgrade/tasks/pre_checks.yml': line 3, column 3, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n\n- name: fail if required variables are not defined\n ^ here\n"}
to retry, use: --limit @/home/oracle/ar_scripts/12c_1_pre_upgrade.retry

PLAY RECAP ****************************************************************************************
apps1159 : ok=2 changed=1 unreachable=0 failed=1

[oracle@pluto1226 ar_scripts]$

@davidhollenberger I noticed a couple scripts aren't having their output stored in a logfile or printed to the screen with debug. Are those mostly ignorable or should we capture the data? A couple examples below:

https://github.com/CruGlobal/ansible-oracle-db-upgrade/blob/master/tasks/upgrade.yml#L88
https://github.com/CruGlobal/ansible-oracle-db-upgrade/blob/master/tasks/upgrade.yml#L94

@davidhollenberger Does this line need to account for the naming differences for RAC vs single instance?

https://github.com/CruGlobal/ansible-oracle-db-upgrade/blob/master/tasks/upgrade.yml#L55

- name: copy spfile file to new home
  shell: "cp {{ oracle_home_old }}/dbs/spfile{{ db_name }}.ora {{ oracle_home }}/dbs/"