When I connect from home to the Oracle Cloud Infrastructure normally I used a Bastion Host, an Open VPN compute instance or Public IPs. Some of the cool stuff like MV2OCI (which transfers data from on-premises to OCI) or integration of an ADB instance in my local running Oracle Enterprise Manager are referred to direct cloud connections. A SSH reverse tunnel works fine, but this cannot be a permanent solution for my lab environment. At home I have an Unifi Security Gateway (USG) up an running at home. This gateway has the capability, to create site-to-site VPN connections. Good: The Oracle Cloud Infrastruicture VPN service is for free, and I don’t expect over 10 TB outbound traffic. Time to create…
Read MoreCategory: Oracle Tools
Windows 10 WSL 2, Docker and Oracle – a perfect Partnership
I admit it, I was not a friend of Oracle databases running in Docker containers for a long time. My database systems for testing and demo purposes were all running in VMware, Virtual Box or in the Oracle Cloud. But I have used the Windows Subsystem for Linux since beginning, to work with the Oracle Oracle Cloud Infrastructure CLI, Git Integration etc.. And what I really like is the WSL extension for Visual Studio Code which gives me to chance, to edit Ansible Vault files in Windows without any additional Linux based VM running. With the update of the existing Windows Subsystem for Linux (WSL) architecture to version 2, the Docker Desktop for Windows is now fully integrated and able…
Read MoreOracle Enterprise Manager EM13c – My Oracle Support is back!
Since a few weeks, the online connection in Oracle Enterprise Manager EM13c to My Oracle Support was broken. This resulted in errors like Error occurred when sending request to My Oracle Support, for example when you tried to set the My Oracle Support credentials in a fresh EM13c setup. Existing configurations were not able to get newest patch information anymore. Oracle has documented it in the note Recent Changes to MOS will Disable Enterprise Manager Online Connections (Doc ID 2664002.1). Screenshot when trying to set MOS credentials in a new EM13c RU4 setup: Now there is a fix available for all current EM 13 releases, RU included. For more details see Patch Now Available For Recent Changes to MOS That Disabled…
Read MoreMV2ADB – One-Click Move of your Data into OCI Autonomous Databases – Auto Operation
In the previous blog post MV2ADB – One-Click Move of your Data into OCI Autonomous Databases – Step by Step I wrote about the new Oracle Cloud Infrastructure tool to transfer local data into Autonomous Databases step by step. There you see how to install and configure mv2adb and how to transfer your data to ADB step by step. The auto operation parameter is now “all in one”, one parameter and all required steps like export, transfer etc. are done fully automated. Prerequisites mv2adb rpm package installed, always get the newest version from My Oracle Support (Doc ID 2463574.1) HTTP/SQL*Net Connectivity from the on premises server to the Autonomous Database Autonomous Database Wallet (can be downloaded from the ATP main…
Read MoreEasy 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