oracle.oci.oci_database_migration_connection_actions (5.0.0) — module

Perform actions on a Connection resource in Oracle Cloud Infrastructure

| "added in version" 2.9.0 of oracle.oci"

Authors: Oracle (@oracle)

preview | supported by community

Install collection

Install with ansible-galaxy collection install oracle.oci:==5.0.0


Add to requirements.yml

  collections:
    - name: oracle.oci
      version: 5.0.0

Description

Perform actions on a Connection resource in Oracle Cloud Infrastructure

For I(action=change_compartment), used to change the Database Connection compartment.

For I(action=connection_diagnostics), perform connection test for a database connection.


Requirements

Usage examples

  • Success
    Steampunk Spotter scan finished with no errors, warnings or hints.
- name: Perform action change_compartment on connection
  oci_database_migration_connection_actions:
    # required
    compartment_id: "ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx"
    connection_id: "ocid1.connection.oc1..xxxxxxEXAMPLExxxxxx"
    action: change_compartment
  • Success
    Steampunk Spotter scan finished with no errors, warnings or hints.
- name: Perform action connection_diagnostics on connection
  oci_database_migration_connection_actions:
    # required
    connection_id: "ocid1.connection.oc1..xxxxxxEXAMPLExxxxxx"
    action: connection_diagnostics

Inputs

    
action:
    choices:
    - change_compartment
    - connection_diagnostics
    description:
    - The action to perform on the Connection.
    required: true
    type: str

region:
    description:
    - The Oracle Cloud Infrastructure region to use for all OCI API requests. If not set,
      then the value of the OCI_REGION variable, if any, is used. This option is required
      if the region is not specified through a configuration file (See C(config_file_location)).
      Please refer to U(https://docs.us-phoenix-1.oraclecloud.com/Content/General/Concepts/regions.htm)
      for more information on OCI regions.
    type: str

tenancy:
    description:
    - OCID of your tenancy. If not set, then the value of the OCI_TENANCY variable, if
      any, is used. This option is required if the tenancy OCID is not specified through
      a configuration file (See C(config_file_location)). To get the tenancy OCID, please
      refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm)
    type: str

api_user:
    description:
    - The OCID of the user, on whose behalf, OCI APIs are invoked. If not set, then the
      value of the OCI_USER_ID environment variable, if any, is used. This option is required
      if the user is not specified through a configuration file (See C(config_file_location)).
      To get the user's OCID, please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm).
    type: str

auth_type:
    choices:
    - api_key
    - instance_principal
    - instance_obo_user
    - resource_principal
    - security_token
    default: api_key
    description:
    - The type of authentication to use for making API requests. By default C(auth_type="api_key")
      based authentication is performed and the API key (see I(api_user_key_file)) in
      your config file will be used. If this 'auth_type' module option is not specified,
      the value of the OCI_ANSIBLE_AUTH_TYPE, if any, is used. Use C(auth_type="instance_principal")
      to use instance principal based authentication when running ansible playbooks within
      an OCI compute instance.
    type: str

cert_bundle:
    description:
    - The full path to a CA certificate bundle to be used for SSL verification. This will
      override the default CA certificate bundle. If not set, then the value of the OCI_ANSIBLE_CERT_BUNDLE
      variable, if any, is used.
    type: str

auth_purpose:
    choices:
    - service_principal
    description:
    - The auth purpose which can be used in conjunction with 'auth_type=instance_principal'.
      The default auth_purpose for instance_principal is None.
    type: str

connection_id:
    aliases:
    - id
    description:
    - The OCID of the database connection
    required: true
    type: str

compartment_id:
    description:
    - The OCID of the compartment to move the resource to.
    - Required for I(action=change_compartment).
    type: str

api_user_key_file:
    description:
    - Full path and filename of the private key (in PEM format). If not set, then the
      value of the OCI_USER_KEY_FILE variable, if any, is used. This option is required
      if the private key is not specified through a configuration file (See C(config_file_location)).
      If the key is encrypted with a pass-phrase, the C(api_user_key_pass_phrase) option
      must also be provided.
    type: str

config_profile_name:
    description:
    - The profile to load from the config file referenced by C(config_file_location).
      If not set, then the value of the OCI_CONFIG_PROFILE environment variable, if any,
      is used. Otherwise, defaults to the "DEFAULT" profile in C(config_file_location).
    type: str

