Oracle FS 12.2 New Feature

.While reading Oracle 12.2 New Features I discovered that we can create filesystems on tablespaces. So I had to try it and it works, but somehow wrong. Docs used: Database PL/SQL Packages and Types Reference In the Large Objects guide you will not find very much: 😀 Database SecureFiles and Large Objects Developer’s Guide I…

filebeat and logstash – first setup

First, let’s install logstash, I have changed my yum repository to have access to their server. Now install and configure filebeat on the database host, I have to install an Oracle database too, I found somewhere on my disk SE2 install files so I used them and configured a very simple database Installing database… Our…

RAC to single standby – revisited

Hi, today I want to show how I think it’s possible to migrate a RAC to single. First let’s identify free disks Install GI and DB Home Prepare your spfile Prepare listener Create a passwordfile Define your connect identifiers Once you can login from these aliases without problems you can duplicate the DB Register this…

Docker with 12c SE2, step by step

Hi all, maybe you are interrested in docker or you want to learn new things like me, I have created a docker guide to a point where you can tnsping the listener. To create a database would be just uninterresting. Everything is in the documentation too, but there is always someone who wants it faster.…

Dataguard Sandbox – like never before

I decided to create a dataguard config using iscsi from orcl-store that will provide 20GB disks to 2 servers.. first of all I would like to create a RAID device on “physical discs” (I created 4 virtual disks, dynamically allocated and attached them to my VM).. Edit: the services are bad. don’t use them.. In…

Catching errors

Sometimes happened that some rows could not be loaded and the application got an ORA-1, how can you find out what value it was, I know, it can be defined other way too, but I wanted it this way… I don’t remember even why I did it this way, this was in a time like…