All articles

Oracle 12c – Is VKTM always your top process?

By William Sescu If VKTM is always your top cpu consuming process, then this blog might be something for you. Especially in virtual environments, I have seen often the VKTM process as the top process, even if the VM was(…)

Oracle 12c – How to Recover lost DataGuard Broker Configuration Files

By William Sescu If you are using RMAN to back up your database, you are already doing the right thing. However, RMAN does not take care of everything. e.g. it is not backing up the following things, to mention just(…)

Introducing AlwaysOn availability groups on Linux

A couple of days ago, Microsoft has rolled out the SQL Server vNext CTP 1.3 which includes very nice features and the one that interested me in the supportability of AlwaysOn availability groups on Linux. That(…)

Oracle 12cR2: Online tablespace encryption

By Franck Pachot . By default, all data is visible in the datafiles. Transparent Tablespace Encryption (TDE) can be used to get them encrypted. It requires Enterprise Edition plus Advanced Security Option. Except in the Oracle Cloud when it is(…)

12cR2: Recover nonlogged blocks after NOLOGGING in Data Guard

By Franck Pachot . You can accept to do NOLOGGING operations on bulk loads or index build according that you do a backup just after, and that your recovery plan mentions how to load the data again in case(…)

Oracle 12c – Recreating a Controlfile in a Data Guard environment with noresetlogs

By William Sescu Sometimes you might run into situations where the controlfile does not represent the backups and archivelogs correctly, because of a mismatch of the control_file_record_keep_time and the RMAN retention. The controlfile has non circular and a circular records.

12c Unified Auditing and AUDIT_TRAIL=DB in mixed mode

By Franck Pachot . Oracle enables some auditing by default, and if you don't do anything, the tables where it is stored will grow in SYSAUX. Don't wait to get an alert when it is too late. Everything that fills(…)

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(…)