The roll-out of the newest Oracle Enterprise Manager 13 Release 4 is a few days old, about time to try out the upgrade process in my ESXi lab environment. First: This blog post about the OEM upgrade process is based on my own experience. Software https://www.oracle.com/enterprise-manager/downloads/cloud-control-downloads.html Documents https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.4/emupg/index.html The Environment Oracle Enterprise Manager 13.3 running on Oracle Linux 7.6 – OEM Patchlevel January 2020 – Non-HA Oracle Enterprise Edition Repository 19.6.0 Single Tenant Database Oracle Restart / ASM 19.6.0 Additional Oracle Linux Server with 19.3.0 Container Databases All targets up and running My Oracle Support connected Software staged directory in /u01/app/oracle/stage/em13cr4 and permission changed to execute bin file (chmod u+x em13400_linux64.bin). oracle@kestenholz:/u01/app/oracle/stage/em13cr4/ [oms1303] ll total 12429656 drwxr-xr-x 2 oracle oinstall…
Read MoreCategory: Oracle RDBMS
Oracle Cloud Infrastructure – Change a Compute Instance Shape – Tested
There is a new feature available in Oracle Cloud infrastructure since the 13th of January 2020, now you can change the shape of a Compute instance. It replaces all the manual steps like stopping the existing instance, create a new one, attach the block device etc. – this is a short summary how it works. From the OCI Release Notes : You can change the shape of a virtual machine (VM) instance without having to rebuild your instances or redeploy your applications. This lets you scale up your Compute resources for increased performance, or scale down to reduce cost. My existing Compute Instance The existing machine has the shape VM-Standard2.1 – one OCPU and 15GB of memory. [opc@webserverpublic01 ~]$ cat…
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 MoreHow to build OCI Infrastructure Environments with Ansible
The Oracle provided Ansible module gives us the opportunity to provision and configure Oracle Cloud Infrastructure resources on an automated base. The Ansible basic setup is very easy and the Oracle provided example playbooks in Git are a good base to start with your infrastructure automation project. Oracle provides Ansible example playbooks for Block Volumes Compute Database File Storage IAM Load Balancer Private Subnets with VPN Delete Objects etc. In this blog post, I will show you how easy it is to bring Ansible and the Oracle Cloud Infrastructure together. Requirements A local machine to install Ansible and the required software and modules, in my case it’s an Oracle Linux 7 virtual machine with Internet access. An Oracle Cloud Infrastructure…
Read MoreOracle Autonomous Transaction Processing – Move your Data with Oracle Data Pump – Part 3
In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump. Part 1: Creation of the ATP database and connection verification Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud Part 3: Import of data into the ATP database with Oracle Data Pump Oracle Import Prerequisites Credentials To get acccess to the dump file on the Oracle Object Storage, a credential has to be created in the Oracle Autonomous Transaction Processing database with the DBMS_CLOUD procedure. For more information about the package, see the blog post from Christian Antognini – DBMS_CLOUD Package – A…
Read More