Module oracle_sql

[luisquilumbat0504]

Hi, I’m using the oracle_sql module, but when I try to use the connection through the wallet, it indicates that I need to provide a username and password. Is there a way for the oracle_sql module to use only the wallet, as the oracle_ping module does?

I don't want to use SYSDBA mode for security reasons.

[ibre5041]

Please provide minimalistic use case and error log message

[luisquilumbat0504]

I would like to mention that when I use the oracle_ping module with a wallet, the task executes successfully. However, when I use the oracle_sql module in normal mode, it indicates that I need to provide a username and password, as shown below:

Playbook:
tasks:
- name: Realizar oracle-ping con wallet
ibre5041.ansible_oracle_modules.oracle_ping:
mode: normal
service_name: CON_ANSILBE
port: 1521
environment:
ORACLE_HOME: "{{ oracle_home }}"
ORACLE_SID: "{{ oracle_sid }}"
register: salida

• name: Realizar oracle-sql
  ibre5041.ansible_oracle_modules.oracle_sql:
  mode: normal
  service_name: CON_ANSILBE
  port: 1521
  sql: "select username,account_status from dba_users where username = 'LAQT261120';"
  environment:
  ORACLE_HOME: "{{ oracle_home }}"
  ORACLE_SID: "{{ oracle_sid }}"
  register: salida

Messages:
TASK [Realizar oracle-ping con wallet] ***********************************************************************************************************************************************************************
ok: [sri12-srirep]

TASK [Debug] *************************************************************************************************************************************************************************************************
ok: [sri12-srirep] => {
"msg": {
"changed": false,
"failed": false,
"msg": "Connection successful: {('startup_time', datetime.datetime(2026, 7, 20, 14, 53, 55)), ('database_status', 'ACTIVE'), ('instance_name', 'SRIREP'), ('host_name', 'sri12'), ('edition', 'EE'), ('active_state', 'NORMAL'), ('version_full', '19.16.0.0.0'), ('database_type', 'SINGLE'), ('version', '19.0.0.0.0'), ('instance_role', 'PRIMARY_INSTANCE'), ('instance_number', 1), ('parallel', 'NO'), ('archiver', 'STARTED'), ('instance_mode', 'REGULAR'), ('blocked', 'NO'), ('log_switch_wait', None), ('version_legacy', '19.0.0.0.0'), ('thread#', 1), ('shutdown_pending', 'NO'), ('family', None), ('status', 'OPEN'), ('logins', 'ALLOWED'), ('con_id', 0)}"
}
}

TASK [Realizar oracle-sql] ***********************************************************************************************************************************************************************************
fatal: [sri12-srirep]: FAILED! => {"changed": false, "msg": "mode is normal but all of the following are missing: username, password"}

Is there a way to use the oracle_sql module in normal mode with a connection through the wallet?

thanks