Database Administration & Monitoring

BLOG Technoark 2017 Conference – Blockchain, beyond the bitcoin.

BLOG Technoark 2017 Conference – Blockchain, beyond the bitcoin. and How applying Blockchain for Enterprise security and data management. I post a brief personal impression of the TechnoArk Conference 2017 in TechnoArk center(…)

OGG: Unable to lock file “/xxx/de000000” (error 11, Resource temporarily unavailable).

When you see the above message in the GoldenGate logfile there are usually orphan processes that prevent GoldenGate from locking the file (typically when your trail files are on NFS). In a case I had at a customer last week(…)

12cR2: lockdown profiles and ORA-01219

By Franck Pachot . When you cannot open a database, you will get some users unhappy. When you cannot open multitenant database, then the number of unhappy users is multiplied by the number of PDBs. I like to encounter problems(…)

Dataguard Oracle 12.2: Keeping Physical Standby Sessions Connected During Role Transition

By Mouhamadou Diaw As of Oracle Database 12c Release 2 (12.2.0.1), when a physical standby database is converted into a primary you have the option to keep any sessions connected to the physical standby, without disruption, during the switchover/failover. When(…)

Oracle 12c – How to correct the error: “RMAN-20005: target database name is ambiguous”

By William Sescu I do have a Data Guard environment, where I have configured the RMAN DB_UNIQUE_NAME persistent setting for my primary and the standby. With the RMAN DB_UNIQUE_NAME settings I am able to run reports my Oracle Data Guard(…)

Converting a column from one data type to another in PostgreSQL

Last week at a customer the following question came up: We have a varchar2 column in Oracle that contains a date but actually is stored as a string. When we want to convert this column to be a real date(…)

12cR2 real-time materialized view (on query computation)

By Franck Pachot . Materialized views is a very old feature (you may remember that it was called snapshots a long time ago). It has all advantages of a view, as you can define any select statement that joins, filters,(…)

Oracle 12c – Combining Flashback Drop and Flashback Query

By William Sescu If you think that Flashback Drop feature just brings back your table, then this is only half of the story. It does much more than that. Besides undropping the table, it also brings back your constraints, your(…)

SQL Server Failover Cluster on Linux and synchronizing uids/gids across nodes

In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to(…)

Oracle 12c – Issues with the HEATMAP Segment even if the heat map feature is not used

By William Sescu When I don’t need I feature, I don’t turn it on, or do not use it because it reduces the possibility to run into issues. Most of the times this is true, however, during the preparation for(…)