search

oravirt / ansible-oracle

Oracle related stuff. Installs RAC/RAC One Node/Single Instance
MIT License
346 stars 249 forks source link

TypeError: '>' not supported between instances of 'tuple' and 'int' #489

Open matthiaslink77 opened 3 weeks ago

matthiaslink77 commented 3 weeks ago

TASK [opitzconsulting.ansible_oracle.oradb_manage_grants : Manage role grants (pdb)] ** An exception occurred during task execution. To see the full traceback, use -vvv. The error was: TypeError: '>' not supported between instances of 'tuple' and 'int'

Seems like a similar issue as mentioned before for ansible-oracle-modules in #174, #175 and #176 :

Files for the following modules contain "if result > 0" or "if result [0] > 0" or if result [0][0] > 0"

oracle_grants.py oracle_directory.py oracle_user.py

oracle_role.py oracle_profile.py oracle_asmdg.py oracle_asmvol.py

Should be "if result" instead.

Best regards, Matthias.

Rendanic commented 1 day ago

Hi Matthias, this needs some mor einformations, bevore I can analyze it.

Are you using CDB or nonCDB? Grants are set in oracle_databases?

Kind Regards Thorsten