ibre5041.ansible_oracle_modules.oracle_ping (3.2.0) — module

Install collection

Install with ansible-galaxy collection install ibre5041.ansible_oracle_modules:==3.2.0

Add to requirements.yml

  collections:
    - name: ibre5041.ansible_oracle_modules
      version: 3.2.0

Description

Test connection to Oracle database

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Connect as sysdba
  oracle_ping:
    mode: sysdba
  register: _oracle_instance

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Connect remotely from control node
  oracle_ping:
    mode: normal
    hostname: dbhost
    port: 1521
    service_name: DBSERVICE
    user: SYSTEM
    password: Oracle123
  delegate_to: localhost

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Connect remotely from control node using wallet
  oracle_ping:
    mode: normal
    hostname: dbhost
    port: 1521
    service_name: DBSERVICE
  delegate_to: localhost

Inputs

    
mode:
    choices:
    - normal
    - sysdba
    default: normal
    description: The mode with which to connect to the database
    required: false

port:
    default: 1521
    description: The listener port number on the host
    required: false

user:
    aliases:
    - un
    - username
    description: The Oracle user name to connect to the database
    required: false

hostname:
    aliases:
    - host
    default: localhost
    description: The Oracle database host
    required: false

password:
    aliases:
    - pw
    description: The Oracle user password for the user
    required: false

service_name:
    aliases:
    - sn
    description: The database service name to connect to
    required: false