Oracle Database Appliance X6 – resize your /u01

Basically on an ODA X6-L the directory /u01 has the size of 100 GB. With seven different ORACLE_HOME directories for the Oracle databases and the Grid Infrastructure software, there is no disk space left for patching the Oracle Database Appliance. ODA patches require between 13 GB and 15 GB free space on /u01 for the new software. Just FYI – during the patch process a new stage directory called /u01/patching is created where the new software is temporarily located. Patch Apply failed – Not enough free Space If there is not enough free space available, update processes like updating a database home fail. [root@oda-srv2046 ~]# odacli describe-job -i f024f27d-7c9a-43fc-9ae8-4f99ef809280 Job details —————————————————————- ID: f024f27d-7c9a-43fc-9ae8-4f99ef809280 Description: DB Home Patching: Home Id…

Read More

Get your Oracle 18c Instance in the Oracle Infrastructure Cloud OCI Classic

Do you want to work with Oracle 18c in the Oracle Cloud but the database version is not selectable in the webinterface? You can create an 18c instance in the command-line interface with the PaaS Service Manager (psm). The installation is very well described here, for example you need Python and OpenSSL. My personal installation of the psm executable runs in the Windows 10 integrated Ubuntu system. Link to the PaaS Service Manager: https://docs.oracle.com/en/cloud/paas/java-cloud/pscli/abouit-paas-service-manager-command-line-interface.html After the successful psm setup, you can create an DBaaS instance with this command $ psm dbcs create-service –config-payload db18c-ee.json The file db18c-ee.json contains all the information you need to create an 18c instance. Here is my example – I have created a cloud storage container…

Read More

Alexa: Storen Büro schliessen – Teil 1

Angefangen hat alles mit einem WLAN-fähigen Storenschalter, und als später noch mit Amazon Echo Dot Alexa den Weg in mein Büro zuhause fand war die Sache klar: Ich will meine Storen im Büro mit Alexa steuern können. In der Schweiz sind Storen übrigens nichts anderes als Rolladen. Was mit der Suche nach neuen Smart Home Komponenten begonnen hat, endete im Programmieren von Alexa Skills. In diesem Blogeintrag will ich aufzeigen was eingesetzt werden kann, um Smart Home Geräte welche eine REST API Schnittstelle besitzen via Alexa Sprachkommando steuern zu können. Bei meinem Projekt habe ich nicht unmittelbar mit dem Programmieren vom Alexa Skill begonnen, sondern ich habe am Ende beim Storenschalter begonnen und mich nach vorne vorgearbeitet. Spassfaktor: hoch, Lernkurve:…

Read More

Oracle Cloud Infrastructure Storage Software Appliance – Installation and Configuration

The Oracle Cloud Infrastructure Storage Software Appliance – also known as Oracle Storage Cloud Software Appliance OSCSA – acts as a gateway between classic storage and the Oracle Cloud Infrastructure Object Storage Service. The appliance can be installed on an on-premises Linux system or in an Oracle Compute Cloud machine and runs in a Docker container. It offers a local cache where clients can place their files before the OSCSA moves them into the Storage Service. The communication between a client with a filesystem to the OSCSA works with NFSv4, from the OSCSA to the Object Storage Service, Oracle is using their REST interface. Traffic from the OSCSA to and from the Oracle cloud can be encrypted and compressed. In this blog post…

Read More

Install and Configure Oracle Application Express with Oracle REST Data Services and Apache Tomcat

In this article I will show you how you can install and configure Oracle Application Express (APEX) and the Oracle REST Data Service (ORDS), which is running on an Apache Tomcat application server. In previous installations I used the Oracle HTTP server and the extenstion mod_plsq. But this does not work anymore with the newest Oracle HTTP server version. In the Oracle Application Express Installation Guide is written: mod_plsql is deprecated as of Oracle HTTP Server 12c (12.1.3). For more information, please see My Oracle Support Note 1576588.1. Oracle recommends using Oracle REST Data Services instead. Oracle REST Data Service is the future – so let’s go to the future. Installation Steps Installation and Configuration Oracle Application Express 5.1.1 Installation and…

Read More