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 readingMonth: July 2017
Resolve 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 reading