ibre5041.ansible_oracle_modules.oracle_crs_service (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 CRS/HAS Database services

Usage examples

Scanned by Steampunk Spotter

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

- name: Create service
  oracle_crs_service:
    name: PRIMARY_SERVICE
    db: DBSID
    state: present
    enabled: true
  register: _

Scanned by Steampunk Spotter

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

- name: Restart database service
  oracle_crs_service:
    name: PRIMARY_SERVICE
    db: DBSID
    state: restarted
  register: _

Inputs

    
db:
    description:
    - -db <db_unique_name> Unique name for the database
    required: true

pdb:
    description:
    - -pdb <pluggable_database> Pluggable database name
    required: false

name:
    description:
    - -service <serv,...> Comma separated service names
    - Or just this for single service name
    required: true

role:
    choices:
    - PRIMARY
    - PHYSICAL_STANDBY
    - LOGICAL_STANDBY
    - SNAPSHOT_STANDBY
    description:
    - -role <role> Role of the service
    required: false

force:
    default: false
    description:
    - Force stop, will stop database and any associated services and any dependent resources
    - Force remove (ignore dependencies)
    - Force the add operation even though a listener is not configured for a network
    required: false
    type: bool

state:
    choices:
    - present
    - absent
    - started
    - stopped
    - restarted
    description:
    - Resource state

global:
    description:
    - -global <global> Global attribute (TRUE or FALSE)
    type: bool

maxlag:
    description:
    - -maxlag <max_lag_time> Maximum replication lag time in seconds (Non-negative integer,
      default value is 'ANY')
    required: false

policy:
    choices:
    - AUTOMATIC
    - MANUAL
    description:
    - -policy <policy> Management policy for the service (AUTOMATIC or MANUAL)
    required: false

clbgoal:
    choices:
    - SHORT
    - LONG
    description:
    - -clbgoal (SHORT | LONG) Connection Load Balancing Goal. Default is LONG.
    required: false

edition:
    description:
    - -edition <edition> Edition (or "" for empty edition value)
    required: false

enabled:
    default: true
    description:
    - Enables the service
    type: bool

rlbgoal:
    choices:
    - SERVICE_TIME
    - THROUGHPUT
    - NONE
    description:
    - -rlbgoal (SERVICE_TIME | THROUGHPUT | NONE) Runtime Load Balancing Goal

retention:
    description:
    - -retention <retention> Specifies the number of seconds the commit outcome is retained
    required: false

stopoption:
    choices:
    - TRANSACTIONAL
    - IMMEDIATE
    description:
    - -stopoption <stop_options>     Options to stop service (e.g. TRANSACTIONAL or IMMEDIATE)
    required: false

failovertype:
    choices:
    - NONE
    - SESSION
    - SELECT
    - TRANSACTION
    - AUTO
    description:
    - -failovertype (NONE | SESSION | SELECT | TRANSACTION | AUTO) Failover type
    required: false

notification:
    description:
    - -notification (TRUE | FALSE)  Enable Fast Application Notification (FAN) for OCI
      connections
    type: bool

drain_timeout:
    description:
    - -drain_timeout <drain_timeout> Service drain timeout specified in seconds
    required: false

failoverdelay:
    description:
    - -failoverdelay <failover_delay> Failover delay (in seconds)
    required: false

failoverretry:
    description:
    - -failoverretry <failover_retries> Number of attempts to retry connection
    required: false

session_state:
    choices:
    - STATIC
    - DYNAMIC
    description:
    - -session_state <session_state> Session state consistency (STATIC or DYNAMIC)
    required: false

tablefamilyid:
    description:
    - -tablefamilyid <table_family_id> Set table family ID for a given service
    required: false

commit_outcome:
    description:
    - -commit_outcome (TRUE | FALSE) Commit outcome
    required: false
    type: bool

failovermethod:
    choices:
    - NONE
    - BASIC
    description:
    - -failovermethod (NONE | BASIC) Failover method
    required: false

failover_restore:
    choices:
    - NONE
    - LEVEL1
    description:
    - -failover_restore <failover_restore> Option to restore initial environment for Application
      Continuity and TAF (NONE or LEVEL1)
    required: false

replay_init_time:
    description:
    - -replay_init_time <replay_initiation_time> Seconds after which replay will not be
      initiated
    required: false

sql_translation_profile:
    description:
    - -sql_translation_profile <sql_translation_profile> Specify a database object for
      SQL translation profile
    required: false