Database links

[tyskjohan]

Just checking if anyone has looked at managing database links from Ansible?

[oravirt]

I've been meaning to explore this but I literally have no time to do so at the moment.

[werner-s-germany]

actually I use create database link via oracle_sql:

# create dblink is not idempotent, so ignore errors 
- name: create dblink 
  oracle_sql: 
    hostname: "{{ oraclehost }}"
    port: "{{ oracleport }}"
    service_name: "{{ oracleservice }}"
    user: "{{ dblink_owner }}"
    password: "{{ schemapwd_rcsus_sync_std }}"
    sql: "CREATE DATABASE LINK {{ dblink_name }} CONNECT TO {{ remote_dbl_schema }} IDENTIFIED BY {{ schemapwd_remote_dbl_schema }} USING '{{ tns_remote_db }}'"
  environment: "{{ oracle_env }}"
  ignore_errors: true