ibre5041.ansible_oracle_modules.oracle_services (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

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