opitzconsulting.ansible_oracle.oracle_services (4.7.0) — module

Install collection

Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0

Add to requirements.yml

  collections:
    - name: opitzconsulting.ansible_oracle
      version: 4.7.0

Description

Manage services in an Oracle database

Requirements

• cx_Oracle

Inputs

    
pdb:
    default: None
    description: The pdb which the service is attached to
    required: false

name:
    default: None
    description: The name of the service
    required: true

port:
    default: 1521
    description: The listener port to connect to the database if using dbms_service
    required: false

role:
    choices:
    - primary
    - physical_standby
    - logical_standby
    - snapshot_standby
    default: None
    description: 'Role of the service (primary, physical_standby, logical_standby, snapshot_standby)

      '
    required: false

force:
    choices:
    - 'true'
    - 'false'
    default: false
    description: Adds the 'force' flag to the srvctl command

state:
    choices:
    - present
    - absent
    - started
    - stopped
    - status
    default: present
    description: 'The intended state of the service. ''status'' will just show the status
      of the service

      '

hostname:
    aliases:
    - host
    default: localhost
    description: The host of the database if using dbms_service
    required: false

password:
    aliases:
    - pw
    default: None
    description: 'The password to connect to the database if using dbms_service

      '
    required: false

username:
    aliases:
    - un
    default: None
    description: 'The database username to connect to the database if using dbms_service

      '
    required: false

oracle_home:
    aliases:
    - oh
    default: None
    description: The name of the service
    required: true

service_name:
    aliases:
    - sn
    default: database_name. Will be set to the pdb-name if pdb is set
    description: 'The service_name to connect to the database if using dbms_service.

      '
    required: false

database_name:
    aliases:
    - db
    default: None
    description: The database in which the service will run
    required: true

available_instances:
    aliases:
    - ai
    default: None
    description: 'The RAC instances on which the service can run in case of failure of
      preferred_instances. Comma-separated list

      '
    required: false

preferred_instances:
    aliases:
    - pi
    default: None
    description: 'The RAC instances on which the service will actively run. Comma-separated
      list

      '
    required: false