+
Skip to content

Conversation

talek
Copy link
Contributor

@talek talek commented Oct 24, 2024

When upgrading timezone for a CDB database it fails with:

TASK [opitzconsulting.ansible_oracle.oradb_tzupgrade : oradb_tzupgrade | Show facts for pdbs_info] ***                                                                                             
Wednesday 23 October 2024  22:15:43 +0200 (0:00:00.055)       0:03:57.589 *****                                                                                                                    
fatal: [mol-oracle-pdvmoras99-snapcdb]: FAILED! => {"msg": "The task includes an option with an undefined variable. The error was: '_oradb_tzupgrade_candidate_pdbs' is undefined. '_oradb_tzupgrade
_candidate_pdbs' is undefined\n\nThe error appears to be in '/home/devopsadm/.ansible/collections/ansible_collections/opitzconsulting/ansible_oracle/roles/oradb_tzupgrade/tasks/cdb.yml': line 40, 
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: oradb_tzupgrade | Show facts for pdbs_info\n  ^ here\n"}   

@Rendanic Rendanic added the bug label Oct 30, 2024
@Rendanic Rendanic added this to the 4.11 milestone Oct 30, 2024
@Rendanic Rendanic merged commit a6a18eb into oravirt:master Oct 30, 2024
6 checks passed
Rendanic added a commit to Rendanic/ansible-oracle that referenced this pull request Mar 2, 2025
v4.12.0
=======

Minor Changes
-------------

- ansible-lint: more excludes (oravirt#505)
- common: remove screen from default rhel8,9 package list (oravirt#496)
- orahost: firewall_service should default to firewalld on OL/EL 8 (oravirt#499)

Bugfixes
--------

- common: Exclude alias interfaces when templating motd.j2 (oravirt#486)
- common: force bool type in certain conditionals
- fix for re global flags when extracting sga/processes parameters in orahost_meta (oravirt#493)
- orahost_meta: Aggregate SGAs fails if no sga_target or sga_max_size is defined (oravirt#498)
- orahost_meta: Applying 'lower' filter to oracle_databases+oracle_asm_instance converts list to string (oravirt#484)
- oraswdb_manage_patches, oraswgi_manage_patches: make unarchive check work for combo patches too (oravirt#482)
- set and check _oradb_tzupgrade_candidate_pdbs fact when upgrading timezone for a CDB database (oravirt#490)
@Rendanic Rendanic mentioned this pull request Mar 2, 2025
Rendanic added a commit that referenced this pull request Mar 2, 2025
v4.12.0
=======

Minor Changes
-------------

- ansible-lint: more excludes (#505)
- common: remove screen from default rhel8,9 package list (#496)
- orahost: firewall_service should default to firewalld on OL/EL 8 (#499)

Bugfixes
--------

- common: Exclude alias interfaces when templating motd.j2 (#486)
- common: force bool type in certain conditionals
- fix for re global flags when extracting sga/processes parameters in orahost_meta (#493)
- orahost_meta: Aggregate SGAs fails if no sga_target or sga_max_size is defined (#498)
- orahost_meta: Applying 'lower' filter to oracle_databases+oracle_asm_instance converts list to string (#484)
- oraswdb_manage_patches, oraswgi_manage_patches: make unarchive check work for combo patches too (#482)
- set and check _oradb_tzupgrade_candidate_pdbs fact when upgrading timezone for a CDB database (#490)
@Rendanic Rendanic modified the milestones: 4.11, 4.12 Mar 2, 2025
@talek talek deleted the tz_cdb_upgrade_issue branch March 15, 2025 19:36
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants

点击 这是indexloc提供的php浏览器服务,不要输入任何密码和下载