Easy Database Migration to Oracle Cloud Infrastructure OCI by Creating a Backup in the Cloud

Oracle has provided an updated OCI command line toolset with a new and easy method to migrate an on-premises database into the Oracle Cloud Infrastructure as DBaaS. According the document here, I have tried it out – and it works: https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/mig-onprembackup.htm My Test Setup Oracle 18c Enterprise Edition with SID=ORA18 Single Tenant Architecture Oracle Linux 7.4 non TDE – Attention: non TDE on-premises data stays unencrypted in the cloud !!! Database and Server Prerequisites Archivelog Mode is enabled Parameter db_create_file_dest is set Server needs Internet Connection Oracle OCI CLI installed and configured – https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliinstall.htm#bash OPC Backup Module available –  https://www.oracle.com/technetwork/database/availability/oracle-cloud-backup-2162729.html Java installed – https://www.java.com/de/download/help/linux_x64rpm_install.xml The OCI CLI Directory  OCI CLI and opc_install.jar plus the .pem file have to be in the same directory. oracle@ol7ora18:~/migrate/…

Read More

Get your Oracle 18c Instance in the Oracle Infrastructure Cloud OCI Classic

Do you want to work with Oracle 18c in the Oracle Cloud but the database version is not selectable in the webinterface? You can create an 18c instance in the command-line interface with the PaaS Service Manager (psm). The installation is very well described here, for example you need Python and OpenSSL. My personal installation of the psm executable runs in the Windows 10 integrated Ubuntu system. Link to the PaaS Service Manager: https://docs.oracle.com/en/cloud/paas/java-cloud/pscli/abouit-paas-service-manager-command-line-interface.html After the successful psm setup, you can create an DBaaS instance with this command $ psm dbcs create-service –config-payload db18c-ee.json The file db18c-ee.json contains all the information you need to create an 18c instance. Here is my example – I have created a cloud storage container…

Read More