Category: Uncategorized

This blog post describes how to use an on-prem Oracle Enterprise Manager 13c to monitor Oracle Cloud Infrastructure Autonomous Databases without internet traffic. In this case, a VPN connection from the data center Mohnweg/Jurasüdfuss/Switzerland to the OCI data center in Zurich is up and running. This method works with a Fast Connect too. From the Oracle Enterprise Manager 13.5 Administrator Guide: Oracle Enterprise Manager supports the following Autonomous Databases and the term “Autonomous Databases” in this guide collectively refers to them: Autonomous Data Warehouse – Dedicated Autonomous Transaction Processing – Dedicated Autonomous Data Warehouse – Shared Autonomous Transaction Processing – Shared Architecture On-Prem: Oracle Enterprise Manager 13.5 RU2 – OL 7 Oracle Cloud Infrastructure: Autonomous Transaction Processing – Shared Requirements…

Read More

Since a few days the 13.5.0.2 Enterprise Manager Cloud Control Base Platform Monthly Release Update (RU) 2 is available to apply. Time to update my 13.5 lab environment at home to get a first experience about a lot of new features like Oracle Cloud Infrastructure Resource Discovery, Oracle Enterprise Manager Dashboards, Database Scheduler Jobs Metrics and many more. Notes and Links My Oracle Support Notes 13.5.0 Enterprise Manager Cloud Control Base Platform Monthly Release Update (RU) 2 (Doc ID 2822316.1) Enterprise Manager 13.5 Main Release Update List (Includes Plug-ins) (Doc ID 2760230.2) Other Links https://blogs.oracle.com/observability/post/oracle-enterprise-manager-13c-release-5-update-2-13502-is-now-available https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.5/emcon/new-features-release-update.html Patch Number 33456001 The Environment Oracle Enterprise Manager 13.5 running on Oracle Linux 7.9 Oracle Enterprise Edition Repository 19.13 Single Tenant Oracle Restart /…

Read More

Cleaning up the OCI Resource Chaos This week I have removed all my Oracle Cloud Infrastructure lab resources and cleaned up my compartment to start from scratch building environments with the Automation Manager. There were a lot of resources with names like webserver01, vcn-lab-01, block-volume-web-clone-47 and so on. When I have realized this naming chaos, I have decided to spend some minutes today Friday to think about a small naming convention for my future Oracle Cloud Infrastructure projects. Why having a naming convention? Wikipedia says about Naming Convention: In computer programming, a naming convention is a set of rules for choosing the character sequence to be used for identifiers which denote variables, types, functions, and other entities in source code and documentation. Sounds good, this is what I need. There are…

Read More

In one of my lab environments where an Oracle 19c database is up and running, it was time to upgrade it to 21c by AutoUpgrade. The new ORACLE_HOME was ready, the software extracted. But when running the OUI installer in silent mode, it stops working: [FATAL] [INS-32035]. runInstaller – 1st run $ cd /u01/app/oracle/product/21.0.0/dbhome_1 $ ./runInstaller -ignorePrereq -waitforcompletion -silent \ -responseFile /u01/app/oracle/product/21.0.0/dbhome_1/install/response/db_install.rsp \ oracle.install.option=INSTALL_DB_SWONLY \ ORACLE_HOSTNAME=heckenweg.kestenholz.net \ UNIX_GROUP_NAME=oinstall \ INVENTORY_LOCATION=/u01/app/oraInventory \ SELECTED_LANGUAGES=en,en_GB \ ORACLE_HOME=/u01/app/oracle/product/21.0.0/dbhome_1 \ ORACLE_BASE=/u01/app/oracle \ oracle.install.db.InstallEdition=EE \ oracle.install.db.OSDBA_GROUP=dba \ oracle.install.db.OSBACKUPDBA_GROUP=dba \ oracle.install.db.OSDGDBA_GROUP=dba \ oracle.install.db.OSKMDBA_GROUP=dba \ oracle.install.db.OSRACDBA_GROUP=dba \ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \ DECLINE_SECURITY_UPDATES=true The error from the OUI logfile: SEVERE: [Aug 24, 2021 5:11:55 PM] [FATAL] [INS-32035] The location (/u01/app/oraInventory) specified for the central inventory is not empty. CAUSE: The specified…

Read More

One of my OCI favorites is finally arrived in Oracle Cloud Infrastructure data center eu-zurich-1 – the possibility to attach one Dynamic Routing Gateway DRG to multiple Virtual Cloud Networks VCNs. To see how it works, Simo has written three blog posts where it’s very well described. Now it’s time to upgrade my existing DRG! OCI Dynamic Routing Gateway Attachments Part 1 – Basics | That Finnish Guy OCI Dynamic Routing Gateway Attachments Part 2 – Dynamic Route Import Distributions | That Finnish Guy OCI Dynamic Routing Gateway Attachments Part 3 – Remote Peering Connections | That Finnish Guy Oracle’s OCI documentation: Dynamic Routing Gateways (DRGs) (oracle.com) How to upgrade an existing DRG? See here – just click on the…

Read More