Never stop Learning – why I love Oracle LiveLabs

Since over one and a half year, this week I was back in an onsite training, live people, live teaching. With a motivated junior DBA class, we started with all about Oracle architecture based on our Trivadis training O-AI – Oracle Architecture and Internals. The training is a mix between slides, demos and labs. Therefore during the course we run the training environments in Oracle Cloud Infrastructure, build by Terraform (Credits to Stefan Oehrli from oradba.ch which has ramped up…

Read More

MV2OCI – One-Click Move of your Data into Oracle Cloud Infrastructure Database

mv2oci is a tool which helps to migrate on-premise data to the Oracle Cloud Infrastructure based on Oracle Data Pump and works as a data load tool. The local Data Pump export is transferred and imported to/on the target cloud server automatically. There is no use of Oracle Cloud Object Storage, the dump files are transferred with rsync or scp to the target database node. This is the different behavior to mv2adb – see my blogpost here – which uses…

Read More

Oracle Release Update 19.9 – Lab Update Time (Grid Infrastructure Standalone & RDBMS)

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…

Read More

Oracle Cloud Infrastructure – Security first: Cloud Guard and Security Zones – a first View

Two new Oracle Cloud Infrastructure Cloud Security Services Good news: Oracle has provided two new services for cloud security. Cloud Guard to get an overview of existing possible security breaches and Security Zones, which allows to create a full restricted compartment.  In this blog, I will give you a short overview about this brand new services. Cloud Guard The Cloud Guard service helps you to identify security issues in your tenancy. Before the first use, it has to be enabled…

Read More

Oracle Cloud Infrastructure and SSH Keys – Jump!

Jump! In our Trivadis Oracle Cloud Infrastructure training environments, we never use direct access to an application or database server by a public IP address. For this case, we use an Oracle Linux based bastion host which acts as a jump host. For security reasons, I never put any SSH keys on a bastion host to connect from there to the target instances. If your bastion host is compromitted, your SSH keys are lost! In one of the last trainings,…

Read More