This code will help you deploy a compute instance and a Virtual Machine (VM) database system in Oracle Cloud Infrastructure.

For details of the architecture, see Migrate an on-premises Oracle Database deployment to a virtual machine DB system

The terraform code will deploy a VCN, a 4 OCPU compute instance in a private subnet and a VM database in a separate private subnet.

• Permission to manage the following types of resources in your Oracle Cloud Infrastructure tenancy: vcns, internet-gateways, route-tables, security-lists, subnets, database-family, and instances.

• Quota to create the following resources: 1 VCN, 2 subnets, 1 Internet Gateway, 1 NAT Gateway, 2 route rules, 1 DB System instance, and 1 compute instance.

If you don't have the required permissions and quota, contact your tenancy administrator. See Policy Reference, Service Limits, Compartment Quotas.

1. Click

   If you aren't already signed in, when prompted, enter the tenancy and user credentials.

2. Review and accept the terms and conditions.

3. Select the region where you want to deploy the stack.

4. Follow the on-screen prompts and instructions to create the stack.

5. After creating the stack, click Terraform Actions, and select Plan.

6. Wait for the job to be completed, and review the plan.

   To make any changes, return to the Stack Details page, click Edit Stack, and make the required changes. Then, run the Plan action again.

7. If no further changes are necessary, return to the Stack Details page, click Terraform Actions, and select Apply.

Now, you'll want a local copy of this repo. You can make that with the commands:

git clone https://github.com/oracle-devrel/terraform-oci-arch-db-migration.git
cd terraform-oci-arch-db-migration/oci-arch-se-vm-db-mig
ls

1. Complete the prerequisites described here.

2. Create a terraform.tfvars file, and specify the following variables:

# Authentication
tenancy_ocid         = "<tenancy_ocid>"
user_ocid            = "<user_ocid>"
fingerprint          = "<finger_print>"
private_key_path     = "<pem_private_key_path>"

# Region
region = "<oci_region>"

# Compartment
compartment_ocid = "<compartment_ocid>"

# Database Admin Password
db_admin_password = "<db_admin_password>"

Run the following commands:

terraform init
terraform plan
terraform apply

When you no longer need the deployment, you can run this command to destroy the resources:

terraform destroy