— Go to Directory location for Statspack Install scripts on the VMDB host —cd /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/admin — From cdb$root — sqlplus…
Oracle Autonomous Database now supports capturing of Data using an Extract and applying it to another Autonomous Database in another…
You have essentially 2 options if you want to replicate data from on-premise Oracle database to Redshift : Option 1…
Connect to Autonomous Database Private Endpoint from On-Premise SQL Developer using SSH Local Port Forwarding Assumptions: Your Bastion/ServiceVM/Bastion Host is…
Architecture: Source : DBCS on Classic 12.1 Enterprise Edition Target : OCI gen2 Autonomous Data Warehouse 19c Pre-Req:———1. Install and…
https://docs.cloud.oracle.com/iaas/Content/Compute/Tasks/managingkeypairs.htm https://docs.cloud.oracle.com/iaas/Content/Compute/Tasks/accessinginstance.htm Generate a local private and public keyfile on the client machine $ ssh-keygen -o $ cd .ssh/ $…
Create Oracle Autonomous Transaction Processing Database(ATP) in your Oracle Cloud Account. Create wallet and down the wallet to your bastion…
We will use Infrastructure automation tool Terraform create an EC2 image in region ‘us-east-1’ with ami id as ‘ami-408c7f28’. If…