rendanic.ansible_oracle.oracle_datapatch (4.0.0) — module

Install collection

Install with ansible-galaxy collection install rendanic.ansible_oracle:==4.0.0

Add to requirements.yml

  collections:
    - name: rendanic.ansible_oracle
      version: 4.0.0

Description

Create/delete a database using dbca

If a responsefile is available, that will be used. If initparams is defined, those will be attached to the createDatabase command

If no responsefile is created, the database will be created based on all other parameters

Requirements

• cx_Oracle

Inputs

    
sid:
    default: None
    description: The instance name
    required: false

port:
    default: 1521
    description: 'The listener port to connect to the database

      '
    required: false

user:
    aliases:
    - un
    default: sys
    description: 'Password for the DB user

      '

output:
    aliases:
    - db
    - database_name
    - name
    default: short
    description: 'The type of output you want. Verbose: stdout of the command short: Pre-defined
      message

      '
    required: false

db_name:
    aliases:
    - db
    - database_name
    - name
    default: None
    description: The name of the database
    required: true

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

      '
    required: false

password:
    aliases:
    - pw
    default: None
    description: 'Password for the DB user

      '
    required: true

oracle_home:
    aliases:
    - oh
    description: The home where the database will be created
    required: false

service_name:
    aliases:
    - sn
    description: 'The service_name to connect to (will default to db_name if empty)

      '
    required: false

db_unique_name:
    aliases:
    - dbunqn
    - unique_name
    default: None
    description: The database db_unique_name
    required: false

fail_on_db_not_exist:
    choices:
    - 'True'
    - 'False'
    default: true
    description: 'Fail the task if the db does not exist If False, continues the play
      (changed=False)

      '
    required: false