ibre5041.ansible_oracle_modules.oracle_pdb (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 pluggable databases in Oracle

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

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

---
- name: Creates a pdb on a different filesystem
  oracle_pdb:
    mode: sysdba
    pdb_name: "XEPDB2"
    state: "closed"
    pdb_admin_username: foo
    pdb_admin_password: bar
    roles: connect
    datafile_dest: /u02/oradata/pdb1
    sourcedb: cdb1

Scanned by Steampunk Spotter

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

- name: Remove a pdb
  oracle_pdb:
    mode: sysdba    
    pdb_name: pdb1
    state: absent

Scanned by Steampunk Spotter

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

- name: Check the status for a pdb
  oracle_pdb:
    mode: sysdba    
    pdb_name: pdb1
    state: status
  register: _oracle_pdb_status

Scanned by Steampunk Spotter

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

- name: Unplug a pdb
  oracle_pdb:
    mode: sysdba    
    pdb_name: pdb1
    plug_file: /tmp/unplugged-pdb.xml
    state: unplugged

Scanned by Steampunk Spotter

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

- name: plug in a pdb
  oracle_pdb:
    mode: sysdba
    pdb_name: plug1
    plug_file: /tmp/unplugged-pdb.xml
    state: present
    pdb_admin_username: foo
    pdb_admin_password: bar

Inputs

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

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

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

state:
    choices:
    - present
    - absent
    - status
    default: present
    description: The intended state of the pdb. status will just show the status of the
      pdb

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

password:
    aliases:
    - pw
    default: None
    description: The password to connect to the database
    required: false

sourcedb:
    aliases:
    - db
    default: None
    description: The container database which will house the pdb
    required: false

username:
    aliases:
    - un
    default: None
    description: The database username to connect to the database
    required: false

oracle_home:
    default: None
    description: The ORACLE_HOME to use
    required: false

service_name:
    aliases:
    - sn
    default: database_name
    description: The service_name to connect to the database
    required: false

datafile_dest:
    aliases:
    - dfd
    default: None
    description: The path where the datafiles will be placed
    required: false

pdb_admin_password:
    aliases:
    - pw
    default: pdb_admin
    description: The password for the pdb admin user
    required: false

pdb_admin_username:
    aliases:
    - un
    default: pdb_admin
    description: The username for the pdb admin user
    required: false