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 MoreOracle Cloud Infrastructure – one DRG to many VCNs – arrived in Zurich / Switzerland – Upgrade Time!
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 MoreOracle EM13c in Oracle Cloud Infrastructure – sending Mail Notifications by Email Delivery Service
For the Trivadis Oracle Enterprise Manager Training, we setup and Oracle EM13c in the Oracle Cloud Infrastructure. One student exercise is, to setup notification rules. Therefore a mail server is required. In Oracle Cloud Infrastructure, there is an Email Delivery service available which fits best: Overview of the Email Delivery Service (oracle.com) I have tried to setup a local postfix mail gateway which used the NAT gateway address as sender’s address. But the NAT gateway addresses are blacklisted in spam services like spamhaus.com. Even Microsoft doesn’t want to allow these mails send by the NAT gateway. You can see my attempts at the bottom of this blog post. Setup Subnet Component Purpose Public Virtual Machine Bastion Server, SSH Access, Apache…
Read MoreOCI Cloud Performance Management for On-Premises Databases – Part 2 – Database Configuration
In the part 1 of this blog post series, we have installed the Management Agent. Now it’s time to add the database. For this case an agent plug-in has to be installed first before we can configure the database. More information about the management agent administration: https://docs.oracle.com/en-us/iaas/management-agents/doc/management-agents-administration-tasks.html This is a small blog post series Part 1 shows the installation of the Management Agent on an on-premises system Part 2 describes how to manage this Oracle database in OCI Part 3 watches behind the scenes for billing, job execution etc. – coming soon… My Setup An OCI Tenant in datacenter EU-FRANKFURT-1 An empty compartment called datacenter-kestenholz An on-premises database called CDB114, running on Oracle Linux 7 OCI Management Agent up and running The goal is to handle the on-premises database in…
Read MoreOracle Cloud Infrastructure – A small and secure Development Environment – Next Level: Terraform
In a previous blog post I wrote how to build a small and secure development environment in Oracle Cloud Infrastructure with an OpenVPN entry point and a compute instance in a private setup. Now there is the Terraform code available in GitHub to setup it on an easy and reusable way: terraform-examples/oci/openvpnas at main · Trivadis/terraform-examples (github.com) What you get After executing the code, you will get this setup here: an OpenVPN Access Server from OCI Marketplace a Compute Instance Prerequisites Oracle OCI CLI installed and configured Terraform up and running Git client installed SSH Key Access An example private and public SSH key to get access on the compute instance in the private subnet is provided in subdirectory SSH,…
Read More