api_user_fingerprint:
    description:
    - Fingerprint for the key pair being used. If not set, then the value of the OCI_USER_FINGERPRINT
      environment variable, if any, is used. This option is required if the key fingerprint
      is not specified through a configuration file (See C(config_file_location)). To
      get the key pair's fingerprint value please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm).
    type: str

config_file_location:
    description:
    - Path to configuration file. If not set then the value of the OCI_CONFIG_FILE environment
      variable, if any, is used. Otherwise, defaults to ~/.oci/config.
    type: str

api_user_key_pass_phrase:
    description:
    - Passphrase used by the key referenced in C(api_user_key_file), if it is encrypted.
      If not set, then the value of the OCI_USER_KEY_PASS_PHRASE variable, if any, is
      used. This option is required if the key passphrase is not specified through a configuration
      file (See C(config_file_location)).
    type: str

realm_specific_endpoint_template_enabled:
    description:
    - Enable/Disable realm specific endpoint template for service client. By Default,
      realm specific endpoint template is disabled. If not set, then the value of the
      OCI_REALM_SPECIFIC_SERVICE_ENDPOINT_TEMPLATE_ENABLED variable, if any, is used.
    type: bool

Outputs

connection:
  contains:
    admin_credentials:
      contains:
        username:
          description:
          - Administrator username
          returned: on success
          sample: username_example
          type: str
      description:
      - ''
      returned: on success
      type: complex
    certificate_tdn:
      description:
      - This name is the distinguished name used while creating the certificate on
        target database.
      returned: on success
      sample: certificate_tdn_example
      type: str
    compartment_id:
      description:
      - OCID of the compartment
      returned: on success
      sample: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
      type: str
    connect_descriptor:
      contains:
        connect_string:
          description:
          - Connect string.
          returned: on success
          sample: connect_string_example
          type: str
        database_service_name:
          description:
          - Database service name.
          returned: on success
          sample: database_service_name_example
          type: str
        host:
          description:
          - Host of the connect descriptor.
          returned: on success
          sample: host_example
          type: str
        port:
          description:
          - Port of the connect descriptor.
          returned: on success
          sample: 56
          type: int
      description:
      - ''
      returned: on success
      type: complex
    credentials_secret_id:
      description:
      - OCID of the Secret in the OCI vault containing the Database Connection credentials.
      returned: on success
      sample: ocid1.credentialssecret.oc1..xxxxxxEXAMPLExxxxxx
      type: str
    database_id:
      description:
      - The OCID of the cloud database.
      returned: on success
      sample: ocid1.database.oc1..xxxxxxEXAMPLExxxxxx
      type: str
    database_type:
      description:
      - Database connection type.
      returned: on success
      sample: MANUAL
      type: str
    defined_tags:
      description:
      - 'Defined tags for this resource. Each key is predefined and scoped to a namespace.
        Example: `{"foo-namespace": {"bar-key": "value"}}`'
      returned: on success
      sample:
        Operations:
          CostCenter: US
      type: dict
    display_name:
      description:
      - Database Connection display name identifier.
      returned: on success
      sample: display_name_example
      type: str
    freeform_tags:
      description:
      - 'Simple key-value pair that is applied without any predefined name, type or
        scope. Exists for cross-compatibility only. Example: `{"bar-key": "value"}`'
      returned: on success
      sample:
        Department: Finance
      type: dict
    id:
      description:
      - The OCID of the resource
      returned: on success
      sample: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
      type: str
    is_dedicated:
      description:
      - True if the Autonomous Connection is dedicated. Not provided for Non-Autonomous
        Connections.
      returned: on success
      sample: true
      type: bool
    lifecycle_details:
      description:
      - A message describing the current state in more detail. For example, can be
        used to provide actionable information for a resource in Failed state.
      returned: on success
      sample: lifecycle_details_example
      type: str
    lifecycle_state:
      description:
      - The current state of the Connection resource.
      returned: on success
      sample: CREATING
      type: str
    manual_database_sub_type:
      description:
      - Database manual connection subtype. This value can only be specified for manual
        connections.
      returned: on success
      sample: ORACLE
      type: str
    nsg_ids:
      description:
      - An array of Network Security Group OCIDs used to define network access for
        Connections.
      returned: on success
      sample: []
      type: list
    private_endpoint:
      contains:
        compartment_id:
          description:
          - The L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm)
            of the compartment to contain the private endpoint.
          returned: on success
          sample: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
          type: str
        id:
          description:
          - L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm)
            of a previously created Private Endpoint.
          returned: on success
          sample: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
          type: str
        subnet_id:
          description:
          - The L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm)
            of the customer's subnet where the private endpoint VNIC will reside.
          returned: on success
          sample: ocid1.subnet.oc1..xxxxxxEXAMPLExxxxxx
          type: str
        vcn_id:
          description:
          - The L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm)
            of the VCN where the Private Endpoint will be bound to.
          returned: on success
          sample: ocid1.vcn.oc1..xxxxxxEXAMPLExxxxxx
          type: str
      description:
      - ''
      returned: on success
      type: complex
    replication_credentials:
      contains:
        username:
          description:
          - Administrator username
          returned: on success
          sample: username_example
          type: str
      description:
      - ''
      returned: on success
      type: complex
    ssh_details:
      contains:
        host:
          description:
          - Name of the host the SSH key is valid for.
          returned: on success
          sample: host_example
          type: str
        sudo_location:
          description:
          - Sudo location
          returned: on success
          sample: sudo_location_example
          type: str
        user:
          description:
          - SSH user
          returned: on success
          sample: user_example
          type: str
      description:
      - ''
      returned: on success
      type: complex
    system_tags:
      description:
      - 'Usage of system tag keys. These predefined keys are scoped to namespaces.
        Example: `{"orcl-cloud": {"free-tier-retained": "true"}}`'
      returned: on success
      sample: {}
      type: dict
    time_created:
      description:
      - The time the Connection resource was created. An RFC3339 formatted datetime
        string.
      returned: on success
      sample: '2013-10-20T19:20:30+01:00'
      type: str
    time_updated:
      description:
      - The time of the last Connection resource details update. An RFC3339 formatted
        datetime string.
      returned: on success
      sample: '2013-10-20T19:20:30+01:00'
      type: str
    vault_details:
      contains:
        compartment_id:
          description:
          - OCID of the compartment where the secret containing the credentials will
            be created.
          returned: on success
          sample: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
          type: str
        key_id:
          description:
          - OCID of the vault encryption key
          returned: on success
          sample: ocid1.key.oc1..xxxxxxEXAMPLExxxxxx
          type: str
        vault_id:
          description:
          - OCID of the vault
          returned: on success
          sample: ocid1.vault.oc1..xxxxxxEXAMPLExxxxxx
          type: str
      description:
      - ''
      returned: on success
      type: complex
  description:
  - Details of the Connection resource acted upon by the current operation
  returned: on success
  sample:
    admin_credentials:
      username: username_example
    certificate_tdn: certificate_tdn_example
    compartment_id: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
    connect_descriptor:
      connect_string: connect_string_example
      database_service_name: database_service_name_example
      host: host_example
      port: 56
    credentials_secret_id: ocid1.credentialssecret.oc1..xxxxxxEXAMPLExxxxxx
    database_id: ocid1.database.oc1..xxxxxxEXAMPLExxxxxx
    database_type: MANUAL
    defined_tags:
      Operations:
        CostCenter: US
    display_name: display_name_example
    freeform_tags:
      Department: Finance
    id: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
    is_dedicated: true
    lifecycle_details: lifecycle_details_example
    lifecycle_state: CREATING
    manual_database_sub_type: ORACLE
    nsg_ids: []
    private_endpoint:
      compartment_id: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
      id: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
      subnet_id: ocid1.subnet.oc1..xxxxxxEXAMPLExxxxxx
      vcn_id: ocid1.vcn.oc1..xxxxxxEXAMPLExxxxxx
    replication_credentials:
      username: username_example
    ssh_details:
      host: host_example
      sudo_location: sudo_location_example
      user: user_example
    system_tags: {}
    time_created: '2013-10-20T19:20:30+01:00'
    time_updated: '2013-10-20T19:20:30+01:00'
    vault_details:
      compartment_id: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
      key_id: ocid1.key.oc1..xxxxxxEXAMPLExxxxxx
      vault_id: ocid1.vault.oc1..xxxxxxEXAMPLExxxxxx
  type: complex