ANSIBLE-DG.md

Configure Oracle Data Guard via Ansible

On the compute source running Ubuntu or on Azure Cloud Shell, follow the steps given below:

1. Switch to the oracle subdirectory:

cd ~/lza-oracle/ansible/bootstrap/oracle

1. Create a new file called inventory and populate it with the following content. Replace <hostname> and <Public IP address of the Azure VM created via terraform> with the appropriate values before running the command:

cat > inventory <<EOF
[ora-x1]
vm-primary-0 ansible_host=<Public IP address of the primary node created via terraform or Bicep>  ansible_ssh_private_key_file=~/.ssh/lza-oracle-data-guard ansible_user=oracle
[ora-x2]
vm-secondary-0 ansible_host=<Public IP address of the secondary node created via terraform or Bicep>   ansible_ssh_private_key_file=~/.ssh/lza-oracle-data-guard ansible_user=oracle
EOF

You can also edit the existing "inventory_dg" file and rename it as "inventory".

Below is an example of what the "inventory" file should look like after running the above command:

1. Start the ansible playbook

ansible-playbook playbook_dg.yml -i inventory --extra-vars "data_guard=yes"

(If you are prompted for "are you sure you want to continue connecting?", enter "yes")

(If using Azure Cloud Shell, remember to refresh your browser by scrolling up or down, every 15 minutes or so since the shell times out after 20 minutes of inaction.)

If you get an error stating "ERROR! Invalid callback for stdout specified: community.general.yaml" then run the following step and then re-run the previous step.

ansible-galaxy collection install community.general

It is acceptable to see warnings highlighted in red.

1. Once the installation and configuration completes, you will see a screen similar to the one below.

1. The installation has now completed and you can connect to the databases to test failover and failback. See the Ansible Data Guard Testing for more details.