The Oracle Release update 19.9 for Linux is available since a few days. Time to upgrade my lab environment at home which consists of the following components: Oracle Grid Infrastructure Standalone 19.8.0 with ASM Normal Redundancy – +ASM Oracle 19.8.0 RDBMS as Repository for Oracle Enterprise Manager – EMREPO The running 19.8 Environment Output from Trivadis base environment tool TVD-Basenv(TM). oracle@mohnweg:/u01/app/19.0.0/grid/OPatch/ [em13cr4] u TYPE (Cluster|DG) : SID/PROCESS STATUS HOME [2020-10-25 19:47:47] ——————————————————————————— Dummy em13cr3 : em13cr4 n/a /u01/app/oracle/product/em13cr4 Dummy emagent : emagent n/a /u01/app/oracle/product/agent13c/agent_13.4.0.0.0 Dummy emagent : emagent_a n/a /u01/app/oracle/product/agent13c/agent_inst Dummy grinf : grinf19 n/a /u01/app/19.0.0/grid Dummy rdbms_ee : rdbms19 n/a /u01/app/oracle/product/19.0.0/dbhome_1 ASM-instance : +ASM up /u01/app/19.0.0/grid DB-instance (N|N) : EMREPO open /u01/app/oracle/product/19.0.0/dbhome_1 Listener : LISTENER up /u01/app/19.0.0/grid Ohs 12c…
Read MoreCategory: Oracle Tools
Let’s IPSec VPN – How to connect your Unifi Security Gateway to Oracle Cloud Infrastructure
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 MoreWindows 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 More