Starting with the release of Grid Infrastructure 12c Release 2, Oracle changed the installation process. Instead of unzipping the downloaded zip files to a staging area, you unzip them to your target Oracle Home location. Afterwards you run the configuration script gridSetup.sh. This new installer has a lot of improvements like patching the installer itself or installing patchset updates or bundle patches before the actual configuration of the Grid Infrastructure starts. I want to demonstrate one of these new features – the creation of a Gold Image of an existing Grid Infrastructure installation.
Continue readingAuthor: Christian Gohmann
tfactl fails on Solaris while using df
This is just a short blog post about a problem using Oracle Tracefile Analyzers commandline utility tfactl on Solaris.
Continue readingUseful vi commands
Vi is a my preferred tool for editing files on Linux/Unix with a huge amount of possibilities. This blog post is a container for useful vi commands. Over the time the content will be extended by additional commands.
Continue readingResolve TNS alias using DBMS_TNS
This short blog post will demonstrate the usage of the new DBMS_TNS package, which was first introduced with the release of Oracle 12.2.0.1 and can be used to resolve a TNS alias to its full connect descriptor.
Continue readingGenerate CSV with SQL*Plus 12.2.0.1
From time to time it is required to get the rows of a table as comma separated values (CSV). With the release of Oracle 12.2.0.1, SQL*Plus has the ability to display the result of a query as CSV. This short blog post will demonstrate the usage of this new feature.
Continue readingGrid Infrastructure does not start after Kernel upgrade to 3.10.0-514.21.2
A lot of operating system vendors released recently an updated version of the Linux Kernel to fix an issue called Stack Clash (CVE-2017-1000364). But after applying the new Kernel version, the startup of the Grid Infrastructure fails.
Continue readingorapwd enforces password complexity rules in 12.2.0.1
Starting with Oracle Database 12.2.0.1 the orapwd utility – used to create Password Files for remote authentication – enforces complexity rules for the provided password.
Continue readingSilent installation of Grid Infrastructure 12.2.0.1 without ASM
This is the first blog post about the recent release 12.2.0.1 of Oracle Grid Infrastructure. In the next lines I will demonstrate how to install Grid Infrastructure for a standalone server (Oracle Restart) without the Automatic Storage Management (ASM) component silently.
Continue readingBlog is back online
After an outage of several months, my blog is back online 🙂
Continue readingHome Verzeichnis für existierenden Benutzer erstellen
Bei dem Versuch das Logical Volume des /home Verzeichnisses zu verkleinern, kam es zu einem Problem, das dazu führte, dass nach der Verkleinerung des Volumes, dieses nicht mehr eingehangen werden konnte. Dadurch waren alle Home Verzeichnisse der Benutzer verloren. Dieser kurze Blog-Beitrag zeigt, wie man für einen existierenden Benutzer, ein Standard Home-Verzeichnis anlegt.
Continue reading