I a customer project I had to update an existing Red Hat Ansible Tower setup from version 3.5.1 to the newest available version 3.8. The upgrade scenario as described in 8. Upgrading an Existing Tower Installation — Ansible Tower Installation and Reference Guide v3.8.0 does not work here. For example: the delivered setup.sh is not able to restore data exported from Postgres 9.6 into a new Postgres 10 database. This upgrade scenario as described is a result of a long discussion with Red Hat support (Thanks to Swati – he did a great job!) and an intensive test period on local virtual machines until the live system was in the row. Remark: The servers in this blog post are listed…
Read MoreYear: 2020
Oracle OCI Data Transfer Service – A journey from Kestenholz/Jurasüdfuss/Switzerland to Frankfurt and back
The Oracle Data Transfer service is a offline data transfer method to migrate data to the Oracle Cloud Infrastructure. A transfer service is useful, when your network bandwidth and connection is not sufficient to upload your migration data in a meaningful time. Oracle offers two methods: The disk-based data transfer and the appliance-based data transfer. The service is no only one-way, data can also be exported in an Oracle Cloud Infrastructure data center and shipped to your data center. According one of my Company Trivadis’ cultural value called curiosity, I was wondering how this service works. This is the story of a tiny USB Hard Disk Drive full of data, which was going on a long journey from Kestenholz /…
Read MoreOracle Cloud Infrastructure Classic Object Storage – Cleanup Day with FTM CLI
Yesterday I decided to cleanup old Oracle Cloud Infrastructure Classic objects. There were a lot of files lying around in the Object Storage of a project from 2018. Cleaning up these files in the OCI console was no option, they can only be deleted one by one. And with over 1500 files, a bad idea. During the search for an option for Object Storage mass deletion, I found this tool: ftmcli – Object Storage Classic File Transfer Manager. The MOS note contains the script and a short manual how to use. It’s a Java based script, a perfect match for my Windows Subsytem for Linux (Ubuntu), which I often use for OCI actions. OAC-Classic : How To Delete A Storage…
Read MoreMV2OCI – 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 the Object Storage. As an option, the data can be transferred via Database Link (mv2oci Parameter –netlink). All you need to know about mv2oci is written in the My Oracle Support Note (OCI) MV2OCI: move data to Oracle Cloud Database…
Read MoreOracle 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 : 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 More