ari_stark.ansible_oracle_modules.oracle_services (1.2.1) — module

Install collection

Install with ansible-galaxy collection install ari_stark.ansible_oracle_modules:==1.2.1

Add to requirements.yml

  collections:
    - name: ari_stark.ansible_oracle_modules
      version: 1.2.1

Description

Manage services in an Oracle database

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

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

- name: Create a service
  oracle_services:
    name: service1
    database_name: db1
    state: present

Scanned by Steampunk Spotter

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

- name: Start a service
  oracle_services:
    name: service1
    database_name: db1
    state: started

Scanned by Steampunk Spotter

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

- name: Stop a service
  oracle_services:
    name: service1
    database_name: db1
    state: stopped

Scanned by Steampunk Spotter

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

- name: Remove a service
  oracle_services:
    name: service1
    database_name: db1
    state: absent

Scanned by Steampunk Spotter

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

- name: Create a service in a RAC pdb and run it on a subset of nodes/instances
  oracle_services:
    name: service1
    database_name: raccdb
    oh: /u01/app/oracle/12.1.0.2/db1
    pdb: mypdb
    pi: raccdb1
    ai: raccdb2,raccdb3
    state: present

Inputs

    
pdb:
    description:
    - The pdb which the service is attached to
    required: false
    type: str

name:
    aliases:
    - service
    description:
    - The name of the service
    required: true
    type: str

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

role:
    choices:
    - primary
    - physical_standby
    - logical_standby
    - snapshot_standby
    description:
    - Role of the service (primary, physical_standby, logical_standby, snapshot_standby)
    required: false
    type: str

user:
    aliases:
    - un
    - username
    description:
    - The database username to connect to the database if using dbms_service
    required: false
    type: str

force:
    default: false
    description:
    - Adds the 'force' flag to the srvctl command
    type: bool

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

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

password:
    aliases:
    - pw
    description:
    - The password to connect to the database if using dbms_service
    required: false
    type: str

oracle_home:
    aliases:
    - oh
    description:
    - The name of the service
    required: false
    type: str

service_name:
    aliases:
    - sn
    description:
    - The service_name to connect to the database if using dbms_service.
    - If not defined, I(database_name) will be used or pdb-name if I(pdb) is set.
    required: false
    type: str

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

available_instances:
    aliases:
    - ai
    description:
    - The RAC instances on which the service can run in case of failure of preferred_instances.
    - Comma-separated list
    required: false
    type: str

preferred_instances:
    aliases:
    - pi
    description:
    - The RAC instances on which the service will actively run. Comma-separated list
    required: false
    type: str